SpreadsheetControl.SheetInserted Event

Occurs after a new worksheet has been added into a workbook via the SpreadsheetControl‘s UI.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v24.1.dll

NuGet Package: DevExpress.Win.Spreadsheet

Declaration

C#

public event SheetInsertedEventHandler SheetInserted

VB.NET

Public Event SheetInserted As SheetInsertedEventHandler

Event Data

The SheetInserted event's data class is SheetInsertedEventArgs.

Remarks

Handle the SheetInserted event to perform specific actions each time an end-user creates a new worksheet in a workbook using the control’s UI.

After a worksheet has been deleted, the SpreadsheetControl.SheetRemoved event is raised.

Note

By default, the SheetInserted event does not occur when inserting a new worksheet in code. However, this event will also be triggered by changes made via an API if you set the WorkbookEventOptions.RaiseOnModificationsViaAPI property (accessible via the SpreadsheetControl.Options.Events.RaiseOnModificationsViaAPI notation) to true.