[Libreoffice-bugs] [Bug 108343] New: Pivot table (cache) in XLSX corrupted after roundtrip, file crashes Excel

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108343

            Bug ID: 108343
           Summary: Pivot table (cache) in XLSX corrupted after roundtrip,
                    file crashes Excel
           Product: LibreOffice
           Version: 4.4.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: major
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: baron at caesar.elte.hu
            Blocks: 103381

Created attachment 133861
  --> https://bugs.documentfoundation.org/attachment.cgi?id=133861&action=edit
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 & 4.4.0.3 / Windows 7.
Roundtripping with 4.0.0.3 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.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=103381
[Bug 103381] [META] Pivot table (aka Data Pilot) bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170605/b1c34b1c/attachment-0001.html>