Spread Windows Forms 8.0 Product Documentation > Developer's Guide > Customizing Row, Column, and Cell Appearance > Customizing the Appearance of a Cell > Coloring a Cell |
You can set the background and foreground (text) colors for a cell or for a group of cells. An example of the different ways to set the colors for a cell is shown in the figure. The code that created these cell colors is given below.
You can specify the background color for a cell in code by using the BackColor property for that cell. You can specify the text color in code by using the ForeColor property.
You can also specify these colors if the cells are selected using SelectionBackColor and SelectionForeColor for the sheet. For more information on selections, refer to Customizing the Selection Appearance.
You can also specify a different color (for background or for text) in locked cells using the LockBackColor and LockForeColor properties of the SheetView or Appearance objects. For more information on locked cells, refer to Locking a Cell.
Set the BackColor property or the ForeColor property for the Cells object.
This example code sets the background color and text color for the second cell, and sets the colors for locked cells, and sets the colors for selections.
C# |
Copy Code
|
---|---|
fpSpread1.ActiveSheet.Cells[0,1].Value = "This is default."; fpSpread1.ActiveSheet.Cells[1,1].Value = "This is custom."; fpSpread1.ActiveSheet.Cells[2,1].Value = "This is locked."; fpSpread1.ActiveSheet.Cells[3,1].Value = "This is selected."; fpSpread1.ActiveSheet.Cells[1,1].BackColor = Color.LimeGreen; fpSpread1.ActiveSheet.Cells[1,1].ForeColor = Color.Yellow; fpSpread1.ActiveSheet.Cells[2,1].Locked = true; fpSpread1.ActiveSheet.Protect = true; fpSpread1.ActiveSheet.LockBackColor = Color.Brown; fpSpread1.ActiveSheet.LockForeColor = Color.Orange; fpSpread1.ActiveSheet.SelectionStyle = FarPoint.Win.Spread.SelectionStyles.SelectionColors; fpSpread1.ActiveSheet.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Range; fpSpread1.ActiveSheet.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Cell; fpSpread1.ActiveSheet.SelectionBackColor = Color.Pink; fpSpread1.ActiveSheet.SelectionForeColor = Color.Red; |
VB |
Copy Code
|
---|---|
FpSpread1.ActiveSheet.Cells(0,1).Value = "This is default." FpSpread1.ActiveSheet.Cells(1,1).Value = "This is custom." FpSpread1.ActiveSheet.Cells(2,1).Value = "This is locked." FpSpread1.ActiveSheet.Cells(3,1).Value = "This is selected." FpSpread1.ActiveSheet.Cells(1,1).BackColor = Color.LimeGreen FpSpread1.ActiveSheet.Cells(1,1).ForeColor = Color.Yellow FpSpread1.ActiveSheet.Cells(2,1).Locked = True FpSpread1.ActiveSheet.Protect = True FpSpread1.ActiveSheet.LockBackColor = Color.Brown FpSpread1.ActiveSheet.LockForeColor = Color.Orange FpSpread1.ActiveSheet.SelectionStyle = FarPoint.Win.Spread.SelectionStyles.SelectionColors FpSpread1.ActiveSheet.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Range FpSpread1.ActiveSheet.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Cell FpSpread1.ActiveSheet.SelectionBackColor = Color.Pink FpSpread1.ActiveSheet.SelectionForeColor = Color.Red |
Set the BackColor property or the ForeColor property for a Cell object.
This example code sets the background color for cell A1 to Azure and the foreground color to Navy, then sets the background color for cells C3 through D4 to Bisque.
C# |
Copy Code
|
---|---|
FarPoint.Win.Spread.Cell cellA1; cellA1 = fpSpread1.ActiveSheet.Cells[0, 0]; cellA1.BackColor = Color.Azure; cellA1.ForeColor = Color.Navy; FarPoint.Win.Spread.Cell cellrange; cellrange = fpSpread1.ActiveSheet.Cells[2,2,3,3]; cellrange.BackColor = Color.Bisque; |
VB |
Copy Code
|
---|---|
Dim cellA1 As FarPoint.Win.Spread.Cell cellA1 = FpSpread1.ActiveSheet.Cells(0, 0) cellA1.BackColor = Color.Azure cellA1.ForeColor = Color.Navy Dim cellrange As FarPoint.Win.Spread.Cell cellrange = FpSpread1.ActiveSheet.Cells(2, 2, 3, 3) cellrange.BackColor = Color.Bisque |