Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / CellVerticalAlignment Enumeration
Example Example


In This Topic
    CellVerticalAlignment Enumeration
    In This Topic
    Specifies the vertical alignment of the cell contents.
    Syntax
    'Declaration
     
    Public Enum CellVerticalAlignment 
       Inherits System.Enum
    'Usage
     
    Dim instance As CellVerticalAlignment
    public enum CellVerticalAlignment : System.Enum 
    Members
    MemberDescription
    Bottom Aligns the cell contents to the bottom
    Center Centers the content in the cell vertically
    Distributed Indicates that whitespace has been inserted to make the text fill the special area.
    General Aligns the cell contents according to the cell's interpretation of the contents
    Justify Indicates that whitespace has been inserted to make the text fill the special area.
    Top Aligns the cell contents to the top
    Example
    using FarPoint.Win.Spread;
    using FarPoint.Win;
    
    private void Form1_Load(object sender, System.EventArgs e)
    {
         FarPoint.Win.Spread.Cell acell;
         acell = fpSpread1.ActiveSheet.Cells[0, 0];
         fpSpread1.ActiveSheet.Cells[0, 0].Text = "Alignment";
         acell.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right;
         acell.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top;
         acell.Locked = true;
         fpSpread1.ActiveSheet.Rows[0].Height = 80;
    }
    Imports FarPoint.Win.Spread
    Imports FarPoint.Win
    
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
         Dim acell As FarPoint.Win.Spread.Cell
         acell = FpSpread1.ActiveSheet.Cells(0, 0)
         fpSpread1.ActiveSheet.Cells(0, 0).Text = "Alignment"
         acell.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right
         acell.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Top
         acell.Locked = True
         fpSpread1.ActiveSheet.Rows(0).Height = 80
    End Sub
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             FarPoint.Win.Spread.CellVerticalAlignment

    See Also