Re: Re: OO: 1.1.x: problems with the edit tables
Frank Schönheit - Sun Microsystems Germa ny <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
Hi Uwe, > I did with OO2.0, same database mysql and the mysql driver. > I added 2 fields in decimal format, 2 in double format. > (BTW what is the difference between numeric/decimal/double?) ask your database's documentation :) > When dragging and dropping them to the scalc document, the decimal > fields get a dollar sign (that can be surpressed by changing the > format of the relevant column as I said.) The doble fields are fine. At first glance, this sounds like a driver bug. I darkly remember that in some cases, a MySQL driver was too generous with declaring certain columns as "currency" - they used a flag which, by definition, should say "is currency", though they wanted to say "_can_ be currency". OOo, respecting the definition of "is currency", then auto-guessed that it should also be formatted as currency. But not sure. We can investigate in the course of the issue(s) you submitted. Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -