Bug 168733 - FILEOPEN XLSX Pivot tables custom number formatting is not imported
Summary: FILEOPEN XLSX Pivot tables custom number formatting is not imported
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table-XLSX
  Show dependency treegraph
 
Reported: 2025-10-07 21:06 UTC by Gabor Kelemen (Collabora)
Modified: 2025-10-07 22:46 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Excel (12.45 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2025-10-07 21:06 UTC, Gabor Kelemen (Collabora)
Details
The pivot table in Excel and Calc (96.19 KB, image/png)
2025-10-07 21:07 UTC, Gabor Kelemen (Collabora)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (Collabora) 2025-10-07 21:06:54 UTC
Created attachment 203181 [details]
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
Comment 1 Gabor Kelemen (Collabora) 2025-10-07 21:07:21 UTC
Created attachment 203182 [details]
The pivot table in Excel and Calc
Comment 2 m_a_riosv 2025-10-07 22:46:28 UTC
I'm wrong or custom formats are not available in LO for PT.

Isn't this a duplicate of tdf#122472?