Workbook Events

A non-visual component that allows you to generate and modify spreadsheet documents.

Name	Description
ActiveSheetChanged

Occurs after an active worksheet in a workbook has been changed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | ActiveSheetChanging |

Occurs when an active worksheet in a workbook is about to be changed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

Occurs before the document is saved (exported to a certain format).

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | BeforeImport |

Occurs before a document is loaded (imported from an external source).

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | BeforePrintSheet |

Occurs before printing a workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | ClipboardDataObtained |

Occurs after data on the clipboard is obtained and recognized, but before data is actually pasted.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | ClipboardDataPasted |

Occurs after data has been pasted from the clipboard onto a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | ClipboardDataPasting |

Occurs before data is pasted into destination cells.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | ColumnsInserted |

Occurs after new columns have been added to a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | ColumnsInserting |

Occurs before new columns are added to a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | ColumnsRemoved |

Occurs after columns have been deleted from a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | ColumnsRemoving |

Occurs before columns are removed from a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | ColumnWidthChanged |

Occurs after the column width was changed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | CommentInserted |

Occurs after a comment was inserted.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | CommentInserting |

Occurs before a comment is inserted.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | CommentRemoved |

Occurs after a comment was deleted.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | CommentRemoving |

Occurs before a comment is deleted.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | ContentChanged |

Occurs when a workbook’s undo history changes. The Undo history is not logged for a Workbook instance by default, so the event is not raised.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | CopiedRangePasted |

Occurs after the range content has been pasted into target cells.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | CopiedRangePasting |

Occurs before the range content is pasted into target cells.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | CustomAssemblyLoading |

Occurs before a custom assembly is loaded for use as the Entity Framework data source during mail merge. Allows you to cancel loading.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | DefinedNameConflictResolving |

Occurs when the formula or sheet being moved or copied contains a defined name which already exists on the destination worksheet or workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | DocumentClosing |

Occurs when a document that has not yet been saved is about to be closed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this property in production code.

| | DocumentLoaded |

Occurs after a document is loaded.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | DocumentSaved |

Occurs after a document has been saved.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | EmptyDocumentCreated |

Occurs when a new document is created.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | EncryptedFileIntegrityCheckFailed |

Raises when the encrypted file did not pass the data integrity verification.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | EncryptedFilePasswordCheckFailed |

Occurs when the encryption password is empty or invalid.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | EncryptedFilePasswordRequest |

Raises when the WorkbookImportOptions.Password property is not set or contains a wrong password.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | InitializeDocument |

Occurs before a document is loaded. Handle this event to set initial document settings.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | InvalidFormatException |

Fires when the supplied data could not be recognized as data in the assumed format for import.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | ModifiedChanged |

Occurs when the value of the Workbook.Modified property is changed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | PanesFrozen |

Occurs after a worksheet area has been frozen.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | PanesUnfrozen |

Occurs after a frozen worksheet area has been unlocked.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | RangeCopied |

Occurs after the range content has been copied.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | RangeCopying |

Occurs before a cell range is copied in a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | RowHeightChanged |

Occurs after the row height was changed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | RowsInserted |

Occurs after new rows have been added to a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | RowsInserting |

Occurs before new rows are added to a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | RowsRemoved |

Occurs after rows have been deleted from a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | RowsRemoving |

Occurs before rows are removed from a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | SchemaChanged |

Occurs when a worksheet or defined name is renamed, inserted or deleted.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | ScrollPositionChanged |

Occurs when the scroll position changes in a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | SelectionChanged |

Fires when the selection changes in a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | ShapeInserted |

Occurs after a drawing object has been inserted into a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | ShapeRemoved |

Occurs after a drawing object has been removed from a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | ShapeRemoving |

Occurs before a drawing object is removed from a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | ShapesCopying |

Occurs before a drawing object is copied in a worksheet.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | SheetInserted |

Occurs after a new worksheet has been added to a workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | SheetRemoved |

Occurs after a worksheet has been removed from a workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | SheetRemoving |

Occurs before a worksheet is removed from a workbook.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | SheetRenamed |

Occurs after a worksheet has been renamed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | SheetRenaming |

Occurs when a worksheet is about to be renamed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | UnitChanged |

Fires after a unit of measurement used in the workbook is changed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | UnitChanging |

Fires before a unit of measurement used within the workbook is changed.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.

| | ValidateCustomSqlQuery |

Allows you to validate a custom SQL query created in the Data Source Wizard.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code.