https://bugs.documentfoundation.org/show_bug.cgi?id=150961
Bug ID: 150961
Summary: Pivot table sorting option is gone after resaving in
LO in xlsx format
Product: LibreOffice
Version: 7.4.0.3 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: thomasji...@geotab.com
Description:
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.
Actual Results:
The pivot table sorting option that was setup in Office Excel is gone after the
file is resaved by LO, following the above steps.
Expected Results:
We expect that LO calc can save the sorting option in pivot table even when it
saves the file in xlsx file format.
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Version: 7.4.0.3 / 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
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
