[Libreoffice-bugs] [Bug 61313] CONDITIONAL FORMATTING: Icon set should have a color reverse switch

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from Gerry <gerry.treppel at googlemail.com> ---
@abstatic: That's great to hear that you want to work on this bug. When I use
icon sets in conditional formatting, I frequently need to use workarounds,
because Calc is lacking the feature to reverse the color or icons.

I illustrate the issue with an example using the icon set "3 smileys":
The issue is that both, the order of the smileys :-) :-| :-( AND the order of
the sign >= are hard coded. In other words, at the moment, Calc always assigns
a :-( to high values. This does not always make sense. 

For example, if you imagine an exam with 100 points. You fail if you have < 50
points, you pass if you have >= 50 points and you get an excellent grade if you
have => 75 points. 

What Calc can do (this is wrong!):

Grades (100 points in exam is very good, 0 points is very bad)
100 :-(
95 :-(
30 :-)
22 :-)
55 :-|

What Calc should be able to do (this is correct!):

Grades (100 points in exam is very good, 0 points is very bad)
100 :-)
95 :-)
30 :-(
22 :-(
55 :-|

What we need is that the order can be inversed. IMHO, it should be possible for
the user to switch the sign >= to <= if the scale is inverse. Currently, in the
dialog, the sign >= is hard coded and cannot be changed by the user. 

Please see the attached screnshot "Smiley dialog example" to illustrate that I
cannot change the order. Instead of an >= I need an <= for my scale of exam
points.

-- 
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/1294002f/attachment-0001.html>