In MSO there are three layout modes fro pivot tables. LO supports two of them (tabular and outline mode). However XLSX export always export outline mode, so after an RT in Calc the layout changes.
Steps to Reproduce:
1. Open attached test document (XLSX), with a pivot table in tabular mode
2. Save back to XLSX
3a. Open in Calc -> layout changes
3b. Open in Excel and refresh pivot table -> layout changes
Pivot table tabular mode is converted to outline mode after an RT in Calc.
Since tabular mode is imported, it should be exported too.
User Profile Reset: No
User-Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36
Created attachment 137018 [details]
A pivot table in tabular mode
Splitted from bug 89139. There you can see also some screenshots.
Tamás Zolnai committed a patch related to this issue.
It has been pushed to "master":
tdf#113159: Pivot table: tabular mode is converted to oultine mode
It will be available in 6.0.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Looks much better now. Thanks.
The only difference is now that after a refresh there is a expand/collapse button in each cell.
(In reply to Gerhard Schaber from comment #4)
> Looks much better now. Thanks.
> The only difference is now that after a refresh there is a expand/collapse
> button in each cell.
Yes, I also see this issue. Excel has these buttons, with which you can make the layout a bit more compact, but LO Calc doesn't support such buttons neither in runtime or by export to file formats. So it might be a good idea to create an other bug report about these buttons. It's independent from the layout mode (e.g. outline vs tabular vs compact), so not part of this bug report.
LOP might not support those buttons, but it adds them when storing the file.