https://bugs.documentfoundation.org/show_bug.cgi?id=92116
Bug ID: 92116
Summary: PIVOTTABLE: Format of Date from registered database
Product: LibreOffice
Version: 4.0.0.3 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: anthony.or...@eree.fr
Created attachment 116584
--> https://bugs.documentfoundation.org/attachment.cgi?id=116584&action=edit
Example with LO 4.2.8.2 / Ubuntu 14.10 LTS (screenshot)
When I create a pivot table from a database registered in LibreOffice, throw a
query or not, the Dates get number format. Whereas dates are formatted well in
the autofilter button, for example (please look at screenshot attached).
It's the same problem, I think that mshiner's one on the bug report n° 80177.
But I don't use PostgreSQL or other connection like that. My database is made
of only one Excel5.0 file stored on a Windows Server.
I tried with a file and database stored locally : same result.
I tried with a dbf file instead of Excel : same result.
I tried add a sheet linked to the source file on the same file of the pivot
table (so no database needed) : Dates format is ok.
I had this problem first when trying LO 4.0.0 beta.
It can be reproduce with LOdev 5.0.0.0 beta3.
So I still use LO 3.6.5.2 for this kind of processing.
There's the same bug in Apache OpenOffice 4.0.1 but it's fixed on AOO 4.1.0.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
