https://bugs.documentfoundation.org/show_bug.cgi?id=168178
Bug ID: 168178
Summary: Calc not save pivot table order saving xlsx, odt and
xls works
Product: LibreOffice
Version: 25.2.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
After creating a pivot table in Calc, I usually modify the order with the pivot
dialogs.
When I save the file in xlsx, with the order chosen, Calc lost the column
order.
Re-opening the file just saved in xlsx, the order:
- apparently it's lost, but
- opening the "Data Option" in Pivot dialogs, the order is set to "Manual" with
the order set to the first column of the Pivot, but I don't set it to Manual
neither to the first column.
I attach the test files saved
Steps to Reproduce:
1. Crete new Calc file
2. Add some dummy data
3. Create a Pivot from that data, modifying the order setting, for example, to
the 2'nd column
4. Save the file in .xlsx format and close it
5. Re-open the file, the order is lost
Actual Results:
LibO lost the order in Pivot table
Expected Results:
LibO have to respect the order in Pivot table and/or load correctly the file
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 25.2.1.2 (X86_64) / LibreOffice Community
Build ID: d3abf4aee5fd705e4a92bba33a32f40bc4e56f49
CPU threads: 8; OS: Linux 6.14; UI render: default; VCL: kf5 (cairo+wayland)
Locale: it-IT (it_IT.UTF-8); UI: it-IT
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
