Represents the VerticalAlign property (index is 4), which specifies the vertical alignment of the object.
Syntax
Example
This example creates a new Appearance object, sets the BackColor property for the object and applies it to an instance of a Cell object. Then the BackColor property is checked to determine if it has been defined, and the result is returned to a text box.
| C# |  Copy Code |
|---|
FarPoint.Web.Spread.Appearanceappr=NewFarPoint.Web.Spread.Appearance();
FarPoint.Web.Spread.Cellacell;
boolbl;
appr.BackColor=Color.Red;
appr.ForeColor=Color.White;
appr.Font.Bold=True;
appr.HorizontalAlign=HorizontalAlign.Right;
appr.VerticalAlign=VerticalAlign.Top;
acell=FpSpread1.Cells[0,0];
acell.BackColor=appr.BackColor;
acell.ForeColor=appr.ForeColor;
acell.Font.Bold=appr.Font.Bold;
acell.HorizontalAlign=appr.HorizontalAlign;
acell.VerticalAlign=appr.VerticalAlign;
FpSpread1.ActiveSheetView.SetCellValue(0,0,"AppearanceTest");
FpSpread1.Columns[0].Width=150;
FpSpread1.Rows[0].Height=60;
bl=appr.IsDefined(FarPoint.Web.Spread.AppearanceProperty.BackColor);
TextBox1.Text=Convert.ToString(bl); |
| Visual Basic | Copy Code |
|---|
DimapprAsNewFarPoint.Web.Spread.Appearance()
DimacellAsFarPoint.Web.Spread.Cell
DimblAsBoolean
appr.BackColor=Color.Red
appr.ForeColor=Color.White
appr.Font.Bold=True
appr.HorizontalAlign=HorizontalAlign.Right
appr.VerticalAlign=VerticalAlign.Top
acell=FpSpread1.Cells(0,0)
acell.BackColor=appr1.BackColor
acell.ForeColor=appr1.ForeColor
acell.Font.Bold=appr1.Font.Bold
acell.HorizontalAlign=appr1.HorizontalAlign
acell.VerticalAlign=appr1.VerticalAlign
FpSpread1.ActiveSheetView.SetCellValue(0,0,"AppearancePropertyTest")
FpSpread1.Columns(0).Width=150
FpSpread1.Rows(0).Height=60
bl=appr.IsDefined(FarPoint.Web.Spread.AppearanceProperty.BackColor)
TextBox1.Text=bl |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
