SpreadsheetControl Members
In This Article
#Constructors
Name | Description |
---|---|
Spreadsheet |
Initializes a new instance of the Spreadsheet |
#Properties
Name | Description |
---|---|
Accepts |
Gets or sets a value indicating whether pressing the ESC key is processed by the Spreadsheet |
Accepts |
Gets or sets a value indicating whether pressing the RETURN key is processed by the Spreadsheet |
Accepts |
Gets or sets a value indicating whether pressing the TAB key is processed by the Spreadsheet |
Accessibility |
Gets the Accessible |
Accessible |
Gets or sets the default action description of the control for use by accessibility client applications. Inherited from Control. |
Accessible |
Gets or sets the description of the control used by accessibility client applications. Inherited from Control. |
Accessible |
Gets or sets the name of the control used by accessibility client applications. Inherited from Control. |
Accessible |
Gets or sets the accessible role of the control. Inherited from Control. |
Active |
Returns an active cell in the active worksheet. |
Active |
Gets the chart sheet that is currently displayed in the Spreadsheet |
Active |
Gets the sheet that is currently displayed in the Spreadsheet |
Active |
Provides access to a Spreadsheet |
Active |
Gets or sets the zoom level for the sheet currently displayed in the Spreadsheet |
Active |
Gets the worksheet that is currently displayed in the Spreadsheet |
Allow |
Overrides the System. |
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. |
Auto |
Gets or sets where this control is scrolled to in Scroll |
Auto |
This property is not relevant for this class. Inherited from Control. |
Back |
This property is not supported by the Spreadsheet |
Background |
This property has no effect on the Spreadsheet |
Background |
This property has no effect on the Spreadsheet |
Binding |
Gets or sets the Binding |
Border |
Gets or sets the Spreadsheet |
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. |
Can |
Gets a value indicating whether the Ime |
Can |
Gets a value indicating whether the control can receive focus. Inherited from Control. |
Can |
Determines if events can be raised on the control. Inherited from Control. |
Can |
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. |
Causes |
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. |
Check |
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. |
Client |
Gets the rectangle that represents the client area of the control. Inherited from Control. |
Client |
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. |
Company |
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. |
Contains |
Gets a value indicating whether the control, or one of its child controls, currently has the input focus. Inherited from Control. |
Context |
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. |
Create |
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. |
Data |
Gets the data bindings for the control. Inherited from Control. |
Default |
Gets the default background color of the control. Inherited from Control. |
Default |
Gets or sets the default cursor for the control. Inherited from Control. |
Default |
Gets the default font of the control. Inherited from Control. |
Default |
Gets the default foreground color of the control. Inherited from Control. |
Default |
Gets the default Input Method Editor (IME) mode supported by the control. Inherited from Control. |
Default |
Gets the space, in pixels, that is specified by default between controls. Inherited from Control. |
Default |
Gets the length and height, in pixels, that is specified as the default maximum size of a control. Inherited from Control. |
Default |
Gets the length and height, in pixels, that is specified as the default minimum size of a control. Inherited from Control. |
Default |
Gets the internal spacing, in pixels, of the contents of a control. Inherited from Control. |
Design |
Gets a value that indicates whether the Component is currently in design mode. Inherited from Component. |
Display |
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. |
Double |
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. |
Dpi |
Gets the current dpi value for the X-coordinate. |
Dpi |
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 Spreadsheet |
Font |
Gets or sets the height of the font of the control. Inherited from Control. |
Fore |
This property is not supported by the Spreadsheet |
Handle | Gets the window handle that the control is bound to. Inherited from Control. |
Has |
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. |
Ime |
Gets or sets the Input Method Editor (IME) mode of the control. Inherited from Control. |
Ime |
Gets or sets the IME mode of a control. Inherited from Control. |
Invoke |
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. |
Is |
Gets or sets a value indicating whether the control is visible to accessibility applications. Inherited from Control. |
Is |
Gets whether the cell editor is currently active. |
Is |
Gets a value indicating whether the control has been disposed of. Inherited from Control. |
Is |
Gets a value indicating whether the control has a handle associated with it. Inherited from Control. |
Is |
Gets a value indicating whether the control is mirrored. Inherited from Control. |
Is |
Indicates whether the Spreadsheet |
Is |
Gets a value indicating whether a preview of the Spreadsheet |
Is |
Returns a value indicating whether the Spreadsheet |
Layout |
Gets a cached instance of the control’s layout engine. Inherited from Control. |
Layout |
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. |
Look |
Provides access to the control’s look and feel settings. |
Margin | Gets or sets the space between controls. Inherited from Control. |
Maximum |
Gets or sets the size that is the upper limit that Get |
Menu |
Gets or sets the menu manager which controls the look and feel of context menus. |
Minimum |
Gets or sets the size that is the lower limit that Get |
Modified | Gets or sets a value that indicates that the document content was modified since it was last saved. |
Modifier |
Gets a value indicating which of the modifier keys (SHIFT, CTRL, and ALT) is in a pressed state. Inherited from Control. |
Mouse |
Gets a value indicating which of the mouse buttons is in a pressed state. Inherited from Control. |
Mouse |
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 Spreadsheet |
Padding | Gets or sets padding within the control. Inherited from Control. |
Parent | Gets or sets the parent container of the control. Inherited from Control. |
Preferred |
Gets the size of a rectangular area into which the control can fit. Inherited from Control. |
Product |
Gets the product name of the assembly containing the control. Inherited from Control. |
Product |
Gets the version of the assembly containing the control. Inherited from Control. |
Propagating |
Gets an object that represents a propagating IME mode. Inherited from Control. |
Read |
Gets or sets whether document modifications are prohibited. |
Recreating |
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. |
Render |
This property is now obsolete. Inherited from Control. |
Resize |
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. |
Right |
This property is not in effect for the Spreadsheet |
Scale |
Gets a value that determines the scaling of child controls. Inherited from Control. |
Selected |
Gets or sets an active cell in the active worksheet. |
Selected |
Gets or sets a comment selected in the active worksheet. |
Selected |
Gets or sets a picture selected in the active worksheet. |
Selected |
Gets or sets a shape selected in the active worksheet. |
Selection | Gets or sets a cell range selected in the active worksheet. |
Show |
Gets a value indicating whether the control should display focus rectangles. Inherited from Control. |
Show |
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. |
Tab |
Gets or sets the tab order of the control within its container. Inherited from Control. |
Tab |
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. |
Tool |
Gets or sets the tooltip controller component that controls the appearance, position and the content of the hints displayed by the Spreadsheet |
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. |
Top |
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. |
Use |
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. |
Visible |
Gets the cell range that is currently visible in the Spreadsheet |
Visible |
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. |
Window |
This property is not relevant for this class. Inherited from Control. |
Worksheet |
Provides access to an object enabling you to specify a worksheet area that is visible in the Spreadsheet |
#Methods
Name | Description |
---|---|
About() static | Invokes the About dialog box. |
Accessibility |
Notifies the accessibility client applications of the specified Accessible |
Accessibility |
Notifies the accessibility client applications of the specified Accessible |
Add |
Adds the specified service to the service container. |
Add |
Adds the specified service to the service container. |
Add |
Adds the specified service to the service container. |
Add |
Adds the specified service to the service container. |
Add |
Adds the specified ribbon tabs/bar groups to the existing ribbon or toolbar menu. |
Assign |
Assigns a shortcut key to a command. |
Begin |
Executes the specified delegate asynchronously with the specified arguments, on the thread that the control’s underlying handle was created on. Inherited from Control. |
Begin |
Executes the specified delegate asynchronously on the thread that the control’s underlying handle was created on. Inherited from Control. |
Begin |
Locks the Spreadsheet |
Bring |
Brings the control to the front of the z-order. Inherited from Control. |
Cancel |
This method supports the internal infrastructure and is not intended to be called directly from your code. Use the Spreadsheet |
Circle |
Displays circles around invalid data in a worksheet to which data validation is applied. |
Clear |
Hides circles around invalid data in a worksheet to which data validation is applied. |
Close |
Closes the cell editor. |
Contains |
Retrieves a value indicating whether the specified control is a child of the control. Inherited from Control. |
Create |
Creates a Bar |
Create |
Adds a Bar |
Create |
Creates a command by its identifier. |
Create |
Forces the creation of the visible control, including the creation of the handle and any visible child controls. Inherited from Control. |
Create |
Creates a new instance of the control collection for the control. Inherited from Control. |
Create |
Creates the Graphics for the control. Inherited from Control. |
Create |
Creates a handle for the control. Inherited from Control. |
Create |
Creates and loads a new empty workbook. |
Create |
Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
Inherited from Marshal |
Create |
Creates a Ribbon |
Create |
Adds a Ribbon |
Create |
Creates a Ribbon |
Create |
Creates a Ribbon |
Create |
Adds a status bar with all Spreadsheet-related items to the Spreadsheet control with a Bar UI. |
Create |
Adds a status bar with the specified items to the Spreadsheet control with a Bar UI. |
Def |
Sends the specified message to the default window procedure. Inherited from Control. |
Destroy |
Destroys the handle associated with the control. Inherited from Control. |
Dispose() | Releases all resources used by the Component. Inherited from Component. |
Do |
Begins a drag-and-drop operation. Inherited from Control. |
Draw |
Supports rendering to the specified bitmap. Inherited from Control. |
End |
Retrieves the return value of the asynchronous operation represented by the IAsync |
End |
Unlocks the Spreadsheet |
Equals |
Determines whether the specified object instances are considered equal. Inherited from Object. |
Equals |
Determines whether the specified object is equal to the current object. Inherited from Object. |
Export |
Exports the specified range to the specified stream in HTML format. |
Export |
Exports the specified worksheet to the specified stream in HTML format. |
Export |
Exports the document’s data to the specified stream in HTML format using the specified options. |
Export |
Exports the specified worksheet to the specified stream in HTML format. |
Export |
Exports the specified range to the specified file in HTML format. |
Export |
Exports the specified worksheet to the specified file in HTML format. |
Export |
Exports the document’s data to the specified file in HTML format using the specified options. |
Export |
Exports the specified worksheet to the specified file in HTML format. |
Export |
Exports the content of the Spreadsheet |
Export |
Exports the content of the Spreadsheet |
Export |
Exports the content of the Spreadsheet |
Export |
Exports the content of the Spreadsheet |
Find |
Retrieves the form that the control is on. Inherited from Control. |
Focus() | Sets input focus to the control. Inherited from Control. |
From |
Retrieves the control that contains the specified handle. Inherited from Control. |
From |
Returns the control that is currently associated with the specified handle. Inherited from Control. |
Get |
Retrieves a value indicating how a control will behave when its Auto |
Get |
Obtains the coordinates and size of a cell specified by the row and column indices. |
Get |
Gets a worksheet cell located at the specified point. |
Get |
Retrieves the child control that is located at the specified coordinates, specifying whether to ignore child controls of a certain type. Inherited from Control. |
Get |
Retrieves the child control that is located at the specified coordinates. Inherited from Control. |
Get |
Returns the next Container |
Get |
Serves as the default hash function. Inherited from Object. |
Get |
Retrieves the current lifetime service object that controls the lifetime policy for this instance.
Inherited from Marshal |
Get |
Retrieves the next control forward or back in the tab order of child controls. Inherited from Control. |
Get |
Retrieves the size of a rectangular area into which a control can be fitted. Inherited from Control. |
Get |
Retrieves the bounds within which the control is scaled. Inherited from Control. |
Get |
Returns cell ranges currently selected in the active worksheet. |
Get |
Returns shapes currently selected in the active worksheet. |
Get |
Gets the service object of the specified type. |
Get |
Gets the specified service. |
Get |
Retrieves the value of the specified control style bit for the control. Inherited from Control. |
Get |
Determines if the control is a top-level control. Inherited from Control. |
Get |
Gets the Type of the current instance. Inherited from Object. |
Hide() | Conceals the control from the user. Inherited from Control. |
Initialize |
Obtains a lifetime service object to control the lifetime policy for this instance.
Inherited from Marshal |
Init |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Executes the specified delegate on the thread that owns the control’s underlying window handle. Inherited from Control. |
Invoke |
Raises the Got |
Invoke |
Raises the Lost |
Invoke |
Raises the Click event for the specified control. Inherited from Control. |
Invoke |
Raises the Paint event for the specified control. Inherited from Control. |
Invoke |
Raises the Paint event for the specified control.
Inherited from Control. |
Is |
Determines if a character is an input character that the control recognizes. Inherited from Control. |
Is |
Determines whether the CAPS LOCK, NUM LOCK, or SCROLL LOCK key is in effect. Inherited from Control. |
Is |
Determines if the specified character is the mnemonic character assigned to the control in the specified string. Inherited from Control. |
Load |
Invokes the Open dialog, creates a specific importer and loads the file. |
Load |
Loads a document from a byte array. |
Load |
Load the document from a Byte[] array. |
Load |
Loads a document from a stream, specifying the document format. |
Load |
Loads the document from a stream. |
Load |
Loads a document from a file, specifying the document format. |
Load |
Loads a document from a file. |
Load |
Invokes the Open file dialog as a child of the specified parent window. |
Memberwise |
Creates a shallow copy of the current Object. Inherited from Object. |
Memberwise |
Creates a shallow copy of the current Marshal |
Notify |
Raises the Invalidated event with a specified region of the control to invalidate. Inherited from Control. |
On |
Raises the Auto |
On |
Raises the Back |
On |
Raises the Background |
On |
Raises the Background |
On |
Raises the Binding |
On |
Raises the Causes |
On |
Raises the Change |
On |
Raises the Click event. Inherited from Control. |
On |
Raises the Client |
On |
Raises the Context |
On |
Raises the Context |
On |
Raises the Control |
On |
Raises the Control |
On |
Raises the Create |
On |
Raises the Cursor |
On |
Raises the Dock |
On |
Raises the Double |
On |
Raises the Enter event. Inherited from Control. |
On |
Raises the Font |
On |
Raises the Fore |
On |
Raises the Help |
On |
Raises the Ime |
On |
Raises the Invalidated event. Inherited from Control. |
On |
Raises the Layout event. Inherited from Control. |
On |
Raises the Leave event. Inherited from Control. |
On |
Raises the Location |
On |
Raises the Margin |
On |
Raises the Mouse |
On |
Raises the Mouse |
On |
Raises the Mouse |
On |
Raises the Mouse |
On |
Raises the Mouse |
On |
Raises the Move event. Inherited from Control. |
On |
Notifies the control of Windows messages. Inherited from Control. |
On |
Raises the Padding |
On |
Raises the Back |
On |
Raises the Background |
On |
Raises the Binding |
On |
Raises the Parent |
On |
Raises the Cursor |
On |
Raises the Enabled |
On |
Raises the Font |
On |
Raises the Fore |
On |
Raises the Right |
On |
Raises the Visible |
On |
Raises the Preview |
On |
Raises the Paint event. Inherited from Control. |
On |
Raises the Region |
On |
Raises the Right |
On |
Raises the Style |
On |
Raises the System |
On |
Raises the Tab |
On |
Raises the Tab |
On |
Raises the Text |
On |
Raises the Validated event. Inherited from Control. |
On |
Raises the Validating event. Inherited from Control. |
On |
Raises the Visible |
Open |
Invokes a cell editor and switches to the spreadsheet edit mode, allowing you to edit cell content. |
Perform |
Forces the control to apply layout logic to all its child controls. Inherited from Control. |
Perform |
Forces the control to apply layout logic to all its child controls. Inherited from Control. |
Point |
Computes the location of the specified screen point into client coordinates. Inherited from Control. |
Point |
Computes the location of the specified client point into screen coordinates. Inherited from Control. |
Pre |
Preprocesses keyboard or input messages within the message loop before they are dispatched. Inherited from Control. |
Pre |
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 |
Prints the document using the specified printer settings. |
Process |
Processes a command key. Inherited from Control. |
Process |
Processes a dialog key. Inherited from Control. |
Process |
Processes a key message and generates the appropriate control events. Inherited from Control. |
Process |
Processes a keyboard message. Inherited from Control. |
Process |
Previews a keyboard message. Inherited from Control. |
Process |
Processes a mnemonic character. Inherited from Control. |
Raise |
Raises the appropriate drag event. Inherited from Control. |
Raise |
Raises the appropriate key event. Inherited from Control. |
Raise |
Raises the appropriate mouse event. Inherited from Control. |
Raise |
Raises the appropriate paint event. Inherited from Control. |
Recreate |
Forces the re-creation of the handle for the control. Inherited from Control. |
Rectangle |
Computes the size and location of the specified screen rectangle in client coordinates. Inherited from Control. |
Rectangle |
Computes the size and location of the specified client rectangle in screen coordinates. Inherited from Control. |
Reference |
Determines whether the specified Object instances are the same instance. Inherited from Object. |
Reflect |
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. |
Remove |
Removes the service of the specified type from the service container. |
Remove |
Removes the service of the specified type from the service container. |
Remove |
Removes a command shortcut. |
Replace |
Allows you to replace the specified service. |
Reset |
Resets the Back |
Reset |
Causes a control bound to the Binding |
Reset |
Resets the Cursor property to its default value. Inherited from Control. |
Reset |
Resets the Font property to its default value. Inherited from Control. |
Reset |
Resets the Fore |
Reset |
Resets the Ime |
Reset |
Updates the layout of the document loaded into control and the control itself. |
Reset |
Resets the control to handle the Mouse |
Reset |
Resets the Right |
Reset |
Resets the Text property to its default value (Empty). Inherited from Control. |
Resume |
Resumes usual layout logic. Inherited from Control. |
Resume |
Resumes usual layout logic, optionally forcing an immediate layout of pending layout requests. Inherited from Control. |
Rtl |
Converts the specified Content |
Rtl |
Converts the specified Horizontal |
Rtl |
Converts the specified Left |
Rtl |
Converts the specified Content |
Rtl |
Converts the specified Horizontal |
Rtl |
Converts the specified Left |
Save |
Saves a document in its original format to its original location. |
Save |
Saves a document to an array of bytes in the specified format and with specified encryption settings. |
Save |
Saves a document to an array of bytes in the specified format. |
Save |
Saves the workbook to a stream, specifying the export format and encryption options. |
Save |
Saves the workbook to a stream, specifying the export format. |
Save |
Saves the control’s document to a file, specifying the document format and encryption settings. |
Save |
Saves the control’s document to a file, specifying the document format. |
Save |
Saves the document to a file with the specified encryption settings. |
Save |
Saves the document to the specified file in the Excel or text format. The file format is identified by the file extension. |
Save |
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. |
Save |
Invokes the Save As dialog and saves a document. |
Save |
Invokes the Save As dialog which is shown modally as a child of the specified parent window. |
Scale |
Scales the control and all child controls by the specified scaling factor. Inherited from Control. |
Scale |
Scales the entire control and any child controls. Inherited from Control. |
Scale |
Scales the control and any child controls. Inherited from Control. |
Scale |
Scales a control’s location, size, padding and margin. Inherited from Control. |
Scale |
This method is not relevant for this class. Inherited from Control. |
Select() | Activates the control. Inherited from Control. |
Select |
Activates a child control. Optionally specifies the direction in the tab order to select the control from. Inherited from Control. |
Select |
Activates the next control. Inherited from Control. |
Send |
Sends the control to the back of the z-order. Inherited from Control. |
Set |
Sets a value indicating how a control will behave when its Auto |
Set |
Sets the specified bounds of the control to the specified location and size. Inherited from Control. |
Set |
Sets the bounds of the control to the specified location and size. Inherited from Control. |
Set |
Performs the work of setting the specified bounds of this control. Inherited from Control. |
Set |
Sets the size of the client area of the control. Inherited from Control. |
Set |
Selects cell ranges in the worksheet and specifies whether the selection expands to fit merged cells. |
Set |
Sets cell ranges selected in the active worksheet. |
Set |
Sets shapes selected in the active worksheet. |
Set |
Sets a specified Controltrue or false .
Inherited from Control. |
Set |
Sets the control as the top-level control. Inherited from Control. |
Set |
Sets the control to the specified visible state. Inherited from Control. |
Show() | Displays the control to the user. Inherited from Control. |
Show |
Invokes the Print dialog to select a printer, specify the print options (number of copies, page range, and paper source) and print the document. |
Show |
Invokes the Print Preview window with a Bar UI. |
Show |
Invokes the Print Preview window with a Ribbon UI. |
Size |
Determines the size of the entire control from the height and width of its client area. Inherited from Control. |
Suspend |
Temporarily suspends the layout logic for the control. Inherited from Control. |
IDrop |
Raises the Drag |
IDrop |
Raises the Drag |
IDrop |
Raises the Drag |
IDrop |
Raises the Drag |
To |
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. |
Update |
Updates the bounds of the control with the current size and location. Inherited from Control. |
Update |
Updates the bounds of the control with the specified size, location, and client size. Inherited from Control. |
Update |
Updates the bounds of the control with the specified size and location. Inherited from Control. |
Update |
Refreshes the Spreadsheet |
Update |
Forces the assigned styles to be reapplied to the control. Inherited from Control. |
Update |
Updates the control in its parent’s z-order. Inherited from Control. |
#Events
Name | Description |
---|---|
Active |
Occurs after an active worksheet has been changed via the Spreadsheet |
Active |
Occurs when an active worksheet is about to be changed via the Spreadsheet |
After |
Occurs after a user dropped the selected cell range in a new location. |
After |
Occurs after a cell range was automatically filled with data based on values in the source range. |
After |
Fires after the expand/collapse operation is executed for row or column groups in a worksheet. |
After |
Fires after a user clicks an outline button for row or column groups. |
Auto |
This event is not relevant for this class. Inherited from Control. |
Back |
Occurs when the value of the Back |
Background |
Occurs when the value of the Background |
Background |
Occurs when the Background |
Before |
Occurs before the Spreadsheet |
Before |
Occurs when a user starts to drag the selected cell range. |
Before |
Occurs when a user is about to drop the selected cell range in a new location. |
Before |
Occurs before detecting the encoding of the loaded CSV or TXT data. |
Before |
Occurs before the document is saved (exported to a certain format). |
Before |
Occurs when a user drags the fill handle to populate cells with data based on values in the source range. |
Before |
Fires before the expand/collapse operation is executed for row or column groups in a worksheet. |
Before |
Occurs before a document is loaded (imported from an external source). |
Before |
Fires before a user clicks an outline button for row or column groups. |
Before |
Provides the capability to prevent printing of the required worksheets in a workbook. |
Binding |
Occurs when the value of the Binding |
Causes |
Occurs when the value of the Causes |
Cell |
Occurs before a cell editor is opened. |
Cell |
Occurs before the cell editor is closed and the entered value is rolled back. |
Cell |
Occurs after a cell editor was activated by a user. |
Cell |
Occurs before a cell editor is closed and the entered value is committed. |
Cell |
Occurs after the cell content was changed via the Spreadsheet |
Change |
Occurs when the focus or keyboard user interface (UI) cues change. Inherited from Control. |
Click | Occurs when the control is clicked. Inherited from Control. |
Client |
Occurs when the value of the Client |
Clipboard |
Occurs after data on the clipboard is obtained and recognized, but before data is pasted. |
Clipboard |
Occurs after data was pasted from the clipboard onto a worksheet. |
Clipboard |
Occurs before data is pasted into destination cells. |
Columns |
Occurs after new columns have been added to a worksheet via the Spreadsheet |
Columns |
Occurs when new columns are about to be inserted into a worksheet. |
Columns |
Occurs after columns have been deleted from a worksheet via the Spreadsheet |
Columns |
Occurs when columns are about to be deleted from a worksheet. |
Column |
Occurs after the column width was changed. |
Comment |
Occurs when a comment is inserted. |
Comment |
Occurs before inserting a comment. |
Comment |
Occurs when a comment is deleted. |
Comment |
Occurs before deleting a comment. |
Content |
Occurs when the document content is changed. |
Context |
Occurs when the value of the Context |
Context |
Occurs when the value of the Context |
Control |
Occurs when a new control is added to the Control. |
Control |
Occurs when a control is removed from the Control. |
Copied |
Occurs after the range content has been pasted into target cells. |
Copied |
Occurs before the range content is pasted into target cells. |
Cursor |
Occurs when the value of the Cursor property changes. Inherited from Control. |
Custom |
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. |
Custom |
Allows you to assign a custom in-place editor to a cell. |
Custom |
Allows you to paint cell content. |
Custom |
Performs custom painting of the cell background. |
Custom |
Enables the column header to be painted manually. |
Custom |
Enables the column header background to be painted manually. |
Custom |
Allows you to customize comment indicators. |
Custom |
Enables frozen pane borders to be painted manually. |
Custom |
Enables the row header to be painted manually. |
Custom |
Enables the row header background to be painted manually. |
Data |
Occurs before a data binding warning dialog is shown in the Spreadsheet |
Defined |
Occurs after the defined name is created. |
Defined |
Occurs when a formula or sheet being moved or copied contains a defined name that already exists in the destination worksheet or workbook. |
Defined |
Occurs after the defined name is deleted. |
Defined |
Occurs before a Defined Name is deleted. |
Defined |
Occurs after the defined name parameters were changed. |
Defined |
Occurs before a Defined Name is being edited. |
Defined |
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. |
Dock |
Occurs when the value of the Dock property changes. Inherited from Control. |
Document |
Occurs when a document that has not yet been saved is about to be closed. |
Document |
Occurs after a document is loaded into the Spreadsheet control. |
Document |
Occurs after one of the Document |
Document |
Occurs after a document has been saved. |
Double |
Occurs when the control is double-clicked. Inherited from Control. |
Drag |
Occurs when a drag-and-drop operation is completed. Inherited from Control. |
Drag |
Occurs when an object is dragged into the control’s bounds. Inherited from Control. |
Drag |
Occurs when an object is dragged out of the control’s bounds. Inherited from Control. |
Drag |
Occurs when an object is dragged over the control’s bounds. Inherited from Control. |
Empty |
Occurs when a new document is created in the Spreadsheet |
Enabled |
Occurs when the Enabled property value has changed. Inherited from Control. |
Encrypted |
Occurs when the encrypted file does not pass data integrity verification. |
Encrypted |
Occurs when the encryption password is empty or invalid. |
Encrypted |
Occurs when the Workbook |
Enter | Occurs when the control is entered. Inherited from Control. |
Font |
Occurs when the Font property value changes. Inherited from Control. |
Fore |
Occurs when the Fore |
Give |
Occurs during a drag operation. Inherited from Control. |
Got |
Occurs when the control receives focus. Inherited from Control. |
Group |
Fires after row or column groups are expanded or collapsed. |
Group |
Fires before row or column groups are expanded or collapsed. |
Handle |
Occurs when a handle is created for the control. Inherited from Control. |
Handle |
Occurs when the control’s handle is in the process of being destroyed. Inherited from Control. |
Help |
Occurs when the user requests help for a control. Inherited from Control. |
Hyperlink |
Occurs when an end-user activates the hyperlink before navigating to the referenced location. |
Ime |
Occurs when the Ime |
Initialize |
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. |
Invalid |
Fires when the supplied data could not be recognized as data in the assumed format for import. |
Key |
Occurs when a key is pressed while the control has focus. Inherited from Control. |
Key |
Occurs when a character. space or backspace key is pressed while the control has focus. Inherited from Control. |
Key |
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. |
Location |
Occurs when the Location property value has changed. Inherited from Control. |
Lost |
Occurs when the control loses focus. Inherited from Control. |
Margin |
Occurs when the control’s margin changes. Inherited from Control. |
Modified |
Occurs when the value of the Spreadsheet |
Mouse |
Occurs when the control loses mouse capture. Inherited from Control. |
Mouse |
Occurs when the control is clicked by the mouse. Inherited from Control. |
Mouse |
Occurs when the control is double clicked by the mouse. Inherited from Control. |
Mouse |
Occurs when the mouse pointer is over the control and a mouse button is pressed. Inherited from Control. |
Mouse |
Occurs when the mouse pointer enters the control. Inherited from Control. |
Mouse |
Occurs when the mouse pointer rests on the control. Inherited from Control. |
Mouse |
Occurs when the mouse pointer leaves the control. Inherited from Control. |
Mouse |
Occurs when the mouse pointer is moved over the control. Inherited from Control. |
Mouse |
Occurs when the mouse pointer is over the control and a mouse button is released. Inherited from Control. |
Mouse |
Occurs when the mouse wheel moves while the control has focus. Inherited from Control. |
Move | Occurs when the control is moved. Inherited from Control. |
Padding |
Occurs when the control’s padding changes. Inherited from Control. |
Paint | Occurs when the control is redrawn. Inherited from Control. |
Panes |
Occurs after a worksheet area has been frozen via the Spreadsheet |
Panes |
Occurs after a frozen worksheet area has been unlocked via the Spreadsheet |
Parent |
Occurs when the Parent property value changes. Inherited from Control. |
Popup |
Occurs when a popup menu is about to be displayed for the Spreadsheet |
Preview |
Occurs before the Key |
Property |
Occurs every time any of the Spreadsheet |
Protection |
Occurs when attempting to edit a locked cell in a protected worksheet. |
Query |
Occurs when Accessible |
Query |
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. |
Range |
Occurs after the range content has been copied. |
Range |
Occurs before a cell range is copied in a worksheet. |
Read |
Occurs when the Spreadsheet |
Region |
Occurs when the value of the Region property changes. Inherited from Control. |
Resize | Occurs when the control is resized. Inherited from Control. |
Right |
Occurs when the Right |
Row |
Occurs after the row height was changed. |
Rows |
Occurs after new rows have been added to a worksheet via the Spreadsheet |
Rows |
Occurs when new rows are about to be inserted into a worksheet. |
Rows |
Occurs after rows have been deleted from a worksheet via the Spreadsheet |
Rows |
Occurs when rows are about to be deleted from a worksheet. |
Scroll |
Occurs when a worksheet is being scrolled in the Spreadsheet |
Selection |
Fires when the selection changes in an active worksheet. |
Shape |
Occurs after a drawing object has been inserted into a worksheet. |
Shape |
Occurs after a drawing object has been removed from a worksheet. |
Shape |
Occurs before a drawing object is removed from a worksheet. |
Shapes |
Occurs before a drawing object is copied. |
Sheet |
Occurs after a new worksheet has been added into a workbook via the Spreadsheet |
Sheet |
Occurs after a worksheet has been removed from a workbook via the Spreadsheet |
Sheet |
Occurs when a worksheet is about to be removed from a workbook. |
Sheet |
Occurs after a worksheet has been renamed via the Spreadsheet |
Sheet |
Occurs when a worksheet is about to be renamed via the Spreadsheet |
Size |
Occurs when the Size property value changes. Inherited from Control. |
Style |
Occurs when the control style changes. Inherited from Control. |
System |
Occurs when the system colors change. Inherited from Control. |
Tab |
Occurs when the Tab |
Tab |
Occurs when the Tab |
Text |
Occurs when the Text property value changes. Inherited from Control. |
Unhandled |
This event is raised when an exception, unhandled by the Spreadsheet |
Unit |
Fires after a unit of measurement used in the workbook is changed. |
Unit |
Fires before a unit of measurement used within the workbook is changed. |
Update |
Raised when changes occur which may affect the control’s UI. |
Validate |
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. |
Visible |
Occurs when the Visible property value changes. Inherited from Control. |
Visible |
Occurs after the visible cell range was changed in the Spreadsheet control. |
Zoom |
Occurs when the current zoom level of the active worksheet has been changed via the Spreadsheet |
See Also