https://bugs.documentfoundation.org/show_bug.cgi?id=170498
Bug ID: 170498
Summary: XLSX - Export dataOnRows attribute in Pivot Table
Product: LibreOffice
Version: 26.8.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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:
--
You are receiving this mail because:
You are the assignee for the bug.
