https://bugs.documentfoundation.org/show_bug.cgi?id=111675
TBeholder <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #7 from TBeholder <[email protected]> ---
Same here, in Version: 5.4.1.2
----
=0+IFS( […],CURRENT(),[…],CURRENT(),[…],CURRENT(),
CURRENT()=1,"[yes!]",[…],CURRENT())
----
shows 1 no matter how the pairs are shuffled, unless you put "CURRENT()=1"
first, in which case it's "Err:518"
Conditions using CURRENT() don't work properly... and if the comparison gets to
the pair
----
…CURRENT()>2,CURRENT()&">2"…
----
it returns "1>2", so it changes.
IFS tries to return TRUE unless some type is given to it:
----
=IFS(0=0,CURRENT(), […]
----
Thus most likely CURRENT() is set to TRUE (which turns into 1 if used in a
number type formula) when the condition is met.
Inside the chosen branch it resets (!):
----
="before"&IFS(0=0,CURRENT()&"z", […]
="before"&IFS(0=0,"z"&CURRENT(), […]
----
the former returns "before1z", the latter "beforezz".
Also, if no condition is met, the returned default value is "N/A"? Not sure
it's a good idea.
Condition "ISNA(CURRENT())" doesn't catch anything either, BTW.
--
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
