Bug 150954 - Pivot table is gone after the file is saved in xlsx file
Summary: Pivot table is gone after the file is saved in xlsx file
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
Keywords: dataLoss
Depends on:
Blocks: Pivot-Table-XLSX
  Show dependency treegraph
Reported: 2022-09-14 11:18 UTC by Thomas Jiang
Modified: 2023-09-23 18:53 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

The original spreadsheet in .ods format (20.16 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-09-14 12:57 UTC, Thomas Jiang
The spreadsheet resaved in xlsx format (6.96 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2022-09-14 12:58 UTC, Thomas Jiang

Note You need to log in before you can comment on or make changes to this bug.
Description Thomas Jiang 2022-09-14 11:18:04 UTC
The pivot table is gone after the file is saved in xlsx file.

Steps to Reproduce:
1. Add some data into spreadsheet in the first sheet, in the a second sheet, add a pivot table.
2. When save the file in the ods format, the pivot table will saved correctly.
3. However, re-save the file in xlsx file, and then open it up, the pivot table is gone.

Actual Results:
When open up the xlsx file, the pivot table is gone, instead we can only see the original data on where the pivot table is supposed to be.

Expected Results:
It is expected that, after the file is saved in xlsx format, the pivot table should stay.

Reproducible: Always

User Profile Reset: Yes

OpenGL enabled: Yes

Additional Info:
Version: / LibreOffice Community
Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a
CPU threads: 32; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: en-CA (en_CA.UTF-8); UI: en-US
Calc: threaded
Comment 1 Thomas Jiang 2022-09-14 12:57:33 UTC
Created attachment 182440 [details]
The original spreadsheet in .ods format

The original .ods format of file has pivot table.
Comment 2 Thomas Jiang 2022-09-14 12:58:25 UTC
Created attachment 182441 [details]
The spreadsheet resaved in xlsx format

Once the file is resaved in .xlsx format, the pivot table is gone.
Comment 3 Roman Kuznetsov 2022-09-17 18:48:31 UTC
Confirm in 7.5 and it looks like a dupe of bug 123225

*** This bug has been marked as a duplicate of bug 123225 ***
Comment 4 Aron Budea 2023-01-17 02:51:52 UTC
I'd treat this separately from bug 123225, that one's about the behavior in Excel after saving as XLSX, while this is about the behavior in Calc. Ideally both should be fixed, but I doubt fixing one of the two will fix the other as well.

Plus the bugdoc in 123225, attachment 149532 [details], doesn't exhibit this issue.
Comment 5 m_a_riosv 2023-09-23 18:53:18 UTC
Seems it has something to do with the option for:
'Vehicle name' – Options – Show Automatically
Source ODS has it set up to 5
Recreating the PT with LibO 7.6.1, keeps the PT but without respect the option.