Bug 163909 - FILEOPEN XLSX: pivot table is not imported as pivot table
Summary: FILEOPEN XLSX: pivot table is not imported as pivot table
Status: NEW
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: filter:xlsx
Depends on:
Blocks: Pivot-Table-XLSX
  Show dependency tree / graph
 
Reported: 2024-11-15 14:57 UTC by Regina Henschel
Modified: 2025-01-27 14:49 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Example with pivot table and pivot chart (96.30 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-11-15 14:57 UTC, Regina Henschel 		Details
Screenshot left Excel right LO (122.29 KB, image/png)
2024-11-15 15:04 UTC, Regina Henschel 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Regina Henschel 2024-11-15 14:57:11 UTC 
Created attachment 197629 [details]
Example with pivot table and pivot chart

Open attached file. It has a pivot table in range F4:L13 in Excel. The opened file has no pivot table there but only ordinary direct cell content.
Comment 1 Regina Henschel 2024-11-15 15:04:28 UTC 
Created attachment 197630 [details]
Screenshot left Excel right LO

To verify that it is no pivot table: Change a value in column C, go to Data > Pivot Table. If it were a pivot table, the item 'Refresh' would be enabled.
Comment 2 m_a_riosv 2024-11-16 01:02:50 UTC 
Reproducible
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 83910246044c1e05a3b50e25d21ac6a31566cc38
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 3 Timur 2025-01-27 14:48:09 UTC Comment hidden (me-too)
Comment 4 Timur 2025-01-27 14:49:57 UTC 
Seems this happens only with original pivot in the same sheet.
If in MSO I create similar pivot in another sheet, that one opens in 25.2+, albeit black&white, without pivot theme colors.