Spread Windows Forms 9.0 Product Documentation
HorizontalAlignment Property (Column)
Example 


Gets or sets the default horizontal alignment for cells in this column.
Syntax
'Declaration
 
Public Property HorizontalAlignment As CellHorizontalAlignment
'Usage
 
Dim instance As Column
Dim value As CellHorizontalAlignment
 
instance.HorizontalAlignment = value
 
value = instance.HorizontalAlignment
public CellHorizontalAlignment HorizontalAlignment {get; set;}

Property Value

CellHorizontalAlignment object containing the horizontal alignment for cell contents
Remarks

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
This example specifies the text alignment for the column.
FarPoint.Win.Spread.Column col;
fpSpread1.ActiveSheet.Cells[0, 0].Text = "Alignment";
col = fpSpread1.ActiveSheet.Columns[0];
col.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right;
col.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center;
col.Width = 120;
fpSpread1.ActiveSheet.Rows[0].Height = 60;
Dim col As FarPoint.Win.Spread.Column
FpSpread1.ActiveSheet.Cells(0, 0).Text = "Alignment"
col = FpSpread1.ActiveSheet.Columns(0)
col.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right
col.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center
col.Width = 120
FpSpread1.ActiveSheet.Rows(0).Height = 60
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

See Also

Reference

Column Class
Column Members

User-Task Documentation

Aligning Cell Contents

 

 


Copyright © GrapeCity, inc. All rights reserved.