https://bugs.documentfoundation.org/show_bug.cgi?id=168946
--- Comment #3 from Eyal Rozenberg <[email protected]> --- (In reply to Heiko Tietze from comment #2) > (In reply to Eyal Rozenberg from comment #0) > > I want to apply coloring to several cells... > Why don't you use Draw? "I want to" is not a use case. Heiko, come on, that is not serious suggestion. Do you really not know that cell coloring is a commonly used feature when designing Calc forms? Also, more generally: Calc is Calc, Draw is Draw. You can't use Draw instead of Cac. In Calc, you don't color cells to make artwork, you color them to emphasize data / fields and their roles - as part of work _in Calc_ on tabular data. > Calc is a (alpha)numeric data based tool. That would describe base more than it would Calc. Calc marries alphanumeric data with interactive manipulation and presentation; and cell coloring is a critical and even well-developed feature in calc. > While you may think of colors like > =GetBackgroundColor(A1) (see bug 96555) expecting something like #FF0000 as > the result, the opposite function =SetBackgroundColor() is obviously not > working. Let me clarify I am interested in this functionality not as a function which is the contents of a cell, nor merely as something I can do in a script but as something that a user can do using the UI, without writing code, and for cells with any value. > Colors might be the representation of numbers either via conditional > formatting or number formats. And you can apply these easily to any range. But I don't want to apply them conditionally. At least, not in the use case in this bug. I just want to apply them, period. (And if you mention it, I can't choose a sequence of colors for application in the Conditional Formatting dialog, either.) -- You are receiving this mail because: You are the assignee for the bug.
