Gets or sets the default font for text in cells in this column.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property Font As FontInfo |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Column
Dim value As FontInfo
instance.Font = value
value = instance.Font |
Property Value
FontInfo object containing the font information 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
