SSpread.Change Event

Occurs when the value of the active cell is changed and when the value of the cell referenced in the formula is changed.

The following child objects are attached to the Event object.

Type	Name	Description
Number	*Col*	Column number of the cell whose value has changed
Number	*Row*	Row number of the cell whose value has changed

When the value of the cell referenced in the formula changes, the event is fired for all related cells.

In the event handler for this event, the Text and Value properties can be used to get the value of the modified cell.

If change the value from the script, the event will not fire.

Example of usage

Function OnChange(e) {
    Col = e.Col;
    Row = e.Row;
    if (Text == "") {
        BackColor = $RED;
    }
}