<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:michaelof@rocketmail.com" title="Michael <michaelof@rocketmail.com>"> <span class="fn">Michael</span></a>
</span> changed
<a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - 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;">Status</td>
<td>CLOSED
</td>
<td>REOPENED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>NOTABUG
</td>
<td>---
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - UI: Functions IFS does not work together with function CURRENT"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111675#c9">Comment # 9</a>
on <a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - 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:michaelof@rocketmail.com" title="Michael <michaelof@rocketmail.com>"> <span class="fn">Michael</span></a>
</span></b>
<pre>(In reply to Eike Rathke from <a href="show_bug.cgi?id=111675#c8">comment #8</a>)
<span class="quote">> IFS() evaluates conditions until it finds a matching one,
> sprinkling CURRENT() all over makes it depend on internal behaviour what
> arguments will be evaluated first, which currently may be all before IFS()
> is called and in future may be only the ones until one is matched.
> </span >
As I opened this bug, I would be thankful if this bug is not going to be closed
because someone else's examples or additions might be misleading or independent
of my bug.
If you look on my example attached
(<a href="https://bugs.documentfoundation.org/attachment.cgi?id=135441">https://bugs.documentfoundation.org/attachment.cgi?id=135441</a>), the IFS formula
in B5 is:
=B2+STYLE(IFS(CURRENT()<B3;"Grün";CURRENT()=B3;"Gelb";CURRENT()>B3;"Rot"))
And my question is: For B3 constantly being e.g. "4", how could a value of "4"
for B2 lead to the condition "CURRENT()>B3" being selected by IFS() ???
--> As ONLY the condition "CURRENT()=B3" is applicable, IMHO it does not have
any impact if IFS() evaluates sub-formulas from left to right, or vice versa.
In the attached example LO shows a value of "4" for B5, so for whatever reason
CURRENT might return any other value than "4", and as B3 is also "4", how could
ever the condition "CURRENT()>B3" evaluated as true ??</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>