Cell color is always black


#1

I’m trying to set the color of a cell using vb:

tmpStyle.ForegroundColor = System.Drawing.Color.FromArgb(210,219,230)

The cellcolor just turns up black, no matter what value I enter - except white.

The Aspose.Excel is version 1.9.0.0

*I tried searching the forum-site for: ForegroundColor, but I get a: Page cannot be found with URL: http://forums.aspose.com/Search/default.aspx&searchText=backgroundcolor&forum=9


#2

Hi,

Please refer to http://www.aspose.com/Products/Aspose.Excel/Api/Aspose.Excel.Excel.ChangePalette.html.

If the color is not in the MS Excel standard palette, you have to use the Excel.ChangePalette method to change the palette first.

excel.ChangePalette(System.Drawing.Color.FromArgb(210,219,230), 55)

tmpStyle.ForegroundColor = System.Drawing.Color.FromArgb(210,219,230)


#3

Thank you - that was it.