[Libreoffice-bugs] [Bug 80177] PIVOTTABLE: Date format PostgreSQL

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=80177

Julien Nabet <serval2412 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com

--- Comment #18 from Julien Nabet <serval2412 at yahoo.fr> ---
On pc Debian x86-64 with master sources updated today, I can still reproduce
from comment 15 (A first ods file with a odb wrapper file and a final ods file
using the odb file).

Several remarks:
1) In first file, even when typing date with 4 years, Calc uses 2 numbers by
default for date.
I must format the column explicitely. (perhaps not related directly to this
bugtracker but concerns format problem)
Note: I didn't use column headers in this file. 

2) In odb file, Base uses the format with 4 numbers for years in column name of
the table, but uses the by default the format with 2 numbers for years for the
values.

3) In third file (so the second ods file), the name of column uses the format
with 4 numbers for years and like the bug tracker describes, I got just numbers
for values.
But I noticed that when clicking on arrow of the column in pivot table (eg to
filter it), values appeared as dates with a format with 2 numbers for years.

Eike: thought you might be interested in this one since it concerns Pivot part.
Any thoughts?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180723/bd71cf0d/attachment.html>