AllowEditOverflow Property

Applies To

fpSpread control

Description

Sets or returns whether data can overflow into adjacent empty cells while edit mode is on in a cell.

Syntax

C++

BOOL CSpreadSheet::GetAllowEditOverflow( );
void CSpreadSheet::SetAllowEditOverflow(BOOL value);

Visual Basic

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

Remarks

The default value for the AllowEditOverflow property is False.

This setting is applied to the entire workbook, including all sheets in the control.

When the AllowEditOverflow property is set to True,

Left-aligned data in a cell overflows to the adjacent right cell.
Right-aligned data in a cell overflows to the adjacent left cell.
When data is centered, data overflows to both the left and right adjacent cells.

When the user moves from the cell, the sheet automatically turns edit mode off and the text that will fit displays only in the cell. To display overflow text in adjacent cells, use the AllowCellOverflow property.

Spread Designer

Choose the Book menu, then the Environment menu, select the Environment tab, and then choose the Edit Overflow check box in the Book Settings dialog box.

Data Type

Integer (Boolean)

DLL Correspondence

SSSetBool function