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.
Conditional formatting applied before save is gone.
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.
User Profile Reset: No
* Save as .xlsx, not xlsc.
I can confirm with Version: 184.108.40.206.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
works in Version 220.127.116.11.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?
645daf9a7c0478dee0ff5df5eba3ae78e571a2a6 is the first bad commit
Author: Jenkins Build User <firstname.lastname@example.org>
Date: Thu Nov 29 02:24:41 2018 +0100
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: 18.104.22.168.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
I also can confirm the bibisect points to the correct change.