Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Property HorizontalAlignment As CellHorizontalAlignment | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As Cell Dim value As CellHorizontalAlignment instance.HorizontalAlignment = value value = instance.HorizontalAlignment | |
| C# | |
|---|---|
public CellHorizontalAlignment HorizontalAlignment {get; set;} | |
Property Value
CellHorizontalAlignment object containing the horizontal alignment for cell contentsRemarks
The HorizontalAlignment and VerticalAlignment properties determine the alignment of the cell's content (that is, the text) which is independent of the alignment of the cell's background image. The Picture class has a constructor for supplying alignment of the background image.
Valid values for this property are the horizontal alignment settings listed in the HorizontalAlign enumeration in the Microsoft .NET Framework Reference. The Distributed enumeration adds space between the words so that they evenly fill the cell.
For more information on cell types, refer to the FarPoint.Spread.CellType namespace and to Customizing with Cell Types.
The setting for this property can be overridden if a named style is assigned to the cell using the StyleName property, and that named style sets the horizontal alignment.
Use the VerticalAlignment property to specify the vertical alignment of the object or text.
Example
| C# | Copy Code |
|---|---|
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 | Copy Code |
|---|---|
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 | |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2