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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #23 from mshiner at uzerp.com ---
Bug is still present

Ubuntu 20.04
Version: 6.4.6.2
Build ID: 1:6.4.6-0ubuntu0.20.04.1
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: en-GB (en_GB.UTF-8); UI-Language: en-US
Calc: threaded

I narrowed it down to the way styles are applied to the PT.

Basically on a new PT (with data in a tab in the file or an external database)
you get 6 styles

Pivot Table Category
Pivot Table Corner
Pivot Table Field
Pivot Table Result
Pivot Table Title
Pivot Table Value

If you change background colour/font etc on, say, the Category or Value it is
applied and survives a refresh. Number format, however is not. Even if you
modify the number format in the style it is not applied at all - I assume the
default of 'general' is applied. 

If you have your data in a calc tab on the same sheet you can apply the number
format there and the PT respects it.

Conclusion, the PT style for number format is always set to 'general' unless
the number is 'formatted' in the data - which only works if the data is in the
same sheet on another.

I also found this link
https://mikekaganski.wordpress.com/2019/04/29/xlsx-interoperability-pivot-tables-related-improvements/
and specifically this

and this fix
https://git.libreoffice.org/core/+/26e85974a0287ab5869e7ff0145a66b853d66a02

related to this bug https://bugs.documentfoundation.org/show_bug.cgi?id=124772
report.

Mike notes "Excel relies on per-field format setting in pivot tables, while
Calc
takes fields formatting from source." which I think is where the problem
resides.

Regards
Martyn

-- 
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/20201009/759ee61b/attachment.htm>