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 an active 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 an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
BeforeExport |
Occurs before the document is saved (exported to a certain format). You need an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 and allows cancelling loading. You need an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active 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 an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |