Description: Conditional formating does not work to all cells that are merged into one cell Steps to Reproduce: 1. Merging 4 Cells into one: 2 horizontal and 2 vertical 2. adding Conditional Formating: 2.1 Condition 1: 2.1.1 Cell value is less or eqal to D4 2.1.2 Apply style "Good" 2.2 Condition 2: 2.2.1 Cell value is greater then D4 2.2.2 Apply style "Error" Actual Results: This Conditional formatting has only an influence to the formating of the upper two cells when changing the value in Cell D4. The lower to Cells stay in the format like before changing the value in D4 Expected Results: All 4 merged cells are formated as wantd by conditional formating Reproducible: Always User Profile Reset: Yes Additional Info: [Information automatically included from LibreOffice] Locale: de Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes
Created attachment 187555 [details] Demo to demonstrate
Created attachment 187563 [details] improve document Everything fine in Version: 7.5.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: ad085990b8073a122ac5222e5220f8f1d6826dcf CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded Al 4 cells are changing, but you have just one condition. This is the improved version of your file. See Format - Conditional - Manage in your file, and in my file.
Created attachment 187564 [details] screenshot This is how I see your file in both cases.
I see the issue with Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 20873f073ae4a9478f0a84355f779a2176bd2ec8 CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded But only a screen refresh problem, with a hard recalc or scrolling the cell out of the visible range, going back to them again the visualization it's fine.
This is an updated version of my wrong comment 2: everything fine with your file. Everything fine in Version: 7.5.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: ad085990b8073a122ac5222e5220f8f1d6826dcf CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
*** This bug has been marked as a duplicate of bug 131471 ***