Link Search Menu Expand Document
KLCV DEV MANUAL

SSpread.TypeEllipses Property

Set whether to display ellipsis ( … ) in cells when displaying text that is too long to fit in the cell .

Abbreviated display example
login image

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)
$CellTypeCurrency (currency type)
$CellTypeNumber (numeric type)
$CellTypePercent (percentage type)
$CellTypeScientific (exponential type)

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

This is valid only when the TypeHAlign property is set to $TypeHAlignLeft (left-aligned) and the TypeTextOrient property is set to $TypeTextOrientHorizontal (horizontal writing).

Also, if the TypeTextWordWrap property of the label type cell and the TypeEditMultiLine property of the character type cell are $TRUE and the display is multi-line, it is invalid.

If the AllowCellOverflow property is set to $ TRUE and the display is overhanging, that will take precedence.

Specify $TRUE to display the ellipsis and $ FALSE to not display it .
The initial value is $FALSE .

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

Example of use

Col = 3;
Row = 2;
CellType = $CellTypeStaticText;
TypeEllipses = $TRUE;
Text = "Biz / Browser & Biz / Designer";
 
BlockMode = $TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeNumber;
TypeHAlign = $TypeHAlignLeft;
TypeEllipses = $TRUE;
Value = 123456789;
BlockMode = $FALSE;

Related item
AllowCellOverflow , CellType , TypeEditMultiLine , TypeHAlign , TypeTextOrient , TypeTextWordWrap properties