Spread Windows Forms 12.0 Product Documentation
CircularFormula Event

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : CircularFormula Event
Occurs when one or more circular reference is created.
Public Event CircularFormula As CircularFormulaEventHandler
Dim instance As FpSpread
Dim handler As CircularFormulaEventHandler
AddHandler instance.CircularFormula, handler
public event CircularFormulaEventHandler CircularFormula
Event Data

The event handler receives an argument of type CircularFormulaEventArgs containing data related to this event. The following CircularFormulaEventArgs properties provide information specific to this event.

Specifies the circular cells.  
This example uses the event.
fpSpread1.Sheets[0].SetFormula(0, 0, "A2");
fpSpread1.Sheets[0].SetFormula(1, 0, "A1");

private void fpSpread1_CircularFormula(object sender, EventArgs e)
        listBox1.Items.Add("Circular Reference");
FpSpread1.Sheets(0).SetFormula(0, 0, "A2")
FpSpread1.Sheets(0).SetFormula(1, 0, "A1")

Private Sub FpSpread1_CircularFormula(sender As Object, e As EventArgs) Handles FpSpread1.CircularFormula
        ListBox1.Items.Add("Circular Reference")
End Sub
See Also