[Libreoffice-bugs] [Bug 99613] optional Paramaters for IF is optional

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #10 from Eike Rathke <erack at redhat.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201007/48d176a7/attachment.htm>