Workbook Events
A non-visual component that allows you to generate and modify spreadsheet documents.Name | Description |
---|---|
Active |
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. |
Active |
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. |
Before |
Occurs before detecting the encoding of the loaded CSV or TXT data. |
Before |
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. |
Before |
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. |
Before |
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. |
Clipboard |
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. |
Clipboard |
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. |
Clipboard |
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. |
Columns |
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. |
Columns |
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. |
Columns |
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. |
Columns |
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. |
Column |
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. |
Comment |
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. |
Comment |
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. |
Comment |
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. |
Comment |
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. |
Content |
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. |
Copied |
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. |
Copied |
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. |
Custom |
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. |
Defined |
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. |
Document |
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. |
Document |
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. |
Document |
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. |
Empty |
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. |
Encrypted |
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. |
Encrypted |
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. |
Encrypted |
Raises when the Workbook You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Initialize |
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. |
Invalid |
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. |
Modified |
Occurs when the value of the Workbook. You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this event in production code. |
Panes |
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. |
Panes |
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. |
Range |
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. |
Range |
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. |
Row |
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. |
Rows |
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. |
Rows |
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. |
Rows |
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. |
Rows |
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. |
Schema |
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. |
Scroll |
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. |
Selection |
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. |
Shape |
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. |
Shape |
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. |
Shape |
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. |
Shapes |
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. |
Sheet |
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. |
Sheet |
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. |
Sheet |
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. |
Sheet |
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. |
Sheet |
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. |
Unit |
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. |
Unit |
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. |
Validate |
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. |