Link Search Menu Expand Document

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