-
Bug
-
Resolution: Fixed
-
Normal
-
3.9.1
-
Security Level: Jimmy
Steps to Reproduce
run the attached file
Current Result
the cells A6 B6 are incorrectly styled with their conditional styling even though the match-formula referencing a non existing sheet fails to evaluate
Expected Result
the conditional styles should not apply in case of formula errors
Debug Info
This only happens with negative operators
"Not Equal", "Not Contains", "Greater Than Or Equal", "Less Than Or Equal"
Root Cause
the negation is applied after the formula evaluation - negating also errors results into "true" leading to styles being applied in case of errors
- relates to
-
ZSS-1335 NPE when evaluating Conditional formattings
- Closed