SpreadsheetControl Properties
Emulates the Microsoft® Excel® appearance and allows you to create, load, edit, save and print spreadsheet documents.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. |
See Also