Description: When I create a pivot table in LO Calc, apply conditional formatting to the pivot table, save it as .xlsc, close the file and then re-open it, the conditional formatting is not retained. Steps to Reproduce: 1.Create a pivot table and apply conditional formatting. 2.Save as .xlsx and close file. 3.Reopen file. Actual Results: Conditional formatting applied before save is gone. Expected Results: Conditional formatting should have been saved. I have been sending this file to others and did not realize the conditional formatting wasn't showing up. Reproducible: Always User Profile Reset: No Additional Info: That's all.
* Save as .xlsx, not xlsc.
I can confirm with Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: f3a82a8ba51195cf31b0f78164735acc7ebbcd2f CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded works in Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
This seems to have begun at the below commit. Adding Cc: to Vasily Melenchuk; Could you possibly take a look at this one? Thanks 645daf9a7c0478dee0ff5df5eba3ae78e571a2a6 is the first bad commit commit 645daf9a7c0478dee0ff5df5eba3ae78e571a2a6 Author: Jenkins Build User <tdf@pollux.tdf> Date: Thu Nov 29 02:24:41 2018 +0100 source 6481bda69ade61cb5420156272fcf17edd43d620 https://git.libreoffice.org/core/+/6481bda69ade61cb5420156272fcf17edd43d620
Hm. Looks like an import issue revealed by that mine commit: * MS Excel does open resulting xlsx file correctly unlike LO * Even reverting of potentially problematic commit 6481bda69ade61cb5420156272fcf17edd43d620 does not resolve the issue I'll try to dig xlsx import
raal, are you sure in bibisect results? My current attempts to repro this problem do show that Calc is not able to candle conditional formatting in pivot tables at all since at least 5.4 (i think since never, but I did not check it).
Created attachment 187042 [details] Example file with Pivot table and CF applied on it
Created attachment 187043 [details] XLSX versions of the example file opened in LO 6.1.0 When the example file is saved as xlsx in 6.1 and 7.6, and opened in 6.1 the CF is not visible with the one made by 7.6. So the roundtrip was indeed good before the bibisected change in 6.3.
Created attachment 187044 [details] XLSX versions of the example file opened in LO 7.6 master If the same files are reloaded in current master the CF is not visible in case the 7.6-saved file, but works with the 6.1-made one.
Created attachment 187046 [details] XLSX versions of the example file opened in Excel 13 Interestingly Excel 13 can read both xlsx files well.
Created attachment 187047 [details] The 6.1-saved xlsx version of the example file
Created attachment 187048 [details] The 7.6-master saved xlsx version of the example file Made with the fresh nightly: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: fb3a6b82b55a298eabf8f431f1451dc826642acd CPU threads: 14; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (hu_HU); UI: en-US Calc: threaded I also can confirm the bibisect points to the correct change.
Reproduced in recent trunk build: Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 8705cfecd5a10f817d3a2a02041d85e77282aa30 CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: CL threaded
Glad you looked into this grave & long standing bug, was expecting release 24.08 to test it as claimed to be fixed. https://wiki.documentfoundation.org/ReleaseNotes/24.8 As said in my initial bug report(126557, considered as duplicate of this one), I do suspect, that there is a call to a CONSTRUCTOR(so a fresh formatting) instead of a call to implementing a refresh function(keeps formatting, but refresh VALUES)?
Created attachment 199625 [details] This bug seems to be a duplicate of the bug 41645 This bug seems to be a duplicate of the bug 41645 because after refreshing the pivot table, described conditional formatting also disappears. Comment 0 behavior confirmed in: Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 36a6bf8bd65e2ece92a4354e9f6d8e47e0f03d84 CPU threads: 8; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: pl-PL (pl_PL); UI: en-US Calc: CL threaded
*** This bug has been marked as a duplicate of bug 41645 ***
Created attachment 199629 [details] LO spoils file at save as XLSX with formatted pivot table When saving a file with a formatted pivot table (e.g. attachment 199627 [details]) in LO, all the arrangements in the pivot table are present. But they disappear when the file is reloaded. Is this still a different problem than in the bug 41645? Now I'm leaving it as resolved. Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 36a6bf8bd65e2ece92a4354e9f6d8e47e0f03d84 CPU threads: 8; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: pl-PL (pl_PL); UI: en-US Calc: CL threaded /daily/master/Win-x86_64@tb77-TDF/2025-03-05_02.28.37/
Created attachment 199630 [details] Excel log (LO xlsx) Log created by: Microsoft® Excel® dla Microsoft 365 MSO (wersja 2501 kompilacji 16.0.18429.20132) 64-bitowa It comes from the ODS file: attachment 199626 [details] that was saved as XLXS by: Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 36a6bf8bd65e2ece92a4354e9f6d8e47e0f03d84 CPU threads: 8; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: pl-PL (pl_PL); UI: en-US Calc: CL threaded also occurs with: Version: 25.2.0.2 (X86_64) / LibreOffice Community Build ID: 62af784cc06624122f17ee71c7cf13d906cbaed0 CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win Locale: pl-PL (pl_PL); UI: en-US Calc: CL threaded