[Libreoffice-bugs] [Bug 138393] Calc automatically evaluates arguments of if() function

[bugzilla-daemon at bugs.documentfoundation.org]

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

Ming Hua <ming.v.hua at qq.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEEDINFO
                 CC|                            |ming.v.hua at qq.com

--- Comment #1 from Ming Hua <ming.v.hua at qq.com> ---
(In reply to libreoffice from comment #0)
> The if() function evaluates all its arguments, regardless of the value of
> the first argument.
Are you sure?

A simple test with formula "=IF(0, 1/0, "Good")" shows that the "1/0" argument
is not evaluated, otherwise it would give a "#DIV/0!" error.  Also from my
understanding (see bug 111675) Calc's IF() shortcuts the evaluation of
arguments, but IFS() doesn't.

So if IF() function is evaluating both second and third argument for you,
please provide a sample document for testing.

-- 
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/20201121/f6c83f99/attachment.htm>