SSpread.TypeTextOrient Property
Set the display direction of the text in the cell.
Only valid for cells with the CellType property.
$CellTypeDate(date type)
$CellTypeEdit(character type)
$CellTypePic(mask type)
$CellTypeStaticText(label type)
$CellTypeTime
$CellTypeCurrency
$CellTypeNumber
$CellTypePercent
$CellTypeScientific
Before setting this property, use the Col , Row properties, and so on to specify what to do.
Specify the following values. The initial value is $ TypeTextOrientHorizontal.
| Constant | Value | Explanation |
|---|---|---|
| $TypeTextOrientHorizontal | 0 | Horizontal writing |
| $TypeTextOrientVerticalLTR | 1 | Vertical writing (folding from left to right) |
| $TypeTextOrientDown | 2 | 90 degree rotation (downward) |
| $TypeTextOrientUp | 3 | 270 degree rotation (upward) |
| $TypeTextOrientInvert | 4 | 180 degree rotation (reversal) |
| $TypeTextOrientVerticalRTL | 5 | Vertical writing (folding from right to left) |
If the input mode ( EditMode property is $TRUE ), the display is normal (horizontal writing, no rotation).
The wrapping direction of $TypeTextOrientVerticalLTR and $TypeTextOrientVerticalRTL (vertical writing) is the direction for multi-line display (TypeTextWordWrap for label type cells , TypeEditMultiLine property for character type cells is $TRUE ).
This property is subject to property inheritance for each data type cells . Notes on property inheritance of each data type cells.
Example of use
Col = 3;
Row = 2;
CellType = $ CellTypeEdit;
TypeTextOrient = $ TypeTextOrientInvert;
Value = "sample";
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $ CellTypeNumber;
TypeTextOrient = $ TypeTextOrientDown;
Value = 10;
BlockMode = $ FALSE;
Related item
CellType property