Bug 157193

Summary:	CALC: Sorting changes made on a Pivot table won't save under .xlxs format
Product:	LibreOffice	Reporter:	Adrián L. <adrianlopezmg>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	miguelangelrv, stephane.guillou
Priority:	medium
Version:	4.4.0.3 release
Hardware:	x86-64 (AMD64)
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=157192
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Sample file saved with 7.6.1.2 reproduced bug guide

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 ***