Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Expand]Controls and Libraries
 [Expand]Common Features
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.DataAccess.UI.Design
  [Expand]DevExpress.DataAccess.UI.EntityFramework
  [Expand]DevExpress.DataAccess.UI.Excel
  [Expand]DevExpress.DataAccess.UI.Localization
  [Expand]DevExpress.DataAccess.UI.ObjectBinding
  [Expand]DevExpress.DataAccess.UI.Sql
  [Expand]DevExpress.DataAccess.UI.Wizard
  [Expand]DevExpress.DataAccess.UI.Wizard.Services
  [Expand]DevExpress.DataAccess.UI.Wizard.Views
  [Expand]DevExpress.DocumentView
  [Expand]DevExpress.DocumentView.Controls
  [Expand]DevExpress.LookAndFeel
  [Expand]DevExpress.LookAndFeel.Helpers
  [Expand]DevExpress.Skins
  [Expand]DevExpress.Snap
  [Expand]DevExpress.Snap.API.Native
  [Expand]DevExpress.Snap.Core
  [Expand]DevExpress.Snap.Core.API
  [Expand]DevExpress.Snap.Core.Fields
  [Expand]DevExpress.Snap.Core.Forms
  [Expand]DevExpress.Snap.Core.Options
  [Expand]DevExpress.Snap.Core.Services
  [Expand]DevExpress.Snap.Extensions
  [Expand]DevExpress.Snap.Extensions.Localization
  [Expand]DevExpress.Snap.Localization
  [Expand]DevExpress.Snap.Options
  [Expand]DevExpress.Snap.Services
  [Expand]DevExpress.Utils
  [Expand]DevExpress.Utils.Animation
  [Expand]DevExpress.Utils.Controls
  [Expand]DevExpress.Utils.Drawing
  [Expand]DevExpress.Utils.Menu
  [Expand]DevExpress.Utils.Taskbar
  [Expand]DevExpress.Utils.Taskbar.Core
  [Expand]DevExpress.Utils.UI.Localization
  [Expand]DevExpress.Utils.VisualEffects
  [Expand]DevExpress.Utils.Win
  [Expand]DevExpress.XtraBars
  [Expand]DevExpress.XtraBars.Alerter
  [Expand]DevExpress.XtraBars.Docking
  [Expand]DevExpress.XtraBars.Docking2010
  [Expand]DevExpress.XtraBars.Docking2010.Customization
  [Expand]DevExpress.XtraBars.Docking2010.Views
  [Expand]DevExpress.XtraBars.Docking2010.Views.NativeMdi
  [Expand]DevExpress.XtraBars.Docking2010.Views.Tabbed
  [Expand]DevExpress.XtraBars.Docking2010.Views.Widget
  [Expand]DevExpress.XtraBars.Docking2010.Views.WindowsUI
  [Expand]DevExpress.XtraBars.Localization
  [Expand]DevExpress.XtraBars.Navigation
  [Expand]DevExpress.XtraBars.Ribbon
  [Expand]DevExpress.XtraBars.Ribbon.Gallery
  [Expand]DevExpress.XtraBars.Ribbon.ViewInfo
  [Expand]DevExpress.XtraBars.ToastNotifications
  [Expand]DevExpress.XtraBars.Utils
  [Expand]DevExpress.XtraBars.WinRTLiveTiles
  [Expand]DevExpress.XtraCharts
  [Expand]DevExpress.XtraCharts.Designer
  [Expand]DevExpress.XtraCharts.Wizard
  [Expand]DevExpress.XtraDataLayout
  [Expand]DevExpress.XtraDiagram
  [Expand]DevExpress.XtraDiagram.Options
  [Expand]DevExpress.XtraEditors
  [Expand]DevExpress.XtraEditors.ButtonPanel
  [Expand]DevExpress.XtraEditors.Calendar
  [Expand]DevExpress.XtraEditors.Camera
  [Expand]DevExpress.XtraEditors.Container
  [Expand]DevExpress.XtraEditors.Controls
  [Expand]DevExpress.XtraEditors.CustomEditor
  [Expand]DevExpress.XtraEditors.DXErrorProvider
  [Expand]DevExpress.XtraEditors.Filtering
  [Expand]DevExpress.XtraEditors.Mask
  [Expand]DevExpress.XtraEditors.Persistent
  [Expand]DevExpress.XtraEditors.Repository
  [Expand]DevExpress.XtraEditors.ViewInfo
  [Expand]DevExpress.XtraFilterEditor
  [Expand]DevExpress.XtraGauges.Presets.Styles
  [Expand]DevExpress.XtraGauges.Win
  [Expand]DevExpress.XtraGauges.Win.Base
  [Expand]DevExpress.XtraGauges.Win.Gauges.Circular
  [Expand]DevExpress.XtraGauges.Win.Gauges.Digital
  [Expand]DevExpress.XtraGauges.Win.Gauges.Linear
  [Expand]DevExpress.XtraGauges.Win.Gauges.State
  [Expand]DevExpress.XtraGrid
  [Expand]DevExpress.XtraGrid.Columns
  [Expand]DevExpress.XtraGrid.EditForm
  [Expand]DevExpress.XtraGrid.FilterEditor
  [Expand]DevExpress.XtraGrid.Localization
  [Expand]DevExpress.XtraGrid.Views.BandedGrid
  [Expand]DevExpress.XtraGrid.Views.BandedGrid.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Base
  [Expand]DevExpress.XtraGrid.Views.Base.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Card
  [Expand]DevExpress.XtraGrid.Views.Card.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Grid
  [Expand]DevExpress.XtraGrid.Views.Grid.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Layout
  [Expand]DevExpress.XtraGrid.Views.Layout.Events
  [Expand]DevExpress.XtraGrid.Views.Layout.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Printing
  [Expand]DevExpress.XtraGrid.Views.Tile
  [Expand]DevExpress.XtraGrid.Views.WinExplorer
  [Expand]DevExpress.XtraGrid.WinExplorer
  [Expand]DevExpress.XtraLayout
  [Expand]DevExpress.XtraLayout.Customization
  [Expand]DevExpress.XtraLayout.HitInfo
  [Expand]DevExpress.XtraLayout.Localization
  [Expand]DevExpress.XtraLayout.Utils
  [Expand]DevExpress.XtraMap
  [Expand]DevExpress.XtraMap.Printing
  [Expand]DevExpress.XtraNavBar
  [Expand]DevExpress.XtraNavBar.ViewInfo
  [Expand]DevExpress.XtraPdfViewer
  [Expand]DevExpress.XtraPdfViewer.Commands
  [Expand]DevExpress.XtraPdfViewer.Localization
  [Expand]DevExpress.XtraPivotGrid
  [Expand]DevExpress.XtraPivotGrid.Data
  [Expand]DevExpress.XtraPrinting
  [Expand]DevExpress.XtraPrinting.Control
  [Expand]DevExpress.XtraPrinting.Preview
  [Expand]DevExpress.XtraPrintingLinks
  [Expand]DevExpress.XtraReports.UI
  [Expand]DevExpress.XtraRichEdit
  [Expand]DevExpress.XtraRichEdit.Commands
  [Expand]DevExpress.XtraRichEdit.Export
  [Expand]DevExpress.XtraRichEdit.Import
  [Expand]DevExpress.XtraRichEdit.Localization
  [Expand]DevExpress.XtraRichEdit.Menu
  [Expand]DevExpress.XtraScheduler
  [Expand]DevExpress.XtraScheduler.Drawing
  [Expand]DevExpress.XtraScheduler.Printing
  [Expand]DevExpress.XtraScheduler.Reporting
  [Expand]DevExpress.XtraScheduler.Reporting.UI
  [Expand]DevExpress.XtraScheduler.Services
  [Expand]DevExpress.XtraScheduler.Services.Implementation
  [Expand]DevExpress.XtraScheduler.UI
  [Expand]DevExpress.XtraSpellChecker
  [Expand]DevExpress.XtraSpellChecker.Localization
  [Expand]DevExpress.XtraSplashForm
  [Expand]DevExpress.XtraSplashScreen
  [Collapse]DevExpress.XtraSpreadsheet
   [Expand]CustomDrawCellBackgroundEventArgs Class
    CustomDrawCellBackgroundEventHandler Delegate
   [Expand]CustomDrawCellEventArgs Class
   [Expand]CustomDrawCellEventArgsBase Class
    CustomDrawCellEventHandler Delegate
   [Expand]CustomDrawColumnHeaderBackgroundEventArgs Class
    CustomDrawColumnHeaderBackgroundEventHandler Delegate
   [Expand]CustomDrawColumnHeaderEventArgs Class
    CustomDrawColumnHeaderEventHandler Delegate
   [Expand]CustomDrawFrozenPaneBorderEventArgs Class
    CustomDrawFrozenPaneBorderEventHandler Delegate
   [Expand]CustomDrawHeaderEventArgsBase Class
   [Expand]CustomDrawObjectEventsArgs Class
   [Expand]CustomDrawRowHeaderBackgroundEventArgs Class
    CustomDrawRowHeaderBackgroundEventHandler Delegate
   [Expand]CustomDrawRowHeaderEventArgs Class
    CustomDrawRowHeaderEventHandler Delegate
    FrozenPaneBorderType Enumeration
   [Expand]PopupMenuShowingEventArgs Class
    PopupMenuShowingEventHandler Delegate
   [Collapse]SpreadsheetControl Class
     SpreadsheetControl Members
     SpreadsheetControl Constructor
    [Expand]SpreadsheetControl Properties
    [Collapse]SpreadsheetControl Events
      ActiveSheetChanged Event
      ActiveSheetChanging Event
      BeforeDispose Event
      BeforeExport 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
      CustomDrawCell Event
      CustomDrawCellBackground Event
      CustomDrawColumnHeader Event
      CustomDrawColumnHeaderBackground Event
      CustomDrawFrozenPaneBorder Event
      CustomDrawRowHeader Event
      CustomDrawRowHeaderBackground Event
      DefinedNameDeleting Event
      DefinedNameEditing Event
      DefinedNameValidating Event
      DocumentClosing Event
      DocumentLoaded Event
      DocumentPropertiesChanged Event
      EmptyDocumentCreated Event
      EncryptedFileIntegrityCheckFailed 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
      ValidateCustomSqlQuery Event
      ZoomChanged Event
    [Expand]SpreadsheetControl Methods
   [Expand]SpreadsheetControlOptions Class
   [Expand]SpreadsheetCustomCellEditEventArgs Class
    SpreadsheetCustomCellEditEventHandler Delegate
   [Expand]SpreadsheetDataSourceWizardOptions Class
    SpreadsheetElementVisibility Enumeration
   [Expand]SpreadsheetFormulaBarControl Class
   [Expand]SpreadsheetHorizontalScrollbarOptions Class
    SpreadsheetMenuType Enumeration
   [Expand]SpreadsheetNameBoxControl Class
   [Expand]SpreadsheetScrollbarOptions Class
    SpreadsheetScrollbarVisibility Enumeration
   [Expand]SpreadsheetTabSelectorOptions Class
   [Expand]SpreadsheetVerticalScrollbarOptions Class
   [Expand]WorksheetDisplayArea Class
  [Expand]DevExpress.XtraSpreadsheet.Services
  [Expand]DevExpress.XtraTab
  [Expand]DevExpress.XtraTab.Buttons
  [Expand]DevExpress.XtraTab.ViewInfo
  [Expand]DevExpress.XtraTabbedMdi
  [Expand]DevExpress.XtraToolbox
  [Expand]DevExpress.XtraTreeList
  [Expand]DevExpress.XtraTreeList.Columns
  [Expand]DevExpress.XtraTreeList.Data
  [Expand]DevExpress.XtraTreeList.Localization
  [Expand]DevExpress.XtraTreeList.Menu
  [Expand]DevExpress.XtraTreeList.Nodes
  [Expand]DevExpress.XtraTreeList.Nodes.Operations
  [Expand]DevExpress.XtraTreeList.StyleFormatConditions
  [Expand]DevExpress.XtraTreeMap
  [Expand]DevExpress.XtraVerticalGrid
  [Expand]DevExpress.XtraVerticalGrid.Events
  [Expand]DevExpress.XtraVerticalGrid.Localization
  [Expand]DevExpress.XtraVerticalGrid.Rows
  [Expand]DevExpress.XtraWaitForm
  [Expand]DevExpress.XtraWizard
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

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 has been changed via the SpreadsheetControl's UI.
Public event ActiveSheetChanging Occurs when an active worksheet is about to be changed via the SpreadsheetControl's UI.
Public event AutoSizeChanged This event is not relevant for this class. (Inherited from System.Windows.Forms.Control)
Public event BackColorChanged Occurs when the value of the System.Windows.Forms.Control.BackColor property changes. (Inherited from System.Windows.Forms.Control)
Public event BackgroundImageChanged Occurs when the value of the System.Windows.Forms.Control.BackgroundImage property changes. (Inherited from System.Windows.Forms.Control)
Public event BackgroundImageLayoutChanged Occurs when the System.Windows.Forms.Control.BackgroundImageLayout property changes. (Inherited from System.Windows.Forms.Control)
Public event BeforeDispose Occurs before the SpreadsheetControl control is released from memory.
Public event BeforeExport Occurs before the document is saved (exported to a certain format).
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 BindingContextChanged Occurs when the value of the System.Windows.Forms.BindingContext property changes. (Inherited from System.Windows.Forms.Control)
Public event CausesValidationChanged Occurs when the value of the System.Windows.Forms.Control.CausesValidation property changes. (Inherited from System.Windows.Forms.Control)
Public event CellBeginEdit Occurs before the 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 the cell editor is closed and the entered value is committed.
Public event CellValueChanged Occurs after the cell content has been changed via the SpreadsheetControl UI.
Public event ChangeUICues Occurs when the focus or keyboard user interface (UI) cues change. (Inherited from System.Windows.Forms.Control)
Public event Click Occurs when the control is clicked. (Inherited from System.Windows.Forms.Control)
Public event ClientSizeChanged Occurs when the value of the System.Windows.Forms.Control.ClientSize property changes. (Inherited from System.Windows.Forms.Control)
Public event ClipboardDataObtained Occurs after data on the clipboard is obtained and recognized, but before data is actually pasted.
Public event ClipboardDataPasted Occurs after data has been 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 added to a worksheet via the SpreadsheetControl's UI.
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 via the SpreadsheetControl's UI.
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 is changed.
Public event ContextMenuChanged Occurs when the value of the System.Windows.Forms.Control.ContextMenu property changes. (Inherited from System.Windows.Forms.Control)
Public event ContextMenuStripChanged Occurs when the value of the System.Windows.Forms.Control.ContextMenuStrip property changes. (Inherited from System.Windows.Forms.Control)
Public event ControlAdded Occurs when a new control is added to the System.Windows.Forms.Control.ControlCollection. (Inherited from System.Windows.Forms.Control)
Public event ControlRemoved Occurs when a control is removed from the System.Windows.Forms.Control.ControlCollection. (Inherited from System.Windows.Forms.Control)
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 CursorChanged Occurs when the value of the System.Windows.Forms.Control.Cursor property changes. (Inherited from System.Windows.Forms.Control)
Public event CustomAssemblyLoading Occurs before a custom assembly is loaded for use as the Entity Framework data source during mail merge and allows cancelling loading.
Public event CustomCellEdit Allows you to assign a custom in-place editor to a cell.
Public event CustomDrawCell Provides the capability to perform custom painting of cell content.
Public event CustomDrawCellBackground Provides the capability to perform custom painting of the cell background.
Public event CustomDrawColumnHeader Enables the column header to be painted manually.
Public event CustomDrawColumnHeaderBackground Enables the column header background to be painted manually.
Public event CustomDrawFrozenPaneBorder Enables frozen pane borders to be painted manually.
Public event CustomDrawRowHeader Enables the row header to be painted manually.
Public event CustomDrawRowHeaderBackground Enables the row header background to be painted manually.
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 Disposed Occurs when the component is disposed by a call to the System.ComponentModel.Component.Dispose method. (Inherited from System.ComponentModel.Component)
Public event DockChanged Occurs when the value of the System.Windows.Forms.Control.Dock property changes. (Inherited from System.Windows.Forms.Control)
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 SpreadsheetControl.
Public event DocumentPropertiesChanged Occurs after one of the DevExpress.Spreadsheet.DocumentProperties is changed.
Public event DoubleClick Occurs when the control is double-clicked. (Inherited from System.Windows.Forms.Control)
Public event DpiChangedAfterParent (Inherited from System.Windows.Forms.Control)
Public event DpiChangedBeforeParent (Inherited from System.Windows.Forms.Control)
Public event DragDrop Occurs when a drag-and-drop operation is completed. (Inherited from System.Windows.Forms.Control)
Public event DragEnter Occurs when an object is dragged into the control's bounds. (Inherited from System.Windows.Forms.Control)
Public event DragLeave Occurs when an object is dragged out of the control's bounds. (Inherited from System.Windows.Forms.Control)
Public event DragOver Occurs when an object is dragged over the control's bounds. (Inherited from System.Windows.Forms.Control)
Public event EmptyDocumentCreated Occurs when a new document is created in the SpreadsheetControl.
Public event EnabledChanged Occurs when the System.Windows.Forms.Control.Enabled property value has changed. (Inherited from System.Windows.Forms.Control)
Public event EncryptedFileIntegrityCheckFailed Raises when the encrypted file did not pass the data integrity verification.
Public event EncryptedFilePasswordRequest Raises when the DevExpress.XtraSpreadsheet.Import.WorkbookImportOptions.Password property is not set or contains a wrong password.
Public event Enter Occurs when the control is entered. (Inherited from System.Windows.Forms.Control)
Public event FontChanged Occurs when the System.Windows.Forms.Control.Font property value changes. (Inherited from System.Windows.Forms.Control)
Public event ForeColorChanged Occurs when the System.Windows.Forms.Control.ForeColor property value changes. (Inherited from System.Windows.Forms.Control)
Public event GiveFeedback Occurs during a drag operation. (Inherited from System.Windows.Forms.Control)
Public event GotFocus Occurs when the control receives focus. (Inherited from System.Windows.Forms.Control)
Public event HandleCreated Occurs when a handle is created for the control. (Inherited from System.Windows.Forms.Control)
Public event HandleDestroyed Occurs when the control's handle is in the process of being destroyed. (Inherited from System.Windows.Forms.Control)
Public event HelpRequested Occurs when the user requests help for a control. (Inherited from System.Windows.Forms.Control)
Public event HyperlinkClick Occurs when an end-user activates the hyperlink before navigating to the referenced location.
Public event ImeModeChanged Occurs when the System.Windows.Forms.Control.ImeMode property has changed. (Inherited from System.Windows.Forms.Control)
Public event InitializeDocument Occurs before a document is loaded. Handle this event to set the initial document settings.
Public event Invalidated Occurs when a control's display requires redrawing. (Inherited from System.Windows.Forms.Control)
Public event InvalidFormatException Fires when the supplied data could not be recognized as data in the assumed format for import.
Public event KeyDown Occurs when a key is pressed while the control has focus. (Inherited from System.Windows.Forms.Control)
Public event KeyPress Occurs when a key is pressed while the control has focus. (Inherited from System.Windows.Forms.Control)
Public event KeyUp Occurs when a key is released while the control has focus. (Inherited from System.Windows.Forms.Control)
Public event Layout Occurs when a control should reposition its child controls. (Inherited from System.Windows.Forms.Control)
Public event Leave Occurs when the input focus leaves the control. (Inherited from System.Windows.Forms.Control)
Public event LocationChanged Occurs when the System.Windows.Forms.Control.Location property value has changed. (Inherited from System.Windows.Forms.Control)
Public event LostFocus Occurs when the control loses focus. (Inherited from System.Windows.Forms.Control)
Public event MarginChanged Occurs when the control's margin changes. (Inherited from System.Windows.Forms.Control)
Public event ModifiedChanged Occurs when the value of the Modified property is changed.
Public event MouseCaptureChanged Occurs when the control loses or gains mouse capture. (Inherited from System.Windows.Forms.Control)
Public event MouseClick Occurs when the control is clicked by the mouse. (Inherited from System.Windows.Forms.Control)
Public event MouseDoubleClick Occurs when the control is double clicked by the mouse. (Inherited from System.Windows.Forms.Control)
Public event MouseDown Occurs when the mouse pointer is over the control and a mouse button is pressed. (Inherited from System.Windows.Forms.Control)
Public event MouseEnter Occurs when the mouse pointer enters the control. (Inherited from System.Windows.Forms.Control)
Public event MouseHover Occurs when the mouse pointer rests on the control. (Inherited from System.Windows.Forms.Control)
Public event MouseLeave Occurs when the mouse pointer leaves the control. (Inherited from System.Windows.Forms.Control)
Public event MouseMove Occurs when the mouse pointer is moved over the control. (Inherited from System.Windows.Forms.Control)
Public event MouseUp Occurs when the mouse pointer is over the control and a mouse button is released. (Inherited from System.Windows.Forms.Control)
Public event MouseWheel Occurs when the mouse wheel moves while the control has focus. (Inherited from System.Windows.Forms.Control)
Public event Move Occurs when the control is moved. (Inherited from System.Windows.Forms.Control)
Public event PaddingChanged Occurs when the control's padding changes. (Inherited from System.Windows.Forms.Control)
Public event Paint Occurs when the control is redrawn. (Inherited from System.Windows.Forms.Control)
Public event PanesFrozen Occurs after a worksheet area has been frozen via the SpreadsheetControl's UI.
Public event PanesUnfrozen Occurs after a frozen worksheet area has been unlocked via the SpreadsheetControl's UI.
Public event ParentChanged Occurs when the System.Windows.Forms.Control.Parent property value changes. (Inherited from System.Windows.Forms.Control)
Public event PopupMenuShowing Occurs when a popup menu is about to be displayed for the SpreadsheetControl's visual elements.
Public event PreviewKeyDown Occurs before the System.Windows.Forms.Control.KeyDown event when a key is pressed while focus is on this control. (Inherited from System.Windows.Forms.Control)
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 QueryAccessibilityHelp Occurs when System.Windows.Forms.AccessibleObject is providing help to accessibility applications. (Inherited from System.Windows.Forms.Control)
Public event QueryContinueDrag 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 System.Windows.Forms.Control)
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 SpreadsheetControl's read-only state is changed.
Public event RegionChanged Occurs when the value of the System.Windows.Forms.Control.Region property changes. (Inherited from System.Windows.Forms.Control)
Public event Resize Occurs when the control is resized. (Inherited from System.Windows.Forms.Control)
Public event RightToLeftChanged Occurs when the System.Windows.Forms.Control.RightToLeft property value changes. (Inherited from System.Windows.Forms.Control)
Public event RowsInserted Occurs after new rows have been added to a worksheet via the SpreadsheetControl's UI.
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 via the SpreadsheetControl's UI.
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 in response to changing cell selection in an active worksheet.
Public event ShapeInserted Occurs after a shape has been inserted into a worksheet.
Public event ShapeRemoved Occurs after a shape has been removed from a worksheet.
Public event ShapeRemoving Occurs before a shape is removed from a worksheet.
Public event ShapesCopying Occurs before a shape is copied.
Public event SheetInserted Occurs after a new worksheet has been added into a workbook via the SpreadsheetControl's UI.
Public event SheetRemoved Occurs after a worksheet has been removed from a workbook via the SpreadsheetControl's UI.
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 via the SpreadsheetControl's UI.
Public event SheetRenaming Occurs when a worksheet is about to be renamed via the SpreadsheetControl's UI.
Public event SizeChanged Occurs when the System.Windows.Forms.Control.Size property value changes. (Inherited from System.Windows.Forms.Control)
Public event StyleChanged Occurs when the control style changes. (Inherited from System.Windows.Forms.Control)
Public event SystemColorsChanged Occurs when the system colors change. (Inherited from System.Windows.Forms.Control)
Public event TabIndexChanged Occurs when the System.Windows.Forms.Control.TabIndex property value changes. (Inherited from System.Windows.Forms.Control)
Public event TabStopChanged Occurs when the System.Windows.Forms.Control.TabStop property value changes. (Inherited from System.Windows.Forms.Control)
Public event TextChanged Occurs when the System.Windows.Forms.Control.Text property value changes. (Inherited from System.Windows.Forms.Control)
Public event UnhandledException This event is raised when an exception, unhandled by the SpreadsheetControl, occurs.
Public event UnitChanged Fires after a unit of measurement used in the workbook is changed.
Public event UnitChanging Fires before a unit of measurement used within the workbook is changed.
Public event UpdateUI Raised when changes occur which may affect the control's UI.
Public event ValidateCustomSqlQuery Allows validation of the custom SQL query created using the Data Source Wizard.
Public event Validated Occurs when the control is finished validating. (Inherited from System.Windows.Forms.Control)
Public event Validating Occurs when the control is validating. (Inherited from System.Windows.Forms.Control)
Public event VisibleChanged Occurs when the System.Windows.Forms.Control.Visible property value changes. (Inherited from System.Windows.Forms.Control)
Public event ZoomChanged Occurs when the current zoom level of the active worksheet has been changed via the SpreadsheetControl's UI.
Top

Expanded See Also

How would you rate this topic?​​​​​​​