Bug 124813 - Pivot table changes structure when saved as XLS and refreshed in Excel
Summary: Pivot table changes structure when saved as XLS and refreshed in Excel
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: filter:xls
Depends on:
Blocks: Pivot-Table-XLS
  Show dependency treegraph
Reported: 2019-04-18 06:20 UTC by Aron Budea
Modified: 2019-04-22 13:29 UTC (History)
0 users

See Also:
Crash report or crash signature:

Comparison screenshot (65.27 KB, image/png)
2019-04-18 06:20 UTC, Aron Budea
Sample with "different" pivot tables (27.00 KB, application/vnd.ms-excel)
2019-04-22 13:28 UTC, Aron Budea

Note You need to log in before you can comment on or make changes to this bug.
Description Aron Budea 2019-04-18 06:20:36 UTC
Created attachment 150843 [details]
Comparison screenshot

Pivot table changes structure when saved as XLS and refreshed in Excel

- Open Calc-created attachment 149245 [details] (ODS from bug 123421) and save it as XLS,
- Open in Excel, right-click table and choose Refresh.

=> The structure of the pivot table becomes incorrect (see attached screenshot).

Observed using LO (2e3b0c5d42d60d46cd9f8b8eda9424b095c63418), / Windows 7.
Comment 1 Roman Kuznetsov 2019-04-20 19:40:10 UTC
confirm in

Version: (x64)
Build ID: 2e3b0c5d42d60d46cd9f8b8eda9424b095c63418
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-04-14_00:37:08
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded
Comment 2 Aron Budea 2019-04-22 13:28:27 UTC
Created attachment 150917 [details]
Sample with "different" pivot tables

Hm, seems like even Excel isn't so firm about the structure itself.
This attached XLS is based on bug 108343's sample XLSX from Excel, saved as XLS (in Excel), and another pivot table added based on the same source sheet.
Sheet2 contains the pivot table added in XLSX format, Sheet3 contains the pivot table added in XLS format. Disregarding the fact that they look quite different even though both added in Excel, the one added in XLS format looks the same as the original Calc-created table when saved as XLS refreshed in Excel.

Closing as NOTABUG.