SpreadsheetControl Events
Emulates the Microsoft® Excel® look and feel and allows you to create, load, edit, save and print spreadsheet documents.
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. |
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. |
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. |
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. |
Cell |
Occurs after a cell value has been changed. |
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 inserted into 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. |
Content |
Occurs when the document content was changed. |
Context |
Occurs just before any context menu on the element is closed.
Inherited from Framework |
Context |
Occurs when any context menu on the element is opened.
Inherited from Framework |
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 and allows canceling loading. |
Custom |
Allows you to assign a custom in-place editor to a cell. |
Data |
Occurs before a data binding warning dialog is shown in the Spreadsheet |
Data |
Occurs when the data context for this element changes.
Inherited from Framework |
Defined |
Occurs after the defined name is created. |
Defined |
Occurs when a formula or sheet being moved or copied contains a defined name which already exists on 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. |
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. |
Drag |
Occurs when the input system reports an underlying drag event with this element as the drag target. Inherited from UIElement. |
Drag |
Occurs when the input system reports an underlying drag event with this element as the drag origin. Inherited from UIElement. |
Drag |
Occurs when the input system reports an underlying drag event with this element as the potential drop target. Inherited from UIElement. |
Drop | Occurs when the input system reports an underlying drop event with this element as the drop target. Inherited from UIElement. |
Empty |
Occurs when a new document is created in the Spreadsheet control. |
Encrypted |
Occurs when the encrypted file did not pass the data integrity verification. |
Encrypted |
Occurs when the encryption password is empty or invalid. |
Encrypted |
Occurs when the Workbook |
Focusable |
Occurs when the value of the Focusable property changes. Inherited from UIElement. |
Give |
Occurs when the input system reports an underlying drag-and-drop event that involves this element. Inherited from UIElement. |
Got |
Occurs when this element gets logical focus. Inherited from UIElement. |
Got |
Occurs when the keyboard is focused on this element. Inherited from UIElement. |
Got |
Occurs when this element captures the mouse. Inherited from UIElement. |
Got |
Occurs when this element captures the stylus. Inherited from UIElement. |
Got |
Occurs when a touch is captured to this element. Inherited from UIElement. |
Group |
Fires after row or column groups are expanded or collapsed. |
Group |
Fires before row or column groups are expanded or collapsed. |
Hyperlink |
Occurs when an end-user clicks the hyperlink to activate it. |
Initialized |
Occurs when this Frameworkfalse (or undefined) to true .
Inherited from Framework |
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. |
Is |
Occurs when the value of the Is |
Is |
Occurs when the value of the Is |
Is |
Occurs when the value of the Is |
Is |
Occurs when the value of the Is |
Is |
Occurs when the value of the Is |
Is |
Occurs when the value of the Is |
Is |
Occurs when the value of the Is |
Is |
Occurs when the value of the Is |
Is |
Occurs when the value of the Is |
Is |
Occurs when the value of the Is |
Is |
Occurs when the value of the Is |
Key |
Occurs when a key is pressed while focus is on this element. Inherited from UIElement. |
Key |
Occurs when a key is released while focus is on this element. Inherited from UIElement. |
Layout |
Occurs when the layout of the various visual elements associated with the current Dispatcher changes. Inherited from UIElement. |
Loaded |
Occurs when the element is laid out, rendered, and ready for interaction.
Inherited from Framework |
Lost |
Occurs when this element loses logical focus. Inherited from UIElement. |
Lost |
Occurs when the keyboard is no longer focused on this element. Inherited from UIElement. |
Lost |
Occurs when this element loses mouse capture. Inherited from UIElement. |
Lost |
Occurs when this element loses stylus capture. Inherited from UIElement. |
Lost |
Occurs when this element loses a touch capture. Inherited from UIElement. |
Manipulation |
Occurs when the manipulation encounters a boundary. Inherited from UIElement. |
Manipulation |
Occurs when a manipulation and inertia on the UIElement object is complete. Inherited from UIElement. |
Manipulation |
Occurs when the input device changes position during a manipulation. Inherited from UIElement. |
Manipulation |
Occurs when the input device loses contact with the UIElement object during a manipulation and inertia begins. Inherited from UIElement. |
Manipulation |
Occurs when an input device begins a manipulation on the UIElement object. Inherited from UIElement. |
Manipulation |
Occurs when the manipulation processor is first created. Inherited from UIElement. |
Modified |
Occurs when the value of the Spreadsheet |
Mouse |
Occurs when a mouse button is clicked two or more times. Inherited from Control. |
Mouse |
Occurs when any mouse button is pressed while the pointer is over this element. Inherited from UIElement. |
Mouse |
Occurs when the mouse pointer enters the bounds of this element. Inherited from UIElement. |
Mouse |
Occurs when the mouse pointer leaves the bounds of this element. Inherited from UIElement. |
Mouse |
Occurs when the left mouse button is pressed while the mouse pointer is over this element. Inherited from UIElement. |
Mouse |
Occurs when the left mouse button is released while the mouse pointer is over this element. Inherited from UIElement. |
Mouse |
Occurs when the mouse pointer moves while over this element. Inherited from UIElement. |
Mouse |
Occurs when the right mouse button is pressed while the mouse pointer is over this element. Inherited from UIElement. |
Mouse |
Occurs when the right mouse button is released while the mouse pointer is over this element. Inherited from UIElement. |
Mouse |
Occurs when any mouse button is released over this element. Inherited from UIElement. |
Mouse |
Occurs when the user rotates the mouse wheel while the mouse pointer is over this element. Inherited from UIElement. |
Panes |
Occurs when freezing a worksheet area via the control’s UI. |
Panes |
Occurs when unfreezing a locked (frozen) worksheet area via the Spreadsheet |
Popup |
Allows you to customize the Spreadsheet control’s context menus. |
Preview |
Occurs when the input system reports an underlying drag event with this element as the drag target. Inherited from UIElement. |
Preview |
Occurs when the input system reports an underlying drag event with this element as the drag origin. Inherited from UIElement. |
Preview |
Occurs when the input system reports an underlying drag event with this element as the potential drop target. Inherited from UIElement. |
Preview |
Occurs when the input system reports an underlying drop event with this element as the drop target. Inherited from UIElement. |
Preview |
Occurs when a drag-and-drop operation is started. Inherited from UIElement. |
Preview |
Occurs when the keyboard is focused on this element. Inherited from UIElement. |
Preview |
Occurs when a key is pressed while focus is on this element. Inherited from UIElement. |
Preview |
Occurs when a key is released while focus is on this element. Inherited from UIElement. |
Preview |
Occurs when the keyboard is no longer focused on this element. Inherited from UIElement. |
Preview |
Occurs when a user clicks the mouse button two or more times. Inherited from Control. |
Preview |
Occurs when any mouse button is pressed while the pointer is over this element. Inherited from UIElement. |
Preview |
Occurs when the left mouse button is pressed while the mouse pointer is over this element. Inherited from UIElement. |
Preview |
Occurs when the left mouse button is released while the mouse pointer is over this element. Inherited from UIElement. |
Preview |
Occurs when the mouse pointer moves while the mouse pointer is over this element. Inherited from UIElement. |
Preview |
Occurs when the right mouse button is pressed while the mouse pointer is over this element. Inherited from UIElement. |
Preview |
Occurs when the right mouse button is released while the mouse pointer is over this element. Inherited from UIElement. |
Preview |
Occurs when any mouse button is released while the mouse pointer is over this element. Inherited from UIElement. |
Preview |
Occurs when the user rotates the mouse wheel while the mouse pointer is over this element. Inherited from UIElement. |
Preview |
Occurs when there is a change in the keyboard or mouse button state during a drag-and-drop operation. Inherited from UIElement. |
Preview |
Occurs when the stylus button is pressed while the pointer is over this element. Inherited from UIElement. |
Preview |
Occurs when the stylus button is released while the pointer is over this element. Inherited from UIElement. |
Preview |
Occurs when the stylus touches the digitizer while it is over this element. Inherited from UIElement. |
Preview |
Occurs when the stylus moves over an element without actually touching the digitizer. Inherited from UIElement. |
Preview |
Occurs when the stylus is close enough to the digitizer to be detected, while over this element. Inherited from UIElement. |
Preview |
Occurs when the stylus moves while over the element. The stylus must move while being detected by the digitizer to raise this event, otherwise, Preview |
Preview |
Occurs when the stylus is too far from the digitizer to be detected. Inherited from UIElement. |
Preview |
Occurs when a user performs one of several stylus gestures. Inherited from UIElement. |
Preview |
Occurs when the user raises the stylus off the digitizer while the stylus is over this element. Inherited from UIElement. |
Preview |
Occurs when this element gets text in a device-independent manner. Inherited from UIElement. |
Preview |
Occurs when a finger touches the screen while the finger is over this element. Inherited from UIElement. |
Preview |
Occurs when a finger moves on the screen while the finger is over this element. Inherited from UIElement. |
Preview |
Occurs when a finger is raised off of the screen while the finger is over this element. Inherited from UIElement. |
Property |
Occurs every time any of the Spreadsheet |
Protection |
Occurs when attempting to edit a locked cell in a protected worksheet. |
Query |
Occurs when there is a change in the keyboard or mouse button state during a drag-and-drop operation. Inherited from UIElement. |
Query |
Occurs when the cursor is requested to display. This event is raised on an element each time that the mouse pointer moves to a new location, which means the cursor object might need to be changed based on its new position. Inherited from UIElement. |
Range |
Occurs after the range content has been copied. |
Range |
Occurs before a cell range is copied in a worksheet. |
Read |
Occurs when the read-only state of the Spreadsheet |
Request |
Occurs when Bring |
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 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 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. |
Size |
Occurs when either the Actual |
Source |
Occurs when the source value changes for any existing property binding on this element.
Inherited from Framework |
Stylus |
Occurs when the stylus button is pressed while the pointer is over this element. Inherited from UIElement. |
Stylus |
Occurs when the stylus button is released while the pointer is over this element. Inherited from UIElement. |
Stylus |
Occurs when the stylus touches the digitizer while the stylus is over this element. Inherited from UIElement. |
Stylus |
Occurs when the stylus enters the bounds of this element. Inherited from UIElement. |
Stylus |
Occurs when the stylus moves over an element without actually touching the digitizer. Inherited from UIElement. |
Stylus |
Occurs when the stylus is close enough to the digitizer to be detected, while over this element. Inherited from UIElement. |
Stylus |
Occurs when the stylus leaves the bounds of the element. Inherited from UIElement. |
Stylus |
Occurs when the stylus moves over this element. The stylus must move while on the digitizer to raise this event. Otherwise, Stylus |
Stylus |
Occurs when the stylus is too far from the digitizer to be detected, while over this element. Inherited from UIElement. |
Stylus |
Occurs when a user performs one of several stylus gestures. Inherited from UIElement. |
Stylus |
Occurs when the user raises the stylus off the digitizer while it is over this element. Inherited from UIElement. |
Target |
Occurs when the target value changes for any property binding on this element.
Inherited from Framework |
Text |
Occurs when this element gets text in a device-independent manner. Inherited from UIElement. |
Tool |
Occurs just before any tooltip on the element is closed.
Inherited from Framework |
Tool |
Occurs when any tooltip on the element is opened.
Inherited from Framework |
Touch |
Occurs when a finger touches the screen while the finger is over this element. Inherited from UIElement. |
Touch |
Occurs when a touch moves from outside to inside the bounds of this element. Inherited from UIElement. |
Touch |
Occurs when a touch moves from inside to outside the bounds of this element. Inherited from UIElement. |
Touch |
Occurs when a finger moves on the screen while the finger is over this element. Inherited from UIElement. |
Touch |
Occurs when a finger is raised off of the screen while the finger is over this element. Inherited from UIElement. |
Unhandled |
This event is raised when an exception unhandled by the Spreadsheet |
Unit |
Fires after the Spreadsheet |
Unit |
Fires before the Spreadsheet |
Unloaded |
Occurs when the element is removed from within an element tree of loaded elements.
Inherited from Framework |
Update |
Raised when changes occur which may affect the control’s UI. |
Visible |
Occurs after the visible cell range was changed in the Spreadsheet control. |
Zoom |
Occurs when the current zoom level has been changed. |
See Also