Spread 8.0 Documentation
CircularFormula Event
Support Options
ActiveX Reference > ActiveX Events > CircularFormula Event

Glossary Item Box

CircularFormula Event


See Also

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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.