Event then worksheet has been added or removed from workbook

[Dmitry]

Is there a way to determine then worksheet has been added or removed from workbook?

[Nikolay Demirev]

Hi Dimitry,

The sheets collection contains Changed event that can notify you for adding, removing or rearranging the sheets. Here is a sample code showing how you can use the Changed event:

this.radSpreadsheet.Workbook.Sheets.Changed += this.Sheets_Changed;

private void Sheets_Changed(object sender, SheetCollectionChangedEventArgs e)
{
    switch (e.ChangeType)
    {
        case SheetCollectionChangeType.Add:
            break;
        case SheetCollectionChangeType.Move:
            break;
        case SheetCollectionChangeType.Remove:
            break;
    }
}

Regards,
Nikolay Demirev
Telerik

 

 

[Dmitry]

Thank you!

But how do i figure out witch worksheet have been removed, added or moved?

[Anna]

Hi Dmitry,

At the moment the event arguments do not provide information regarding which sheet has been modified. I am going to include this as an item in our backlog to be implemented in the future. For the time being what I can suggest to work around this limitation is to keep a separate sheet collection which you can compare to the existing one in order to determine which is the modified sheet.

I hope this helps. Please, let me know if you have any concerns.

Regards,
Anna
Telerik