SSpread.CircularFormula Event

Occurs when a circular reference is used when recalculating a formula.

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

Example of usage

Function OnCircularFormula(e) {
    MessageBox (strf ("(% 1,% 2) cells are circularly referenced ", e.Col, e.Row));
}