The pivot table sorting option that was setup in Office Excel is gone after the file is resaved by LO.
Steps to Reproduce:
1. Create a spreadsheet in Office Excel, and create a pivot table.
2. In the pivot table, set one of the row to be sort by desc, and only show top 5 items. Save the Excel file in Office Excel in the format of xlsx.
3. Open the file in LO calc, save it in xlsx format, and close LO calc.
4. Reopen the file using LO calc, one will find that the sorting option/show top option is gone.
The pivot table sorting option that was setup in Office Excel is gone after the file is resaved by LO, following the above steps.
We expect that LO calc can save the sorting option in pivot table even when it saves the file in xlsx file format.
User Profile Reset: Yes
OpenGL enabled: Yes
Version: 184.108.40.206 / LibreOffice Community
Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a
CPU threads: 32; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: en-CA (en_CA.UTF-8); UI: en-US
Created attachment 182448 [details]
The xlsx file with pivot table option created by Office Excel
Created attachment 182449 [details]
The xlsx file resaved using LO
In this file, even though in the pivot table is still there, but sorting option is gone.
I confirm with the file attached, however I'm unable to re-create such a pivot table from scratch with LibreOffice or MSO Excel Online.
It might be Office 2013 specific..
Telesto, which Office Excel version are you using?
(In reply to Thomas Jiang from comment #4)
> Telesto, which Office Excel version are you using?
Created attachment 182500 [details]
The xlsx file with pivot table option created by Office Excel 365
We created the same pivot table using Office 365, and we can confirm the same issue. Use he attached xlsx by Office Excel 365 as reference.
Confirm with Version: 220.127.116.11.alpha0+ / LibreOffice Community
Build ID: e46f9cc4b506c325cbe1060777bbc81fd1630f49
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
but not in Version 18.104.22.168.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
This seems to have begun at the below commit.
61c7a88e60ab9d5079194c16bc0dec0772f9f76d is the first bad commit
Author: Matthew Francis <firstname.lastname@example.org>
Date: Sun Mar 15 01:59:58 2015 +0800
Author: Kohei Yoshida <email@example.com>
AuthorDate: Fri Aug 22 22:57:05 2014 -0400
Commit: Kohei Yoshida <firstname.lastname@example.org>
CommitDate: Thu Aug 28 21:37:08 2014 -0400
bnc#822173: Initial work on exporting pivot cache and pivot table to xlsx.