Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / Column Class / ForeColor Property

In This Topic
    ForeColor Property (Column)
    In This Topic
    Gets or sets the default text color for cells in this column.
    Public Property ForeColor As Color
    Dim instance As Column
    Dim value As Color
    instance.ForeColor = value
    value = instance.ForeColor
    public Color ForeColor {get; set;}

    Property Value

    Color object containing the text color

    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.

    This example uses a color dialog to set the text color for the column.
    FarPoint.Win.Spread.Column col;
    col = fpSpread1.ActiveSheet.Columns[0];
    ColorDialog cd = new ColorDialog();
    if (cd.ShowDialog() == DialogResult.OK)
         col.ForeColor = cd.Color;     
         fpSpread1.ActiveSheet.Cells[0, 0].Text = "ForeColor";
    Dim cd As New ColorDialog()
    Dim col As FarPoint.Win.Spread.Column
    col = fpSpread1.ActiveSheet.Columns(0)
    If cd.ShowDialog = DialogResult.OK Then
         col.ForeColor = cd.Color
         fpSpread1.ActiveSheet.Cells(0, 0).Text = "ForeColor"
    End If
    See Also