Spread Windows Forms 6.0 Product Documentation
HorizontalAlignment Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Appearance Class : HorizontalAlignment Property


Glossary Item Box

Gets or sets the horizontal alignment of an object or text in a cell.

Syntax

Visual Basic (Declaration) 
Public Property HorizontalAlignment As CellHorizontalAlignment
Visual Basic (Usage)Copy Code
Dim instance As Appearance
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 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 illustrates the use of this property. An Appearance object is used to set up the behavior for a StyleInfo object.
C#Copy Code
FarPoint.Win.Spread.Appearance appr = new FarPoint.Win.Spread.Appearance();
FarPoint.Win.Spread.StyleInfo si = new FarPoint.Win.Spread.StyleInfo();
appr.BackColor = Color.Yellow;
appr.DrawPrimaryButton = false;
appr.DrawSecondaryButton = false;
appr.Font = new Font("Comic Sans MS", 10);
appr.ForeColor = Color.DarkBlue;
appr.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right;
appr.LockBackColor = Color.Black;
appr.LockForeColor = Color.White;
appr.SelectionBackColor = Color.Teal;
appr.SelectionForeColor = Color.DarkGreen;
appr.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Bottom;
si.SetAppearance(appr);
fpSpread1.ActiveSheet.SetStyleInfo(0, 0, si);
fpSpread1.ActiveSheet.Cells[0, 0].Text = "Apprearance Test";
Visual BasicCopy Code
Dim appr As New FarPoint.Win.Spread.Appearance
Dim si As New FarPoint.Win.Spread.StyleInfo
appr.BackColor = Color.Yellow
appr.DrawPrimaryButton = False
appr.DrawSecondaryButton = False
appr.Font = New Font("Comic Sans MS", 10)
appr.ForeColor = Color.DarkBlue
appr.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right
appr.LockBackColor = Color.Black
appr.LockForeColor = Color.White
appr.SelectionBackColor = Color.Teal
appr.SelectionForeColor = Color.DarkGreen
appr.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Bottom
si.SetAppearance(appr)
FpSpread1.ActiveSheet.SetStyleInfo(0, 0, si)
FpSpread1.ActiveSheet.Cells(0, 0).Text = "Apprearance Test"

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

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.