Convert color values

From The Document Foundation Wiki
Jump to navigation Jump to search
Other languages:
Deutsch • ‎English

Foreword

Color Value Conversion "Hexadecimal to Decimal" and "Decimal to Hexdecimal"

The video shows how to convert hexadecimal and decimal color values, under LibreOffice, and links to this page here, which provides more information.

This description refers to the version LibreOffice 7.0 under Windows 10.

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 7.0

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

Example conversion hexadecimal to decimal

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

Example conversion hexadecimal to decimal

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

Example conversion decimal to hexadecimal

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

Example conversion decimal to hexadecimal

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 Tools ▸ Protect Sheet…-

"Umrechnung Hex-Dez Dez-Hex.ods"

Documentation / Manuals

Here you will find the Documentation / Manuals:

Documentation / Manuals

Any questions?

For questions on this topic go to:

Ask.LibreOffice

Get Involved

Join us today and help us to make it even better!

Get Involved

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.

- To the top -