[Libreoffice-bugs] [Bug 126131] New: Calc sheet with a PIVOTTABLE and saved as .xlsx errors when opened in Excel

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 126131
           Summary: Calc sheet with a PIVOTTABLE and saved as .xlsx errors
                    when opened in Excel
           Product: LibreOffice
           Version: 6.0 all versions
          Hardware: Other
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mberthelemy at wyversolutions.co.uk

Description:
Version: 6.0.3.2
Build ID: 1:6.0.3-0ubuntu1
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-GB (en_GB.UTF-8); Calc: group

Saving a sheet with a pivot table as xlsx causes an issue when opening in Excel

Steps to Reproduce:
Steps to replicate:

1) Create a Calc spreadsheet with a Pivot Table on a separate sheet
2) Save as .xlsx
3) Open in MS Excel



Actual Results:
Actual behaviour

- Excel gives the error: "We found a problem with some content in
'spreadsheet.xlsx' Do you want us to try to recover as much as we can?
- The spreadsheet is recovered (unsure yet if the pivot table gets recreated
accurately)



Expected Results:
Expected behaviour

- The sheet will open in Excel and the pivot table will display


Reproducible: Always


User Profile Reset: No



Additional Info:
Removing the pivot table removes the problem.

-- 
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/20190627/398bf33a/attachment.html>