SSpread.EditModeOff Event

Occurs when the cell input mode is turned off.

The following child objects are attached to the Event object.

Type	Name	Description
Number	*Col*	Active cell column number
Number	*Row*	Active cell row number
Number	*ChangeMade*	$TRUE if the value changes, $FALSE otherwise

Example of usage

String oldvalue;
Function OnEditModeOn (e) {
    oldvalue = GetText (e.Col, e.Row);
}
Function OnEditModeOff (e) {
    if (e.ChangeMade == $ TRUE) {
        if (GetText (e.Col, e.Row) == "") {
            MessageBox (" Enter ");
            SetText (e.Col, e.Row, oldvalue);
            EditMode = $ TRUE;
            return;
        }
    }
}

Related Item
EditEnterAction, EditMode, EditModePermanent, EditModeReplace property
EditChange, EditError, EditModeOn event