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 Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

Cell Class
Cell Members
VerticalAlign Property
StyleName Property
NamedStyle Class