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

Glossary Item Box

TypeEditMultiLine Property

See Also    DLL    Example

Applies To

fpSpread control


Sets or returns whether data is displayed on multiple lines in an edit cell. This property is available at run time only.



BOOL CSpreadSheet::GetTypeEditMultiLine( );
void CSpreadSheet::SetTypeEditMultiLine(BOOL value);

Visual Basic

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


The default value for the TypeEditMultiLine property is False.

When editing a multiple-line edit cell, pressing the Enter key advances to the next line.

Use the MaxTextRowHeight property or the MaxTextCellHeight property in conjunction with the TypeEditMultiLine property to determine if the size of the cell needs adjusting to display all the text the user has typed.

To use the TypeEditMultiLine 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 TypeEditMultiLine property for a cell or cells, any subsequent edit cells you create will use the same TypeEditMultiLine setting unless you reset it for those cells.

The TypeEditMultiLine property does not have an effect unless the CellType property is set to 1 (Edit) for the specified cell or cells.

The number of characters allowed in an edit cell is limited by default to 60. You can change that limit using the TypeMaxEditLen property.

Spread Designer

Choose the Cell menu, the Cell Type menu, the Edit menu, and then the Settings tab, and then select the Multiple Lines check box in the Cell Type Settings dialog box.

Data Type

Integer (Boolean)

See Also

Limiting User Entry in an Edit Cell

CellType, MaxTextCellHeight, MaxTextRowHeight, Sheet, TypeMaxEditLen properties

DLL Correspondence

SSSetTypeEdit function

Copyright © GrapeCity, inc. All rights reserved.