SpreadsheetControl Members

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

Constructors

Name Description
SpreadsheetControl() Initializes a new instance of the SpreadsheetControl class with default settings.

Properties

Name Description
AcceptsEscape Gets or sets a value indicating whether pressing the ESC key is processed by the SpreadsheetControl.
AcceptsReturn Gets or sets a value indicating whether pressing the RETURN key is processed by the SpreadsheetControl.
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.
AccessibilityObject Gets the AccessibleObject assigned to the control. Inherited from Control.
AccessibleDefaultActionDescription Gets or sets the default action description of the control for use by accessibility client applications. Inherited from Control.
AccessibleDescription Gets or sets the description of the control used by accessibility client applications. Inherited from Control.
AccessibleName Gets or sets the name of the control used by accessibility client applications. Inherited from Control.
AccessibleRole Gets or sets the accessible role of the control. Inherited from Control.
ActiveCell Returns an active cell in the active worksheet.
ActiveChartSheet Gets the chart sheet that is currently displayed in the SpreadsheetControl.
ActiveSheet Gets the sheet that is currently displayed in the SpreadsheetControl.
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.
ActiveViewZoom Gets or sets the zoom level for the sheet currently displayed in the SpreadsheetControl.
ActiveWorksheet Gets the worksheet that is currently displayed in the SpreadsheetControl.
AllowDrop Overrides the System.Windows.Forms.Control.AllowDrop 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 Control.
AutoScrollOffset Gets or sets where this control is scrolled to in ScrollControlIntoView(Control). Inherited from Control.
AutoSize This property is not relevant for this class. Inherited from Control.
BackColor This property is not supported by the SpreadsheetControl class.
BackgroundImage This property has no effect on the SpreadsheetControl.
BackgroundImageLayout This property has no effect on the SpreadsheetControl.
BindingContext Gets or sets the BindingContext for the control. Inherited from Control.
BorderStyle Gets or sets the SpreadsheetControl's border style.
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 Control.
Bounds Gets or sets the size and location of the control including its nonclient elements, in pixels, relative to the parent control. Inherited from Control.
CanEnableIme protected Gets a value indicating whether the ImeMode property can be set to an active value, to enable IME support. Inherited from Control.
CanFocus Gets a value indicating whether the control can receive focus. Inherited from Control.
CanRaiseEvents protected Determines if events can be raised on the control. Inherited from Control.
CanSelect Gets a value indicating whether the control can be selected. Inherited from Control.
Capture Gets or sets a value indicating whether the control has captured the mouse. Inherited from Control.
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 Control.
CheckForIllegalCrossThreadCalls static Gets or sets a value indicating whether to catch calls on the wrong thread that access a control's Handle property when an application is being debugged. Inherited from Control.
ClientRectangle Gets the rectangle that represents the client area of the control. Inherited from Control.
ClientSize Gets or sets the height and width of the client area of the control. Inherited from Control.
Clipboard Provides access to the object used for working with the system Clipboard.
CompanyName Gets the name of the company or creator of the application containing the control. Inherited from Control.
Container Gets the IContainer that contains the Component. Inherited from Component.
ContainsFocus Gets a value indicating whether the control, or one of its child controls, currently has the input focus. Inherited from Control.
ContextMenu Gets or sets the shortcut menu associated with the control. Inherited from Control.
ContextMenuStrip Gets or sets the ContextMenuStrip associated with this control. Inherited from Control.
Controls Gets the collection of controls contained within the control. Inherited from Control.
Created Gets a value indicating whether the control has been created. Inherited from Control.
CreateParams protected Gets the required creation parameters when the control handle is created. Inherited from Control.
Cursor Gets or sets the cursor that is displayed when the mouse pointer is over the control. Inherited from Control.
DataBindings Gets the data bindings for the control. Inherited from Control.
DefaultBackColor static Gets the default background color of the control. Inherited from Control.
DefaultCursor protected Gets or sets the default cursor for the control. Inherited from Control.
DefaultFont static Gets the default font of the control. Inherited from Control.
DefaultForeColor static Gets the default foreground color of the control. Inherited from Control.
DefaultImeMode protected Gets the default Input Method Editor (IME) mode supported by the control. Inherited from Control.
DefaultMargin protected Gets the space, in pixels, that is specified by default between controls. Inherited from Control.
DefaultMaximumSize protected Gets the length and height, in pixels, that is specified as the default maximum size of a control. Inherited from Control.
DefaultMinimumSize protected Gets the length and height, in pixels, that is specified as the default minimum size of a control. Inherited from Control.
DefaultPadding protected Gets the internal spacing, in pixels, of the contents of a control. Inherited from Control.
DesignMode protected Gets a value that indicates whether the Component is currently in design mode. Inherited from Component.
DeviceDpi Gets the DPI value for the display device where the control is currently being displayed. Inherited from Control.
DisplayRectangle Gets the rectangle that represents the display area of the control. Inherited from Control.
Disposing Gets a value indicating whether the base Control class is in the process of disposing. Inherited from Control.
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 Control.
Document Provides access to a workbook loaded in the control.
DoubleBuffered protected Gets or sets a value indicating whether this control should redraw its surface using a secondary buffer to reduce or prevent flicker. Inherited from Control.
DpiX Gets the current dpi value for the X-coordinate.
DpiY Gets the current dpi value for the Y-coordinate.
Enabled Gets or sets a value indicating whether the control can respond to user interaction. Inherited from Control.
Events protected Gets the list of event handlers that are attached to this Component. Inherited from Component.
Focused Gets a value indicating whether the control has input focus. Inherited from Control.
Font This property is not supported by the SpreadsheetControl class.
FontHeight protected Gets or sets the height of the font of the control. Inherited from Control.
ForeColor This property is not supported by the SpreadsheetControl class.
Handle Gets the window handle that the control is bound to. Inherited from Control.
HasChildren Gets a value indicating whether the control contains one or more child controls. Inherited from Control.
Height Gets or sets the height of the control. Inherited from Control.
ImeMode Gets or sets the Input Method Editor (IME) mode of the control. Inherited from Control.
ImeModeBase protected Gets or sets the IME mode of a control. Inherited from Control.
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 Control.
IsAccessible Gets or sets a value indicating whether the control is visible to accessibility applications. Inherited from Control.
IsCellEditorActive Gets whether the cell editor is currently active.
IsDisposed Gets a value indicating whether the control has been disposed of. Inherited from Control.
IsHandleCreated Gets a value indicating whether the control has a handle associated with it. Inherited from Control.
IsMirrored Gets a value indicating whether the control is mirrored. Inherited from Control.
IsPrintingAvailable Indicates whether the SpreadsheetControl can be printed or exported.
IsPrintPreviewAvailable Gets a value indicating whether a preview of the SpreadsheetControl's document is allowed.
IsUpdateLocked Returns a value indicating whether the SpreadsheetControl is locked for update.
LayoutEngine Gets a cached instance of the control's layout engine. Inherited from Control.
LayoutUnit Gets or sets a unit of measure used for a document layout.
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 Control.
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 Control.
LookAndFeel Provides access to the control's look and feel settings.
Margin Gets or sets the space between controls. Inherited from Control.
MaximumSize Gets or sets the size that is the upper limit that GetPreferredSize(Size) can specify. Inherited from Control.
MenuManager Gets or sets the menu manager which controls the look and feel of context menus.
MinimumSize Gets or sets the size that is the lower limit that GetPreferredSize(Size) can specify. Inherited from Control.
Modified Gets or sets a value that indicates that the document content was modified since it was last saved.
ModifierKeys static Gets a value indicating which of the modifier keys (SHIFT, CTRL, and ALT) is in a pressed state. Inherited from Control.
MouseButtons static Gets a value indicating which of the mouse buttons is in a pressed state. Inherited from Control.
MousePosition static Gets the position of the mouse cursor in screen coordinates. Inherited from Control.
Name Gets or sets the name of the control. Inherited from Control.
Options Provides access to the variety of options which can be specified for the document loaded into the SpreadsheetControl and the control itself.
Padding Gets or sets padding within the control. Inherited from Control.
Parent Gets or sets the parent container of the control. Inherited from Control.
PreferredSize Gets the size of a rectangular area into which the control can fit. Inherited from Control.
ProductName Gets the product name of the assembly containing the control. Inherited from Control.
ProductVersion Gets the version of the assembly containing the control. Inherited from Control.
PropagatingImeMode protected static Gets an object that represents a propagating IME mode. Inherited from Control.
ReadOnly Gets or sets whether document modifications are prohibited.
RecreatingHandle Gets a value indicating whether the control is currently re-creating its handle. Inherited from Control.
Region Gets or sets the window region associated with the control. Inherited from Control.
RenderRightToLeft protected This property is now obsolete. Inherited from Control.
ResizeRedraw protected Gets or sets a value indicating whether the control redraws itself when resized. Inherited from Control.
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 Control.
RightToLeft This property is not in effect for the SpreadsheetControl class.
ScaleChildren protected Gets a value that determines the scaling of child controls. Inherited from Control.
SelectedCell Gets or sets an active cell in the active worksheet.
SelectedComment Gets or sets a comment selected in the active worksheet.
SelectedPicture Gets or sets a picture selected in the active worksheet.
SelectedShape Gets or sets a shape selected in the active worksheet.
Selection Gets or sets a cell range selected in the active worksheet.
ShowFocusCues protected Gets a value indicating whether the control should display focus rectangles. Inherited from Control.
ShowKeyboardCues protected Gets a value indicating whether the user interface is in the appropriate state to show or hide keyboard accelerators. Inherited from Control.
Site Gets or sets the site of the control. Inherited from Control.
Size Gets or sets the height and width of the control. Inherited from Control.
TabIndex Gets or sets the tab order of the control within its container. Inherited from Control.
TabStop Gets or sets a value indicating whether the user can give the focus to this control using the TAB key. Inherited from Control.
Tag Gets or sets the object that contains data about the control. Inherited from Control.
Text Gets or sets the text associated with this control. Inherited from Control.
ToolTipController Gets or sets the tooltip controller component that controls the appearance, position and the content of the hints displayed by the SpreadsheetControl.
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 Control.
TopLevelControl Gets the parent control that is not parented by another Windows Forms control. Typically, this is the outermost Form that the control is contained in. Inherited from Control.
Unit Gets or sets a unit of measure used in the workbook.
UseWaitCursor Gets or sets a value indicating whether to use the wait cursor for the current control and all child controls. Inherited from Control.
Visible Gets or sets a value indicating whether the control and all its child controls are displayed. Inherited from Control.
VisibleRange Gets the cell range that is currently visible in the SpreadsheetControl.
VisibleUnfrozenRange Gets the visible cell range of the scrollable area when there are frozen rows and columns in the worksheet.
Width Gets or sets the width of the control. Inherited from Control.
WindowTarget This property is not relevant for this class. Inherited from Control.
WorksheetDisplayArea Provides access to an object enabling you to specify a worksheet area that is visible in the SpreadsheetControl and allows end-user input.

