https://bugs.documentfoundation.org/show_bug.cgi?id=168733
Bug ID: 168733
Summary: FILEOPEN XLSX Pivot tables custom number formatting is
not imported
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 112416
Created attachment 203181
--> https://bugs.documentfoundation.org/attachment.cgi?id=203181&action=edit
Example file from Excel
Attached example file has a custom number formatting applied on data used by a
pivot table.
The pivot table also uses this custom number format, but when the file is
opened in Calc, it resets to standard number format.
1. Open attached file
-> in the pivot table on Sheet3 the number appear as 1, 2 instead of the custom
format that would show "less" and "much" strings instead of these.
On the Sheet1.F2:G5 range - which are plain cells without pivot table - these
custom number formats work.
Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 708abf24664a9a1aaeac452bcc8436026030e74e
CPU threads: 14; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster;
VCL: win
Locale: de-DE (hu_HU); UI: en-US
Calc: threaded
and back to 3.3
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=112416
[Bug 112416] [META] XLSX (OOXML) pivot table bugs
--
You are receiving this mail because:
You are the assignee for the bug.
