Bug 61313 - CONDITIONAL FORMATTING: Icon set should have a color reverse switch
Summary: CONDITIONAL FORMATTING: Icon set should have a color reverse switch
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
QA Contact:
Keywords: difficultyInteresting, easyHack, skillCpp, skillUI
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
Reported: 2013-02-22 21:42 UTC by Horst
Modified: 2017-05-13 17:38 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Horst 2013-02-22 21:42:56 UTC
The new Icon Set should have a switch for color reversal (like Excel). Small values are not always bad (red) and big values are not always good (green).

An alternative would be also an "Icon Set 2 invers colors".
Comment 1 Markus Mohrhard 2013-03-25 08:45:06 UTC
Additionally there should be a way to change each icon but I have no plans to implement that in the near future.
Comment 2 Gerry 2013-11-26 10:11:49 UTC
I second this enhancement request. However, maybe it can be solved easier:

Instead of switching the order of icon sets, why not just switching the signs. It should be possible to select:

"<=" instead of ">=" 

Then, the problem is solved. I assume this is easier to implement?!?
Comment 3 Markus Mohrhard 2017-04-08 18:56:24 UTC
This has been implemented for a long time. The options are just not exposed in the UI.
Comment 4 Markus Mohrhard 2017-04-08 22:48:46 UTC
The remaining part that needs implementation for this feature is to introduce advanced configuration solutions for the icon set entry in the conditional format dialog.

The code for the icon set entry in the dialog is in sc/source/ui/condformatdlg

The code for the icon set model part, including the reverse flag, the configuration that allows any image for an icon can be found in sc/inc/colorscale.hxx and sc/source/core/data/colorscale.cxx