<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:miguelangelrv@libreoffice.org" title="m.a.riosv <miguelangelrv@libreoffice.org>"> <span class="fn">m.a.riosv</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - the current() function is confused if used inside or()"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121105">bug 121105</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;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>REOPENED
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - the current() function is confused if used inside or()"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121105#c8">Comment # 8</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - the current() function is confused if used inside or()"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121105">bug 121105</a>
from <span class="vcard"><a class="email" href="mailto:miguelangelrv@libreoffice.org" title="m.a.riosv <miguelangelrv@libreoffice.org>"> <span class="fn">m.a.riosv</span></a>
</span></b>
<pre>=5+OR(3;CURRENT())=6
=5+OR(1;1)=5+1=6
=5+OR(0;CURRENT())=5
=5+OR(0;0)=5+0=5
=5+OR(CURRENT()<3)+CURRENT()=10
=5+ 0 + 5 =10
=5+OR(CURRENT()>3)+CURRENT()=12
=5+ 1ยด + 6 =12
CURRENT() takes the value inside the function, what looks fine at that step,
until the calculation of the function is finished.
At this time change their behavior it's not an option.
VLOOKUP with an inner array I think can do it.
=A1+STYLE(VLOOKUP(CURRENT();{0|"green";3|"red";4|"green"};2;1))
Change ; and | for your array row and column separator in
Menu/Tools/Options/LibreOffice calc/Formula
Please, if you are not agree reopen it again.</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>