Description: Condition formating based on formula does not autorefresh in this case. Steps to Reproduce: 1.Open sample spreadsheet; 2.Change value in B8 cell. Actual Results: You need to manually refresh column B formatting by: scroll or PgDn&PgUp or RecalculateHard Expected Results: Autorefresh like in column C Reproducible: Always User Profile Reset: No Additional Info: Similar to 2nd issue from https://ask.libreoffice.org/t/two-conditional-formatting-bugs-in-calc-anything-with-existing-formatting-overrides-conditional-formatting-and-does-not-update-in-realtime/53753 Version: 24.2.5.2 (X86_64) / LibreOffice Community Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59 CPU threads: 6; OS: Windows 10.0 Build 22000; UI render: Skia/Vulkan; VCL: win Locale: pl-PL (pl_PL); UI: en-US Calc: CL threaded
Created attachment 196004 [details] Spreadsheet picturing no autorefresh conditional formatting
The condition is always false. A way is to verify the formula in the spreadsheet. In this case it's easy, copy CF formula in B1 and drag down. If I understand what is looking for, a more simple formula like: INDEX(B:B;MATCH("X";$A:$A;0))="YES" works just fine for me. Don't forget to verify the option: Menu/Tools/LibreOffice Calc/Calculate — Case sensitive.
(In reply to m_a_riosv from comment #2) > The condition is always false. I don't understand what you mean. If I change cell B8 to "YES", then the condition results in FALSE, so the CF should react and change the background color of B1:B7. But, in order to actually see the change, you have to scroll that range out of the screen and scroll back to it, which is what the OP reported in comment 0. It is true that the formula in the CF for cells B1:B7 seems over-complicated, but that is not the point. The point is that the screen is not immediately refreshed with the CF result. One detail: if the cells B1:B7 contain the formula (from the CF dialog) =INDIRECT(ADDRESS(ROW()+MATCH("X";INDIRECT(ADDRESS(ROW();1;4)&":"&ADDRESS(ROW()+16;1;4));0)-1;COLUMN();2;1))="NO" then the reaction on screen is immediately seen as soon as cell B8 is changed from NO to YES; there is no need to scroll in such case.