Gets or sets the default background color for cells in this column.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property BackColor As Color |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Column
Dim value As Color
instance.BackColor = value
value = instance.BackColor |
| C# | |
|---|
public Color BackColor {get; set;} |
Property Value
Color object that contains the background color for cells in this column
Remarks
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.
| C# | Copy Code |
|---|
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");
} |
| Visual Basic | Copy Code |
|---|
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 |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also
