Spread 8.0 Documentation
TypeEllipses Property
Support Options
ActiveX Reference > ActiveX Properties > TypeEllipses Property

Glossary Item Box

TypeEllipses Property


See Also    DLL    Example

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:

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)

See Also

Displaying an Ellipsis to Indicate More Text

AllowCellOverflow, Sheet, TypeEditMultiLine, TypeHAlign, TypeTextWordWrap properties

DLL Correspondence

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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.