Bug 90962 - CONDITIONAL FORMATTING: Color gradient presets for color scales
Summary: CONDITIONAL FORMATTING: Color gradient presets for color scales
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Conditional-Formatting-Editing
  Show dependency treegraph
Reported: 2015-04-30 12:56 UTC by Yousuf Philips (jay) (retired)
Modified: 2019-12-20 23:18 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Conditional Formatting with Gradient Presets mockup (31.47 KB, image/png)
2015-04-30 12:56 UTC, Yousuf Philips (jay) (retired)

Note You need to log in before you can comment on or make changes to this bug.
Description Yousuf Philips (jay) (retired) 2015-04-30 12:56:02 UTC
Created attachment 115217 [details]
Conditional Formatting with Gradient Presets mockup

When setting color scale conditional formatting with 2 or 3 entries, it would be useful to have color gradient presets for users to choose from rather than having to select individual colors, similar to how we have presets for icon sets.

Example 3 Entries Presets:
Heat Gradient: Red, Orange 1, White
Traffic Sign Gradient: Red, Yellow, Green
Blue, White, Red (not sure the name for this one)

Example 2 Entries Presets:

There is also a large gradient list at http://colrd.com/gradient/
Comment 1 Yousuf Philips (jay) (retired) 2015-04-30 13:09:18 UTC
Setting NEW as ux-advise enhancement.
Comment 2 Heiko Tietze 2015-04-30 13:20:18 UTC
R has a lot of cool graphic features including colorRamp() https://stat.ethz.ch/R-manual/R-devel/library/grDevices/html/colorRamp.html 
The code should be available somewhere.
Comment 3 Yousuf Philips (jay) (retired) 2015-05-01 11:44:53 UTC
Excel has also implemented a few 3 and 2 entry color scale presets, but this feature is only available in its toolbar drop down [attachment 109790 [details]]:

Green, Yellow, Red
Red, Yellow, Green
Green, White, Red
Red, White, Green
Light Blue, White, Red
Red, White, Light Blue

White, Red
Red, White
Green, White
White, Green
Green, Yellow
Yellow, Green