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: [email protected]
Reporter: [email protected]
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.
