In MSO there are more view types (oultine, tabular, compact). It seems to me LO calc only supports outline mode. In the attached test document I added a simple pivot table in outline view in Excel. If I round trip it in Calc and reopen it in Excel, a popup button / selector is missing in G1 cell for field2 pivot table field. It seems the issue is that the outline mode is not correctly exported by Calc.
Steps to Reproduce:
1. Open attached test document in Calc
2. Resave it to an XLSX file
3. Open it in Excel and refresh the table
When opening the document, the selector is missing. After an update it switches to compact mode.
Selector button should be there after importing the document. After a refresh the same outline layout should be displayed as in Calc or in the original test document.
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 136813 [details]
Simple pivot table in outline view
Tamás Zolnai committed a patch related to this issue.
It has been pushed to "master":
tdf#112946: Pivot table: Missing selector for a row field after RT in Calc
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.