Description: 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: 7.4.0.3 / 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
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.
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.