https://bugs.documentfoundation.org/show_bug.cgi?id=121105
--- Comment #12 from Eike Rathke <[email protected]> ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
