https://bugs.documentfoundation.org/show_bug.cgi?id=121105
m.a.riosv <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|REOPENED |RESOLVED
--- Comment #8 from m.a.riosv <[email protected]> ---
=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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
