Link Search Menu Expand Document

SSpread.EditModeOn Event

Occurs when the cell input mode is turned ON.

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

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, EditModeOff, EnterRow event