Created attachment 150843 [details]
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 184.108.40.206.alpha0+ (2e3b0c5d42d60d46cd9f8b8eda9424b095c63418), 220.127.116.11 / Windows 7.
Version: 18.104.22.168.alpha0+ (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
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.