https://bugs.documentfoundation.org/show_bug.cgi?id=124710
--- Comment #5 from Eike Rathke <[email protected]> ---
Seems to be an error in error propagation..
Same with
=IFS( OR(I9="pago",I9="reci"), NA(), AND(I9="tran",E9>0),"FT from",
AND(I9="tran",E9<0), "FT to", 1, "no idea")
but not with
=IFS( 0, NA(), 0,"FT from", 0, "FT to", 1, "no idea")
where the result is "no idea".
Also
=IFS( OR(I9="pago",I9="reci"), NA(), 0,"FT from", 1, "no idea")
produces the expected result, but not
=IFS( OR(I9="pago",I9="reci"), NA(), 0+0,"FT from", 1, "no idea")
and also not
=IFS( OR(I9="pago",I9="reci"), NA(), 0,"FT from", 1+0, "no idea")
So whenever an expression is to be evaluated for the condition after a not to
be returned error result was encountered.
--
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
