Spire.Spreadsheet is a powerful component to view spreadsheet. As a standalone spreadsheet class library, Spire.Spreadsheet is a companion component to Spire.XLS, which mainly focus on how to display spreadsheet.

Sun Nov 18, 2018 9:19 am

Hey,

it is not possibe to set backcolor of a cell

Sheet.Item(ColRow.Row, ColRow.Column).Style.BackgroundColor = System.Drawing.Color.Red

GH

GHWels
 
Posts: 75
Joined: Sun Nov 23, 2014 7:22 pm

Mon Nov 19, 2018 10:17 am

Hi,

Thanks for your inquiry.
Please use the Spire.Spreadsheet Pack(hot fix) Version:2.10.3 and refer to below code to set the background-color.
Code: Select all
Sheet.Item(ColRow.Row, ColRow.Column).Style.ForegroundColor = System.Drawing.Color.Red
Sincerely,
Mike
E-iceblue support team
User avatar

Mike.Zhang
 
Posts: 93
Joined: Thu Sep 27, 2018 7:11 am

Tue Nov 20, 2018 10:16 am

Thank you for your fast help.
GH

GHWels
 
Posts: 75
Joined: Sun Nov 23, 2014 7:22 pm

Wed Nov 21, 2018 7:49 am

Hi,

It's my pleasure.
Any question, just feel free to contact us.
Sincerely,
Mike
E-iceblue support team
User avatar

Mike.Zhang
 
Posts: 93
Joined: Thu Sep 27, 2018 7:11 am

Return to Spire.Spreadsheet