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
    [Expand]SpreadsheetControl Events
    [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 Members

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

Expanded Public Constructors

Show: Inherited
  Name Description
Public method SpreadsheetControl Initializes a new instance of the SpreadsheetControl class with default settings.
Top

Expanded Public Properties

Show: Inherited
  Name Description
Public property AcceptsEscape Gets or sets a value indicating whether pressing the ESC key is processed by the SpreadsheetControl.
Public property AcceptsReturn Gets or sets a value indicating whether pressing the RETURN key is processed by the SpreadsheetControl.
Public property AcceptsTab Gets or sets a value indicating whether pressing the TAB key is processed by the SpreadsheetControl instead of moving the focus to the next control in the tab order.
Public property AccessibilityObject Gets the System.Windows.Forms.AccessibleObject assigned to the control. (Inherited from System.Windows.Forms.Control)
Public property AccessibleDefaultActionDescription Gets or sets the default action description of the control for use by accessibility client applications. (Inherited from System.Windows.Forms.Control)
Public property AccessibleDescription Gets or sets the description of the control used by accessibility client applications. (Inherited from System.Windows.Forms.Control)
Public property AccessibleName Gets or sets the name of the control used by accessibility client applications. (Inherited from System.Windows.Forms.Control)
Public property AccessibleRole Gets or sets the accessible role of the control (Inherited from System.Windows.Forms.Control)
Public property ActiveCell Gets an active cell in the active worksheet.
Public property ActiveView Provides access to a SpreadsheetView object that contains layout information. This member supports the internal infrastructure and is not intended to be used directly from your code.
Public property ActiveWorksheet Gets the worksheet that is currently displayed in the SpreadsheetControl.
Public property AllowDrop Overrides the System.Windows.Forms.Control.AllowDrop property.
Public property Anchor Gets or sets the edges of the container to which a control is bound and determines how a control is resized with its parent. (Inherited from System.Windows.Forms.Control)
Public property AutoScrollOffset Gets or sets where this control is scrolled to in System.Windows.Forms.ScrollableControl.ScrollControlIntoView. (Inherited from System.Windows.Forms.Control)
Public property AutoSize This property is not relevant for this class. (Inherited from System.Windows.Forms.Control)
Public property BackColor This property is not supported by the SpreadsheetControl class.
Public property BackgroundImage This property has no effect on the SpreadsheetControl.
Public property BackgroundImageLayout This property has no effect on the SpreadsheetControl.
Public property BindingContext Gets or sets the System.Windows.Forms.BindingContext for the control. (Inherited from System.Windows.Forms.Control)
Public property BorderStyle Gets or sets the SpreadsheetControl's border style.
Public property Bottom Gets the distance, in pixels, between the bottom edge of the control and the top edge of its container's client area. (Inherited from System.Windows.Forms.Control)
Public property Bounds Gets or sets the size and location of the control including its nonclient elements, in pixels, relative to the parent control. (Inherited from System.Windows.Forms.Control)
Public property CanFocus Gets a value indicating whether the control can receive focus. (Inherited from System.Windows.Forms.Control)
Public property CanSelect Gets a value indicating whether the control can be selected. (Inherited from System.Windows.Forms.Control)
Public property Capture Gets or sets a value indicating whether the control has captured the mouse. (Inherited from System.Windows.Forms.Control)
Public property CausesValidation Gets or sets a value indicating whether the control causes validation to be performed on any controls that require validation when it receives focus. (Inherited from System.Windows.Forms.Control)
Public propertyStatic member CheckForIllegalCrossThreadCalls Gets or sets a value indicating whether to catch calls on the wrong thread that access a control's System.Windows.Forms.Control.Handle property when an application is being debugged. (Inherited from System.Windows.Forms.Control)
Public property ClientRectangle Gets the rectangle that represents the client area of the control. (Inherited from System.Windows.Forms.Control)
Public property ClientSize Gets or sets the height and width of the client area of the control. (Inherited from System.Windows.Forms.Control)
Public property Clipboard Provides access to the object used for working with the system Clipboard.
Public property CompanyName ControlCompanyNameDescr (Inherited from System.Windows.Forms.Control)
Public property Container Gets the System.ComponentModel.IContainer that contains the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
Public property ContainsFocus Gets a value indicating whether the control, or one of its child controls, currently has the input focus. (Inherited from System.Windows.Forms.Control)
Public property ContextMenu Gets or sets the shortcut menu associated with the control. (Inherited from System.Windows.Forms.Control)
Public property ContextMenuStrip Gets or sets the System.Windows.Forms.ContextMenuStrip associated with this control. (Inherited from System.Windows.Forms.Control)
Public property Controls Gets the collection of controls contained within the control. (Inherited from System.Windows.Forms.Control)
Public property Created Gets a value indicating whether the control has been created. (Inherited from System.Windows.Forms.Control)
Public property Cursor Gets or sets the cursor that is displayed when the mouse pointer is over the control. (Inherited from System.Windows.Forms.Control)
Public property DataBindings Gets the data bindings for the control. (Inherited from System.Windows.Forms.Control)
Public propertyStatic member DefaultBackColor Gets the default background color of the control. (Inherited from System.Windows.Forms.Control)
Public propertyStatic member DefaultFont Gets the default font of the control. (Inherited from System.Windows.Forms.Control)
Public propertyStatic member DefaultForeColor Gets the default foreground color of the control. (Inherited from System.Windows.Forms.Control)
Public property DeviceDpi (Inherited from System.Windows.Forms.Control)
Public property DisplayRectangle Gets the rectangle that represents the display area of the control. (Inherited from System.Windows.Forms.Control)
Public property Disposing Gets a value indicating whether the base System.Windows.Forms.Control class is in the process of disposing. (Inherited from System.Windows.Forms.Control)
Public property Dock Gets or sets which control borders are docked to its parent control and determines how a control is resized with its parent. (Inherited from System.Windows.Forms.Control)
Public property Document Provides access to a workbook loaded in the control.
Public property DpiX Gets the current dpi value for the X-coordinate.
Public property DpiY Gets the current dpi value for the Y-coordinate.
Public property Enabled Gets or sets a value indicating whether the control can respond to user interaction. (Inherited from System.Windows.Forms.Control)
Public property Focused Gets a value indicating whether the control has input focus. (Inherited from System.Windows.Forms.Control)
Public property Font This property is not supported by the SpreadsheetControl class.
Public property ForeColor This property is not supported by the SpreadsheetControl class.
Public property Handle Gets the window handle that the control is bound to. (Inherited from System.Windows.Forms.Control)
Public property HasChildren Gets a value indicating whether the control contains one or more child controls. (Inherited from System.Windows.Forms.Control)
Public property Height Gets or sets the height of the control. (Inherited from System.Windows.Forms.Control)
Public property ImeMode Gets or sets the Input Method Editor (IME) mode of the control. (Inherited from System.Windows.Forms.Control)
Public property InvokeRequired Gets a value indicating whether the caller must call an invoke method when making method calls to the control because the caller is on a different thread than the one the control was created on. (Inherited from System.Windows.Forms.Control)
Public property IsAccessible Gets or sets a value indicating whether the control is visible to accessibility applications. (Inherited from System.Windows.Forms.Control)
Public property IsCellEditorActive Gets whether the cell editor is currently active.
Public property IsDisposed Gets a value indicating whether the control has been disposed of. (Inherited from System.Windows.Forms.Control)
Public property IsHandleCreated Gets a value indicating whether the control has a handle associated with it. (Inherited from System.Windows.Forms.Control)
Public property IsMirrored Gets a value indicating whether the control is mirrored. (Inherited from System.Windows.Forms.Control)
Public property IsPrintingAvailable Indicates whether the SpreadsheetControl can be printed or exported.
Public property IsPrintPreviewAvailable Gets a value indicating whether a preview of the SpreadsheetControl's document is allowed.
Public property IsUpdateLocked Gets whether the control has been locked for updating.
Public property LayoutEngine Gets a cached instance of the control's layout engine. (Inherited from System.Windows.Forms.Control)
Public property LayoutUnit Gets or sets a unit of measure used for a document layout.
Public property Left Gets or sets the distance, in pixels, between the left edge of the control and the left edge of its container's client area. (Inherited from System.Windows.Forms.Control)
Public property Location Gets or sets the coordinates of the upper-left corner of the control relative to the upper-left corner of its container. (Inherited from System.Windows.Forms.Control)
Public property LookAndFeel Provides access to the control's look and feel settings.
Public property Margin Gets or sets the space between controls. (Inherited from System.Windows.Forms.Control)
Public property MaximumSize Gets or sets the size that is the upper limit that System.Windows.Forms.Control.GetPreferredSize can specify. (Inherited from System.Windows.Forms.Control)
Public property MenuManager Gets or sets the menu manager which controls the look and feel of context menus.
Public property MinimumSize Gets or sets the size that is the lower limit that System.Windows.Forms.Control.GetPreferredSize can specify. (Inherited from System.Windows.Forms.Control)
Public property Modified Gets or sets a value that indicates that the document content was modified since it was last saved.
Public propertyStatic member ModifierKeys Gets a value indicating which of the modifier keys (SHIFT, CTRL, and ALT) is in a pressed state. (Inherited from System.Windows.Forms.Control)
Public propertyStatic member MouseButtons Gets a value indicating which of the mouse buttons is in a pressed state. (Inherited from System.Windows.Forms.Control)
Public propertyStatic member MousePosition Gets the position of the mouse cursor in screen coordinates. (Inherited from System.Windows.Forms.Control)
Public property Name Gets or sets the name of the control. (Inherited from System.Windows.Forms.Control)
Public property Options Provides access to the variety of options which can be specified for the document loaded into the SpreadsheetControl and the control itself.
Public property Padding Gets or sets padding within the control. (Inherited from System.Windows.Forms.Control)
Public property Parent Gets or sets the parent container of the control. (Inherited from System.Windows.Forms.Control)
Public property PreferredSize Gets the size of a rectangular area into which the control can fit. (Inherited from System.Windows.Forms.Control)
Public property ProductName Gets the product name of the assembly containing the control. (Inherited from System.Windows.Forms.Control)
Public property ProductVersion Gets the version of the assembly containing the control. (Inherited from System.Windows.Forms.Control)
Public property ReadOnly Gets or sets whether document modifications are prohibited.
Public property RecreatingHandle Gets a value indicating whether the control is currently re-creating its handle. (Inherited from System.Windows.Forms.Control)
Public property Region Gets or sets the window region associated with the control. (Inherited from System.Windows.Forms.Control)
Public property Right Gets the distance, in pixels, between the right edge of the control and the left edge of its container's client area. (Inherited from System.Windows.Forms.Control)
Public property RightToLeft This property is not in effect for the SpreadsheetControl class.
Public property SelectedCell Gets or sets an active cell in the active worksheet.
Public property SelectedPicture Gets or sets a picture selected in the active worksheet.
Public property SelectedShape Gets or sets a shape selected in the active worksheet.
Public property Selection Gets or sets a cell range selected in the active worksheet.
Public property Site Gets or sets the site of the control. (Inherited from System.Windows.Forms.Control)
Public property Size Gets or sets the height and width of the control. (Inherited from System.Windows.Forms.Control)
Public property TabIndex Gets or sets the tab order of the control within its container. (Inherited from System.Windows.Forms.Control)
Public property TabStop Gets or sets a value indicating whether the user can give the focus to this control using the TAB key. (Inherited from System.Windows.Forms.Control)
Public property Tag Gets or sets the object that contains data about the control. (Inherited from System.Windows.Forms.Control)
Public property Text Gets or sets the text associated with this control. (Inherited from System.Windows.Forms.Control)
Public property ToolTipController Gets or sets the tooltip controller component that controls the appearance, position and the content of the hints displayed by the SpreadsheetControl.
Public property Top Gets or sets the distance, in pixels, between the top edge of the control and the top edge of its container's client area. (Inherited from System.Windows.Forms.Control)
Public property TopLevelControl Gets the parent control that is not parented by another Windows Forms control. Typically, this is the outermost System.Windows.Forms.Form that the control is contained in. (Inherited from System.Windows.Forms.Control)
Public property Unit Gets or sets a unit of measure used in the workbook.
Public property UseWaitCursor Gets or sets a value indicating whether to use the wait cursor for the current control and all child controls. (Inherited from System.Windows.Forms.Control)
Public property Visible Gets or sets a value indicating whether the control and all its parent controls are displayed. (Inherited from System.Windows.Forms.Control)
Public property VisibleRange Gets the cell range that is currently visible in the SpreadsheetControl.
Public property VisibleUnfrozenRange Gets the visible cell range of the scrollable area when there are frozen rows and columns in the worksheet.
Public property Width Gets or sets the width of the control. (Inherited from System.Windows.Forms.Control)
Public property WindowTarget This property is not relevant for this class. (Inherited from System.Windows.Forms.Control)
Public property WorksheetDisplayArea Provides access to an object enabling you to specify a worksheet area that is visible in the SpreadsheetControl and allows end-user input.
Top

Expanded Public Methods

Show: Inherited
  Name Description
Public methodStatic member About Invokes the About dialog box.
Public method AddService Overloaded. Adds the specified service to the service container.
Public method AssignShortcutKeyToCommand Assigns a shortcut key to a command.
Public method BeginInvoke Executes the specified delegate asynchronously with the specified arguments, on the thread that the control's underlying handle was created on. (Inherited from System.Windows.Forms.Control)
Public method BeginUpdate Locks the SpreadsheetControl, preventing visual updates of the object and its elements until the EndUpdate or CancelUpdate method is called.
Public method BringToFront Brings the control to the front of the z-order. (Inherited from System.Windows.Forms.Control)
Public method CancelUpdate Unlocks the SpreadsheetControl object after it has been locked by the BeginUpdate method, without causing an immediate visual update.
Public method CircleInvalidData Displays circles around invalid data in a worksheet to which data validation is applied.
Public method ClearValidationCircles Hides circles around invalid data in a worksheet to which data validation is applied.
Public method CloseCellEditor Closes the cell editor.
Public method Contains Retrieves a value indicating whether the specified control is a child of the control. (Inherited from System.Windows.Forms.Control)
Public method CreateCommand Creates a command by its identifier.
Public method CreateControl Forces the creation of the control, including the creation of the handle and any child controls. (Inherited from System.Windows.Forms.Control)
Public method CreateGraphics Creates the System.Drawing.Graphics for the control. (Inherited from System.Windows.Forms.Control)
Public method CreateNewDocument Creates and loads a new empty workbook.
Public method CreateObjRef Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject)
Public method Dispose Releases all resources used by the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
Public method DoDragDrop Begins a drag-and-drop operation. (Inherited from System.Windows.Forms.Control)
Public method DrawToBitmap Supports rendering to the specified bitmap. (Inherited from System.Windows.Forms.Control)
Public method EndInvoke Retrieves the return value of the asynchronous operation represented by the System.IAsyncResult passed. (Inherited from System.Windows.Forms.Control)
Public method EndUpdate Unlocks the SpreadsheetControl object after a call to the BeginUpdate method and causes an immediate visual update.
Public method Equals Determines whether the specified System.Object is equal to the current System.Object. (Inherited from System.Object)
Public methodStatic member Equals Determines whether the specified System.Object instances are considered equal. (Inherited from System.Object)
Public method ExportToHtml Overloaded. Exports the specified worksheet to the specified stream in HTML format.
Public method ExportToPdf Overloaded. Exports the content of the SpreadsheetControl to the specified file in PDF format.
Public method FindForm Retrieves the form that the control is on. (Inherited from System.Windows.Forms.Control)
Public method Focus Sets input focus to the control. (Inherited from System.Windows.Forms.Control)
Public methodStatic member FromChildHandle Retrieves the control that contains the specified handle. (Inherited from System.Windows.Forms.Control)
Public methodStatic member FromHandle Returns the control that is currently associated with the specified handle. (Inherited from System.Windows.Forms.Control)
Public method GetCellBounds Obtains the bounds of a cell specified by the row and column indices.
Public method GetCellFromPoint Gets a worksheet cell located at the specified point.
Public method GetChildAtPoint Retrieves the child control that is located at the specified coordinates, specifying whether to ignore child controls of a certain type. (Inherited from System.Windows.Forms.Control)
Public method GetContainerControl Returns the next System.Windows.Forms.ContainerControl up the control's chain of parent controls. (Inherited from System.Windows.Forms.Control)
Public method GetHashCode Serves as a hash function for a particular type. System.Object.GetHashCode is suitable for use in hashing algorithms and data structures like a hash table. (Inherited from System.Object)
Public method GetLifetimeService Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
Public method GetNextControl Retrieves the next control forward or back in the tab order of child controls. (Inherited from System.Windows.Forms.Control)
Public method GetPreferredSize Retrieves the size of a rectangular area into which a control can be fitted. (Inherited from System.Windows.Forms.Control)
Public method GetSelectedRanges Returns cell ranges currently selected in the active worksheet.
Public method GetSelectedShapes Returns shapes currently selected in the active worksheet.
Public method GetService Gets the service object of the specified type.
Public method GetService<T> Gets the specified service.
Public method GetType Gets the System.Type of the current instance. (Inherited from System.Object)
Public method Hide Conceals the control from the user. (Inherited from System.Windows.Forms.Control)
Public method InitializeLifetimeService Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
Public method Invalidate Invalidates a specific region of the control and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. (Inherited from System.Windows.Forms.Control)
Public method Invoke Executes the specified delegate, on the thread that owns the control's underlying window handle, with the specified list of arguments. (Inherited from System.Windows.Forms.Control)
Public methodStatic member IsKeyLocked Determines whether the CAPS LOCK, NUM LOCK, or SCROLL LOCK key is in effect. (Inherited from System.Windows.Forms.Control)
Public methodStatic member IsMnemonic Determines if the specified character is the mnemonic character assigned to the control in the specified string. (Inherited from System.Windows.Forms.Control)
Public method LoadDocument Overloaded. Loads a document from a stream, specifying the document format.
Public method LogicalToDeviceUnits (Inherited from System.Windows.Forms.Control)
Public method OpenCellEditor Invokes a cell editor and switches to the spreadsheet edit mode, allowing you to edit cell content.
Public method PerformLayout Forces the control to apply layout logic to all its child controls. (Inherited from System.Windows.Forms.Control)
Public method PointToClient Computes the location of the specified screen point into client coordinates. (Inherited from System.Windows.Forms.Control)
Public method PointToScreen Computes the location of the specified client point into screen coordinates. (Inherited from System.Windows.Forms.Control)
Public method PreProcessControlMessage Preprocesses keyboard or input messages within the message loop before they are dispatched. (Inherited from System.Windows.Forms.Control)
Public method PreProcessMessage Preprocesses keyboard or input messages within the message loop before they are dispatched. (Inherited from System.Windows.Forms.Control)
Public method Print Prints the document to the default printer.
Public method RectangleToClient Computes the size and location of the specified screen rectangle in client coordinates. (Inherited from System.Windows.Forms.Control)
Public method RectangleToScreen Computes the size and location of the specified client rectangle in screen coordinates. (Inherited from System.Windows.Forms.Control)
Public methodStatic member ReferenceEquals Determines whether the specified System.Object instances are the same instance. (Inherited from System.Object)
Public method Refresh Forces the control to invalidate its client area and immediately redraw itself and any child controls. (Inherited from System.Windows.Forms.Control)
Public method RemoveService Overloaded. Removes the service of the specified type from the service container.
Public method RemoveShortcutKey Removes a command shortcut.
Public method ReplaceService<T> Performs a service substitution.
Public method ResetBackColor Resets the System.Windows.Forms.Control.BackColor property to its default value. (Inherited from System.Windows.Forms.Control)
Public method ResetBindings Causes a control bound to the System.Windows.Forms.BindingSource to reread all the items in the list and refresh their displayed values. (Inherited from System.Windows.Forms.Control)
Public method ResetCursor Resets the System.Windows.Forms.Control.Cursor property to its default value. (Inherited from System.Windows.Forms.Control)
Public method ResetFont Resets the System.Windows.Forms.Control.Font property to its default value. (Inherited from System.Windows.Forms.Control)
Public method ResetForeColor Resets the System.Windows.Forms.Control.ForeColor property to its default value. (Inherited from System.Windows.Forms.Control)
Public method ResetImeMode Resets the System.Windows.Forms.Control.ImeMode property to its default value. (Inherited from System.Windows.Forms.Control)
Public method ResetLayout Updates the layout of the document loaded into control and the control itself.
Public method ResetRightToLeft Resets the System.Windows.Forms.Control.RightToLeft property to its default value. (Inherited from System.Windows.Forms.Control)
Public method ResetText Resets the System.Windows.Forms.Control.Text property to its default value. (Inherited from System.Windows.Forms.Control)
Public method ResumeLayout Resumes usual layout logic, optionally forcing an immediate layout of pending layout requests. (Inherited from System.Windows.Forms.Control)
Public method SaveDocument Overloaded. Saves the control's document to a file, specifying the document format.
Public method SaveDocumentAs Overloaded. Invokes the Save As dialog and saves a document.
Public method Scale Obsolete. Scales the entire control and any child controls. (Inherited from System.Windows.Forms.Control)
Public method ScaleBitmapLogicalToDevice (Inherited from System.Windows.Forms.Control)
Public method Select Activates the control. (Inherited from System.Windows.Forms.Control)
Public method SelectNextControl Activates the next control. (Inherited from System.Windows.Forms.Control)
Public method SendToBack Sends the control to the back of the z-order. (Inherited from System.Windows.Forms.Control)
Public method SetBounds Sets the bounds of the control to the specified location and size. (Inherited from System.Windows.Forms.Control)
Public method SetSelectedRanges Overloaded. Selects cell ranges in the worksheet and specifies whether the selection expands to fit merged cells.
Public method SetSelectedShapes Sets shapes selected in the active worksheet.
Public method Show Displays the control to the user. (Inherited from System.Windows.Forms.Control)
Public method ShowPrintDialog Invokes the Print dialog to select a printer, specify the print options (number of copies, page range, and paper source) and print the document.
Public method ShowPrintPreview Invokes the Print Preview window with a Bar UI.
Public method ShowRibbonPrintPreview Invokes the Print Preview window with a Ribbon UI.
Public method SuspendLayout Temporarily suspends the layout logic for the control. (Inherited from System.Windows.Forms.Control)
Public method ToString Returns a System.String containing the name of the System.ComponentModel.Component, if any. This method should not be overridden. (Inherited from System.ComponentModel.Component)
Public method Update Causes the control to redraw the invalidated regions within its client area. (Inherited from System.Windows.Forms.Control)
Public method UpdateCommandUI Refreshes the SpreadsheetControl command UI.
Top

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?​​​​​​​