[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

--- Comment #12 from Eike Rathke <erack at redhat.com> ---
Just for explanation of the original description case:
=A1+STYLE(IF(OR(CURRENT() > 4, CURRENT() <3),"green","red"))
The first CURRENT() is the value of A1 pushed last onto the evaluation stack,
the second CURRENT() is the result of the comparison CURRENT() > 4 hence A1 > 4
which yields either 1 or 0 and as such is always <3 therefore the "green" style
is always applied.

As a general advice, do not use the STYLE() function but conditional formatting
instead.

-- 
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/20190226/b5dd2e55/attachment.html>