<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - CONDITIONAL FORMATTING: Icon set should have a color reverse switch"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=61313#c6">Comment # 6</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - CONDITIONAL FORMATTING: Icon set should have a color reverse switch"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=61313">bug 61313</a>
from <span class="vcard"><a class="email" href="mailto:gerry.treppel@googlemail.com" title="Gerry <gerry.treppel@googlemail.com>"> <span class="fn">Gerry</span></a>
</span></b>
<pre>@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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>