SSpread.EditChange Event
Occurs when the value is changed in a cell whose input mode is ON (edited state).
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 |
This event is fired for every single character entered, but there is no guarantee that the OnEditChange event handler will be called immediately. In other words, it is not suitable for processing that checks errors for each character.
Also, it is not recommended to change the properties related to the entire spreadsheet or change the settings that cause inconsistencies in the cell being edited in the event handler that occurs while editing the cell, as it may not work properly.
Example of usage
Function OnEditChange (e) {
print (e.Col, e.Row, GetText (e.Col, e.Row), "\ n");
}
Related Item
EditEnterAction, EditMode, EditModePermanent, EditModeReplace property
EditError, EditModeOff, EditModeOn event