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.
See Also
SheetSendingEvent, Text, Value properties