[Libreoffice-bugs] [Bug 121105] the current() function is confused if used inside or()

[bugzilla-daemon at bugs.documentfoundation.org]

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

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|REOPENED                    |RESOLVED

--- Comment #8 from m.a.riosv <miguelangelrv at libreoffice.org> ---
=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.

-- 
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/20181102/0843d942/attachment.html>