Font Property (StyleInfo)

Visual Basic
C#

'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

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.

The following example creates a sheet with 1000 rows and 7 columns. Alternate rows display a yellow backcolor and navy blue, bold text.

C#

 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;

Visual Basic

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

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

Reference

StyleInfo Class
StyleInfo Members