Description: Open the attached XLS file and save it as XLSX. Excel throws an error when opening the resulting XLSX file. Save the same XLS file in Excel as XLSX. Unzip both, the file saved and Excel and the file saved in LibreOffice, format both the folders using the below command ``` find {folder_name}/ . -name "*.xml*" -exec xmllint --format {} -o {} \; ``` Looking at the diff of `pivotTable1.xml` b/w both folders, we see that in Excel version in `pivotTableDefinition` element `dataOnRows` attribute is exported, which is not exported in LibreOffice version. Exporting this `dataOnRows` attribute in XLSX fixes the issue. Actual Results: Expected Results: Reproducible: Always User Profile Reset: Yes Additional Info:
Created attachment 205204 [details] XLS File