Spread for ASP.NET 11 Product Documentation
Font Property (StyleInfo)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > StyleInfo Class : Font Property
Gets or sets the style of the cell font settings.
Syntax
'Declaration
 
Public Overridable Property Font As FontInfo
'Usage
 
Dim instance As StyleInfo
Dim value As FontInfo
 
instance.Font = value
 
value = instance.Font
public virtual FontInfo Font {get; set;}

Property Value

FontInfo object that contains the font settings for text in cells of this style
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 object.

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

Example
The following example creates a sheet with 1000 rows and 7 columns. Alternate rows display a yellow backcolor and navy blue, bold text.
 FpSpread1.Sheets[0].ColumnCount = 7;
 FpSpread1.Sheets[0].RowCount = 1000;
 FarPoint.Web.Spread.StyleInfo altrowstyle = new FarPoint.Web.Spread.StyleInfo();
 altrowstyle.BackColor = Color.LemonChiffon;
 altrowstyle.ForeColor = Color.Navy;
 altrowstyle.Font.Bold = true;
 FarPoint.Web.Spread.Model.DefaultSheetStyleModel altrowmodel = new FarPoint.Web.Spread.Model.DefaultSheetStyleModel(1000,
7); 
 altrowmodel.SetDirectAltRowInfo(1, altrowstyle);
 FpSpread1.Sheets[0].StyleModel = altrowmodel;
FpSpread1.Sheets(0).ColumnCount = 7
FpSpread1.Sheets(0).RowCount = 1000
Dim altrowstyle As New FarPoint.Web.Spread.StyleInfo()
altrowstyle.BackColor = Color.LemonChiffon
altrowstyle.ForeColor = Color.Navy
altrowstyle.Font.Bold = True 
Dim altrowmodel As New FarPoint.Web.Spread.Model.DefaultSheetStyleModel(1000, 7)
altrowmodel.SetDirectAltRowInfo(1, altrowstyle)
FpSpread1.Sheets(0).StyleModel = altrowmodel
See Also

Reference

StyleInfo Class
StyleInfo Members