HorizontalAlign Property (Cell)

Gets or sets the horizontal alignment of contents for a cell.

Syntax

Visual Basic
C#

'Declaration
 
Public Property HorizontalAlign As HorizontalAlign

'Usage
 
Dim instance As Cell
Dim value As HorizontalAlign
 
instance.HorizontalAlign = value
 
value = instance.HorizontalAlign

public HorizontalAlign HorizontalAlign {get; set;}

Property Value

HorizontalAlign object containing the alignment of text for this cell

Remarks

Valid values for this property are the horizontal alignment settings listed in the HorizontalAlign enumeration in the Microsoft .NET Framework Reference.

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 VerticalAlign property to specify the vertical alignment of the object or text.

Example

This example creates a Cell object and adjusts the alignment of the text in the cell. The height of the row is changed so that the alignment changes can be easily seen.

FarPoint.Web.Spread.Cell mycell;
mycell=FpSpread1.Cells[0,0];
FpSpread1.ActiveSheetView.SetValue(0,0,"Alignment");
mycell.HorizontalAlign=HorizontalAlign.Right;
mycell.VerticalAlign=VerticalAlign.Top;
FpSpread1.ActiveSheetView.Rows[0].Height=80;

Visual Basic

Dim mycell As FarPoint.Web.Spread.Cell
mycell=FpSpread1.Cells(0,0)
FpSpread1.ActiveSheetView.SetValue(0,0,"Alignment")
mycell.HorizontalAlign=HorizontalAlign.Right
mycell.VerticalAlign=VerticalAlign.Top
FpSpread1.ActiveSheetView.Rows(0).Height=80

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

Cell Class
Cell Members
VerticalAlign Property
StyleName Property
NamedStyle Class