Using attachment 134539 [details] from bug 109016. I save it into an XLSX file with LO Calc, then Excel opens it without displaying a pivot table filtering button on A3 Cell.
Steps to Reproduce:
1. Open attachment 134539 [details] in Calc
2. Save it to an XLSX file
3. Open the saved file in Excel
Filtering button is not displayed in Excel.
Button should be displayed on A3 cell.
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
Tamás Zolnai committed a patch related to this issue.
It has been pushed to "master":
tdf#112733: Pivot table is displayed wrong in Excel after saved in LO 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.