Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Appearance Class / Font Property
Example


In This Topic
    Font Property (Appearance)
    In This Topic
    Gets or sets font information for an object.
    Syntax
    'Declaration
     
    Public Property Font As FontInfo
    'Usage
     
    Dim instance As Appearance
    Dim value As FontInfo
     
    instance.Font = value
     
    value = instance.Font
    public FontInfo Font {get; set;}

    Property Value

    FontInfo object that contains the font settings
    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
    This example creates a new Appearance object, sets the several properties such as color and alignment, then applies those settings to an instance of a Cell object.
    FarPoint.Web.Spread.Appearance appr = new FarPoint.Web.Spread.Appearance();
    FarPoint.Web.Spread.Cell acell;
    appr.BackColor = Color.Red;
    appr.ForeColor = Color.White;
    appr.Font.Bold = true;
    appr.HorizontalAlign = HorizontalAlign.Right;
    appr.VerticalAlign = VerticalAlign.Top;
    acell = FpSpread1.Cells[0,0];
    acell.BackColor = appr.BackColor;
    acell.ForeColor = appr.ForeColor;
    acell.Font.Bold = appr.Font.Bold;
    acell.HorizontalAlign = appr.HorizontalAlign;
    acell.VerticalAlign = appr.VerticalAlign;
    FpSpread1.ActiveSheetView.SetValue(0, 0, "Appearance Test");
    FpSpread1.Columns[0].Width = 150;
    FpSpread1.Rows[0].Height = 60;
    
    Dim appr As New FarPoint.Web.Spread.Appearance()
    appr.BackColor = Color.Red
    appr.ForeColor = Color.White
    appr.Font.Bold = True
    appr.HorizontalAlign = HorizontalAlign.Right
    appr.VerticalAlign = VerticalAlign.Top
    Dim acell As FarPoint.Web.Spread.Cell
    acell = FpSpread1.Cells(0, 0)
    acell.BackColor = appr.BackColor
    acell.ForeColor = appr.ForeColor
    acell.Font.Bold = appr.Font.Bold
    acell.HorizontalAlign = appr.HorizontalAlign
    acell.VerticalAlign = appr.VerticalAlign
    FpSpread1.ActiveSheetView.SetValue(0, 0, "Appearance Test")
    FpSpread1.Columns(0).Width = 150
    FpSpread1.Rows(0).Height = 60
    
    See Also