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

Glossary Item Box

EditModeReplace Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns whether the existing text in a cell is selected when the cell enters edit mode.

Syntax

C++

BOOL CSpreadSheet::GetEditModeReplace( );
void CSpreadSheet::SetEditModeReplace(BOOL value);

Visual Basic

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

Remarks

The default value for the EditModeReplace property is False.

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

When the EditModeReplace property is set to True, when a cell in the sheet enters edit mode, the existing text in the cell is selected. Then, if users start typing, their text replaces the existing text. When the EditModeReplace property is set to False, the cursor is placed at the end of the existing text when the cell enters edit mode; new characters are appended to the existing text.

Note: 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 Replace Existing Text check box in the Settings dialog box

Data Type

Integer (Boolean)

See Also

Replacing Text as You Edit

EditEnterAction, EditMode, EditModePermanent properties

EditMode event

DLL Correspondence

SSGetBool (SSB_EDITMODEREPLACE), SSSetBool (SSB_EDITMODEREPLACE) functions

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