Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetViewCollection Class / Changing Event

In This Topic
    Changing Event (SheetViewCollection)
    In This Topic
    Occurs when a sheet is about to be added, removed, or changed in the collection.
    Public Event Changing As CollectionChangeEventHandler
    Dim instance As SheetViewCollection
    Dim handler As CollectionChangeEventHandler
    AddHandler instance.Changing, handler
    public event CollectionChangeEventHandler Changing
    Event Data

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

    The event handler receives an argument of type CollectionChangeEventHandler containing data related to this event.
    This example creates the Changing event for the collection, which occurs when another sheet is added to the collection.
    public FarPoint.Win.Spread.SheetViewCollection svc;
    fpSpread1.Sheets.Count = 3;
    fpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always;
    FarPoint.Win.Spread.SheetView sv = new FarPoint.Win.Spread.SheetView();
    sv.SheetName = "Added";
    svc = fpSpread1.Sheets;
    svc.Changing += new System.ComponentModel.CollectionChangeEventHandler(svc_Changing);
    public void svc_Changing(object sender, System.ComponentModel.CollectionChangeEventArgs e)
    listBox1.Items.Add("Collection Changing");
    Friend WithEvents svc As FarPoint.Win.Spread.SheetViewCollection
    FpSpread1.Sheets.Count = 3
    FpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always
    Dim sv As New FarPoint.Win.Spread.SheetView()
    sv.SheetName = "Added"
    svc = FpSpread1.Sheets
    Public Sub svc_changing(ByVal sender As Object, ByVal e As System.ComponentModel.CollectionChangeEventArgs) Handles svc.Changing
    ListBox1.Items.Add("Collection Changing")
    End Sub
    See Also