Methods

Name Description
About() static Invokes the About dialog box.
AccessibilityNotifyClients(AccessibleEvents, Int32) protected Notifies the accessibility client applications of the specified AccessibleEvents for the specified child control. Inherited from Control.
AccessibilityNotifyClients(AccessibleEvents, Int32, Int32) protected Notifies the accessibility client applications of the specified AccessibleEvents for the specified child control . Inherited from Control.
AddService(Type, ServiceCreatorCallback) Adds the specified service to the service container.
AddService(Type, ServiceCreatorCallback, Boolean) Adds the specified service to the service container.
AddService(Type, Object) Adds the specified service to the service container.
AddService(Type, Object, Boolean) Adds the specified service to the service container.
AddToolbarToMenuManager(SpreadsheetToolbarType) Adds the specified ribbon tabs/bar groups to the existing ribbon or toolbar menu.
AssignShortcutKeyToCommand(Keys, Keys, SpreadsheetCommandId) Assigns a shortcut key to a command.
BeginInvoke(Delegate) Executes the specified delegate asynchronously on the thread that the control's underlying handle was created on. Inherited from Control.
BeginInvoke(Delegate, Object[]) Executes the specified delegate asynchronously with the specified arguments, on the thread that the control's underlying handle was created on. Inherited from Control.
BeginUpdate() Locks the SpreadsheetControl to prevent its visual updates until the SpreadsheetControl.EndUpdate method is called.
BringToFront() Brings the control to the front of the z-order. Inherited from Control.
CancelUpdate() This method supports the internal infrastructure and is not intended to be called directly from your code. Use the SpreadsheetControl.EndUpdate method instead.
CircleInvalidData() Displays circles around invalid data in a worksheet to which data validation is applied.
ClearValidationCircles() Hides circles around invalid data in a worksheet to which data validation is applied.
CloseCellEditor(CellEditorEnterValueMode) Closes the cell editor.
Contains(Control) Retrieves a value indicating whether the specified control is a child of the control. Inherited from Control.
CreateAccessibilityInstance() protected Creates a new accessibility object for the control. Inherited from Control.
CreateBars() Creates a BarManager that contains all SpreadsheetControl-specific bars.
CreateBars(SpreadsheetToolbarType) Adds a BarManager with the specified bars to the SpreadsheetControl.
CreateCommand(SpreadsheetCommandId) Creates a command by its identifier.
CreateControl() Forces the creation of the visible control, including the creation of the handle and any visible child controls. Inherited from Control.
CreateControlsInstance() protected Creates a new instance of the control collection for the control. Inherited from Control.
CreateGraphics() Creates the Graphics for the control. Inherited from Control.
CreateHandle() protected Creates a handle for the control. Inherited from Control.
CreateNewDocument() Creates and loads a new empty workbook.
CreateObjRef(Type) Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. Inherited from MarshalByRefObject.
CreateRibbon() Creates a RibbonControl with all SpreadsheetControl-specific ribbon tabs.
CreateRibbon(SpreadsheetToolbarType) Adds a RibbonControl with the specified tabs to the SpreadsheetControl.
CreateRibbonStatusBar(RibbonControl) Creates a RibbonStatusBar with all Spreadsheet-related items and binds it to the specified RibbonControl.
CreateRibbonStatusBar(RibbonControl, SpreadsheetStatusBarItems) Creates a RibbonStatusBar with the specified items and binds it to the RibbonControl.
CreateStatusBarManager() Adds a status bar with all Spreadsheet-related items to the Spreadsheet control with a Bar UI.
CreateStatusBarManager(SpreadsheetStatusBarItems) Adds a status bar with the specified items to the Spreadsheet control with a Bar UI.
DefWndProc(Message) protected Sends the specified message to the default window procedure. Inherited from Control.
DestroyHandle() protected Destroys the handle associated with the control. Inherited from Control.
Dispose() Releases all resources used by the Component. Inherited from Component.
DoDragDrop(Object, DragDropEffects) Begins a drag-and-drop operation. Inherited from Control.
DrawToBitmap(Bitmap, Rectangle) Supports rendering to the specified bitmap. Inherited from Control.
EndInvoke(IAsyncResult) Retrieves the return value of the asynchronous operation represented by the IAsyncResult passed. Inherited from Control.
EndUpdate() Unlocks the SpreadsheetControl object after a call to the SpreadsheetControl.BeginUpdate method and causes an immediate visual update.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
ExportToHtml(Stream, CellRange) Exports the specified range to the specified stream in HTML format.
ExportToHtml(Stream, Worksheet) Exports the specified worksheet to the specified stream in HTML format.
ExportToHtml(Stream, HtmlDocumentExporterOptions) Exports the document's data to the specified stream in HTML format using the specified options.
ExportToHtml(Stream, Int32) Exports the specified worksheet to the specified stream in HTML format.
ExportToHtml(String, CellRange) Exports the specified range to the specified file in HTML format.
ExportToHtml(String, Worksheet) Exports the specified worksheet to the specified file in HTML format.
ExportToHtml(String, HtmlDocumentExporterOptions) Exports the document's data to the specified file in HTML format using the specified options.
ExportToHtml(String, Int32) Exports the specified worksheet to the specified file in HTML format.
ExportToPdf(Stream) Exports the content of the SpreadsheetControl to the specified stream in PDF format.
ExportToPdf(Stream, PdfExportOptions) Exports the content of the SpreadsheetControl to the specified stream in PDF format using the specified options.
ExportToPdf(String) Exports the content of the SpreadsheetControl to the specified file in PDF format.
ExportToPdf(String, PdfExportOptions) Exports the content of the SpreadsheetControl to the specified file in PDF format using the specified options.
FindForm() Retrieves the form that the control is on. Inherited from Control.
Focus() Sets input focus to the control. Inherited from Control.
FromChildHandle(IntPtr) static Retrieves the control that contains the specified handle. Inherited from Control.
FromHandle(IntPtr) static Returns the control that is currently associated with the specified handle. Inherited from Control.
GetAccessibilityObjectById(Int32) protected Retrieves the specified AccessibleObject. Inherited from Control.
GetAutoSizeMode() protected Retrieves a value indicating how a control will behave when its AutoSize property is enabled. Inherited from Control.
GetCellBounds(Int32, Int32) Obtains the coordinates and size of a cell specified by the row and column indices.
GetCellFromPoint(PointF) Gets a worksheet cell located at the specified point.
GetChildAtPoint(Point) Retrieves the child control that is located at the specified coordinates. Inherited from Control.
GetChildAtPoint(Point, GetChildAtPointSkip) Retrieves the child control that is located at the specified coordinates, specifying whether to ignore child controls of a certain type. Inherited from Control.
GetContainerControl() Returns the next ContainerControl up the control's chain of parent controls. Inherited from Control.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetLifetimeService() Retrieves the current lifetime service object that controls the lifetime policy for this instance. Inherited from MarshalByRefObject.
GetNextControl(Control, Boolean) Retrieves the next control forward or back in the tab order of child controls. Inherited from Control.
GetPreferredSize(Size) Retrieves the size of a rectangular area into which a control can be fitted. Inherited from Control.
GetScaledBounds(Rectangle, SizeF, BoundsSpecified) protected Retrieves the bounds within which the control is scaled. Inherited from Control.
GetSelectedRanges() Returns cell ranges currently selected in the active worksheet.
GetSelectedShapes() Returns shapes currently selected in the active worksheet.
GetService(Type) Gets the service object of the specified type.
GetService<T>() Gets the specified service.
GetStyle(ControlStyles) protected Retrieves the value of the specified control style bit for the control. Inherited from Control.
GetTopLevel() protected Determines if the control is a top-level control. Inherited from Control.
GetType() Gets the Type of the current instance. Inherited from Object.
Hide() Conceals the control from the user. Inherited from Control.
InitializeLifetimeService() Obtains a lifetime service object to control the lifetime policy for this instance. Inherited from MarshalByRefObject.
InitLayout() protected Called after the control has been added to another container. Inherited from Control.
Invalidate() Invalidates the entire surface of the control and causes the control to be redrawn. Inherited from Control.
Invalidate(Boolean) 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 Control.
Invalidate(Rectangle) Invalidates the specified region of the control (adds it to the control's update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Inherited from Control.
Invalidate(Rectangle, Boolean) Invalidates the specified region of the control (adds it to the control's update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. Inherited from Control.
Invalidate(Region) Invalidates the specified region of the control (adds it to the control's update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Inherited from Control.
Invalidate(Region, Boolean) Invalidates the specified region of the control (adds it to the control's update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. Inherited from Control.
Invoke(Delegate) Executes the specified delegate on the thread that owns the control's underlying window handle. Inherited from Control.
Invoke(Delegate, Object[]) Executes the specified delegate, on the thread that owns the control's underlying window handle, with the specified list of arguments. Inherited from Control.
InvokeGotFocus(Control, EventArgs) protected Raises the GotFocus event for the specified control. Inherited from Control.
InvokeLostFocus(Control, EventArgs) protected Raises the LostFocus event for the specified control. Inherited from Control.
InvokeOnClick(Control, EventArgs) protected Raises the Click event for the specified control. Inherited from Control.
InvokePaint(Control, PaintEventArgs) protected Raises the Paint event for the specified control. Inherited from Control.
InvokePaintBackground(Control, PaintEventArgs) protected Raises the PaintBackground event for the specified control. Inherited from Control.
IsInputChar(Char) protected Determines if a character is an input character that the control recognizes. Inherited from Control.
IsKeyLocked(Keys) static Determines whether the CAPS LOCK, NUM LOCK, or SCROLL LOCK key is in effect. Inherited from Control.
IsMnemonic(Char, String) static Determines if the specified character is the mnemonic character assigned to the control in the specified string. Inherited from Control.
LoadDocument() Invokes the Open dialog, creates a specific importer and loads the file.
LoadDocument(Byte[]) Load the document from a Byte[] array.
LoadDocument(Byte[], DocumentFormat) Loads a document from a byte array.
LoadDocument(Stream) Loads the document from a stream.
LoadDocument(Stream, DocumentFormat) Loads a document from a stream, specifying the document format.
LoadDocument(String) Loads a document from a file.
LoadDocument(String, DocumentFormat) Loads a document from a file, specifying the document format.
LoadDocument(IWin32Window) Invokes the Open file dialog as a child of the specified parent window.
LogicalToDeviceUnits(Size) Transforms a size from logical to device units by scaling it for the current DPI and rounding down to the nearest integer value for width and height. Inherited from Control.
LogicalToDeviceUnits(Int32) Converts a Logical DPI value to its equivalent DeviceUnit DPI value. Inherited from Control.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
MemberwiseClone(Boolean) protected Creates a shallow copy of the current MarshalByRefObject object. Inherited from MarshalByRefObject.
NotifyInvalidate(Rectangle) protected Raises the Invalidated event with a specified region of the control to invalidate. Inherited from Control.
OnAutoSizeChanged(EventArgs) protected Raises the AutoSizeChanged event. Inherited from Control.
OnBackColorChanged(EventArgs) protected Raises the BackColorChanged event. Inherited from Control.
OnBackgroundImageChanged(EventArgs) protected Raises the BackgroundImageChanged event. Inherited from Control.
OnBackgroundImageLayoutChanged(EventArgs) protected Raises the BackgroundImageLayoutChanged event. Inherited from Control.
OnBindingContextChanged(EventArgs) protected Raises the BindingContextChanged event. Inherited from Control.
OnCausesValidationChanged(EventArgs) protected Raises the CausesValidationChanged event. Inherited from Control.
OnChangeUICues(UICuesEventArgs) protected Raises the ChangeUICues event. Inherited from Control.
OnClick(EventArgs) protected Raises the Click event. Inherited from Control.
OnClientSizeChanged(EventArgs) protected Raises the ClientSizeChanged event. Inherited from Control.
OnContextMenuChanged(EventArgs) protected Raises the ContextMenuChanged event. Inherited from Control.
OnContextMenuStripChanged(EventArgs) protected Raises the ContextMenuStripChanged event. Inherited from Control.
OnControlAdded(ControlEventArgs) protected Raises the ControlAdded event. Inherited from Control.
OnControlRemoved(ControlEventArgs) protected Raises the ControlRemoved event. Inherited from Control.
OnCreateControl() protected Raises the CreateControl() method. Inherited from Control.
OnCursorChanged(EventArgs) protected Raises the CursorChanged event. Inherited from Control.
OnDockChanged(EventArgs) protected Raises the DockChanged event. Inherited from Control.
OnDoubleClick(EventArgs) protected Raises the DoubleClick event. Inherited from Control.
OnDpiChangedAfterParent(EventArgs) protected Raises the DpiChangedAfterParent event. Inherited from Control.
OnDpiChangedBeforeParent(EventArgs) protected Raises the DpiChangedBeforeParent event. Inherited from Control.
OnEnter(EventArgs) protected Raises the Enter event. Inherited from Control.
OnFontChanged(EventArgs) protected Raises the FontChanged event. Inherited from Control.
OnForeColorChanged(EventArgs) protected Raises the ForeColorChanged event. Inherited from Control.
OnHelpRequested(HelpEventArgs) protected Raises the HelpRequested event. Inherited from Control.
OnImeModeChanged(EventArgs) protected Raises the ImeModeChanged event. Inherited from Control.
OnInvalidated(InvalidateEventArgs) protected Raises the Invalidated event. Inherited from Control.
OnLayout(LayoutEventArgs) protected Raises the Layout event. Inherited from Control.
OnLeave(EventArgs) protected Raises the Leave event. Inherited from Control.
OnLocationChanged(EventArgs) protected Raises the LocationChanged event. Inherited from Control.
OnMarginChanged(EventArgs) protected Raises the MarginChanged event. Inherited from Control.
OnMouseCaptureChanged(EventArgs) protected Raises the MouseCaptureChanged event. Inherited from Control.
OnMouseClick(MouseEventArgs) protected Raises the MouseClick event. Inherited from Control.
OnMouseDoubleClick(MouseEventArgs) protected Raises the MouseDoubleClick event. Inherited from Control.
OnMouseEnter(EventArgs) protected Raises the MouseEnter event. Inherited from Control.
OnMouseHover(EventArgs) protected Raises the MouseHover event. Inherited from Control.
OnMove(EventArgs) protected Raises the Move event. Inherited from Control.
OnNotifyMessage(Message) protected Notifies the control of Windows messages. Inherited from Control.
OnPaddingChanged(EventArgs) protected Raises the PaddingChanged event. Inherited from Control.
OnParentBackColorChanged(EventArgs) protected Raises the BackColorChanged event when the BackColor property value of the control's container changes. Inherited from Control.
OnParentBackgroundImageChanged(EventArgs) protected Raises the BackgroundImageChanged event when the BackgroundImage property value of the control's container changes. Inherited from Control.
OnParentBindingContextChanged(EventArgs) protected Raises the BindingContextChanged event when the BindingContext property value of the control's container changes. Inherited from Control.
OnParentChanged(EventArgs) protected Raises the ParentChanged event. Inherited from Control.
OnParentCursorChanged(EventArgs) protected Raises the CursorChanged event. Inherited from Control.
OnParentEnabledChanged(EventArgs) protected Raises the EnabledChanged event when the Enabled property value of the control's container changes. Inherited from Control.
OnParentFontChanged(EventArgs) protected Raises the FontChanged event when the Font property value of the control's container changes. Inherited from Control.
OnParentForeColorChanged(EventArgs) protected Raises the ForeColorChanged event when the ForeColor property value of the control's container changes. Inherited from Control.
OnParentRightToLeftChanged(EventArgs) protected Raises the RightToLeftChanged event when the RightToLeft property value of the control's container changes. Inherited from Control.
OnParentVisibleChanged(EventArgs) protected Raises the VisibleChanged event when the Visible property value of the control's container changes. Inherited from Control.
OnPreviewKeyDown(PreviewKeyDownEventArgs) protected Raises the PreviewKeyDown event. Inherited from Control.
OnPrint(PaintEventArgs) protected Raises the Paint event. Inherited from Control.
OnRegionChanged(EventArgs) protected Raises the RegionChanged event. Inherited from Control.
OnRightToLeftChanged(EventArgs) protected Raises the RightToLeftChanged event. Inherited from Control.
OnStyleChanged(EventArgs) protected Raises the StyleChanged event. Inherited from Control.
OnSystemColorsChanged(EventArgs) protected Raises the SystemColorsChanged event. Inherited from Control.
OnTabIndexChanged(EventArgs) protected Raises the TabIndexChanged event. Inherited from Control.
OnTabStopChanged(EventArgs) protected Raises the TabStopChanged event. Inherited from Control.
OnTextChanged(EventArgs) protected Raises the TextChanged event. Inherited from Control.
OnValidated(EventArgs) protected Raises the Validated event. Inherited from Control.
OnValidating(CancelEventArgs) protected Raises the Validating event. Inherited from Control.
OnVisibleChanged(EventArgs) protected Raises the VisibleChanged event. Inherited from Control.
OpenCellEditor(CellEditorMode) Invokes a cell editor and switches to the spreadsheet edit mode, allowing you to edit cell content.
PerformLayout() Forces the control to apply layout logic to all its child controls. Inherited from Control.
PerformLayout(Control, String) Forces the control to apply layout logic to all its child controls. Inherited from Control.
PointToClient(Point) Computes the location of the specified screen point into client coordinates. Inherited from Control.
PointToScreen(Point) Computes the location of the specified client point into screen coordinates. Inherited from Control.
PreProcessControlMessage(Message) Preprocesses keyboard or input messages within the message loop before they are dispatched. Inherited from Control.
PreProcessMessage(Message) Preprocesses keyboard or input messages within the message loop before they are dispatched. Inherited from Control.
Print() Prints the document to the default printer.
Print(PrinterSettings) Prints the document using the specified printer settings.
ProcessCmdKey(Message, Keys) protected Processes a command key. Inherited from Control.
ProcessDialogKey(Keys) protected Processes a dialog key. Inherited from Control.
ProcessKeyEventArgs(Message) protected Processes a key message and generates the appropriate control events. Inherited from Control.
ProcessKeyMessage(Message) protected Processes a keyboard message. Inherited from Control.
ProcessKeyPreview(Message) protected Previews a keyboard message. Inherited from Control.
ProcessMnemonic(Char) protected Processes a mnemonic character. Inherited from Control.
RaiseDragEvent(Object, DragEventArgs) protected Raises the appropriate drag event. Inherited from Control.
RaiseKeyEvent(Object, KeyEventArgs) protected Raises the appropriate key event. Inherited from Control.
RaiseMouseEvent(Object, MouseEventArgs) protected Raises the appropriate mouse event. Inherited from Control.
RaisePaintEvent(Object, PaintEventArgs) protected Raises the appropriate paint event. Inherited from Control.
RecreateHandle() protected Forces the re-creation of the handle for the control. Inherited from Control.
RectangleToClient(Rectangle) Computes the size and location of the specified screen rectangle in client coordinates. Inherited from Control.
RectangleToScreen(Rectangle) Computes the size and location of the specified client rectangle in screen coordinates. Inherited from Control.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
ReflectMessage(IntPtr, Message) protected static Reflects the specified message to the control that is bound to the specified handle. Inherited from Control.
Refresh() Forces the control to invalidate its client area and immediately redraw itself and any child controls. Inherited from Control.
RemoveService(Type) Removes the service of the specified type from the service container.
RemoveService(Type, Boolean) Removes the service of the specified type from the service container.
RemoveShortcutKey(Keys, Keys) Removes a command shortcut.
ReplaceService<T>(T) Performs a service substitution.
RescaleConstantsForDpi(Int32, Int32) protected Provides constants for rescaling the control when a DPI change occurs. Inherited from Control.
ResetBackColor() Resets the BackColor property to its default value. Inherited from Control.
ResetBindings() Causes a control bound to the BindingSource to reread all the items in the list and refresh their displayed values. Inherited from Control.
ResetCursor() Resets the Cursor property to its default value. Inherited from Control.
ResetFont() Resets the Font property to its default value. Inherited from Control.
ResetForeColor() Resets the ForeColor property to its default value. Inherited from Control.
ResetImeMode() Resets the ImeMode property to its default value. Inherited from Control.
ResetLayout() Updates the layout of the document loaded into control and the control itself.
ResetMouseEventArgs() protected Resets the control to handle the MouseLeave event. Inherited from Control.
ResetRightToLeft() Resets the RightToLeft property to its default value. Inherited from Control.
ResetText() Resets the Text property to its default value (Empty). Inherited from Control.
ResumeLayout() Resumes usual layout logic. Inherited from Control.
ResumeLayout(Boolean) Resumes usual layout logic, optionally forcing an immediate layout of pending layout requests. Inherited from Control.
RtlTranslateAlignment(ContentAlignment) protected Converts the specified ContentAlignment to the appropriate ContentAlignment to support right-to-left text. Inherited from Control.
RtlTranslateAlignment(HorizontalAlignment) protected Converts the specified HorizontalAlignment to the appropriate HorizontalAlignment to support right-to-left text. Inherited from Control.
RtlTranslateAlignment(LeftRightAlignment) protected Converts the specified LeftRightAlignment to the appropriate LeftRightAlignment to support right-to-left text. Inherited from Control.
RtlTranslateContent(ContentAlignment) protected Converts the specified ContentAlignment to the appropriate ContentAlignment to support right-to-left text. Inherited from Control.
RtlTranslateHorizontal(HorizontalAlignment) protected Converts the specified HorizontalAlignment to the appropriate HorizontalAlignment to support right-to-left text. Inherited from Control.
RtlTranslateLeftRight(LeftRightAlignment) protected Converts the specified LeftRightAlignment to the appropriate LeftRightAlignment to support right-to-left text. Inherited from Control.
SaveDocument() Saves a document in its original format to its original location.
SaveDocument(DocumentFormat) Saves a document to an array of bytes in the specified format.
SaveDocument(DocumentFormat, EncryptionSettings) Saves a document to an array of bytes in the specified format and with specified encryption settings.
SaveDocument(Stream, DocumentFormat) Saves the workbook to a stream, specifying the export format.
SaveDocument(Stream, DocumentFormat, EncryptionSettings) Saves the workbook to a stream, specifying the export format and encryption options.
SaveDocument(String) Saves the document to the specified file in the Excel or text format. The file format is identified by the file extension.
SaveDocument(String, DocumentFormat) Saves the control's document to a file, specifying the document format.
SaveDocument(String, DocumentFormat, EncryptionSettings) Saves the control's document to a file, specifying the document format and encryption settings.
SaveDocument(String, EncryptionSettings) Saves the document to a file with the specified encryption settings.
SaveDocument(IWin32Window) Saves a document in its original format to its original location. If original format and location are not specified, invokes the Save As dialog that is shown modally as a child of the specified parent window.
SaveDocumentAs() Invokes the Save As dialog and saves a document.
SaveDocumentAs(IWin32Window) Invokes the Save As dialog which is shown modally as a child of the specified parent window.
Scale(SizeF) Scales the control and all child controls by the specified scaling factor. Inherited from Control.
Scale(Single) Scales the control and any child controls. Inherited from Control.
Scale(Single, Single) Scales the entire control and any child controls. Inherited from Control.
ScaleBitmapLogicalToDevice(Bitmap) Scales a logical bitmap value to it's equivalent device unit value when a DPI change occurs. Inherited from Control.
ScaleControl(SizeF, BoundsSpecified) protected Scales a control's location, size, padding and margin. Inherited from Control.
ScaleCore(Single, Single) protected This method is not relevant for this class. Inherited from Control.
Select() Activates the control. Inherited from Control.
Select(Boolean, Boolean) protected Activates a child control. Optionally specifies the direction in the tab order to select the control from. Inherited from Control.
SelectNextControl(Control, Boolean, Boolean, Boolean, Boolean) Activates the next control. Inherited from Control.
SendToBack() Sends the control to the back of the z-order. Inherited from Control.
SetAutoSizeMode(AutoSizeMode) protected Sets a value indicating how a control will behave when its AutoSize property is enabled. Inherited from Control.
SetBounds(Int32, Int32, Int32, Int32) Sets the bounds of the control to the specified location and size. Inherited from Control.
SetBounds(Int32, Int32, Int32, Int32, BoundsSpecified) Sets the specified bounds of the control to the specified location and size. Inherited from Control.
SetBoundsCore(Int32, Int32, Int32, Int32, BoundsSpecified) protected Performs the work of setting the specified bounds of this control. Inherited from Control.
SetClientSizeCore(Int32, Int32) protected Sets the size of the client area of the control. Inherited from Control.
SetSelectedRanges(IList<CellRange>) Sets cell ranges selected in the active worksheet.
SetSelectedRanges(IList<CellRange>, Boolean) Selects cell ranges in the worksheet and specifies whether the selection expands to fit merged cells.
SetSelectedShapes(IList<Shape>) Sets shapes selected in the active worksheet.
SetStyle(ControlStyles, Boolean) protected Sets a specified ControlStyles flag to either true or false. Inherited from Control.
SetTopLevel(Boolean) protected Sets the control as the top-level control. Inherited from Control.
SetVisibleCore(Boolean) protected Sets the control to the specified visible state. Inherited from Control.
Show() Displays the control to the user. Inherited from Control.
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.
ShowPrintPreview() Invokes the Print Preview window with a Bar UI.
ShowRibbonPrintPreview() Invokes the Print Preview window with a Ribbon UI.
SizeFromClientSize(Size) protected Determines the size of the entire control from the height and width of its client area. Inherited from Control.
SuspendLayout() Temporarily suspends the layout logic for the control. Inherited from Control.
IDropTarget.OnDragDrop(DragEventArgs) Raises the DragDrop event. Inherited from Control.
IDropTarget.OnDragEnter(DragEventArgs) Raises the DragEnter event. Inherited from Control.
IDropTarget.OnDragLeave(EventArgs) Raises the DragLeave event. Inherited from Control.
IDropTarget.OnDragOver(DragEventArgs) Raises the DragOver event. Inherited from Control.
ToString() Returns a String containing the name of the Component, if any. This method should not be overridden. Inherited from Component.
Update() Causes the control to redraw the invalidated regions within its client area. Inherited from Control.
UpdateBounds() protected Updates the bounds of the control with the current size and location. Inherited from Control.
UpdateBounds(Int32, Int32, Int32, Int32) protected Updates the bounds of the control with the specified size and location. Inherited from Control.
UpdateBounds(Int32, Int32, Int32, Int32, Int32, Int32) protected Updates the bounds of the control with the specified size, location, and client size. Inherited from Control.
UpdateCommandUI() Refreshes the SpreadsheetControl command UI.
UpdateStyles() protected Forces the assigned styles to be reapplied to the control. Inherited from Control.
UpdateZOrder() protected Updates the control in its parent's z-order. Inherited from Control.

Events

Name Description
ActiveSheetChanged Occurs after an active worksheet has been changed via the SpreadsheetControl's UI.
ActiveSheetChanging Occurs when an active worksheet is about to be changed via the SpreadsheetControl's UI.
AfterDropRange Occurs after a user dropped the selected cell range in a new location.
AfterFillRange Occurs after a cell range was automatically filled with data based on values in the source range.
AutoSizeChanged This event is not relevant for this class. Inherited from Control.
BackColorChanged Occurs when the value of the BackColor property changes. Inherited from Control.
BackgroundImageChanged Occurs when the value of the BackgroundImage property changes. Inherited from Control.
BackgroundImageLayoutChanged Occurs when the BackgroundImageLayout property changes. Inherited from Control.
BeforeDispose Occurs before the SpreadsheetControl control is released from memory.
BeforeDragRange Occurs when a user starts to drag the selected cell range.
BeforeDropRange Occurs when a user is about to drop the selected cell range in a new location.
BeforeExport Occurs before the document is saved (exported to a certain format).
BeforeFillRange Occurs when a user drags the fill handle to populate cells with data based on values in the source range.
BeforeImport Occurs before a document is loaded (imported from an external source).
BeforePrintSheet Provides the capability to prevent printing of the required worksheets in a workbook.
BindingContextChanged Occurs when the value of the BindingContext property changes. Inherited from Control.
CausesValidationChanged Occurs when the value of the CausesValidation property changes. Inherited from Control.
CellBeginEdit Occurs before a cell editor is opened.
CellCancelEdit Occurs before the cell editor is closed and the entered value is rolled back.
CellEndEdit Occurs before a cell editor is closed and the entered value is committed.
CellValueChanged Occurs after the cell content was changed via the SpreadsheetControl UI.
ChangeUICues Occurs when the focus or keyboard user interface (UI) cues change. Inherited from Control.
Click Occurs when the control is clicked. Inherited from Control.
ClientSizeChanged Occurs when the value of the ClientSize property changes. Inherited from Control.
ClipboardDataObtained Occurs after data on the clipboard is obtained and recognized, but before data is pasted.
ClipboardDataPasted Occurs after data was pasted from the clipboard onto a worksheet.
ClipboardDataPasting Occurs before data is pasted into destination cells.
ColumnsInserted Occurs after new columns have been added to a worksheet via the SpreadsheetControl's UI.
ColumnsInserting Occurs when new columns are about to be inserted into a worksheet.
ColumnsRemoved Occurs after columns have been deleted from a worksheet via the SpreadsheetControl's UI.
ColumnsRemoving Occurs when columns are about to be deleted from a worksheet.
ColumnWidthChanged Occurs after the column width was changed.
CommentInserted Occurs when a comment is inserted.
CommentInserting Occurs before inserting a comment.
CommentRemoved Occurs when a comment is deleted.
CommentRemoving Occurs before deleting a comment.
ContentChanged Occurs when the document content is changed.
ContextMenuChanged Occurs when the value of the ContextMenu property changes. Inherited from Control.
ContextMenuStripChanged Occurs when the value of the ContextMenuStrip property changes. Inherited from Control.
ControlAdded Occurs when a new control is added to the Control.ControlCollection. Inherited from Control.
ControlRemoved Occurs when a control is removed from the Control.ControlCollection. Inherited from Control.
CopiedRangePasted Occurs after the range content has been pasted into target cells.
CopiedRangePasting Occurs before the range content is pasted into target cells.
CursorChanged Occurs when the value of the Cursor property changes. Inherited from Control.
CustomAssemblyLoading Occurs before a custom assembly is loaded for use as the Entity Framework data source during mail merge and allows cancelling loading.
CustomCellEdit Allows you to assign a custom in-place editor to a cell.
CustomDrawCell Allows you to paint cell content.
CustomDrawCellBackground Performs custom painting of the cell background.
CustomDrawColumnHeader Enables the column header to be painted manually.
CustomDrawColumnHeaderBackground Enables the column header background to be painted manually.
CustomDrawCommentIndicator Allows you to customize comment indicators.
CustomDrawFrozenPaneBorder Enables frozen pane borders to be painted manually.
CustomDrawRowHeader Enables the row header to be painted manually.
CustomDrawRowHeaderBackground Enables the row header background to be painted manually.
DataBindingWarning Occurs before a data binding warning dialog is shown in the SpreadsheetControl.
DefinedNameConflictResolving Occurs when a formula or sheet being moved or copied contains a defined name which already exists on the destination worksheet or workbook.
DefinedNameDeleting Occurs before a Defined Name is deleted.
DefinedNameEditing Occurs before a Defined Name is being edited.
DefinedNameValidating Occurs when a new Defined Name is created before it is added to a collection.
Disposed Occurs when the component is disposed by a call to the Dispose() method. Inherited from Component.
DockChanged Occurs when the value of the Dock property changes. Inherited from Control.
DocumentClosing Occurs when a document that has not yet been saved is about to be closed.
DocumentLoaded Occurs after a document is loaded into the Spreadsheet control.
DocumentPropertiesChanged Occurs after one of the DocumentProperties is changed.
DocumentSaved Occurs after a document has been saved.
DoubleClick Occurs when the control is double-clicked. Inherited from Control.
DpiChangedAfterParent Occurs when the DPI setting for a control is changed programmatically after the DPI of its parent control or form has changed. Inherited from Control.
DpiChangedBeforeParent Occurs when the DPI setting for a control is changed programmatically before a DPI change event for its parent control or form has occurred. Inherited from Control.
DragDrop Occurs when a drag-and-drop operation is completed. Inherited from Control.
DragEnter Occurs when an object is dragged into the control's bounds. Inherited from Control.
DragLeave Occurs when an object is dragged out of the control's bounds. Inherited from Control.
DragOver Occurs when an object is dragged over the control's bounds. Inherited from Control.
EmptyDocumentCreated Occurs when a new document is created in the SpreadsheetControl.
EnabledChanged Occurs when the Enabled property value has changed. Inherited from Control.
EncryptedFileIntegrityCheckFailed Occurs when the encrypted file does not pass data integrity verification.
EncryptedFilePasswordCheckFailed Occurs when the encryption password is empty or invalid.
EncryptedFilePasswordRequest Occurs when the WorkbookImportOptions.Password property is not set or contains the wrong password.
Enter Occurs when the control is entered. Inherited from Control.
FontChanged Occurs when the Font property value changes. Inherited from Control.
ForeColorChanged Occurs when the ForeColor property value changes. Inherited from Control.
GiveFeedback Occurs during a drag operation. Inherited from Control.
GotFocus Occurs when the control receives focus. Inherited from Control.
HandleCreated Occurs when a handle is created for the control. Inherited from Control.
HandleDestroyed Occurs when the control's handle is in the process of being destroyed. Inherited from Control.
HelpRequested Occurs when the user requests help for a control. Inherited from Control.
HyperlinkClick Occurs when an end-user activates the hyperlink before navigating to the referenced location.
ImeModeChanged Occurs when the ImeMode property has changed. Inherited from Control.
InitializeDocument Occurs before a document is loaded. Handle this event to set the initial document settings.
Invalidated Occurs when a control's display requires redrawing. Inherited from Control.
InvalidFormatException Fires when the supplied data could not be recognized as data in the assumed format for import.
KeyDown Occurs when a key is pressed while the control has focus. Inherited from Control.
KeyPress Occurs when a character. space or backspace key is pressed while the control has focus. Inherited from Control.
KeyUp Occurs when a key is released while the control has focus. Inherited from Control.
Layout Occurs when a control should reposition its child controls. Inherited from Control.
Leave Occurs when the input focus leaves the control. Inherited from Control.
LocationChanged Occurs when the Location property value has changed. Inherited from Control.
LostFocus Occurs when the control loses focus. Inherited from Control.
MarginChanged Occurs when the control's margin changes. Inherited from Control.
ModifiedChanged Occurs when the value of the SpreadsheetControl.Modified property is changed.
MouseCaptureChanged Occurs when the control loses mouse capture. Inherited from Control.
MouseClick Occurs when the control is clicked by the mouse. Inherited from Control.
MouseDoubleClick Occurs when the control is double clicked by the mouse. Inherited from Control.
MouseDown Occurs when the mouse pointer is over the control and a mouse button is pressed. Inherited from Control.
MouseEnter Occurs when the mouse pointer enters the control. Inherited from Control.
MouseHover Occurs when the mouse pointer rests on the control. Inherited from Control.
MouseLeave Occurs when the mouse pointer leaves the control. Inherited from Control.
MouseMove Occurs when the mouse pointer is moved over the control. Inherited from Control.
MouseUp Occurs when the mouse pointer is over the control and a mouse button is released. Inherited from Control.
MouseWheel Occurs when the mouse wheel moves while the control has focus. Inherited from Control.
Move Occurs when the control is moved. Inherited from Control.
PaddingChanged Occurs when the control's padding changes. Inherited from Control.
Paint Occurs when the control is redrawn. Inherited from Control.
PanesFrozen Occurs after a worksheet area has been frozen via the SpreadsheetControl's UI.
PanesUnfrozen Occurs after a frozen worksheet area has been unlocked via the SpreadsheetControl's UI.
ParentChanged Occurs when the Parent property value changes. Inherited from Control.
PopupMenuShowing Occurs when a popup menu is about to be displayed for the SpreadsheetControl's visual elements.
PreviewKeyDown Occurs before the KeyDown event when a key is pressed while focus is on this control. Inherited from Control.
PropertyChanged Occurs every time any of the SpreadsheetControl class properties has changed its value.
ProtectionWarning Occurs when attempting to edit a locked cell in a protected worksheet.
QueryAccessibilityHelp Occurs when AccessibleObject is providing help to accessibility applications. Inherited from Control.
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 Control.
RangeCopied Occurs after the range content has been copied.
RangeCopying Occurs before a cell range is copied in a worksheet.
ReadOnlyChanged Occurs when the SpreadsheetControl's read-only state is changed.
RegionChanged Occurs when the value of the Region property changes. Inherited from Control.
Resize Occurs when the control is resized. Inherited from Control.
RightToLeftChanged Occurs when the RightToLeft property value changes. Inherited from Control.
RowHeightChanged Occurs after the row height was changed.
RowsInserted Occurs after new rows have been added to a worksheet via the SpreadsheetControl's UI.
RowsInserting Occurs when new rows are about to be inserted into a worksheet.
RowsRemoved Occurs after rows have been deleted from a worksheet via the SpreadsheetControl's UI.
RowsRemoving Occurs when rows are about to be deleted from a worksheet.
ScrollPositionChanged Occurs when a worksheet is being scrolled in the SpreadsheetControl's UI.
SelectionChanged Fires when the selection changes in an active worksheet.
ShapeInserted Occurs after a drawing object has been inserted into a worksheet.
ShapeRemoved Occurs after a drawing object has been removed from a worksheet.
ShapeRemoving Occurs before a drawing object is removed from a worksheet.
ShapesCopying Occurs before a drawing object is copied.
SheetInserted Occurs after a new worksheet has been added into a workbook via the SpreadsheetControl's UI.
SheetRemoved Occurs after a worksheet has been removed from a workbook via the SpreadsheetControl's UI.
SheetRemoving Occurs when a worksheet is about to be removed from a workbook.
SheetRenamed Occurs after a worksheet has been renamed via the SpreadsheetControl's UI.
SheetRenaming Occurs when a worksheet is about to be renamed via the SpreadsheetControl's UI.
SizeChanged Occurs when the Size property value changes. Inherited from Control.
StyleChanged Occurs when the control style changes. Inherited from Control.
SystemColorsChanged Occurs when the system colors change. Inherited from Control.
TabIndexChanged Occurs when the TabIndex property value changes. Inherited from Control.
TabStopChanged Occurs when the TabStop property value changes. Inherited from Control.
TextChanged Occurs when the Text property value changes. Inherited from Control.
UnhandledException This event is raised when an exception, unhandled by the SpreadsheetControl, occurs.
UnitChanged Fires after a unit of measurement used in the workbook is changed.
UnitChanging Fires before a unit of measurement used within the workbook is changed.
UpdateUI Raised when changes occur which may affect the control's UI.
ValidateCustomSqlQuery Allows validation of the custom SQL query created using the Data Source Wizard.
Validated Occurs when the control is finished validating. Inherited from Control.
Validating Occurs when the control is validating. Inherited from Control.
VisibleChanged Occurs when the Visible property value changes. Inherited from Control.
VisibleRangeChanged Occurs after the visible cell range was changed in the Spreadsheet control.
ZoomChanged Occurs when the current zoom level of the active worksheet has been changed via the SpreadsheetControl's UI.
See Also