EditModePermanent Property

Applies To

fpSpread control

Description

Sets or returns whether a cell is in edit mode whenever it becomes the active cell.

Syntax

C++

BOOL CSpreadSheet::GetEditModePermanent( );
void CSpreadSheet::SetEditModePermanent(BOOL value);

Visual Basic

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

Remarks

The default value for the EditModePermanent property is False.

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

If the EditModePermanent property is set to True, when any cell in the sheet becomes the active cell, it immediately enters edit mode. In effect, setting the EditModePermanent property to True creates a sheet with cells that do not display the focus rectangle. You can use this option to emulate a table of edit controls.

When the EditModePermanent property is set to True, every time you move the active cell, the EditMode event occurs twice: when you leave the current active cell and when you move to the new active cell.

Note: Setting the EditModePermanent property to True automatically sets the SelectBlockOptions property to 0. If you then set the EditModePermanent property to False, you must reset the SelectBlockOptions property to its original setting.

Tip: If you set the EditModePermanent property to True, you might want to set the EditModeReplace property to False to prevent users from accidentally deleting their data.

Spread Designer

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

Data Type

Integer (Boolean)

DLL Correspondence

SSGetBool (SSB_EDITMODEPERMANENT), SSSetBool (SSB_EDITMODEPERMANENT) functions