https://bugs.documentfoundation.org/show_bug.cgi?id=74967
--- Comment #6 from Regina Henschel <[email protected]> ---
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:".
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
