ISpreadsheetComponent Events

Exposes the basic functionality to manage workbooks.

Name	Description
ActiveSheetChanged	Occurs after an active worksheet in a workbook has been changed.
ActiveSheetChanging	Occurs when an active worksheet in a workbook is about to be changed.
BeforeExport	Occurs before the document is saved (exported to a certain format).
BeforeImport	Occurs before a document is loaded (imported from an external source).
BeforePrintSheet	Occurs before printing a workbook.
ClipboardDataObtained	Occurs after data on the Clipboard is obtained and recognized, but before data is actually pasted.
ClipboardDataPasted	Occurs after data has been pasted from the Clipboard onto a worksheet.
ClipboardDataPasting	Occurs before data is pasted from the Clipboard.
ColumnsInserted	Occurs after new columns have been added to a worksheet.
ColumnsInserting	Occurs when new columns are about to be inserted into a worksheet.
ColumnsRemoved	Occurs after columns have been deleted from a worksheet.
ColumnsRemoving	Occurs when columns are about to be deleted from a worksheet.
CommentInserted	Occurs when a comment is inserted.
CommentInserting	Occurs before inserting a comment.
CommentRemoved	Occurs when a comment is deleted.
CommentRemoving	Occurs before deleting a comment.
CopiedRangePasted	Occurs after the range content has been pasted into target cells.
CopiedRangePasting	Occurs before the range content is pasted into target cells.
CustomAssemblyLoading	Occurs before a custom assembly is loaded for use as the Entity Framework data source during mail merge and allows cancelling loading.
DefinedNameConflictResolving	Occurs when a formula or sheet being moved or copied contains the defined name, which already exists on the destination worksheet or workbook.
DocumentClosing	Occurs when a document that has not yet been saved is about to be closed.
DocumentLoaded	Occurs after a document is loaded.
DocumentSaved	Occurs after a document has been saved.
EmptyDocumentCreated	Occurs when a new document is created.
EncryptedFileIntegrityCheckFailed	Raises when the encrypted file did not pass the data integrity verification.
EncryptedFilePasswordCheckFailed	Occurs when the encryption password is empty or invalid.
EncryptedFilePasswordRequest	Raises when the WorkbookImportOptions.Password property is not set or contains a wrong password.
InitializeDocument	Occurs before a document is loaded. Handle this event to set initial document settings.
InvalidFormatException	Fires when the supplied data could not be recognized as data in the assumed format for import.
ModifiedChanged	Occurs when the value of the ISpreadsheetComponent.Modified property is changed.
PanesFrozen	Occurs after a worksheet area has been frozen.
PanesUnfrozen	Occurs after a frozen worksheet area has been unlocked.
RangeCopied	Occurs after the range content has been copied.
RangeCopying	Occurs before a cell range is copied in a worksheet.
RowsInserted	Occurs after new rows have been added to a worksheet.
RowsInserting	Occurs when new rows are about to be inserted into a worksheet.
RowsRemoved	Occurs after rows have been deleted from a worksheet.
RowsRemoving	Occurs when rows are about to be deleted from a worksheet.
ScrollPositionChanged	Occurs when the scroll position changes in a worksheet.
SelectionChanged	Fires in response to changing cell selection in a worksheet.
ShapeInserted	Occurs after a drawing object has been inserted into a worksheet.
ShapeRemoved	Occurs after a drawing object has been removed from a worksheet.
ShapeRemoving	Occurs before a drawing object is removed from a worksheet.
ShapesCopying	Occurs before a drawing object is copied in a worksheet.
SheetInserted	Occurs after a new worksheet has been added to a workbook.
SheetRemoved	Occurs after a worksheet has been removed from a workbook.
SheetRemoving	Occurs when a worksheet is about to be removed from a workbook.
SheetRenamed	Occurs after a worksheet has been renamed.
SheetRenaming	Occurs when a worksheet is about to be renamed.
UnitChanged	Fires after a unit of measurement used in the workbook is changed.
UnitChanging	Fires before a unit of measurement used within the workbook is changed.