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
Created attachment 186993 [details] XLSX file example with the pivot table compact layout
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?
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
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".