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. |
| 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. |
| 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, Int32) protected | Notifies the accessibility client applications of the specified AccessibleEvents for the specified child control . Inherited from Control. |
| AccessibilityNotifyClients(AccessibleEvents, Int32) protected | Notifies the accessibility client applications of the specified AccessibleEvents for the specified child control. Inherited from Control. |
| AddService(Type, ServiceCreatorCallback, Boolean) | Adds the specified service to the service container. |
| AddService(Type, ServiceCreatorCallback) | Adds the specified service to the service container. |
| AddService(Type, Object, Boolean) | Adds the specified service to the service container. |
| AddService(Type, Object) | 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, 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. |
| BeginInvoke(Delegate) | Executes the specified delegate asynchronously 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. |
| 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, SpreadsheetStatusBarItems) | Creates a RibbonStatusBar with the specified items and binds it to the RibbonControl. |
| CreateRibbonStatusBar(RibbonControl) | Creates a RibbonStatusBar with all Spreadsheet-related items and binds it to the specified 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, Object) static | Determines whether the specified object instances are considered equal. Inherited from Object. |
| Equals(Object) | Determines whether the specified object is equal to the current object. 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, PdfExportOptions) | Exports the content of the SpreadsheetControl to the specified stream in PDF format using the specified options. |
| ExportToPdf(Stream) | Exports the content of the SpreadsheetControl to the specified stream in PDF format. |
| ExportToPdf(String, PdfExportOptions) | Exports the content of the SpreadsheetControl to the specified file in PDF format using the specified options. |
| ExportToPdf(String) | Exports the content of the SpreadsheetControl to the specified file in PDF format. |
| 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. |
| 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, 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. |
| GetChildAtPoint(Point) | Retrieves the child control that is located at the specified coordinates. 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, 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(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(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. |
| 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. |
| 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. |
| Invoke(Delegate) | Executes the specified delegate on the thread that owns the control’s underlying window handle. 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[], DocumentFormat) | Loads a document from a byte array. |
| LoadDocument(Byte[]) | Load the document from a Byte[] array. |
| LoadDocument(Stream, DocumentFormat) | Loads a document from a stream, specifying the document format. |
| LoadDocument(Stream) | Loads the document from a stream. |
| LoadDocument(String, DocumentFormat) | Loads a document from a file, specifying the document format. |
| LoadDocument(String) | Loads a document from a file. |
| LoadDocument(IWin32Window) | Invokes the Open file dialog as a child of the specified parent window. |
| 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. |
| 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, Boolean) | Removes the service of the specified type from the service container. |
| RemoveService(Type) | Removes the service of the specified type from the service container. |
| RemoveShortcutKey(Keys, Keys) | Removes a command shortcut. |
| ReplaceService<T>(T) | Allows you to replace the specified service. |
| 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, EncryptionSettings) | Saves a document to an array of bytes in the specified format and with specified encryption settings. |
| SaveDocument(DocumentFormat) | Saves a document to an array of bytes in the specified format. |
| SaveDocument(Stream, DocumentFormat, EncryptionSettings) | Saves the workbook to a stream, specifying the export format and encryption options. |
| SaveDocument(Stream, DocumentFormat) | Saves the workbook to a stream, specifying the export format. |
| SaveDocument(String, DocumentFormat, EncryptionSettings) | Saves the control’s document to a file, specifying the document format and encryption settings. |
| SaveDocument(String, DocumentFormat) | Saves the control’s document to a file, specifying the document format. |
| SaveDocument(String, EncryptionSettings) | Saves the document to a file with the specified encryption settings. |
| 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(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, Single) | Scales the entire control and any child controls. Inherited from Control. |
| Scale(Single) | Scales the control and any child controls. 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, BoundsSpecified) | Sets the specified bounds of the control to the specified location and size. Inherited from Control. |
| SetBounds(Int32, Int32, Int32, Int32) | Sets the 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>, Boolean) | Selects cell ranges in the worksheet and specifies whether the selection expands to fit merged cells. |
| SetSelectedRanges(IList<CellRange>) | Sets cell ranges selected in the active worksheet. |
| 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, Int32, Int32) protected | Updates the bounds of the control with the specified size, location, and client size. Inherited from Control. |
| UpdateBounds(Int32, Int32, Int32, Int32) protected | Updates the bounds of the control with the specified size and location. 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. |
| AfterGroupProcessing | Fires after the expand/collapse operation is executed for row or column groups in a worksheet. |
| AfterOutlineButtonClick | Fires after a user clicks an outline button for row or column groups. |
| 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. |
| BeforeEncodingDetection | Occurs before detecting the encoding of the loaded CSV or TXT data. |
| 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. |
| BeforeGroupProcessing | Fires before the expand/collapse operation is executed for row or column groups in a worksheet. |
| BeforeImport | Occurs before a document is loaded (imported from an external source). |
| BeforeOutlineButtonClick | Fires before a user clicks an outline button for row or column groups. |
| 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. |
| CellEditorOpened | Occurs after a cell editor was activated by a user. |
| 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 you to cancel the operation. |
| 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. |
| DefinedNameAdded | Occurs after the defined name is created. |
| DefinedNameConflictResolving | Occurs when a formula or sheet being moved or copied contains a defined name that already exists in the destination worksheet or workbook. |
| DefinedNameDeleted | Occurs after the defined name is deleted. |
| DefinedNameDeleting | Occurs before a Defined Name is deleted. |
| DefinedNameEdited | Occurs after the defined name parameters were changed. |
| 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. |
| 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. |
| GroupStateChanged | Fires after row or column groups are expanded or collapsed. |
| GroupStateChanging | Fires before row or column groups are expanded or collapsed. |
| 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