Description: I am using conditional formatting in most of my files to highlight some value, like most negative ones, or bigger that, less than, quite simple conditions. However, Calc uses my formatting every day, and every day I need to correct it, it makes few mins lost every day. What calc does is it change style set in conditional formatting to ConditionalStyle_1 from "Bad", "Good" or "Error" which I set. It makes all cells looks the same, with no formatting. Steps to Reproduce: 1. set conditional formatting, use Bad, good or error formating 2.save and close 3. open file Actual Results: conditional formatting lost Expected Results: conditional formatting in place Reproducible: Always User Profile Reset: No Additional Info: Wersja: 6.2.2.2 (x64) Build ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d Wątki CPU: 4; OS:Windows 10.0; UI render:domyślny; VCL: win; Ustawienia regionalne: pl-PL (pl_PL); Język interfejsu: pl-PL Calc: threaded
Created attachment 150817 [details] sample file with problems sheet "Arkusz1" contains conditional formatting
I am using XLSX format to enable work on many devices; please find attached sample file, please look into sheet "Arkusz1" for conditional formatting
steps to reproduce with attached file: - Menu Format/Conditional/Manage... - select Z4:Z71 - set Condition1: style "Good" - set Condition2: style "Bad" - save & reload - Menu Format/Conditional/Manage... - select Z4:Z71 -> Condition1 changed: ConditionalStyle_3 -> Condition2 changed: ConditionalStyle_4
(In reply to tkurnatowski from comment #2) > I am using XLSX format to enable work on many devices; > please find attached sample file, please look into sheet "Arkusz1" for > conditional formatting saving with *.ods format seems to work
(In reply to Oliver Brinzing from comment #3) > steps to reproduce with attached file: > > - Menu Format/Conditional/Manage... > - select Z4:Z71 > - set Condition1: style "Good" > - set Condition2: style "Bad" > - save & reload > - Menu Format/Conditional/Manage... > - select Z4:Z71 > -> Condition1 changed: ConditionalStyle_3 > -> Condition2 changed: ConditionalStyle_4 This is not a bug, but a feature. Or: conceptual difference. Calc uses styles to conditionally format cells. Excel on the other hand uses direct cell formatting. On opening an XLSX file Calc takes the direct formatting of conditions and converts it to ConditionalStyle_N styles. And on saving it writes these implicit styles content as direct formatting to XLSX. So it is normal to see the style "Good" becoming "ConditionalStyle_3" - but that's only the name: the font color and background color is retained and works fine after opening in Excel too.