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.

Thu Jul 12, 2018 8:09 am

Hey,

Dim Sheet As Spire.Spreadsheet.Forms.IWorksheet = Spreadsheet1.ActiveWorksheet
Dim ColRow As CellAdressInfo = Sheet.ActiveCellAdressInfo
Sheet.Item(ColRow.Row, ColRow.Column).Style.BackgroundColor = System.Drawing.Color.Azure
Spreadsheet1.Refresh()

I want to set the backgroundcolor, but it does not work.

GH

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

Thu Jul 12, 2018 9:38 am

Dear GH,

Thanks for your inquiry.
I have noticed the issue and posted it to our Dev team. We will let you know as soon as there is any update.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 2513
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.Spreadsheet