CircularFormula Event

Occurs when one or more circular reference is created.

Syntax

Visual Basic
C#

'Declaration
 
Public Event CircularFormula As CircularFormulaEventHandler

'Usage
 
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.

Property	Description
CircularCells	Specifies the circular cells.

Example

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");
     }

Visual Basic

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

Reference

FpSpread Class
FpSpread Members

Product Support Forum | Print this page