Description: Check the attached test document. It was created in MS Excel and contains a simple pivot table. If I open it in Calc and save back to an XLSX file than MSO opens it, but when I try to refresh the pivot table it crashes. After some testing I found out that this is because of the field called "DATA". This "DATA" name might collide with some internally used name. I would guess something like that. If I change it to "DATA1" in the source range and refesh the table, then roundtriping in Calc will not lead to this issue. Steps to Reproduce: 1. Open attached test XLSX in Calc 2. Save it back to an XLSX file 3. Open in Excel and refresh the table (right click on pivot table -> refresh) Actual Results: Excel crashes. Expected Results: Excel should not crash on the roundtripped document. Reproducible: Always User Profile Reset: No Additional Info: 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 136802 [details] Simple pivot table with a field named "DATA"
Tamás Zolnai committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=bab595df78bd05a45f92aa15dca058f27b86d5be tdf#112936: Pivot table: LO created XLSX file makes Excel to crash 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: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/d2505dd4cc0960e97a5fca848996c8f1b043880d tdf#112936: Add unittest It will be available in 7.0.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.