<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Allow rule for "no value (entered)" in conditional formatting" href="https://bugs.documentfoundation.org/show_bug.cgi?id=74967#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Allow rule for "no value (entered)" in conditional formatting" href="https://bugs.documentfoundation.org/show_bug.cgi?id=74967">bug 74967</a> from <a class="email" href="mailto:rb.henschel@t-online.de" title="Regina Henschel <rb.henschel@t-online.de>"> Regina Henschel</a> <pre>Set cell cursor on Cell A1. Define condition as: Condition type "Formula is" with formula "AND(A1=0;NOT(ISBLANK(A1)))" or with formula "IF(ISBLANK(A1);FALSE();A1=0)" on range "A1:A7". Because the address A1 is relative it adapts for the other cells of the range to e.g "AND(A7=0;NOT(ISBLANK(A7)))" for cell A7. Unfortunately the ODF part 2 has in section "6.3.5 Conversion to Number" the rule: "If the expected type is Number, then if value is of type Reference ... If the cell is empty (blank), use 0 (zero) as the value. ..." The comparison with operator = and one value 0 expects a number from the reference A1. So getting "A1=0 return false for an empty cell A1" seems only possible, if not using namespace "of:".</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>