CircularFormula Event

Applies To

fpSpread control

Description

Occurs during the recalculation of a formula that contains a circular reference when iterations are turned off.

Syntax

C++

afx_msg void OnCircularFormulafpSpread(short Sheet,long Col, long Row);

Visual Basic

Sub fpSpread_CircularFormula(ByVal Sheet As Integer, ByVal Col As Long, ByVal Row As Long)

Parameters

The following parameters are available:

Parameter	Description
Sheet	Sheet number
Col	Column number of cell with circular reference
Row	Row number of cell with circular reference

Remarks

This event could be used to set a flag for a warning message if there is a circular reference. Set a flag in this event, check the flag, and show the message in the UserFormulaEntered or EditMode (when edit mode is false) event.