[Libreoffice-bugs] [Bug 111675] UI: Functions IFS does not work together with function CURRENT

[bugzilla-daemon at bugs.documentfoundation.org]

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

TBeholder <turbobeholder at mail.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |turbobeholder at mail.ru

--- Comment #7 from TBeholder <turbobeholder at mail.ru> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171102/ecf192d6/attachment.html>