Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / AlternatingRow Class / VerticalAlignment Property
Example


In This Topic
    VerticalAlignment Property (AlternatingRow)
    In This Topic
    Gets or sets the vertical alignment for text in the cells in this alternating row.
    Syntax
    'Declaration
     
    Public Property VerticalAlignment As CellVerticalAlignment
    'Usage
     
    Dim instance As AlternatingRow
    Dim value As CellVerticalAlignment
     
    instance.VerticalAlignment = value
     
    value = instance.VerticalAlignment
    public CellVerticalAlignment VerticalAlignment {get; set;}

    Property Value

    CellVerticalAlignment object containing the vertical alignment for cell contents
    Remarks

    To create alternating rows, first set the AlternatingRows.Count property to specify the number of alternating row patterns, then set the properties for each pattern.

    Example
    This example specifies the text alignment for the alternating row.
    FarPoint.Win.Spread.AlternatingRow altrow;
    altrow = fpSpread1.ActiveSheet.AlternatingRows[0];
    altrow.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right;
    altrow.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top;
    fpSpread1.ActiveSheet.Rows[0].Height = 80;
    fpSpread1.ActiveSheet.Columns[0].Width = 120;
    fpSpread1.ActiveSheet.Cells[0, 0].Text = "Alignment";
    Dim altrow As FarPoint.Win.Spread.AlternatingRow
    altrow = fpSpread1.ActiveSheet.AlternatingRows(0)
    altrow.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right
    altrow.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top
    fpSpread1.ActiveSheet.Rows(0).Height = 80
    fpSpread1.ActiveSheet.Columns(0).Width = 120
    fpSpread1.ActiveSheet.Cells(0, 0).Text = "Alignment"
    See Also