Font Property (Appearance)

Visual Basic
C#

'Declaration
 
Public Property Font As Font

'Usage
 
Dim instance As Appearance
Dim value As Font
 
instance.Font = value
 
value = instance.Font

public Font Font {get; set;}

Property Value

Font object containing the font settings

You can specify the name, size, and other properties of the font. You can also specify whether the font style is bold, italic, underlined, overlined, or strikeout.

For more information on the font settings, refer to the Font members and to the FontInfo members 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.

This example illustrates the use of this property. An Appearance object is used to set up the behavior for a StyleInfo object.

C#

FarPoint.Win.Spread.Appearance appr = new FarPoint.Win.Spread.Appearance();
FarPoint.Win.Spread.StyleInfo si = new FarPoint.Win.Spread.StyleInfo();
appr.BackColor = Color.Yellow;
appr.DrawPrimaryButton = false;
appr.DrawSecondaryButton = false;
appr.Font = new Font("Comic Sans MS", 10);
appr.ForeColor = Color.DarkBlue;
appr.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right;
appr.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Bottom;
si.SetAppearance(appr);
fpSpread1.ActiveSheet.SetStyleInfo(0, 0, si);
fpSpread1.ActiveSheet.Cells[0, 0].Text = "Apprearance Test";

Visual Basic

Dim appr As New FarPoint.Win.Spread.Appearance
Dim si As New FarPoint.Win.Spread.StyleInfo
appr.BackColor = Color.Yellow
appr.DrawPrimaryButton = False
appr.DrawSecondaryButton = False
appr.Font = New Font("Comic Sans MS", 10)
appr.ForeColor = Color.DarkBlue
appr.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right
appr.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Bottom
si.SetAppearance(appr)
fpSpread1.ActiveSheet.SetStyleInfo(0, 0, si)
fpSpread1.ActiveSheet.Cells(0, 0).Text = "Apprearance Test"

Reference

Appearance Class
Appearance Members