Spread Windows Forms 11.0 Product Documentation
CellVerticalAlignment Enumeration
Example Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace : CellVerticalAlignment Enumeration
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
BottomAligns the cell contents to the bottom
CenterCenters the content in the cell vertically
DistributedIndicates that whitespace has been inserted to make the text fill the special area.
GeneralAligns the cell contents according to the cell's interpretation of the contents
JustifyIndicates that whitespace has been inserted to make the text fill the special area.
TopAligns 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

Reference

FarPoint.Win.Spread Namespace
VerticalAlignment Property (Cell Class)

User-Task Documentation

Aligning Cell Contents