- "Le-shin Wu" wrote:
> HI Adrian,
>
> Thanks for pointing out the reporting bug information about my
> problem. I have tried your suggestion and it works great. But this
> approach can only solve one part of my problem, because I also need to
> open an existing db table through Clac, edit
HI Adrian,
Thanks for pointing out the reporting bug information about my problem. I
have tried your suggestion and it works great. But this approach can only
solve one part of my problem, because I also need to open an existing db
table through Clac, edit some tuples, and then save it as a new ta
- "Le-shin Wu" wrote:
> Hi Adrian,
>
> Thanks for your information. I think your suggestion will be my last
> approach, if I really can not find a way to solve my problem.
> Actually, I tried to format the cells type (the "date" column in my
> sheet) in Calc as "Date" before I copy and past
- "Tom Lane" wrote:
> Adrian Klaver writes:
> >> The problem is that dates in spreadsheets are stored as days from
> some
> >> date. For a more complete answer see:
> >> http://www.lexicon.net/sjmachin/xlrd.html
>
> Somebody should file a bug/RFE against OpenOffice, suggesting that
> there
Hi Adrian,
Thanks for your information. I think your suggestion will be my last
approach, if I really can not find a way to solve my problem. Actually, I
tried to format the cells type (the "date" column in my sheet) in Calc as
"Date" before I copy and past, but somehow it works for only once. Thi
Adrian Klaver writes:
>> The problem is that dates in spreadsheets are stored as days from some
>> date. For a more complete answer see:
>> http://www.lexicon.net/sjmachin/xlrd.html
Somebody should file a bug/RFE against OpenOffice, suggesting that there
ought to be an option to store dates as da
On Tuesday 01 December 2009 7:40:26 am Adrian Klaver wrote:
> On Tuesday 01 December 2009 7:21:45 am Le-shin Wu wrote:
> > Hi,
> >
> > I use OpenOffice Base as the front end tool to connect a postgreSQL
> > server. It works great. But when I am trying to create a table by copying
> > data from Open
On Tuesday 01 December 2009 7:21:45 am Le-shin Wu wrote:
> Hi,
>
> I use OpenOffice Base as the front end tool to connect a postgreSQL server.
> It works great. But when I am trying to create a table by copying data from
> OpenOffice Calc and then pasting to my postgreSQL database (connected
> thro
Hi,
I use OpenOffice Base as the front end tool to connect a postgreSQL server.
It works great. But when I am trying to create a table by copying data from
OpenOffice Calc and then pasting to my postgreSQL database (connected
through OpenOffice base), I always got an invalid input syntax error for
