View previous topic :: View next topic |
Author |
Message |
Vrenn Guru
Joined: 15 Dec 2004 Posts: 311
|
Posted: Tue Nov 22, 2011 3:02 pm Post subject: libreoffice base Report displays unformatted date |
|
|
I have a simple Database with one field containing dates like 18.11.2011.
The date is stored as 18.11.2011
Making a report the date is displayed as 40865.
What is going wrong?
Old databases display the reports correct. Making a new report even in an old database makes a 40865-like number again instead a formatted date.
Is that a new bug?
can somebody reproduce it?
using app-office/libreoffice-3.4.3.2-r1 and dev-db/hsqldb-1.8.1.2-r1
Thanks for any help. _________________ With nice greetings
Vrenn |
|
Back to top |
|
|
Vrenn Guru
Joined: 15 Dec 2004 Posts: 311
|
Posted: Sun Nov 27, 2011 8:47 am Post subject: |
|
|
Manually change the format in the editor is a solution. But the report-generator has a bug. Windows-Libreoffice does this all fine.
My question still remains:
Am I alone or are there enough to open a bug? _________________ With nice greetings
Vrenn |
|
Back to top |
|
|
Rambo Tribble n00b
Joined: 14 Jun 2013 Posts: 2
|
Posted: Fri Jun 14, 2013 5:07 pm Post subject: |
|
|
The solution is to right-click on the report name in the database console and choose "Edit". Then right-click on the cell which should display the date, choose "Number format" from the resulting drop-down, then choose "Date" from the resulting number format dialog. |
|
Back to top |
|
|
Vrenn Guru
Joined: 15 Dec 2004 Posts: 311
|
Posted: Fri Jun 14, 2013 5:55 pm Post subject: |
|
|
Thank you, thats right (and should be mentioned here, so thanks for your post)
It worked before without manual adjusting (and seems to be fixed, tested with libreoffice 3.6.6) _________________ With nice greetings
Vrenn |
|
Back to top |
|
|
Rambo Tribble n00b
Joined: 14 Jun 2013 Posts: 2
|
Posted: Fri Jun 14, 2013 6:25 pm Post subject: |
|
|
It appears to be back with 4.0, on Kubuntu 12.04, anyway. It was searching for the solution that I found your original posts. It was the only such posting I found, so when I worked out the solution I figured I'd add it to the thread. The key is that reports are Writer documents and subject to its formatting. Apparently, in some cases the report generator simply fails to pass the formatting information to Writer. |
|
Back to top |
|
|
Vrenn Guru
Joined: 15 Dec 2004 Posts: 311
|
Posted: Fri Jun 14, 2013 7:13 pm Post subject: |
|
|
4.0 again? I hope this is just a (missing/added) distro-patch
Anyway, you are right. _________________ With nice greetings
Vrenn |
|
Back to top |
|
|
|