TypeEllipses Property

Applies To

Spread control

Description

Sets or returns whether an ellipsis (...) is displayed when text is too long to fit in the cell. This property is available at run time only.

Syntax

C++

BOOL CSpreadsheet::GetTypeEllipses( );
void CSpreadsheet::SetTypeEllipses(BOOL Value);

Visual Basic

[form.]fpSpread.TypeEllipses[ = boolean%]

Remarks

The default value for the TypeEllipses property is False, which means the cell does not display an ellipsis when the text is too long to be displayed.

Use the TypeEllipses property to display an ellipsis in date, edit, currency, number, percent, PIC, scientific, static text, and time cells. The ellipsis displays only if the TypeHAlign property is set to 0 (Left) and the TypeTextOrient property is set to 0 (Horizontal).

To use the TypeEllipses property, specify the sheet with which you want to work by setting the Sheet property. Then specify the cell or cells to which to apply the property, as described in Using Column and Row Properties. Once you set the TypeEllipses property for a valid cell or cells, any subsequent cells of that type that you create use the same TypeEllipses setting unless you reset it for those cells.

If the cell is set to display an ellipsis when the text is too long to be displayed in the cell and the text is left-aligned, the ellipsis is displayed on the right side of the cell, as shown in the following figure.

If the cell does not display an ellipsis when the text is too long to be displayed, one of the following may be the cause:

The text that does not fit in the cell is not displayed.
The AllowCellOverflow property may be set to True.
The text wraps within an edit or static text cell if the TypeEditMultiLine or the TypeTextWordWrap property is set to True for that cell or for the next level in the hierarchy.
The TypeHAlign property is set to a value other than 0 (Left).
The TypeTextOrient property is set to a value other than 0 (Horizontal).

This property does not have an effect if the AllowCellOverflow property is set to True or if the TypeEditMultiLine or TypeTextWordWrap property is set to True for an edit or static text cell.

Spread Designer

Choose the Cell menu, the Cell Type menu, the Currency, Date, Edit, Number, Label (Static), Mask (Pic), Percent, Scientific, or Time menu, and then the Settings tab, and then select the Ellipses check box in the Cell Type Settings dialog box.

Data Type

Integer (Boolean)

DLL Correspondence

SSS_ELLIPSES style in the Style parameter of the SSSetTypeDate, SSSetTypeEdit, SSSetTypeCurrency, SSSetTypeNumber, SSSetTypePercent, SSSetTypePic, SSSetTypeStaticText, and SSSetTypeTime functions