SpreadsheetControl Events
Emulates the Microsoft® Excel® appearance and allows you to create, load, edit, save and print spreadsheet documents.
Name | Description |
---|---|
Active |
Occurs after an active worksheet has been changed via the Spreadsheet |
Active |
Occurs when an active worksheet is about to be changed via the Spreadsheet |
After |
Occurs after a user dropped the selected cell range in a new location. |
After |
Occurs after a cell range was automatically filled with data based on values in the source range. |
After |
Fires after the expand/collapse operation is executed for row or column groups in a worksheet. |
After |
Fires after a user clicks an outline button for row or column groups. |
Auto |
This event is not relevant for this class. Inherited from Control. |
Back |
Occurs when the value of the Back |
Background |
Occurs when the value of the Background |
Background |
Occurs when the Background |
Before |
Occurs before the Spreadsheet |
Before |
Occurs when a user starts to drag the selected cell range. |
Before |
Occurs when a user is about to drop the selected cell range in a new location. |
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 when a user drags the fill handle to populate cells with data based on values in the source range. |
Before |
Fires before the expand/collapse operation is executed for row or column groups in a worksheet. |
Before |
Occurs before a document is loaded (imported from an external source). |
Before |
Fires before a user clicks an outline button for row or column groups. |
Before |
Provides the capability to prevent printing of the required worksheets in a workbook. |
Binding |
Occurs when the value of the Binding |
Causes |
Occurs when the value of the Causes |
Cell |
Occurs before a cell editor is opened. |
Cell |
Occurs before the cell editor is closed and the entered value is rolled back. |
Cell |
Occurs after a cell editor was activated by a user. |
Cell |
Occurs before a cell editor is closed and the entered value is committed. |
Cell |
Occurs after the cell content was changed via the Spreadsheet |
Change |
Occurs when the focus or keyboard user interface (UI) cues change. Inherited from Control. |
Click | Occurs when the control is clicked. Inherited from Control. |
Client |
Occurs when the value of the Client |
Clipboard |
Occurs after data on the clipboard is obtained and recognized, but before data is pasted. |
Clipboard |
Occurs after data was pasted from the clipboard onto a worksheet. |
Clipboard |
Occurs before data is pasted into destination cells. |
Columns |
Occurs after new columns have been added to a worksheet via the Spreadsheet |
Columns |
Occurs when new columns are about to be inserted into a worksheet. |
Columns |
Occurs after columns have been deleted from a worksheet via the Spreadsheet |
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. |
Content |
Occurs when the document content is changed. |
Context |
Occurs when the value of the Context |
Context |
Occurs when the value of the Context |
Control |
Occurs when a new control is added to the Control. |
Control |
Occurs when a control is removed from the Control. |
Copied |
Occurs after the range content has been pasted into target cells. |
Copied |
Occurs before the range content is pasted into target cells. |
Cursor |
Occurs when the value of the Cursor property changes. Inherited from Control. |
Custom |
Occurs before a custom assembly is loaded for use as the Entity Framework data source during mail merge and allows you to cancel the operation. |
Custom |
Allows you to assign a custom in-place editor to a cell. |
Custom |
Allows you to paint cell content. |
Custom |
Performs custom painting of the cell background. |
Custom |
Enables the column header to be painted manually. |
Custom |
Enables the column header background to be painted manually. |
Custom |
Allows you to customize comment indicators. |
Custom |
Enables frozen pane borders to be painted manually. |
Custom |
Enables the row header to be painted manually. |
Custom |
Enables the row header background to be painted manually. |
Data |
Occurs before a data binding warning dialog is shown in the Spreadsheet |
Defined |
Occurs after the defined name is created. |
Defined |
Occurs when a formula or sheet being moved or copied contains a defined name that already exists in the destination worksheet or workbook. |
Defined |
Occurs after the defined name is deleted. |
Defined |
Occurs before a Defined Name is deleted. |
Defined |
Occurs after the defined name parameters were changed. |
Defined |
Occurs before a Defined Name is being edited. |
Defined |
Occurs when a new Defined Name is created before it is added to a collection. |
Disposed | Occurs when the component is disposed by a call to the Dispose() method. Inherited from Component. |
Dock |
Occurs when the value of the Dock property changes. Inherited from Control. |
Document |
Occurs when a document that has not yet been saved is about to be closed. |
Document |
Occurs after a document is loaded into the Spreadsheet control. |
Document |
Occurs after one of the Document |
Document |
Occurs after a document has been saved. |
Double |
Occurs when the control is double-clicked. Inherited from Control. |
Drag |
Occurs when a drag-and-drop operation is completed. Inherited from Control. |
Drag |
Occurs when an object is dragged into the control’s bounds. Inherited from Control. |
Drag |
Occurs when an object is dragged out of the control’s bounds. Inherited from Control. |
Drag |
Occurs when an object is dragged over the control’s bounds. Inherited from Control. |
Empty |
Occurs when a new document is created in the Spreadsheet |
Enabled |
Occurs when the Enabled property value has changed. Inherited from Control. |
Encrypted |
Occurs when the encrypted file does not pass data integrity verification. |
Encrypted |
Occurs when the encryption password is empty or invalid. |
Encrypted |
Occurs when the Workbook |
Enter | Occurs when the control is entered. Inherited from Control. |
Font |
Occurs when the Font property value changes. Inherited from Control. |
Fore |
Occurs when the Fore |
Give |
Occurs during a drag operation. Inherited from Control. |
Got |
Occurs when the control receives focus. Inherited from Control. |
Group |
Fires after row or column groups are expanded or collapsed. |
Group |
Fires before row or column groups are expanded or collapsed. |
Handle |
Occurs when a handle is created for the control. Inherited from Control. |
Handle |
Occurs when the control’s handle is in the process of being destroyed. Inherited from Control. |
Help |
Occurs when the user requests help for a control. Inherited from Control. |
Hyperlink |
Occurs when an end-user activates the hyperlink before navigating to the referenced location. |
Ime |
Occurs when the Ime |
Initialize |
Occurs before a document is loaded. Handle this event to set the initial document settings. |
Invalidated | Occurs when a control’s display requires redrawing. Inherited from Control. |
Invalid |
Fires when the supplied data could not be recognized as data in the assumed format for import. |
Key |
Occurs when a key is pressed while the control has focus. Inherited from Control. |
Key |
Occurs when a character. space or backspace key is pressed while the control has focus. Inherited from Control. |
Key |
Occurs when a key is released while the control has focus. Inherited from Control. |
Layout | Occurs when a control should reposition its child controls. Inherited from Control. |
Leave | Occurs when the input focus leaves the control. Inherited from Control. |
Location |
Occurs when the Location property value has changed. Inherited from Control. |
Lost |
Occurs when the control loses focus. Inherited from Control. |
Margin |
Occurs when the control’s margin changes. Inherited from Control. |
Modified |
Occurs when the value of the Spreadsheet |
Mouse |
Occurs when the control loses mouse capture. Inherited from Control. |
Mouse |
Occurs when the control is clicked by the mouse. Inherited from Control. |
Mouse |
Occurs when the control is double clicked by the mouse. Inherited from Control. |
Mouse |
Occurs when the mouse pointer is over the control and a mouse button is pressed. Inherited from Control. |
Mouse |
Occurs when the mouse pointer enters the control. Inherited from Control. |
Mouse |
Occurs when the mouse pointer rests on the control. Inherited from Control. |
Mouse |
Occurs when the mouse pointer leaves the control. Inherited from Control. |
Mouse |
Occurs when the mouse pointer is moved over the control. Inherited from Control. |
Mouse |
Occurs when the mouse pointer is over the control and a mouse button is released. Inherited from Control. |
Mouse |
Occurs when the mouse wheel moves while the control has focus. Inherited from Control. |
Move | Occurs when the control is moved. Inherited from Control. |
Padding |
Occurs when the control’s padding changes. Inherited from Control. |
Paint | Occurs when the control is redrawn. Inherited from Control. |
Panes |
Occurs after a worksheet area has been frozen via the Spreadsheet |
Panes |
Occurs after a frozen worksheet area has been unlocked via the Spreadsheet |
Parent |
Occurs when the Parent property value changes. Inherited from Control. |
Popup |
Occurs when a popup menu is about to be displayed for the Spreadsheet |
Preview |
Occurs before the Key |
Property |
Occurs every time any of the Spreadsheet |
Protection |
Occurs when attempting to edit a locked cell in a protected worksheet. |
Query |
Occurs when Accessible |
Query |
Occurs during a drag-and-drop operation and enables the drag source to determine whether the drag-and-drop operation should be canceled. Inherited from Control. |
Range |
Occurs after the range content has been copied. |
Range |
Occurs before a cell range is copied in a worksheet. |
Read |
Occurs when the Spreadsheet |
Region |
Occurs when the value of the Region property changes. Inherited from Control. |
Resize | Occurs when the control is resized. Inherited from Control. |
Right |
Occurs when the Right |
Row |
Occurs after the row height was changed. |
Rows |
Occurs after new rows have been added to a worksheet via the Spreadsheet |
Rows |
Occurs when new rows are about to be inserted into a worksheet. |
Rows |
Occurs after rows have been deleted from a worksheet via the Spreadsheet |
Rows |
Occurs when rows are about to be deleted from a worksheet. |
Scroll |
Occurs when a worksheet is being scrolled in the Spreadsheet |
Selection |
Fires when the selection changes in an active 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. |
Sheet |
Occurs after a new worksheet has been added into a workbook via the Spreadsheet |
Sheet |
Occurs after a worksheet has been removed from a workbook via the Spreadsheet |
Sheet |
Occurs when a worksheet is about to be removed from a workbook. |
Sheet |
Occurs after a worksheet has been renamed via the Spreadsheet |
Sheet |
Occurs when a worksheet is about to be renamed via the Spreadsheet |
Size |
Occurs when the Size property value changes. Inherited from Control. |
Style |
Occurs when the control style changes. Inherited from Control. |
System |
Occurs when the system colors change. Inherited from Control. |
Tab |
Occurs when the Tab |
Tab |
Occurs when the Tab |
Text |
Occurs when the Text property value changes. Inherited from Control. |
Unhandled |
This event is raised when an exception, unhandled by the Spreadsheet |
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. |
Update |
Raised when changes occur which may affect the control’s UI. |
Validate |
Allows validation of the custom SQL query created using the Data Source Wizard. |
Validated | Occurs when the control is finished validating. Inherited from Control. |
Validating | Occurs when the control is validating. Inherited from Control. |
Visible |
Occurs when the Visible property value changes. Inherited from Control. |
Visible |
Occurs after the visible cell range was changed in the Spreadsheet control. |
Zoom |
Occurs when the current zoom level of the active worksheet has been changed via the Spreadsheet |
See Also