After opening attachment 133861 [details] from bug 108343 , it's opened well displaying a simple pivot table. Then I save it in XLS format and try to open it in MS Excel (Excel 2016). Excel opens it in protected view, saying that the file has a problem (e.g. corrupted) and I can't edit it anymore.
Steps to Reproduce:
1. Open attachment 133861 [details] from bug 108343 in Calc
2. Save it to XLS file without doing anything with it in Calc
3. Open it in MS Excel
Excel opens the exported XLS in protected view and I can't edit the content.
Excel should not detect any problem with the exported XLS.
User Profile Reset: No
User-Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36
Created attachment 135870 [details]
Corrupted XLS file exported from Calc
Tamás Zolnai committed a patch related to this issue.
It has been pushed to "master":
tdf#112106: Corrupted pivot table after XLSX -> XLS conversion 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.