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