Bug 170498 - XLSX - Export dataOnRows attribute in Pivot Table
Summary: XLSX - Export dataOnRows attribute in Pivot Table
Status: ASSIGNED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
26.8.0.0 alpha0+ master
Hardware: All All
: medium normal
Assignee: Karthik
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2026-01-27 14:57 UTC by Karthik
Modified: 2026-01-28 19:48 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
XLS File (14.50 KB, application/vnd.ms-excel)
2026-01-27 14:58 UTC, Karthik
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Karthik 2026-01-27 14:57:01 UTC
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:
Comment 1 Karthik 2026-01-27 14:58:21 UTC
Created attachment 205204 [details]
XLS File