Back to Devexpress

SpreadsheetControl.SheetInserted Event

windowsforms-devexpress-dot-xtraspreadsheet-dot-spreadsheetcontrol-50842dd2.md

latest2.5 KB
Original Source

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.v25.2.dll

NuGet Package : DevExpress.Win.Spreadsheet

Declaration

csharp
public event SheetInsertedEventHandler SheetInserted
vb
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.

See Also

SheetRemoved

How to: Add a New Worksheet

SpreadsheetControl Class

SpreadsheetControl Members

DevExpress.XtraSpreadsheet Namespace