[Libreoffice-bugs] [Bug 123421] New: FILESAVE XLSX Calc creates corrupted pivot table

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 123421
           Summary: FILESAVE XLSX Calc creates corrupted pivot table
           Product: LibreOffice
           Version: 6.1.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: baron at caesar.elte.hu
            Blocks: 104839, 112416

Created attachment 149245
  --> https://bugs.documentfoundation.org/attachment.cgi?id=149245&action=edit
Sample ODS

The attached ODS is a simple pivot table created similarly to attachment 133861
from bug 108343, just in Calc, and there's a filter on Product.

Save it as XLSX, and open it in Excel.

=>
A couple of issues:
- Filter button for Product is in the wrong row.
- Filter on Country is missing.
- Changing Product filter crashes Excel 2013.
- Right-clicking table, and selecting Refresh crashes Excel 2013.

Observed using LO 6.3.0.0.alpha0+ (e0745a11597e5d57eb8001a295314e86810a6027) /
Windows 7.
In 6.1.0.3 the pivot table isn't even exported as a pivot table, no point in
checking with earlier versions.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=104839
[Bug 104839] [META] Saved XLSX files that MS Excel can't open
https://bugs.documentfoundation.org/show_bug.cgi?id=112416
[Bug 112416] [META] XLSX pivot table bugs
-- 
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/20190212/f62590a1/attachment-0001.html>