Spread for ASP.NET 11 Product Documentation
VerticalAlign Property (Appearance)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > Appearance Class : VerticalAlign Property
Gets or sets the vertical alignment of an object or text.
Syntax
'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
Remarks

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.

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

Reference

Appearance Class
Appearance Members
HorizontalAlign Property