[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand].NET Core 3 Support
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Expand]Controls and Libraries
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.Charts.Designer
  [Expand]DevExpress.Data
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.UI.Interactivity
  [Expand]DevExpress.Mvvm.UI.ModuleInjection
  [Expand]DevExpress.Xpf.Accordion
  [Expand]DevExpress.Xpf.Bars
  [Expand]DevExpress.Xpf.Carousel
  [Expand]DevExpress.Xpf.Charts
  [Expand]DevExpress.Xpf.Charts.Localization
  [Expand]DevExpress.Xpf.Charts.RangeControlClient
  [Expand]DevExpress.Xpf.ChunkList
  [Expand]DevExpress.Xpf.Controls
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Core.ConditionalFormatting
  [Expand]DevExpress.Xpf.Core.DataSources
  [Expand]DevExpress.Xpf.Core.FilteringUI
  [Expand]DevExpress.Xpf.Core.Native
  [Expand]DevExpress.Xpf.Core.ServerMode
  [Expand]DevExpress.Xpf.Data
  [Expand]DevExpress.Xpf.DataAccess
  [Expand]DevExpress.Xpf.DataAccess.DataSourceWizard
  [Expand]DevExpress.Xpf.Diagram
  [Expand]DevExpress.Xpf.Dialogs
  [Expand]DevExpress.Xpf.Docking
  [Expand]DevExpress.Xpf.Docking.Base
  [Expand]DevExpress.Xpf.DocumentViewer
  [Expand]DevExpress.Xpf.DXBinding
  [Expand]DevExpress.Xpf.Editors
  [Expand]DevExpress.Xpf.Editors.DataPager
  [Expand]DevExpress.Xpf.Editors.DateNavigator
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor.Native
  [Expand]DevExpress.Xpf.Editors.Filtering
  [Expand]DevExpress.Xpf.Editors.Flyout
  [Expand]DevExpress.Xpf.Editors.Flyout.Native
  [Expand]DevExpress.Xpf.Editors.Helpers
  [Expand]DevExpress.Xpf.Editors.Native
  [Expand]DevExpress.Xpf.Editors.Popups
  [Expand]DevExpress.Xpf.Editors.RangeControl
  [Expand]DevExpress.Xpf.Editors.Settings
  [Expand]DevExpress.Xpf.Editors.Validation
  [Expand]DevExpress.Xpf.ExpressionEditor
  [Expand]DevExpress.Xpf.Gantt
  [Expand]DevExpress.Xpf.Gauges
  [Expand]DevExpress.Xpf.Gauges.Localization
  [Expand]DevExpress.Xpf.Grid
  [Expand]DevExpress.Xpf.Grid.ConditionalFormatting
  [Expand]DevExpress.Xpf.Grid.LookUp
  [Expand]DevExpress.Xpf.Grid.TreeList
  [Expand]DevExpress.Xpf.Layout.Core
  [Expand]DevExpress.Xpf.LayoutControl
  [Expand]DevExpress.Xpf.Map
  [Expand]DevExpress.Xpf.NavBar
  [Expand]DevExpress.Xpf.Navigation
  [Expand]DevExpress.Xpf.PdfViewer
  [Expand]DevExpress.Xpf.PivotGrid
  [Expand]DevExpress.Xpf.PivotGrid.Printing
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpf.Printing.Parameters
  [Expand]DevExpress.Xpf.Printing.Parameters.Models
  [Expand]DevExpress.Xpf.Printing.PreviewControl
  [Expand]DevExpress.Xpf.Printing.PreviewControl.Bars
  [Expand]DevExpress.Xpf.Prism
  [Expand]DevExpress.Xpf.PropertyGrid
  [Expand]DevExpress.Xpf.Reports.UserDesigner
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Extensions
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Localization
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard.Pages
  [Expand]DevExpress.Xpf.Ribbon
  [Expand]DevExpress.Xpf.RichEdit
  [Expand]DevExpress.Xpf.RichEdit.Menu
  [Expand]DevExpress.Xpf.Scheduler
  [Expand]DevExpress.Xpf.Scheduler.Drawing
  [Expand]DevExpress.Xpf.Scheduler.Menu
  [Expand]DevExpress.Xpf.Scheduler.Reporting
  [Expand]DevExpress.Xpf.Scheduler.UI
  [Expand]DevExpress.Xpf.Scheduling
  [Expand]DevExpress.Xpf.Scheduling.Common
  [Expand]DevExpress.Xpf.Scheduling.Editors
  [Expand]DevExpress.Xpf.Scheduling.iCalendar
  [Expand]DevExpress.Xpf.Scheduling.Reporting
  [Expand]DevExpress.Xpf.Scheduling.Visual
  [Expand]DevExpress.Xpf.Scheduling.VisualData
  [Expand]DevExpress.Xpf.SpellChecker
  [Collapse]DevExpress.Xpf.Spreadsheet
   [Expand]CellData Class
    CommandBarStyle Enumeration
    NameBoxItemDisplayMode Enumeration
    ShowCellToolTipMode Enumeration
   [Expand]SpreadsheetAxisLabelOverlappingOptions Class
   [Expand]SpreadsheetBehaviorOptions Class
   [Expand]SpreadsheetCapabilitiesOptions Class
   [Expand]SpreadsheetCellOptions Class
   [Expand]SpreadsheetClipboardOptions Class
   [Expand]SpreadsheetColumnBehaviorOptions Class
   [Expand]SpreadsheetCommentBehaviorOptions Class
   [Collapse]SpreadsheetControl Class
     SpreadsheetControl Members
     SpreadsheetControl Constructor
    [Expand]SpreadsheetControl Properties
    [Collapse]SpreadsheetControl Events
      ActiveSheetChanged Event
      ActiveSheetChanging Event
      AfterDropRange Event
      AfterFillRange Event
      BeforeDispose Event
      BeforeDragRange Event
      BeforeDropRange Event
      BeforeExport Event
      BeforeFillRange Event
      BeforeImport Event
      BeforePrintSheet Event
      CellBeginEdit Event
      CellCancelEdit Event
      CellEndEdit Event
      CellValueChanged Event
      ClipboardDataObtained Event
      ClipboardDataPasted Event
      ClipboardDataPasting Event
      ColumnsInserted Event
      ColumnsInserting Event
      ColumnsRemoved Event
      ColumnsRemoving Event
      CommentInserted Event
      CommentInserting Event
      CommentRemoved Event
      CommentRemoving Event
      ContentChanged Event
      CopiedRangePasted Event
      CopiedRangePasting Event
      CustomAssemblyLoading Event
      CustomCellEdit Event
      DataBindingWarning Event
      DefinedNameConflictResolving Event
      DefinedNameDeleting Event
      DefinedNameEditing Event
      DefinedNameValidating Event
      DocumentClosing Event
      DocumentLoaded Event
      DocumentPropertiesChanged Event
      DocumentSaved Event
      EmptyDocumentCreated Event
      EncryptedFileIntegrityCheckFailed Event
      EncryptedFilePasswordCheckFailed Event
      EncryptedFilePasswordRequest Event
      HyperlinkClick Event
      InitializeDocument Event
      InvalidFormatException Event
      ModifiedChanged Event
      PanesFrozen Event
      PanesUnfrozen Event
      PopupMenuShowing Event
      PropertyChanged Event
      ProtectionWarning Event
      RangeCopied Event
      RangeCopying Event
      ReadOnlyChanged Event
      RowsInserted Event
      RowsInserting Event
      RowsRemoved Event
      RowsRemoving Event
      ScrollPositionChanged Event
      SelectionChanged Event
      ShapeInserted Event
      ShapeRemoved Event
      ShapeRemoving Event
      ShapesCopying Event
      SheetInserted Event
      SheetRemoved Event
      SheetRemoving Event
      SheetRenamed Event
      SheetRenaming Event
      UnhandledException Event
      UnitChanged Event
      UnitChanging Event
      UpdateUI Event
      VisibleRangeChanged Event
      ZoomChanged Event
    [Expand]SpreadsheetControl Methods
   [Expand]SpreadsheetControlOptions Class
   [Expand]SpreadsheetCopyOptions Class
   [Expand]SpreadsheetCsvExportOptions Class
   [Expand]SpreadsheetCsvImportOptions Class
   [Expand]SpreadsheetCustomCellEditEventArgs Class
    SpreadsheetCustomCellEditEventHandler Delegate
   [Expand]SpreadsheetDataValidationBehaviorOptions Class
   [Expand]SpreadsheetDocumentSource Class
   [Expand]SpreadsheetDrawingBehaviorOptions Class
    SpreadsheetElementVisibility Enumeration
   [Expand]SpreadsheetExportOptions Class
   [Expand]SpreadsheetFormulaAutoCompleteOptions Class
    SpreadsheetFormulaAutoCompleteSearchMode Enumeration
   [Expand]SpreadsheetFormulaBarControl Class
   [Expand]SpreadsheetGroupBehaviorOptions Class
   [Expand]SpreadsheetImportOptions Class
    SpreadsheetMenuType Enumeration
   [Expand]SpreadsheetOpenXmlImportOptions Class
   [Expand]SpreadsheetPivotTableFieldListOptions Class
    SpreadsheetPivotTableFieldListStartPosition Enumeration
   [Expand]SpreadsheetProtectionBehaviorOptions Class
   [Expand]SpreadsheetRealTimeDataOptions Class
   [Expand]SpreadsheetRowBehaviorOptions Class
   [Expand]SpreadsheetSaveOptions Class
   [Expand]SpreadsheetSelectionBehaviorOptions Class
   [Expand]SpreadsheetTxtExportOptions Class
   [Expand]SpreadsheetTxtImportOptions Class
   [Expand]SpreadsheetViewOptions Class
   [Expand]SpreadsheetWorksheetBehaviorOptions Class
   [Expand]SpreadsheetXlsImportOptions Class
   [Expand]SpreadsheetXlsmImportOptions Class
   [Expand]WorksheetDisplayArea Class
  [Expand]DevExpress.Xpf.Spreadsheet.Menu
  [Expand]DevExpress.Xpf.TreeMap
  [Expand]DevExpress.Xpf.Utils.Themes
  [Expand]DevExpress.Xpf.WindowsUI
  [Expand]DevExpress.Xpf.WindowsUI.Internal
  [Expand]DevExpress.Xpf.WindowsUI.Navigation
  [Expand]DevExpress.XtraRichEdit
  [Expand]DevExpress.XtraRichEdit.Printing
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

