Bug 126131 - Calc sheet with a PIVOTTABLE and saved as .xlsx errors when opened in Excel
Summary: Calc sheet with a PIVOTTABLE and saved as .xlsx errors when opened in Excel
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0 all versions
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-06-27 13:07 UTC by Mark Berthelemy
Modified: 2019-10-13 20:43 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Mark Berthelemy 2019-06-27 13:07:47 UTC 
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.
Comment 1 Mike Kaganski 2019-06-27 13:44:50 UTC 
Please check with current versions (6.2). Version 6.0 is EOLed quite some time ago; even 6.1 will EOL soon. There have been quite some changes in between, and some more in upcoming 6.3.

If your problem is reproducible with these versions, please attach a reproducing document, and reset status back to UNCONFIRMED. Thanks!
Comment 2 Mark Berthelemy 2019-06-27 13:49:57 UTC 
Hi Mike,
Thanks for the advice. I'd wrongly assumed that the version in the Ubuntu Software library was relatively recent.

I'll sort out upgrading.

Regards,
Mark
Comment 3 QA Administrators 2019-06-28 03:00:06 UTC Comment hidden (obsolete)
Comment 4 raal 2019-06-28 13:55:43 UTC 
Works for me with Version: 6.4.0.0.alpha0+ (x64)
Build ID: d8932ff5df0939b5c5e378b7ad0a63a25df5b3b0
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 

Seems to be fixed with dev version. Please could you test it with dev version?  You can download it here: http://dev-builds.libreoffice.org/daily/master/
Thank you
Comment 5 Roman Kuznetsov 2019-10-13 20:43:50 UTC 
(In reply to raal from comment #4)
> Works for me with Version: 6.4.0.0.alpha0+ (x64)
> Build ID: d8932ff5df0939b5c5e378b7ad0a63a25df5b3b0
> CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
> 
> Seems to be fixed with dev version. Please could you test it with dev
> version?  You can download it here:
> http://dev-builds.libreoffice.org/daily/master/
> Thank you

let's close it as WFM. I checked it now in master