Convert color values
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Foreword
The video "Farbwerte umrechnen in Calc – LibreOffice" shows how to convert hexadecimal and decimal color values, and links to this page here, which provides more information.
The Work file can be used immediately as a finished solution.
Link to the Video
Link to the Video (in German [DE]):
Farbwerte umrechnen in Calc – LibreOffice
Convert color code
The color code RGB values (Red, Green, Blue) are often given in hexadecimal or decimal.
The hexadecimal code is 6-digits, 2-digits each for Red, Green and Blue.
The decimal code is 3-digits each for Red, Green and Blue.
Calc offers the possibility to convert the given code, so to speak at once.
Here is a color table of LibreOffice, in which hexadecimal and decimal values are given:
Marketing Branding Color_Table
Convert color code from hexadecimal to decimal
To convert the hexadecimal code (6-digits) into decimal values, we first separate it into three 2-digits hexadecimal values according to the color values.
Then we convert the three 2-digits hexadecimal values into three 3-digits decimal values.
Unravel with the "MID" function
We do this with the MID(Text,Start,Number) function
- MID - returns a partial text string of a text string
- Text - Text (required); The text string in which partial words are to be determined
- Start - Start (required); The position from which the part word is to be determined
- Number - Number (required); The number of characters for the text string
Example
MID(D4;1;2).
- D4, there is the 6-digits hexadecimal code
- 1 indicates, start with Pos.1 left (Red)
- 2 indicates, use two digits
MID(D4,3,2)
- 3 indicates, start at pos.3 left (Green)
MID(D4,5,2)
- 5 indicates, start at pos.5 left (Blue)
Convert hex to dec with the "HEX2DEC" function
The hexadecimal values for the individual colors are now available.
They are converted to decimal values using the HEX2DEC(Number) function.
- HEX2DEC - converts hexadecimal to decimal
- Number - Number (required); The hexadecimal number to be converted (as text)
Example
HEX2DEC(E4)
- E4, there the 2-digits hexadecimal code for Red
HEX2DEC(F4)
- F4 indicates the 2-digits code for Green
HEX2DEC(G4)
- G4 indicates the 2-digits code for Blue
The values in fields E4, F4 and G4 are the result (decimal numbers of colors) of the conversion.
Convert color code from decimal to hexadecimal
To convert the three 3-digits decimal values into hexadecimal values, they are each converted using the DECINHEX function.
Then the three 2-digits hexadecimal values are combined to a 6-digits value.
Convert dec to hex with the "DEC2HEX" function
We do this with the function DEC2HEX(Number; Places)
- DEC2HEX - Converts a decimal number to a hexadecimal number
- Number - Number (required); The decimal integer to be converted
- Places - Places (optional) Number of places used
Example
DEC2HEX(E10;2)
- E10 - contains the 3-digits decimal value for Red
- 2 - indicates the number of places used
DEC2HEX(F10;2)
- F10 - contains the 3-digits decimal value for Green
DEC2HEX(G10;2)
- G10 - contains the 3-digits decimal value for Blue
Merging the three 2-digits hexadecimal values with "CONCAT" function
You do this with the function CONCAT(Text1; Text2; ...)
- CONCAT - Combines several text items into one, accepts cell ranges as arguments.
- Text1 - Text1 (required); text and/or cell ranges for the concatenation.
- Text2' - Text2 (optional); Text and/or cell ranges for the concatenation
Example
COCATENATE(E11;F11;G11)
- E11 - contains the hexadecimal value for Red
- F11 - contains the hexadecimal value for Green
- G11 - contains the hexadecimal value for Blue
Field D11 contains the result of the 6-digits hexadecimal code.
Further Informations
Work file
The table in the working file has been protected so that only the input fields can be accessed and changed after the file has been called.
The protection can be removed if necessary, no password is stored.
Table protect/unprotect in menu ▸ -
"Umrechnung Hex-Dez Dez-Hex.ods"
Documentation / Manuals
Here you will find the Documentation / Manuals:
Any questions?
For questions on this topic go to:
Get Involved
Join us today and help us to make it even better!
Donate
LibreOffice is Free Software and is made available free of charge.
Your donation, which is purely optional, supports our worldwide community.
If you like the software, please consider a Donation.