RGB values in Calc
In a LibreOffice Calc sheet I have entered manually some numbers (RGB values), each value in a different cell, horizontally.
What I need is: What formula should I type/use in order to get an actual colored cell with the RGB values type in the previous cells?
Thank you! C:\fakepath\rgb-cells.ods
From my point of view there is no such formula and you even cannot write your own function (!!!) to achieve your goal, since as far as I understand functions are not allowed to change the sheet from where they are called (see also answer from Andrew at https://stackoverflow.com/questions/12089051/changing-cell-background-color-in-libreoffice)
Thank you @Opaque. I also found a topic after posting my question, but I do not know where and how to put the code suggested by arindam in this topic I mentioned: https://ask.libreoffice.org/en/questi...
Hello - check out for
Tools -> Macros -> Edit Macros- that's the place, where these subroutines (and functions) go to and afterwards you may assign it to some toolbar or you create a simple button within your sheet.For a long time now the restrictions concerning side-effects of user functions were weakened. You can set the
.Stringand the.Valueproperty, and also.Formulae.g.However, the setting of many other properties is still prohibited (without throwing an error) and I don't know any specification insofar. We have to expect changes without notice, and should therefore not rely on side-effects afflicting cells in the same sheet from where the user function was called.
See also: https://bugs.documentfoundation.org/s...