CellVerticalAlignment Enumeration

Specifies the vertical alignment of the cell contents.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum CellVerticalAlignment 
   Inherits System.Enum

'Usage
 
Dim instance As CellVerticalAlignment

public enum CellVerticalAlignment : System.Enum

Members

Member	Description
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;
}

Visual Basic

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

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

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

User-Task Documentation

Aligning Cell Contents