Spread ASP.NET 16
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Column Class / BackColor Property
Example


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

    Property Value

    Color object that contains the background color for cells in this column
    Remarks
    The setting for this property can be overridden if a named style is assigned to the cell using the StyleName property, and that named style sets the background color.

    Specify the text color for the cell by setting the ForeColor property.

    Example
    This example creates a spreadsheet with 10 columns and 20 rows. A Column object is then created and assigned to the second column of the spreadsheet. The BackColor, ForeColor, Font and Width properties are set to various values and the text inserted into the column reflect the changes.
    FpSpread1.ActiveSheetView.ColumnCount=10;
    FpSpread1.ActiveSheetView.PageSize=20;
    FpSpread1.ActiveSheetView.RowCount=20;
    FarPoint.Web.Spread.Column mycol;
    mycol=FpSpread1.ActiveSheetView.Columns[1];
    mycol.BackColor=Color.Yellow;
    mycol.ForeColor=Color.Red;
    mycol.Font.Bold=true;
    mycol.Font.Name="ComicSansMS";
    mycol.Width=140;
    for(int i=0;i<FpSpread1.ActiveSheetView.RowCount;i++)
    {
    FpSpread1.ActiveSheetView.SetValue(i,1,"ColumnTest");
    }
    FpSpread1.ActiveSheetView.ColumnCount=10
    FpSpread1.ActiveSheetView.PageSize=20
    FpSpread1.ActiveSheetView.RowCount=20
    Dim mycol As FarPoint.Web.Spread.Column
    Dim col,i As Integer
    col=1
    mycol=FpSpread1.ActiveSheetView.Columns(col)
    mycol.BackColor=Color.Yellow
    mycol.ForeColor=Color.Red
    mycol.Font.Bold=True
    mycol.Font.Name="ComicSansMS"
    mycol.Width=140
    For i = 0 To FpSpread1.ActiveSheetView.RowCount-1
    FpSpread1.ActiveSheetView.SetValue(i,1,"ColumnTest")
    Next i
    See Also