FarPoint.Win.Spread
ForeColor Property
See Also  Example
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Row Class : ForeColor Property


Gets or sets the default text color for cells in this row.

Syntax

Visual Basic (Declaration) 
Public Property ForeColor As Color
Visual Basic (Usage)Copy Code
Dim instance As Row
Dim value As Color
 
instance.ForeColor = value
 
value = instance.ForeColor
C# 
public Color ForeColor {get; set;}

Return Value

Color object containing the text color

Example

This example specifies the text color for the cells in the row.
C#Copy Code
FarPoint.Win.Spread.Row r;
r = fpSpread1.ActiveSheet.Rows[0];
ColorDialog c = new ColorDialog();
if (c.ShowDialog() == DialogResult.OK)
{
    r.ForeColor = c.Color;
    fpSpread1.ActiveSheet.Cells[0, 0].Text = "ForeColor";
}
Visual BasicCopy Code
Dim r As FarPoint.Win.Spread.Row
r = FpSpread1.ActiveSheet.Rows(0)
Dim c As New ColorDialog()
If c.ShowDialog = DialogResult.OK Then
     r.ForeColor = c.Color
     FpSpread1.ActiveSheet.Cells(0, 0).Text = "ForeColor"
End If

Remarks

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

When cells in a column 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 of the active cell is returned.

This property does not change the text color of the drop-down list portion of a combo box cell. The text color of the drop-down list portion of a combo box cell is always black.

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 cells in a column by setting the BackColor property.


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.

See Also