[Libreoffice-bugs] [Bug 74967] Allow rule for "no value (entered)" in conditional formatting

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=74967

--- Comment #6 from Regina Henschel <rb.henschel at t-online.de> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180308/732a32ee/attachment.html>