[Libreoffice-bugs] [Bug 46587] : Report Displays a Number incorrectly if formatted as 'number' but correctly if format described as 'text'.

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Sun Jul 8 20:21:59 CEST 2012


https://bugs.freedesktop.org/show_bug.cgi?id=46587

robert at familiegrosskopf.de changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |robert at familiegrosskopf.de

--- Comment #2 from robert at familiegrosskopf.de 2012-07-08 11:21:59 PDT ---
Your phone-number is formated as VARCHAR in the table. What should the report
do with that formatted as number?
I have changed the query in your database:
SELECT "TOWN", "POSTCODE", CONVERT ( "TELEPHONE" , INTEGER ) AS "Number",
"TELEPHONE" FROM "Table1"
... and then linked it to the report. the filed "Number" is correctly shown in
a number-format.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.



More information about the Libreoffice-bugs mailing list