SSpread.TypeVAlign Property

Set the vertical alignment within the cell.

Only valid for cells with the following values set in the CellType property.
$ CellTypeDate (date type)
$ CellTypeEdit (character type)
$ CellTypePic (mask type)
$ CellTypeStaticText (label type)
$ CellTypeTime (time type)
$ CellTypeComboBox (combo box type)
$ CellTypePicture
$ CellTypeCheckBox (checkbox type)
$ CellTypeCurrency
$ CellTypeNumber
$ CellTypePercent
$CellTypeScientific (exponential type)

Before setting this property, use the Col , Row properties, and so on to specify what to do.

Specify the following values. The initial values are $ TypeVAlignCenter for label cells in check box cells, column headers, and row headers, and $ TypeVAlignTop for other cells.

Constant	Value	Explanation
$TypeVAlignTop	0	Top alignment
$TypeVAlignBottom	1	Bottom alignment
$TypeVAlignCenter	2	Centered

The horizontal alignment is set with the TypeHAlign property. The placement of command button cell types is set with the TypeButtonAlign property.

This property is subject to property inheritance for each data type cell . Notes on property inheritance of combo box type cells Notes on property inheritance of label type cells

use case

Col = 3;
Row = 2;
CellType = $CellTypeStaticText;
TypeHAlign = $TypeHAlignRight;
TypeVAlign = $TypeVAlignBottom;
Text = "sample";
 
BlockMode = $TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeNumber;
TypeHAlign = $TypeHAlignLeft;
TypeVAlign = $TypeVAlignCenter;
Value = 12345;
BlockMode = $FALSE;