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