SSpread.UserFormulaEntered Event
Occurs when AllowUserFormulas is set to $TRUE and the user enters a formula in a cell.
The following child objects are attached to the Event object.
| Type | Name | Description |
|---|---|---|
| Number | Col | Column number of the entered or changed cell |
| Number | Row | Row number of cell entered or changed |
Example of usage
AllowUserFormulas = $TRUE;
Function OnUserFormulaEntered(e) {
Col = e.Col;
Row = e.Row;
MessageBox (strf ("(% 1,% 2) cell formula changed to % 3 ", Col, Row, Formula));
}
Related Item AllowUserFormulas, Formula property