SpreadsheetControl Events

Emulates the Microsoft® Excel® look and feel and allows you to create, load, edit, save and print spreadsheet documents.

Expanded Public Events

Show: Inherited
  Name Description
Public event ActiveSheetChanged Occurs after an active worksheet in a workbook has been changed.
Public event ActiveSheetChanging Occurs when an active worksheet in a workbook is about to be changed.
Public event AfterDropRange Occurs after a user dropped the selected cell range in a new location.
Public event AfterFillRange Occurs after a cell range was automatically filled with data based on values in the source range.
Public event BeforeDispose Occurs before the SpreadsheetControl control is released from memory.
Public event BeforeDragRange Occurs when a user starts to drag the selected cell range.
Public event BeforeDropRange Occurs when a user is about to drop the selected cell range in a new location.
Public event BeforeExport Occurs before the document is saved (exported to a certain format).
Public event BeforeFillRange Occurs when a user drags the fill handle to populate cells with data based on values in the source range.
Public event BeforeImport Occurs before a document is loaded (imported from an external source).
Public event BeforePrintSheet Provides the capability to prevent printing of the required worksheets in a workbook.
Public event CellBeginEdit Occurs before a cell editor is opened.
Public event CellCancelEdit Occurs before the cell editor is closed and the entered value is rolled back.
Public event CellEndEdit Occurs before a cell editor is closed.
Public event CellValueChanged Occurs after a cell value has been changed.
Public event ClipboardDataObtained Occurs after data on the clipboard is obtained and recognized, but before data is pasted.
Public event ClipboardDataPasted Occurs after data was pasted from the clipboard onto a worksheet.
Public event ClipboardDataPasting Occurs before data is pasted into destination cells.
Public event ColumnsInserted Occurs after new columns have been inserted into a worksheet.
Public event ColumnsInserting Occurs when new columns are about to be inserted into a worksheet.
Public event ColumnsRemoved Occurs after columns have been deleted from a worksheet.
Public event ColumnsRemoving Occurs when columns are about to be deleted from a worksheet.
Public event CommentInserted Occurs when a comment is inserted.
Public event CommentInserting Occurs before inserting a comment.
Public event CommentRemoved Occurs when a comment is deleted.
Public event CommentRemoving Occurs before deleting a comment.
Public event ContentChanged Occurs when the document content was changed.
Public event ContextMenuClosing Occurs just before any context menu on the element is closed. (Inherited from System.Windows.FrameworkElement)
Public event ContextMenuOpening Occurs when any context menu on the element is opened. (Inherited from System.Windows.FrameworkElement)
Public event CopiedRangePasted Occurs after the range content has been pasted into target cells.
Public event CopiedRangePasting Occurs before the range content is pasted into target cells.
Public event CustomAssemblyLoading Occurs before a custom assembly is loaded for use as the Entity Framework data source and allows canceling loading.
Public event CustomCellEdit Allows you to assign a custom in-place editor to a cell.
Public event DataBindingWarning Occurs before a data binding warning dialog is shown in the SpreadsheetControl.
Public event DataContextChanged Occurs when the data context for this element changes. (Inherited from System.Windows.FrameworkElement)
Public event DefinedNameConflictResolving Occurs when a formula or sheet being moved or copied contains a defined name which already exists on the destination worksheet or workbook.
Public event DefinedNameDeleting Occurs before a Defined Name is deleted.
Public event DefinedNameEditing Occurs before a Defined Name is being edited.
Public event DefinedNameValidating Occurs when a new Defined Name is created before it is added to a collection.
Public event DocumentClosing Occurs when a document that has not yet been saved is about to be closed.
Public event DocumentLoaded Occurs after a document is loaded into the Spreadsheet control.
Public event DocumentPropertiesChanged Occurs after one of the DevExpress.Spreadsheet.DocumentProperties is changed.
Public event DocumentSaved Occurs after a document has been saved.
Public event DragEnter Occurs when the input system reports an underlying drag event with this element as the drag target. (Inherited from System.Windows.UIElement)
Public event DragLeave Occurs when the input system reports an underlying drag event with this element as the drag origin. (Inherited from System.Windows.UIElement)
Public event DragOver Occurs when the input system reports an underlying drag event with this element as the potential drop target. (Inherited from System.Windows.UIElement)
Public event Drop Occurs when the input system reports an underlying drop event with this element as the drop target. (Inherited from System.Windows.UIElement)
Public event EmptyDocumentCreated Occurs when a new document is created in the Spreadsheet control.
Public event EncryptedFileIntegrityCheckFailed Raises when the encrypted file did not pass the data integrity verification.
Public event EncryptedFilePasswordCheckFailed Occurs when the encryption password is empty or invalid.
Public event EncryptedFilePasswordRequest Raises when the DevExpress.XtraSpreadsheet.Import.WorkbookImportOptions.Password property is not set or contains a wrong password.
Public event FocusableChanged Occurs when the value of the System.Windows.UIElement.Focusable property changes. (Inherited from System.Windows.UIElement)
Public event GiveFeedback Occurs when the input system reports an underlying drag-and-drop event that involves this element. (Inherited from System.Windows.UIElement)
Public event GotFocus Occurs when this element gets logical focus. (Inherited from System.Windows.UIElement)
Public event GotKeyboardFocus Occurs when the keyboard is focused on this element. (Inherited from System.Windows.UIElement)
Public event GotMouseCapture Occurs when this element captures the mouse. (Inherited from System.Windows.UIElement)
Public event GotStylusCapture Occurs when this element captures the stylus. (Inherited from System.Windows.UIElement)
Public event GotTouchCapture (Inherited from System.Windows.UIElement)
Public event HyperlinkClick Occurs when an end-user clicks the hyperlink to activate it.
Public event Initialized Occurs when this System.Windows.FrameworkElement is initialized. This event coincides with cases where the value of the System.Windows.FrameworkElement.IsInitialized property changes from false (or undefined) to true. (Inherited from System.Windows.FrameworkElement)
Public event InitializeDocument Occurs before a document is loaded. Handle this event to set initial document settings.
Public event InvalidFormatException Fires when the supplied data could not be recognized as data in the assumed format for import.
Public event IsEnabledChanged Occurs when the value of the System.Windows.UIElement.IsEnabled property on this element changes. (Inherited from System.Windows.UIElement)
Public event IsHitTestVisibleChanged Occurs when the value of the System.Windows.UIElement.IsHitTestVisible dependency property changes on this element. (Inherited from System.Windows.UIElement)
Public event IsKeyboardFocusedChanged Occurs when the value of the System.Windows.UIElement.IsKeyboardFocused property changes on this element. (Inherited from System.Windows.UIElement)
Public event IsKeyboardFocusWithinChanged Occurs when the value of the System.Windows.UIElement.IsKeyboardFocusWithinChanged property changes on this element. (Inherited from System.Windows.UIElement)
Public event IsMouseCapturedChanged Occurs when the value of the System.Windows.UIElement.IsMouseCaptured property changes on this element. (Inherited from System.Windows.UIElement)
Public event IsMouseCaptureWithinChanged Occurs when the value of the System.Windows.UIElement.IsMouseCaptureWithinProperty changes on this element. (Inherited from System.Windows.UIElement)
Public event IsMouseDirectlyOverChanged Occurs when the value of the System.Windows.UIElement.IsMouseDirectlyOver property changes on this element. (Inherited from System.Windows.UIElement)
Public event IsStylusCapturedChanged Occurs when the value of the System.Windows.UIElement.IsStylusCaptured property changes on this element. (Inherited from System.Windows.UIElement)
Public event IsStylusCaptureWithinChanged Occurs when the value of the System.Windows.UIElement.IsStylusCaptureWithin property changes on this element. (Inherited from System.Windows.UIElement)
Public event IsStylusDirectlyOverChanged Occurs when the value of the System.Windows.UIElement.IsStylusDirectlyOver property changes on this element. (Inherited from System.Windows.UIElement)
Public event IsVisibleChanged Occurs when the value of the System.Windows.UIElement.IsVisible property changes on this element. (Inherited from System.Windows.UIElement)
Public event KeyDown Occurs when a key is pressed while focus is on this element. (Inherited from System.Windows.UIElement)
Public event KeyUp Occurs when a key is released while focus is on this element. (Inherited from System.Windows.UIElement)
Public event LayoutUpdated Occurs when the layout of the various visual elements associated with the current System.Windows.Threading.Dispatcher changes. (Inherited from System.Windows.UIElement)
Public event Loaded Occurs when the element is laid out, rendered, and ready for interaction. (Inherited from System.Windows.FrameworkElement)
Public event LostFocus Occurs when this element loses logical focus. (Inherited from System.Windows.UIElement)
Public event LostKeyboardFocus Occurs when the keyboard is no longer focused on this element,. (Inherited from System.Windows.UIElement)
Public event LostMouseCapture Occurs when this element loses mouse capture. (Inherited from System.Windows.UIElement)
Public event LostStylusCapture Occurs when this element loses stylus capture. (Inherited from System.Windows.UIElement)
Public event LostTouchCapture (Inherited from System.Windows.UIElement)
Public event ManipulationBoundaryFeedback (Inherited from System.Windows.UIElement)
Public event ManipulationCompleted (Inherited from System.Windows.UIElement)
Public event ManipulationDelta (Inherited from System.Windows.UIElement)
Public event ManipulationInertiaStarting (Inherited from System.Windows.UIElement)
Public event ManipulationStarted (Inherited from System.Windows.UIElement)
Public event ManipulationStarting (Inherited from System.Windows.UIElement)
Public event ModifiedChanged Occurs when the value of the Modified property is changed.
Public event MouseDoubleClick Occurs when a mouse button is clicked two or more times. (Inherited from System.Windows.Controls.Control)
Public event MouseDown Occurs when any mouse button is pressed while the pointer is over this element. (Inherited from System.Windows.UIElement)
Public event MouseEnter Occurs when the mouse pointer enters the bounds of this element. (Inherited from System.Windows.UIElement)
Public event MouseLeave Occurs when the mouse pointer leaves the bounds of this element. (Inherited from System.Windows.UIElement)
Public event MouseLeftButtonDown Occurs when the left mouse button is pressed while the mouse pointer is over this element. (Inherited from System.Windows.UIElement)
Public event MouseLeftButtonUp Occurs when the left mouse button is released while the mouse pointer is over this element. (Inherited from System.Windows.UIElement)
Public event MouseMove Occurs when the mouse pointer moves while over this element. (Inherited from System.Windows.UIElement)
Public event MouseRightButtonDown Occurs when the right mouse button is pressed while the mouse pointer is over this element. (Inherited from System.Windows.UIElement)
Public event MouseRightButtonUp Occurs when the right mouse button is released while the mouse pointer is over this element. (Inherited from System.Windows.UIElement)
Public event MouseUp Occurs when any mouse button is released over this element. (Inherited from System.Windows.UIElement)
Public event MouseWheel Occurs when the user rotates the mouse wheel while the mouse pointer is over this element. (Inherited from System.Windows.UIElement)
Public event PanesFrozen Occurs when freezing a worksheet area via the control's UI.
Public event PanesUnfrozen Occurs when unfreezing a locked (frozen) worksheet area via the SpreadsheetControl UI.
Public event PopupMenuShowing Occurs before a popup menu is created for the control's document whenever a context menu is being invoked.
Public event PreviewDragEnter Occurs when the input system reports an underlying drag event with this element as the drag target. (Inherited from System.Windows.UIElement)
Public event PreviewDragLeave Occurs when the input system reports an underlying drag event with this element as the drag origin. (Inherited from System.Windows.UIElement)
Public event PreviewDragOver Occurs when the input system reports an underlying drag event with this element as the potential drop target. (Inherited from System.Windows.UIElement)
Public event PreviewDrop Occurs when the input system reports an underlying drop event with this element as the drop target. (Inherited from System.Windows.UIElement)
Public event PreviewGiveFeedback Occurs when a drag-and-drop operation is started. (Inherited from System.Windows.UIElement)
Public event PreviewGotKeyboardFocus Occurs when the keyboard is focused on this element. (Inherited from System.Windows.UIElement)
Public event PreviewKeyDown Occurs when a key is pressed while focus is on this element. (Inherited from System.Windows.UIElement)
Public event PreviewKeyUp Occurs when a key is released while focus is on this element. (Inherited from System.Windows.UIElement)
Public event PreviewLostKeyboardFocus Occurs when the keyboard is no longer focused on this element. (Inherited from System.Windows.UIElement)
Public event PreviewMouseDoubleClick Occurs when a user clicks the mouse button two or more times. (Inherited from System.Windows.Controls.Control)
Public event PreviewMouseDown Occurs when any mouse button is pressed while the pointer is over this element. (Inherited from System.Windows.UIElement)
Public event PreviewMouseLeftButtonDown Occurs when the left mouse button is pressed while the mouse pointer is over this element. (Inherited from System.Windows.UIElement)
Public event PreviewMouseLeftButtonUp Occurs when the left mouse button is released while the mouse pointer is over this element. (Inherited from System.Windows.UIElement)
Public event PreviewMouseMove Occurs when the mouse pointer moves while the mouse pointer is over this element. (Inherited from System.Windows.UIElement)
Public event PreviewMouseRightButtonDown Occurs when the right mouse button is pressed while the mouse pointer is over this element. (Inherited from System.Windows.UIElement)
Public event PreviewMouseRightButtonUp Occurs when the right mouse button is released while the mouse pointer is over this element. (Inherited from System.Windows.UIElement)
Public event PreviewMouseUp Occurs when any mouse button is released while the mouse pointer is over this element. (Inherited from System.Windows.UIElement)
Public event PreviewMouseWheel Occurs when the user rotates the mouse wheel while the mouse pointer is over this element. (Inherited from System.Windows.UIElement)
Public event PreviewQueryContinueDrag Occurs when there is a change in the keyboard or mouse button state during a drag-and-drop operation. (Inherited from System.Windows.UIElement)
Public event PreviewStylusButtonDown Occurs when the stylus button is pressed while the pointer is over this element. (Inherited from System.Windows.UIElement)
Public event PreviewStylusButtonUp Occurs when the stylus button is released while the pointer is over this element. (Inherited from System.Windows.UIElement)
Public event PreviewStylusDown Occurs when the stylus touches the digitizer while it is over this element. (Inherited from System.Windows.UIElement)
Public event PreviewStylusInAirMove Occurs when the stylus moves over an element without actually touching the digitizer. (Inherited from System.Windows.UIElement)
Public event PreviewStylusInRange Occurs when the stylus is close enough to the digitizer to be detected, while over this element. (Inherited from System.Windows.UIElement)
Public event PreviewStylusMove Occurs when the stylus moves while over the element. The stylus must move while being detected by the digitizer to raise this event, otherwise, System.Windows.UIElement.PreviewStylusInAirMove is raised instead. (Inherited from System.Windows.UIElement)
Public event PreviewStylusOutOfRange Occurs when the stylus is too far from the digitizer to be detected. (Inherited from System.Windows.UIElement)
Public event PreviewStylusSystemGesture Occurs when a user performs one of several stylus gestures. (Inherited from System.Windows.UIElement)
Public event PreviewStylusUp Occurs when the user raises the stylus off the digitizer while the stylus is over this element. (Inherited from System.Windows.UIElement)
Public event PreviewTextInput Occurs when this element gets text in a device-independent manner. (Inherited from System.Windows.UIElement)
Public event PreviewTouchDown (Inherited from System.Windows.UIElement)
Public event PreviewTouchMove (Inherited from System.Windows.UIElement)
Public event PreviewTouchUp (Inherited from System.Windows.UIElement)
Public event PropertyChanged Occurs every time any of the SpreadsheetControl class properties has changed its value.
Public event ProtectionWarning Occurs when attempting to edit a locked cell in a protected worksheet.
Public event QueryContinueDrag Occurs when there is a change in the keyboard or mouse button state during a drag-and-drop operation. (Inherited from System.Windows.UIElement)
Public event QueryCursor 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 System.Windows.UIElement)
Public event RangeCopied Occurs after the range content has been copied.
Public event RangeCopying Occurs before a cell range is copied in a worksheet.
Public event ReadOnlyChanged Occurs when the read-only state of the SpreadsheetControl control is changed.
Public event RequestBringIntoView Occurs when System.Windows.FrameworkElement.BringIntoView is called on this element. (Inherited from System.Windows.FrameworkElement)
Public event RowsInserted Occurs after new rows have been added to a worksheet.
Public event RowsInserting Occurs when new rows are about to be inserted into a worksheet.
Public event RowsRemoved Occurs after rows have been deleted from a worksheet.
Public event RowsRemoving Occurs when rows are about to be deleted from a worksheet.
Public event ScrollPositionChanged Occurs when a worksheet is being scrolled in the SpreadsheetControl's UI.
Public event SelectionChanged Fires when the selection changes in an active worksheet.
Public event ShapeInserted Occurs after a drawing object has been inserted into a worksheet.
Public event ShapeRemoved Occurs after a drawing object has been removed from a worksheet.
Public event ShapeRemoving Occurs before a drawing object is removed from a worksheet.
Public event ShapesCopying Occurs before a drawing object is copied in a worksheet.
Public event SheetInserted Occurs after a new worksheet has been added to a workbook.
Public event SheetRemoved Occurs after a worksheet has been removed from a workbook.
Public event SheetRemoving Occurs when a worksheet is about to be removed from a workbook.
Public event SheetRenamed Occurs after a worksheet has been renamed.
Public event SheetRenaming Occurs when a worksheet is about to be renamed.
Public event SizeChanged Occurs when either the System.Windows.FrameworkElement.ActualHeight or the System.Windows.FrameworkElement.ActualWidth properties change value on this element. (Inherited from System.Windows.FrameworkElement)
Public event SourceUpdated Occurs when the source value changes for any existing property binding on this element. (Inherited from System.Windows.FrameworkElement)
Public event StylusButtonDown Occurs when the stylus button is pressed while the pointer is over this element. (Inherited from System.Windows.UIElement)
Public event StylusButtonUp Occurs when the stylus button is released while the pointer is over this element. (Inherited from System.Windows.UIElement)
Public event StylusDown Occurs when the stylus touches the digitizer while the stylus is over this element. (Inherited from System.Windows.UIElement)
Public event StylusEnter Occurs when the stylus enters the bounds of this element. (Inherited from System.Windows.UIElement)
Public event StylusInAirMove Occurs when the stylus moves over an element without actually touching the digitizer. (Inherited from System.Windows.UIElement)
Public event StylusInRange Occurs when the stylus is close enough to the digitizer to be detected, while over this element. (Inherited from System.Windows.UIElement)
Public event StylusLeave Occurs when the stylus leaves the bounds of the element. (Inherited from System.Windows.UIElement)
Public event StylusMove Occurs when the stylus moves over this element. The stylus must move while on the digitizer to raise this event. Otherwise, System.Windows.UIElement.StylusInAirMove is raised instead. (Inherited from System.Windows.UIElement)
Public event StylusOutOfRange Occurs when the stylus is too far from the digitizer to be detected, while over this element. (Inherited from System.Windows.UIElement)
Public event StylusSystemGesture Occurs when a user performs one of several stylus gestures. (Inherited from System.Windows.UIElement)
Public event StylusUp Occurs when the user raises the stylus off the digitizer while it is over this element. (Inherited from System.Windows.UIElement)
Public event TargetUpdated Occurs when the target value changes for any property binding on this element. (Inherited from System.Windows.FrameworkElement)
Public event TextInput Occurs when this element gets text in a device-independent manner. (Inherited from System.Windows.UIElement)
Public event ToolTipClosing Occurs just before any tooltip on the element is closed. (Inherited from System.Windows.FrameworkElement)
Public event ToolTipOpening Occurs when any tooltip on the element is opened. (Inherited from System.Windows.FrameworkElement)
Public event TouchDown (Inherited from System.Windows.UIElement)
Public event TouchEnter (Inherited from System.Windows.UIElement)
Public event TouchLeave (Inherited from System.Windows.UIElement)
Public event TouchMove (Inherited from System.Windows.UIElement)
Public event TouchUp (Inherited from System.Windows.UIElement)
Public event UnhandledException This event is raised when an exception unhandled by the SpreadsheetControl occurs.
Public event UnitChanged Fires after the SpreadsheetControl.Unit property is changed.
Public event UnitChanging Fires before the SpreadsheetControl.Unit property is changed.
Public event Unloaded Occurs when the element is removed from within an element tree of loaded elements. (Inherited from System.Windows.FrameworkElement)
Public event UpdateUI Raised when changes occur which may affect the control's UI.
Public event VisibleRangeChanged Occurs after the visible cell range was changed in the Spreadsheet control.
Public event ZoomChanged Occurs when the current zoom level has been changed.
Top

Expanded See Also

Is this topic helpful?​​​​​​​