https://bugs.documentfoundation.org/show_bug.cgi?id=138393
Ming Hua <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|0 |1
Status|UNCONFIRMED |NEEDINFO
CC| |[email protected]
--- Comment #1 from Ming Hua <[email protected]> ---
(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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
