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)?