Bug 155073

Summary:	Calc doesn't save pivot table compact layout to ODS file format
Product:	LibreOffice	Reporter:	Roman Kuznetsov <79045_79045>
Component:	Calc	Assignee:	Dennis Francis <dennisfrancis.in>
Status:	ASSIGNED ---
Severity:	normal	CC:	79045_79045, aron.budea, dennisfrancis.in, ilmari.lauhakangas, jluth, telesto
Priority:	medium
Version:	7.6.0.0 alpha0+
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=155089
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	103381
Attachments:	XLSX file example with the pivot table compact layout

Description Roman Kuznetsov 2023-04-28 22:19:32 UTC

Description:
Calc doesn't save pivot table compact layout to ODS file format.

After https://gerrit.libreoffice.org/c/core/+/151057 Calc supports pivot table compact layout mode in XLSX files. 
If you open XLSX file that already contains that pivot table compact layout then it works as expected and it works after resave the file to XLSX format. 
But if you will try to save the XLSX file with pivot table compact layout to ODS format, then after reloading the pivot table compact layout is disappeared.

Steps to Reproduce:
1. Open in Calc (please use latest daily build for it) XLSX file with pivot table compact layout
2. Save it to ODS format
3. Reload the document

Actual Results:
the pivot table compact layout is disappeared after saving to ODS

Expected Results:
the pivot table compact layout is still here and works as should after saving to ODS


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 2eb3922750b385dcadfd124d7baf686cec40eb5e
CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL threaded

Comment 1 Roman Kuznetsov 2023-04-28 22:20:03 UTC

Created attachment 186993 [details]
XLSX file example with the pivot table compact layout

Comment 2 Roman Kuznetsov 2023-04-28 22:27:36 UTC

Dennis, I'm not sure if you plan to work on this feature further, but I CC'ed you as author of the patch with implementation of the pivot table compact layout.

PS: I found that pivot table compact layout is still here in ODS, BUT only when you Update the pivot table after ODS opening

PPS: Dennis, I can't create the pivot table compact layout from scratch in Calc. It isn't implemented yet?

Comment 3 Buovjaga 2023-05-11 15:57:37 UTC

Reproduced

Arch Linux 64-bit, X11
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 1fdb056ef034109f330b79c85da39af44c3a8251
CPU threads: 8; OS: Linux 6.3; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 11 May 2023

Comment 4 Dennis Francis 2023-05-12 11:51:20 UTC

Thanks. I will take a look. On a first glance I see that the compact layout is still there when opening ods file but the expand/collapse buttons are missing.

It is possible to create pivot tables in Calc, but at the moment this is kind of hidden and tedious. While creating pivot table, The layout of each Row field member can be changed by double clicking on them and in the "Data Field" dialog, click on Options button, and in "Data Field Options" dialog the layout can be changed under "Display options".