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.
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.
It is expected that, after the file is saved in xlsx format, the pivot table should stay.
User Profile Reset: Yes
OpenGL enabled: Yes
Version: 184.108.40.206 / 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
Created attachment 182440 [details]
The original spreadsheet in .ods format
The original .ods format of file has pivot table.
Created attachment 182441 [details]
The spreadsheet resaved in xlsx format
Once the file is resaved in .xlsx format, the pivot table is gone.
Confirm in 7.5 and it looks like a dupe of bug 123225
*** This bug has been marked as a duplicate of bug 123225 ***
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.