Arch Linux

Olnex

Member

Registered: 2008-04-10

Posts: 89

I need a OOO calc formula calculates an integer from three RGB values

Hello, can anyone gives me a OOO calc formula that can calculates a GRID that contains three integer values from 0-255 into an integer and put it in another GRID?
For example

          1                    2                   3         4         5
1    255,255,255     0x00FFFFFF
2       0                  0x000000
3

because:
0x00FFFFFF = RGB(255,255,255)
it does not need to be of the HEX form 0x00XXXXXX, I just don't want to calculates the integer value.

If I put the three RGB values into three different grids, I can easily calculate by Grid1 * xxx + Grid2 * xx + Grid3, but I need to put them into one box, so the difficulty here is how to tokenize a text containing three integers separated by ,