Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Appearance Class / VerticalAlign Property
Example


In This Topic
    VerticalAlign Property (Appearance)
    In This Topic
    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