CellHorizontalAlignment Enumeration

Specifies the horizontal alignment of the cell contents.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum CellHorizontalAlignment 
   Inherits System.Enum

'Usage
 
Dim instance As CellHorizontalAlignment

public enum CellHorizontalAlignment : System.Enum

Members

Member	Description
Center	Centers the content in the cell horizontally
Distributed	Indicates that whitespace has been inserted to make the text fill the special area.
General	Aligns the cell content according to the cell's interpretation of the content
Justify	Indicates that whitespace has been inserted to make the text fill the special area.
Left	Aligns the cell content to the left
Right	Aligns the cell content to the right

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.CellHorizontalAlignment

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
HorizontalAlignment Property (Cell Class)

User-Task Documentation

Aligning Cell Contents