Bug 163910 - FILESAVE XLSX: pivot chart is wrongly exported
Summary: FILESAVE XLSX: pivot chart is wrongly exported
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.2.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: Pivot-Chart
  Show dependency tree / graph
 
Reported: 2024-11-15 15:30 UTC by Regina Henschel
Modified: 2024-11-16 11:07 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Pivot chart made by LO (25.61 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-11-15 15:30 UTC, Regina Henschel 		Details
Screenshot (176.04 KB, image/png)
2024-11-15 15:34 UTC, Regina Henschel 		Details
Screenshot opened with Microsoft® Excel® Microsoft 365 MSO (ver 2410 compil 16.0.18129.20158) 64 bits (33.33 KB, image/png)
2024-11-16 01:09 UTC, m_a_riosv 		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 15:30:00 UTC 
Created attachment 197631 [details]
Pivot chart made by LO

Open attached document and save it xlsx format. Open the created xlsx file in Excel. Notice that the pivot chart is not exported as pivot chart and as a simple chart has wrong labels for categories and series.
Comment 1 Regina Henschel 2024-11-15 15:34:42 UTC 
Created attachment 197632 [details]
Screenshot

The screenshot shows left the original file in LibreOffice and right the file exported by LO to xlsx format opened in Excel.
Comment 2 m_a_riosv 2024-11-16 01:09:31 UTC 
Created attachment 197643 [details]
Screenshot opened with Microsoft® Excel® Microsoft 365 MSO (ver 2410 compil 16.0.18129.20158) 64 bits

Reproducible with
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