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

Glossary Item Box

TypeTextWordWrap Property

See Also    DLL    Example

Applies To

fpSpread control


Sets or returns whether text in static text cells is displayed on multiple lines. This property is available at run time only.



BOOL CSpreadSheet::GetTypeTextWordWrap( );
void CSpreadSheet::SetTypeTextWordWrap(BOOL value);

Visual Basic

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


The default value for the TypeTextWordWrap property is False except for cells in column headers and row headers. The default value for the TypeTextWordWrap property for header cells is True.

When the TypeTextWordWrap property is set to True, text is wrapped when it is wider than the width of the cell. Use a linefeed character (ASCII 10 or `\n' in C++) to force a line break. When the TypeTextWordWrap property is set to False, text that is wider than the cell is not displayed in the cell.

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

The TypeTextWordWrap property does not have an effect unless the CellType property is set to 5 (Static Text) for the specified cell or cells, or if the specified cell or cells are header cells.

If you prefer, instead of wrapping text, cells can display their text in adjacent empty cells if you set the AllowCellOverflow property to True.

Spread Designer

Choose the Cell menu, the Cell Type menu, the Label(Static) menu, and then the Settings tab, and then select the Word Wrap check box in the Cell Type Settings dialog box.

Data Type

Integer (Boolean)

See Also

Creating and Customizing a Static Text Cell

CellType, Sheet properties

DLL Correspondence

SSSetTypeStaticText function

Copyright © GrapeCity, inc. All rights reserved.