Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Property VerticalAlignment As CellVerticalAlignment | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As Appearance Dim value As CellVerticalAlignment instance.VerticalAlignment = value value = instance.VerticalAlignment | |
| C# | |
|---|---|
public CellVerticalAlignment VerticalAlignment {get; set;} | |
Property Value
CellVerticalAlignment object containing the vertical alignment for cell contentsRemarks
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
| 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 Basic | Copy 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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8