Created attachment 133861 [details]
Sample pivot table created in Excel
The attached simple pivot table was created in Excel 2013.
If the file is roundtripped in LibreOffice (just needs to be saved after loading), it opens asking for recovery in Excel, and produces the following report after repairs:
"Repaired Records: PivotTable report from /xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache)"
In the repaired file refreshing pivot table data crashes Excel.
Clicking on autofilter dropdown of Country selector also crashes Excel. Note how "(All)" was changed to "- all -" in LibreOffice.
Observed with LO 5.4beta1 & 18.104.22.168 / Windows 7.
Roundtripping with 22.214.171.124 didn't even preserve the pivot table.
This could be the same as bug 89139 in its current state (gives the same message after repairs, crashes Excel the same way). Since the original issue of bug 89139 is gone, and it's preferred to have new bug reports for new issues, I decided to open this instead.
Created attachment 133862 [details]
Sample roundtripped with LO 5.4beta1
I can reproduce the repairing dialog in MSO 2010 under wine after a roundtrip with
Build ID: f2d40b8ba172d90be9a43c30cd5cbd62c0e8e548
CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; VCL: gtk3;
Locale: ca-ES (ca_ES.UTF-8); Calc: group
However, MSO 2010 doesn't crash for me
I have resolved Cache corruption issue in the bug report: tdf#89139.
It should now works fine in LibreoOffice 6.0. I'm closing this bug as fixed.
Please test different pivots, and let me know if it is working correctly.
If you find other corruption issues with pivot, please attach sample to bug report tdf#89139
*** This bug has been marked as a duplicate of bug 89139 ***