VerticalAlign Property (Appearance)

Visual Basic
C#

'Declaration
 
Public Property VerticalAlign As VerticalAlign

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

public VerticalAlign VerticalAlign {get; set;}

Property Value

VerticalAlign object containing the alignment of text

Valid values for this property are the vertical alignment settings listed in the VerticalAlign enumeration in the Microsoft .NET Framework Reference.

Use the HorizontalAlign property to specify the horizontal alignment of the object or text.

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.

C#

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;

Visual Basic

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

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

Appearance Class
Appearance Members
HorizontalAlign Property