Bug 157193 - CALC: Sorting changes made on a Pivot table won't save under .xlxs format
Summary: CALC: Sorting changes made on a Pivot table won't save under .xlxs format
Status: RESOLVED DUPLICATE of bug 150961
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.0.3 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-09-11 17:30 UTC by Adrián L.
Modified: 2023-09-25 20:39 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Sample file saved with 7.6.1.2 (10.46 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2023-09-11 19:08 UTC, m_a_riosv 		Details
reproduced bug guide (106.10 KB, application/vnd.oasis.opendocument.text)
2023-09-15 11:19 UTC, Adrián L. 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Adrián L. 2023-09-11 17:30:13 UTC 
Description:
Once a Pivot table is created, any arrangment made on either row or column fields won't ramain later if the spreadsheet is saved under the Microsoft format .xlxs 

Steps to Reproduce:
1.Generate a Pivot table.
2.Use sort funtions/tools to arrange either rows or columns within the Pivot table area.
3.Save and create a new file as .xlxs 
4.Open the new file.

Actual Results:
Pivot table got rearranged by default as it was generated. It won't save any changes made.

Expected Results:
Every change should remain after loading the file.


Reproducible: Always


User Profile Reset: No

Additional Info:
Bug is not present when the spreadsheet is saved as .ods
Comment 1 m_a_riosv 2023-09-11 19:08:27 UTC 
Created attachment 189503 [details]
Sample file saved with 7.6.1.2

Works for me with
Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 8740a1db21298be2dc81a8388a2df3aa8451531c
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Jumbo
Version: 7.6.1.2 (X86_64) / LibreOffice Community
Build ID: f5defcebd022c5bc36bbb79be232cb6926d8f674
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: default; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Comment 2 Adrián L. 2023-09-15 10:35:44 UTC 
Delaying news until new version is released. Bug still remains for me.
Comment 3 Adrián L. 2023-09-15 11:19:46 UTC 
Created attachment 189605 [details]
reproduced bug guide
Comment 4 Stéphane Guillou (stragu) 2023-09-25 20:39:27 UTC 
Thank you both.

Reproduced as described in attachment 189605 [details]. Here it is for easier access:

0. Open attachment 189503 [details]
1. Open Pivot Table properties by right clicking on any cells inside it > Properties; double-click the ‘a’ field inside the ‘row fields’ box.
2. Click on "Options"
3. Pick "Descending" in the "sort by" options (keep in mind some versions might have bug 157192)
4. Pick "Sum -c" as data field to sort.
5. Press OK on all dialogs

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 19e9fe7c8c89399753ac1730e1c76378b18418bc
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Testing with the linux-64-releases bibisect repo, I can reproduce in libreoffice-4.4.0.3 but not in libreoffice-4.3.0.3, so I am assuming it is the same issue as bug 150961 and marking as duplicate.

*** This bug has been marked as a duplicate of bug 150961 ***