ISpreadsheetComponent Events
Exposes the basic functionality to manage workbooks.
Name | Description |
---|---|
Active |
Occurs after an active worksheet in a workbook has been changed. |
Active |
Occurs when an active worksheet in a workbook is about to be changed. |
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). |
Before |
Occurs before a document is loaded (imported from an external source). |
Before |
Occurs before printing a workbook. |
Clipboard |
Occurs after data on the Clipboard is obtained and recognized, but before data is actually pasted. |
Clipboard |
Occurs after data has been pasted from the Clipboard onto a worksheet. |
Clipboard |
Occurs before data is pasted from the Clipboard. |
Columns |
Occurs after new columns have been added to a worksheet. |
Columns |
Occurs when new columns are about to be inserted into a worksheet. |
Columns |
Occurs after columns have been deleted from a worksheet. |
Columns |
Occurs when columns are about to be deleted from a worksheet. |
Column |
Occurs after the column width was changed. |
Comment |
Occurs when a comment is inserted. |
Comment |
Occurs before inserting a comment. |
Comment |
Occurs when a comment is deleted. |
Comment |
Occurs before deleting a comment. |
Copied |
Occurs after the range content has been pasted into target cells. |
Copied |
Occurs before the range content is pasted into target cells. |
Custom |
Occurs before a custom assembly is loaded for use as the Entity Framework data source during mail merge and allows you to cancel loading. |
Defined |
Occurs when a formula or sheet being moved or copied contains the defined name, which already exists on the destination worksheet or workbook. |
Document |
Occurs when a document that has not yet been saved is about to be closed. |
Document |
Occurs after a document is loaded. |
Document |
Occurs after a document has been saved. |
Empty |
Occurs when a new document is created. |
Encrypted |
Raises when the encrypted file did not pass the data integrity verification. |
Encrypted |
Occurs when the encryption password is empty or invalid. |
Encrypted |
Raises when the Workbook |
Initialize |
Occurs before a document is loaded. Handle this event to set initial document settings. |
Invalid |
Fires when the supplied data could not be recognized as data in the assumed format for import. |
Modified |
Occurs when the value of the ISpreadsheet |
Panes |
Occurs after a worksheet area has been frozen. |
Panes |
Occurs after a frozen worksheet area has been unlocked. |
Range |
Occurs after the range content has been copied. |
Range |
Occurs before a cell range is copied in a worksheet. |
Row |
Occurs after the row height was changed. |
Rows |
Occurs after new rows have been added to a worksheet. |
Rows |
Occurs when new rows are about to be inserted into a worksheet. |
Rows |
Occurs after rows have been deleted from a worksheet. |
Rows |
Occurs when rows are about to be deleted from a worksheet. |
Scroll |
Occurs when the scroll position changes in a worksheet. |
Selection |
Fires in response to changing cell selection in a worksheet. |
Shape |
Occurs after a drawing object has been inserted into a worksheet. |
Shape |
Occurs after a drawing object has been removed from a worksheet. |
Shape |
Occurs before a drawing object is removed from a worksheet. |
Shapes |
Occurs before a drawing object is copied in a worksheet. |
Sheet |
Occurs after a new worksheet has been added to a workbook. |
Sheet |
Occurs after a worksheet has been removed from a workbook. |
Sheet |
Occurs when a worksheet is about to be removed from a workbook. |
Sheet |
Occurs after a worksheet has been renamed. |
Sheet |
Occurs when a worksheet is about to be renamed. |
Unit |
Fires after a unit of measurement used in the workbook is changed. |
Unit |
Fires before a unit of measurement used within the workbook is changed. |
See Also