Spread ASP.NET 6.0 Product Documentation
Font Property
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > Column Class : Font Property


Glossary Item Box

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
C# 
public FontInfo Font {get; set;}

Property Value

FontInfo object containing the font information for cells in this column

Remarks

You can specify several aspects of the font, including the the style, the size, and the face name. For more information on the font settings in general, refer to the FontInfo class members, and for a list of the font styles in particular, refer to the FontStyle enumeration, in the Microsoft .NET Framework Reference.

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 font.

Note: The overline style is not supported in browsers release prior to Internet Explorer 4.

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.Columnmycol;
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(inti=0;i<FpSpread1.ActiveSheetView.RowCount;i++)
{
FpSpread1.ActiveSheetView.SetValue(i,1,"ColumnTest");
}
Visual BasicCopy Code
FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.PageSize=20
FpSpread1.ActiveSheetView.RowCount=20
DimmycolAsFarPoint.Web.Spread.Column
Dimcol,iAsInteger
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
Fori=0ToFpSpread1.ActiveSheetView.RowCount-1
FpSpread1.ActiveSheetView.SetValue(i,1,"ColumnTest")
Nexti

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.