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

--- Comment #10 from Eike Rathke <[email protected]> ---
Note that in IF(A1;;"something") the second argument *is* given, but given as
empty argument. An empty argument usually evaluates to 0.

Do not confuse absent (trailing optional argument omitted) and empty null
arguments.

See also ODFF 6.15.4 IF
https://docs.oasis-open.org/office/OpenDocument/v1.3/cs01/part4-formula/OpenDocument-v1.3-cs01-part4-formula.html#IF

-- 
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

Reply via email to