Spread for ASP.NET 8.0 Product Documentation
Font Property (AlternatingRow)
Example 


Gets or sets the default font for text in cells in this alternating row.
Syntax
'Declaration
 
Public Property Font As FontInfo
'Usage
 
Dim instance As AlternatingRow
Dim value As FontInfo
 
instance.Font = value
 
value = instance.Font
public FontInfo Font {get; set;}

Property Value

FontInfo object containing the font information for cells in this alternating row
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 down-level browsers, those released prior to Internet Explorer 4.

Example
This example sets the text in three cells and changes the font in all of the alternating rows.
FpSpread1.Sheets[0].SetValue(0, 0, "Test");
FpSpread1.Sheets[0].SetValue(1, 0, "for");
FpSpread1.Sheets[0].SetValue(2, 0, "Fonts");
FpSpread1.Sheets[0].AlternatingRows[0].Font.Bold = true;
FpSpread1.Sheets[0].AlternatingRows[1].Font.Bold = true;
FpSpread1.Sheets[0].AlternatingRows[0].Font.Italic = true;
FpSpread1.Sheets[0].AlternatingRows[1].Font.Italic = true;
FpSpread1.Sheets(0).SetValue(0, 0, "Test")
FpSpread1.Sheets(0).SetValue(1, 0, "for")
FpSpread1.Sheets(0).SetValue(2, 0, "Fonts")
FpSpread1.Sheets(0).AlternatingRows(0).Font.Bold = True
FpSpread1.Sheets(0).AlternatingRows(1).Font.Bold = True
FpSpread1.Sheets(0).AlternatingRows(0).Font.Italic = True
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

Reference

AlternatingRow Class
AlternatingRow Members

 

 


Copyright © GrapeCity, inc. All rights reserved.