Spread for ASP.NET 11 Product Documentation
VerticalAlign Property (StyleInfo)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > StyleInfo Class : VerticalAlign Property
Gets or sets the vertical alignment of the cell for the style.
Syntax
'Declaration
 
Public Overridable Property VerticalAlign As VerticalAlign
'Usage
 
Dim instance As StyleInfo
Dim value As VerticalAlign
 
instance.VerticalAlign = value
 
value = instance.VerticalAlign
public virtual VerticalAlign VerticalAlign {get; set;}

Property Value

VerticalAlign object containing the alignment of text for the cells of this style
Remarks

Valid values for this property are the vertical alignment settings listed in the VerticalAlign enumeration in the Microsoft .NET Framework Reference.

Use the HorizontalAlign property to specify the horizontal alignment of the object or text.

Example
This example creates a StyleInfo object and adjusts the alignment of the text in the first cell. Whether the object is empty is returned to a list box, along with its Parent NamedStyle, if it has one.
FarPoint.Web.Spread.StyleInfo minfo = new FarPoint.Web.Spread.StyleInfo();
FarPoint.Web.Spread.Inset inset = new FarPoint.Web.Spread.Inset(50, 10, 5, 50);
minfo.HorizontalAlign = HorizontalAlign.Right;
minfo.VerticalAlign = VerticalAlign.Top;
minfo.Margin = inset;
FpSpread1.Sheets[0].SetStyleInfo(0, 0, minfo);
FpSpread1.Sheets[0].SetValue(0, 0, "StyleInfo");
FpSpread1.Columns[0].Width = 140;
FpSpread1.Rows[0].Height = 60;
bool bol;  
bol = minfo.IsEmpty;
ListBox1.Items.Add(Convert.ToString(bol));
ListBox1.Items.Add(minfo.Parent);
Dim minfo As New FarPoint.Web.Spread.StyleInfo()
Dim inset As New FarPoint.Web.Spread.Inset(50, 10, 5, 50)
minfo.HorizontalAlign = HorizontalAlign.Right
minfo.VerticalAlign = VerticalAlign.Top
minfo.Margin = inset 
FpSpread1.Sheets(0).SetStyleInfo(0, 0, minfo)
FpSpread1.Sheets(0).SetValue(0, 0, "StyleInfo")
FpSpread1.Columns(0).Width = 140
FpSpread1.Rows(0).Height = 60
Dim bol As Boolean
bol = minfo.IsEmpty()
ListBox1.Items.Add(bol)
ListBox1.Items.Add(minfo.Parent())
See Also

Reference

StyleInfo Class
StyleInfo Members
HorizontalAlign Property