Escala de colores (Colors Scale)


Warning message

This extension was not updated recently. It might not work with latest versions of OpenOffice.

Primary tabs

TOKONHU de México

Average: 3.7 (6 votes)

calc, extension, Español, extension, Mexico, extension, TOKONHU, extension, emoreno, extension, colors, extension
Post date:
Monday, 4 January, 2010 - 11:56
Week: Not tracked - Month: Not tracked - Year: Not tracked - Timeline
Download extension
System Independent version - All releases
Compatible with OpenOffice 4: Unknown
User feedback:
Compatible with OpenOffice 4.x?

[En] Assign colors to the cells depending on the value and scale generated by the maximum and minimum.
Add submenú Color Scale... in menu Data.
New interface with new controls. 2.0.1 version correct presentation in Linux.

[Es] Asigna colores a las celdas dependiendo del valor y la escala generada por el máximo y mínimo.
Agrega el submenú Escala de colores... en el menú Datos.
Nueva interfaz con nuevos controles. La versión 2.0.1 corrige la presentación en Linux.

Escala de colores (Colors Scale)

Version Operating system Compatibility Release date
2.0.1 System Independent 3.4 03/03/2010 - 11:59 More information Download
2.0.0-Stable System Independent 3.4 01/03/2010 - 11:45 More information Download
1.0.0 System Independent 3.4 04/01/2010 - 12:01 More information Download


Nice funtion but I have a comment, I just use it on a column with text values and the funtion breaks.

i have made an evolution for my own usage ,

test and participate before an official version


nice idea, two suggestions though:
- put the menu item in Tools > Addons
- make the colors customizable, e.g. by providing 3 fields for the user to choose the color instead of the 8 hardcoded options

No add in Tools>Addons becouse if all my extensión add in this menu, the menu will be unoperable.

I think use a selector to the colors but if the user select two similar colors (Example: RGB(0,0,255) and RGB(0,0254)) the control of error are very complicated. Maybe do.

Eduardo Moreno
TOKONHU de México

i think custom color scales would be a great improvement for your extension.

think about it.

While it might be true that Tools>Addons could be flooded if you install a huge number of extensions I doubt that any user will have more than 20 extensions placing their items there. And even with a large number of items in that menu it's a lot easier to find extensions there than being required to scan every menu for the place of one extensions menu item (don't expect me to remember that extension A placed itself in Edit, B in Insert, C in Data, ...). Extension menu items being spread all over the place is totally confusing, they should be in one common place.