Spread for ASP.NET 11 Product Documentation
ForeColor Property (Column)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > Column Class : ForeColor Property
Gets or sets the default text color for cells in this column.
Syntax
'Declaration
 
Public Property ForeColor As Color
'Usage
 
Dim instance As Column
Dim value As Color
 
instance.ForeColor = value
 
value = instance.ForeColor
public Color ForeColor {get; set;}

Property Value

Color object that contains the text 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 text color.

Specify the background color for the cell by setting the BackColor 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

Reference

Column Class
Column Members
BackColor Property