Spread Windows Forms 12.0 Product Documentation
ForeColor Property (Cell)

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Cell Class : ForeColor Property
Gets or sets the text (foreground) color for a cell.
Public Property ForeColor As Color
Dim instance As Cell
Dim value As Color
instance.ForeColor = value
value = instance.ForeColor
public Color ForeColor {get; set;}

Property Value

Color object containing the text color of the cell

The setting for this property can be overridden if a named style is assigned to the cell using the the StyleName property, and that named style sets the text color.

When cells are locked with the Lock and Protect properties, the value of the SheetView.LockForeColor property overrides the value of this property.

If you use this property to retrieve the text color for a range of cells that do not have the same text color, the text color for the active cell is returned.

If you are working with button cells, use the CellType.ButtonCellType.ButtonColor property to specify the color of the text in the buttons.

Specify the background color for the cell by setting the BackColor property.

This example generates random background and foreground colors and assigns them to the cells in the sheet.
FarPoint.Win.Spread.Cell acell;
int i, j;
int iColorR = 0;
int iColorG = 0;
int iColorB = 0;
Random rand = new Random();
fpSpread1.ActiveSheet.ColumnCount = 20;
fpSpread1.ActiveSheet.RowCount = 20;
acell = fpSpread1.ActiveSheet.Cells[0, 0];
for (i = 0; i <= fpSpread1.ActiveSheet.RowCount - 1; i++)
     for (j = 0; j<= fpSpread1.ActiveSheet.ColumnCount - 1; j++)
          acell = fpSpread1.ActiveSheet.Cells[i, j];
          acell.BackColor = Color.FromArgb(iColorR, iColorG, iColorB);
          acell.ForeColor = Color.FromArgb(iColorB, iColorR, iColorG);
          iColorR = rand.Next(0, 255);
          iColorG = rand.Next(0, 255);
          iColorB = rand.Next(0,255);
Dim acell As FarPoint.Win.Spread.Cell
Dim i, j, c As Integer
Dim iColorR, iColorG, iColorB As Integer
fpSpread1.ActiveSheet.ColumnCount = 20
fpSpread1.ActiveSheet.RowCount = 20
For i = 0 To fpSpread1.ActiveSheet.RowCount - 1
     For j = 0 To fpSpread1.ActiveSheet.ColumnCount - 1
          acell = fpSpread1.ActiveSheet.Cells(i, j)
          iColorR = Int(255 * Rnd()) + 1
          iColorG = Int(255 * Rnd()) + 1
          iColorB = Int(255 * Rnd()) + 1
          acell.BackColor = Color.FromArgb(iColorR, iColorG, iColorB)
          acell.ForeColor = Color.FromArgb(iColorB, iColorR, iColorG)
     Next j
Next i
See Also


Cell Class
Cell Members
BackColor Property
StyleName Property
NamedStyle Class