I can't seem to get the back color of a cell, row or column to set programatically.
The ribbon lets me choose a back (fill) color, but nothing happens.
I can find the 'setForeColor' method, but there isn't a 'setBackColor'. Can you confirm that this is right ?
I CAN set back colors using the Styles = good/bad/neutral from the UI.
So is the only way to set the back color to create my own CellStyle, and use that?
Is there any documentation on how to do this? Using the Visual Studio debugger makes it a very slow process of software archeology!