Back to Devexpress

SpreadsheetControl Properties

windowsforms-devexpress-dot-xtraspreadsheet-dot-spreadsheetcontrol-dot-underscore-properties.md

latest39.7 KB
Original Source

SpreadsheetControl Properties

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

NameDescription
AcceptsEscapeGets or sets a value indicating whether pressing the ESC key is processed by the SpreadsheetControl.
AcceptsReturnGets or sets a value indicating whether pressing the RETURN key is processed by the SpreadsheetControl.
AcceptsTabGets 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.
AccessibilityObjectGets the AccessibleObject assigned to the control. Inherited from Control.
AccessibleDefaultActionDescriptionGets or sets the default action description of the control for use by accessibility client applications. Inherited from Control.
AccessibleDescriptionGets or sets the description of the control used by accessibility client applications. Inherited from Control.
AccessibleNameGets or sets the name of the control used by accessibility client applications. Inherited from Control.
AccessibleRoleGets or sets the accessible role of the control. Inherited from Control.
ActiveCellReturns an active cell in the active worksheet.
ActiveChartSheetGets the chart sheet that is currently displayed in the SpreadsheetControl.
ActiveSheetGets the sheet that is currently displayed in the SpreadsheetControl.
ActiveViewProvides 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.
ActiveViewZoomGets or sets the zoom level for the sheet currently displayed in the SpreadsheetControl.
ActiveWorksheetGets the worksheet that is currently displayed in the SpreadsheetControl.
AllowDropOverrides the System.Windows.Forms.Control.AllowDrop property.
AnchorGets 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.
AutoScrollOffsetGets or sets where this control is scrolled to in ScrollControlIntoView(Control). Inherited from Control.
AutoSizeThis property is not relevant for this class. Inherited from Control.
BackColorThis property is not supported by the SpreadsheetControl class.
BackgroundImageThis property has no effect on the SpreadsheetControl.
BackgroundImageLayoutThis property has no effect on the SpreadsheetControl.
BindingContextGets or sets the BindingContext for the control. Inherited from Control.
BorderStyleGets or sets the SpreadsheetControl’s border style.
BottomGets the distance, in pixels, between the bottom edge of the control and the top edge of its container’s client area. Inherited from Control.
BoundsGets or sets the size and location of the control including its nonclient elements, in pixels, relative to the parent control. Inherited from Control.
CanEnableIme protectedGets a value indicating whether the ImeMode property can be set to an active value, to enable IME support. Inherited from Control.
CanFocusGets a value indicating whether the control can receive focus. Inherited from Control.
CanRaiseEvents protectedDetermines if events can be raised on the control. Inherited from Control.
CanSelectGets a value indicating whether the control can be selected. Inherited from Control.
CaptureGets or sets a value indicating whether the control has captured the mouse. Inherited from Control.
CausesValidationGets 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 staticGets 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.
ClientRectangleGets the rectangle that represents the client area of the control. Inherited from Control.
ClientSizeGets or sets the height and width of the client area of the control. Inherited from Control.
ClipboardProvides access to the object used for working with the system Clipboard.
CompanyNameGets the name of the company or creator of the application containing the control. Inherited from Control.
ContainerGets the IContainer that contains the Component. Inherited from Component.
ContainsFocusGets a value indicating whether the control, or one of its child controls, currently has the input focus. Inherited from Control.
ContextMenuGets or sets the shortcut menu associated with the control. Inherited from Control.
ControlsGets the collection of controls contained within the control. Inherited from Control.
CreatedGets a value indicating whether the control has been created. Inherited from Control.
CreateParams protectedGets the required creation parameters when the control handle is created. Inherited from Control.
CursorGets or sets the cursor that is displayed when the mouse pointer is over the control. Inherited from Control.
DataBindingsGets the data bindings for the control. Inherited from Control.
DefaultBackColor staticGets the default background color of the control. Inherited from Control.
DefaultCursor protectedGets or sets the default cursor for the control. Inherited from Control.
DefaultFont staticGets the default font of the control. Inherited from Control.
DefaultForeColor staticGets the default foreground color of the control. Inherited from Control.
DefaultImeMode protectedGets the default Input Method Editor (IME) mode supported by the control. Inherited from Control.
DefaultMargin protectedGets the space, in pixels, that is specified by default between controls. Inherited from Control.
DefaultMaximumSize protectedGets the length and height, in pixels, that is specified as the default maximum size of a control. Inherited from Control.
DefaultMinimumSize protectedGets the length and height, in pixels, that is specified as the default minimum size of a control. Inherited from Control.
DefaultPadding protectedGets the internal spacing, in pixels, of the contents of a control. Inherited from Control.
DesignMode protectedGets a value that indicates whether the Component is currently in design mode. Inherited from Component.
DisplayRectangleGets the rectangle that represents the display area of the control. Inherited from Control.
DisposingGets a value indicating whether the base Control class is in the process of disposing. Inherited from Control.
DockGets or sets which control borders are docked to its parent control and determines how a control is resized with its parent. Inherited from Control.
DocumentProvides access to a workbook loaded in the control.
DoubleBuffered protectedGets or sets a value indicating whether this control should redraw its surface using a secondary buffer to reduce or prevent flicker. Inherited from Control.
DpiXGets the current dpi value for the X-coordinate.
DpiYGets the current dpi value for the Y-coordinate.
EnabledGets or sets a value indicating whether the control can respond to user interaction. Inherited from Control.
Events protectedGets the list of event handlers that are attached to this Component. Inherited from Component.
FocusedGets a value indicating whether the control has input focus. Inherited from Control.
FontThis property is not supported by the SpreadsheetControl class.
FontHeight protectedGets or sets the height of the font of the control. Inherited from Control.
ForeColorThis property is not supported by the SpreadsheetControl class.
HandleGets the window handle that the control is bound to. Inherited from Control.
HasChildrenGets a value indicating whether the control contains one or more child controls. Inherited from Control.
HeightGets or sets the height of the control. Inherited from Control.
ImeModeGets or sets the Input Method Editor (IME) mode of the control. Inherited from Control.
ImeModeBase protectedGets or sets the IME mode of a control. Inherited from Control.
InvokeRequiredGets 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.
IsAccessibleGets or sets a value indicating whether the control is visible to accessibility applications. Inherited from Control.
IsCellEditorActiveGets whether the cell editor is currently active.
IsDisposedGets a value indicating whether the control has been disposed of. Inherited from Control.
IsHandleCreatedGets a value indicating whether the control has a handle associated with it. Inherited from Control.
IsMirroredGets a value indicating whether the control is mirrored. Inherited from Control.
IsPrintingAvailableIndicates whether the SpreadsheetControl can be printed or exported.
IsPrintPreviewAvailableGets a value indicating whether a preview of the SpreadsheetControl’s document is allowed.
IsUpdateLockedReturns a value indicating whether the SpreadsheetControl is locked for update.
LayoutEngineGets a cached instance of the control’s layout engine. Inherited from Control.
LayoutUnitGets or sets a unit of measure used for a document layout.
LeftGets 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.
LocationGets or sets the coordinates of the upper-left corner of the control relative to the upper-left corner of its container. Inherited from Control.
LookAndFeelProvides access to the control’s look and feel settings.
MarginGets or sets the space between controls. Inherited from Control.
MaximumSizeGets or sets the size that is the upper limit that GetPreferredSize(Size) can specify. Inherited from Control.
MenuManagerGets or sets the menu manager which controls the look and feel of context menus.
MinimumSizeGets or sets the size that is the lower limit that GetPreferredSize(Size) can specify. Inherited from Control.
ModifiedGets or sets a value that indicates that the document content was modified since it was last saved.
ModifierKeys staticGets a value indicating which of the modifier keys (SHIFT, CTRL, and ALT) is in a pressed state. Inherited from Control.
MouseButtons staticGets a value indicating which of the mouse buttons is in a pressed state. Inherited from Control.
MousePosition staticGets the position of the mouse cursor in screen coordinates. Inherited from Control.
NameGets or sets the name of the control. Inherited from Control.
OptionsProvides access to the variety of options which can be specified for the document loaded into the SpreadsheetControl and the control itself.
PaddingGets or sets padding within the control. Inherited from Control.
ParentGets or sets the parent container of the control. Inherited from Control.
PreferredSizeGets the size of a rectangular area into which the control can fit. Inherited from Control.
ProductNameGets the product name of the assembly containing the control. Inherited from Control.
ProductVersionGets the version of the assembly containing the control. Inherited from Control.
PropagatingImeMode protected staticGets an object that represents a propagating IME mode. Inherited from Control.
ReadOnlyGets or sets whether document modifications are prohibited.
RecreatingHandleGets a value indicating whether the control is currently re-creating its handle. Inherited from Control.
RegionGets or sets the window region associated with the control. Inherited from Control.
RenderRightToLeft protectedThis property is now obsolete. Inherited from Control.
ResizeRedraw protectedGets or sets a value indicating whether the control redraws itself when resized. Inherited from Control.
RightGets the distance, in pixels, between the right edge of the control and the left edge of its container’s client area. Inherited from Control.
RightToLeftThis property is not in effect for the SpreadsheetControl class.
ScaleChildren protectedGets a value that determines the scaling of child controls. Inherited from Control.
SelectedCellGets or sets an active cell in the active worksheet.
SelectedCommentGets or sets a comment selected in the active worksheet.
SelectedPictureGets or sets a picture selected in the active worksheet.
SelectedShapeGets or sets a shape selected in the active worksheet.
SelectionGets or sets a cell range selected in the active worksheet.
ShowFocusCues protectedGets a value indicating whether the control should display focus rectangles. Inherited from Control.
ShowKeyboardCues protectedGets a value indicating whether the user interface is in the appropriate state to show or hide keyboard accelerators. Inherited from Control.
SiteGets or sets the site of the control. Inherited from Control.
SizeGets or sets the height and width of the control. Inherited from Control.
TabIndexGets or sets the tab order of the control within its container. Inherited from Control.
TabStopGets or sets a value indicating whether the user can give the focus to this control using the TAB key. Inherited from Control.
TagGets or sets the object that contains data about the control. Inherited from Control.
TextGets or sets the text associated with this control. Inherited from Control.
ToolTipControllerGets or sets the tooltip controller component that controls the appearance, position and the content of the hints displayed by the SpreadsheetControl.
TopGets 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.
TopLevelControlGets 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.
UnitGets or sets a unit of measure used in the workbook.
UseWaitCursorGets or sets a value indicating whether to use the wait cursor for the current control and all child controls. Inherited from Control.
VisibleGets or sets a value indicating whether the control and all its child controls are displayed. Inherited from Control.
VisibleRangeGets the cell range that is currently visible in the SpreadsheetControl.
VisibleUnfrozenRangeGets the visible cell range of the scrollable area when there are frozen rows and columns in the worksheet.
WidthGets or sets the width of the control. Inherited from Control.
WindowTargetThis property is not relevant for this class. Inherited from Control.
WorksheetDisplayAreaProvides access to an object enabling you to specify a worksheet area that is visible in the SpreadsheetControl and allows end-user input.

See Also

SpreadsheetControl Class

SpreadsheetControl Members

DevExpress.XtraSpreadsheet Namespace