<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:turbobeholder@mail.ru" title="TBeholder <turbobeholder@mail.ru>"> <span class="fn">TBeholder</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - UI: Functions IFS does not work together with function CURRENT"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111675">bug 111675</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>turbobeholder@mail.ru
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - UI: Functions IFS does not work together with function CURRENT"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111675#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - UI: Functions IFS does not work together with function CURRENT"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111675">bug 111675</a>
from <span class="vcard"><a class="email" href="mailto:turbobeholder@mail.ru" title="TBeholder <turbobeholder@mail.ru>"> <span class="fn">TBeholder</span></a>
</span></b>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>