[Libreoffice-bugs] [Bug 115334] variant Icon set in Conditional formatting cant be setup

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Feb 25 16:12:06 UTC 2018


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

--- Comment #4 from Markus Mohrhard <markus.mohrhard at googlemail.com> ---
(In reply to Eric from comment #3)
> One field there is not a box to type into but also look at the logic of the
> arrows, its not mutually exclusive as it should be (see the image i attached
> in my original post) They are using >= and <= instead of >, =, <

They are exclusive in the sense that first the >= condition for green is
evaluated, then the >= for yellow and if none of the two matches the last
condition (red) is taken. The equivalent pseudo code would be:

if (val >= green_limit)
    set(green)
else if (val >= yellow_limit(
    set(yellow)
else
    set(red)


Your proposal is unable to handle more than 3 conditions and does not allow to
set a range for the middle condition.

-- 
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/20180225/af7ed65f/attachment.html>


More information about the Libreoffice-bugs mailing list