Return a numeric value calculated by a combination of three colors (red, green and blue) and the alpha channel, in the RGBA color system. The result depends on the color system used by your computer.


COLOR(Red; Green; Blue [; Alpha])

Red, Green and Blue – required arguments. The value for the red, green and blue components of the color. The values must be between 0 and 255. Zero means no color component and 255 means full color component.

Alpha – optional argument. The value for the alpha channel or alpha composite. Alpha is a integer value between 0 and 255. The value of zero for alpha means the color is fully transparent, whereas a value of 255 in the alpha channel gives a fully opaque color.


COLOR(255;255;255;1) returns 33554431

COLOR(0;0;255;0) returns 255

COLOR(0;0;255;255) returns 4278190335

COLOR(0;0;400;0) returns Err:502 (Invalid argument) because the blue value is greater than 255.

Technical information


Tuta funkcija je wot LibreOffice 4.4 k dispoziciji.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is


Prošu podpěrajće nas!