[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