Applying backgroundcolor to cells with pattern solid

Aspose.Cells Product Family
1

Why is it that you can't apply a solid background colour to a cell? Of all the things to not work (meaning this product has outperformed most competitors’ products by a long way) this one just doesn’t make any sense. Is there a workaround or anything? I need to have a bold font with a solid coloured background for the heading row - not my choice but that of a client, although it's a pretty fair request..<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

2

Hi,

Please follow the links below. These link have all the related infomration with code samples.

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/format-worksheet-cells-in-a-workbook.html

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/conditional-formatting.html

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/excel-2007-themes-and-colors.html

Thanks,

3

Hi, Thanks for the prompt reply.

I had already checked this documentation but looking over it again it would appear that in order to set the "Background" colour you actually have to set the "Foreground" colour (defined in your documentation as being the cell outline) and then set cell shading to true - is this correct? I cant test right now as I am not at my work pc but I will try this in the morning.. Thank you.

4

Hi,

Yes, your understanding is correct.

For further reference about Colors and Background patterns, see the topic:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/colors-background-patterns.html

Thank you.