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