Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Property ForeColor As Color | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As Cell Dim value As Color instance.ForeColor = value value = instance.ForeColor | |
| C# | |
|---|---|
public Color ForeColor {get; set;} | |
Property Value
Color object containing the text color of the cellRemarks
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.
Example
| C# | Copy Code |
|---|---|
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); } } | |
| Visual Basic | Copy Code |
|---|---|
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) Randomize() 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 | |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2