https://bugs.documentfoundation.org/show_bug.cgi?id=148484
Bug ID: 148484 Summary: Conditional FORMATTING works in one range, but not in another Product: LibreOffice Version: 7.3.2.2 release Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: 5rjvh...@posteo.de Description: I have a spreadsheet (vacation calendar) with many conditional formatting rules, some of them with overlapping ranges. A certain rule works for a certain range, but the same rule doesn't work for a different range. In the attached document (Ferien2022.ods), go to Sheet "Jahresplan", and open "Format > Conditional > Manage". * Works: Range C4:C34, Formula is "C4>D4+E4", Apply style "Bad" * Doesn't work: H4:H34, Formula is "H4>I4+J4", Apply style "Bad" Steps to Reproduce: 1. Check that * C6 = "1" * D6 and E6 are empty * C6 is highlighted red 2. Enter "1" in D6 or E6. => C6 highlighting disappears, as expected. 3. Enter "1" in H4. => H4 is highlighted red, as expected. 4. Enter "1" in I4 or J4. => H6 is still highlighted red. This is _not_ expected, since the result of the formula "H4>I4+J4" is now FALSE. Actual Results: H6 is highlighted, although the formula of the conditional formatting rule evaluates to FALSE. Expected Results: H6 is not highlighted. Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: N/A -- You are receiving this mail because: You are the assignee for the bug.