Spread Windows Forms 11.0 Product Documentation
VerticalAlignment Property (Appearance)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Appearance Class : VerticalAlignment Property
Gets or sets the vertical alignment of an object or text in a cell.
Syntax
'Declaration
 
Public Property VerticalAlignment As CellVerticalAlignment
'Usage
 
Dim instance As Appearance
Dim value As CellVerticalAlignment
 
instance.VerticalAlignment = value
 
value = instance.VerticalAlignment
public CellVerticalAlignment VerticalAlignment {get; set;}

Property Value

CellVerticalAlignment object containing the vertical 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. This property does not apply to the rich text cell.

Valid values for this property are the vertical alignment settings listed in the VerticalAlign 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 vertical alignment.

Use the HorizontalAlignment property to specify the horizontal 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.
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.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Bottom;
si.SetAppearance(appr);
fpSpread1.ActiveSheet.SetStyleInfo(0, 0, si);
fpSpread1.ActiveSheet.Cells[0, 0].Text = "Apprearance Test";
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.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Bottom
si.SetAppearance(appr)
fpSpread1.ActiveSheet.SetStyleInfo(0, 0, si)
fpSpread1.ActiveSheet.Cells(0, 0).Text = "Apprearance Test"
See Also

Reference

Appearance Class
Appearance Members
CellVerticalAlignment Enum