Link Search Menu Expand Document

SSpread.EnterRow Event

Occurs when the OperationMode property is $OperationModeRow (row mode), go to a new row and double-click (when in row edit state).

The following child objects are attached to the Event object.

Type Name Description
Number Row Destination row number
Number RowIsLast $TRUE for rows after the last row where the value is entered, $FALSE otherwise

The LeaveRow event is fired when the row edit state ends.

Example of usage

OperationMode = $OperationModeRow;
Function OnEnterRow(e) {
    Col = -1;
    Row = e.Row;
    if (e.RowIsLast == $TRUE) {
        BackColor = $CCFFFF;
    } else {
        BackColor = $FFFFCC;
    }
}

Related Items
OperationMode property
EditModeOn, LeaveRow event