Back to Devexpress

SpreadsheetControl Methods

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

latest93.9 KB
Original Source

SpreadsheetControl Methods

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

NameDescription
About() staticInvokes the About dialog box.
AccessibilityNotifyClients(AccessibleEvents, Int32, Int32) protectedNotifies the accessibility client applications of the specified AccessibleEvents for the specified child control . Inherited from Control.
AccessibilityNotifyClients(AccessibleEvents, Int32) protectedNotifies 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() protectedCreates a new instance of the control collection for the control. Inherited from Control.
CreateGraphics()Creates the Graphics for the control. Inherited from Control.
CreateHandle() protectedCreates 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) protectedSends the specified message to the default window procedure. Inherited from Control.
DestroyHandle() protectedDestroys 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) staticDetermines 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) staticRetrieves the control that contains the specified handle. Inherited from Control.
FromHandle(IntPtr) staticReturns the control that is currently associated with the specified handle. Inherited from Control.
GetAutoSizeMode() protectedRetrieves 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) protectedRetrieves 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) protectedRetrieves the value of the specified control style bit for the control. Inherited from Control.
GetTopLevel() protectedDetermines 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() protectedCalled 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) protectedRaises the GotFocus event for the specified control. Inherited from Control.
InvokeLostFocus(Control, EventArgs) protectedRaises the LostFocus event for the specified control. Inherited from Control.
InvokeOnClick(Control, EventArgs) protectedRaises the Click event for the specified control. Inherited from Control.
InvokePaint(Control, PaintEventArgs) protectedRaises the Paint event for the specified control. Inherited from Control.
InvokePaintBackground(Control, PaintEventArgs) protectedRaises the PaintBackground event for the specified control. Inherited from Control.
IsInputChar(Char) protectedDetermines if a character is an input character that the control recognizes. Inherited from Control.
IsKeyLocked(Keys) staticDetermines whether the CAPS LOCK, NUM LOCK, or SCROLL LOCK key is in effect. Inherited from Control.
IsMnemonic(Char, String) staticDetermines 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() protectedCreates a shallow copy of the current Object. Inherited from Object.
MemberwiseClone(Boolean) protectedCreates a shallow copy of the current MarshalByRefObject object. Inherited from MarshalByRefObject.
NotifyInvalidate(Rectangle) protectedRaises the Invalidated event with a specified region of the control to invalidate. Inherited from Control.
OnAutoSizeChanged(EventArgs) protectedRaises the AutoSizeChanged event. Inherited from Control.
OnBackColorChanged(EventArgs) protectedRaises the BackColorChanged event. Inherited from Control.
OnBackgroundImageChanged(EventArgs) protectedRaises the BackgroundImageChanged event. Inherited from Control.
OnBackgroundImageLayoutChanged(EventArgs) protectedRaises the BackgroundImageLayoutChanged event. Inherited from Control.
OnBindingContextChanged(EventArgs) protectedRaises the BindingContextChanged event. Inherited from Control.
OnCausesValidationChanged(EventArgs) protectedRaises the CausesValidationChanged event. Inherited from Control.
OnChangeUICues(UICuesEventArgs) protectedRaises the ChangeUICues event. Inherited from Control.
OnClick(EventArgs) protectedRaises the Click event. Inherited from Control.
OnClientSizeChanged(EventArgs) protectedRaises the ClientSizeChanged event. Inherited from Control.
OnContextMenuChanged(EventArgs) protectedRaises the ContextMenuChanged event. Inherited from Control.
OnContextMenuStripChanged(EventArgs) protectedRaises the ContextMenuStripChanged event. Inherited from Control.
OnControlAdded(ControlEventArgs) protectedRaises the ControlAdded event. Inherited from Control.
OnControlRemoved(ControlEventArgs) protectedRaises the ControlRemoved event. Inherited from Control.
OnCreateControl() protectedRaises the CreateControl() method. Inherited from Control.
OnCursorChanged(EventArgs) protectedRaises the CursorChanged event. Inherited from Control.
OnDockChanged(EventArgs) protectedRaises the DockChanged event. Inherited from Control.
OnDoubleClick(EventArgs) protectedRaises the DoubleClick event. Inherited from Control.
OnEnter(EventArgs) protectedRaises the Enter event. Inherited from Control.
OnFontChanged(EventArgs) protectedRaises the FontChanged event. Inherited from Control.
OnForeColorChanged(EventArgs) protectedRaises the ForeColorChanged event. Inherited from Control.
OnHelpRequested(HelpEventArgs) protectedRaises the HelpRequested event. Inherited from Control.
OnImeModeChanged(EventArgs) protectedRaises the ImeModeChanged event. Inherited from Control.
OnInvalidated(InvalidateEventArgs) protectedRaises the Invalidated event. Inherited from Control.
OnLayout(LayoutEventArgs) protectedRaises the Layout event. Inherited from Control.
OnLeave(EventArgs) protectedRaises the Leave event. Inherited from Control.
OnLocationChanged(EventArgs) protectedRaises the LocationChanged event. Inherited from Control.
OnMarginChanged(EventArgs) protectedRaises the MarginChanged event. Inherited from Control.
OnMouseCaptureChanged(EventArgs) protectedRaises the MouseCaptureChanged event. Inherited from Control.
OnMouseClick(MouseEventArgs) protectedRaises the MouseClick event. Inherited from Control.
OnMouseDoubleClick(MouseEventArgs) protectedRaises the MouseDoubleClick event. Inherited from Control.
OnMouseEnter(EventArgs) protectedRaises the MouseEnter event. Inherited from Control.
OnMouseHover(EventArgs) protectedRaises the MouseHover event. Inherited from Control.
OnMove(EventArgs) protectedRaises the Move event. Inherited from Control.
OnNotifyMessage(Message) protectedNotifies the control of Windows messages. Inherited from Control.
OnPaddingChanged(EventArgs) protectedRaises the PaddingChanged event. Inherited from Control.
OnParentBackColorChanged(EventArgs) protectedRaises the BackColorChanged event when the BackColor property value of the control’s container changes. Inherited from Control.
OnParentBackgroundImageChanged(EventArgs) protectedRaises the BackgroundImageChanged event when the BackgroundImage property value of the control’s container changes. Inherited from Control.
OnParentBindingContextChanged(EventArgs) protectedRaises the BindingContextChanged event when the BindingContext property value of the control’s container changes. Inherited from Control.
OnParentChanged(EventArgs) protectedRaises the ParentChanged event. Inherited from Control.
OnParentCursorChanged(EventArgs) protectedRaises the CursorChanged event. Inherited from Control.
OnParentEnabledChanged(EventArgs) protectedRaises the EnabledChanged event when the Enabled property value of the control’s container changes. Inherited from Control.
OnParentFontChanged(EventArgs) protectedRaises the FontChanged event when the Font property value of the control’s container changes. Inherited from Control.
OnParentForeColorChanged(EventArgs) protectedRaises the ForeColorChanged event when the ForeColor property value of the control’s container changes. Inherited from Control.
OnParentRightToLeftChanged(EventArgs) protectedRaises the RightToLeftChanged event when the RightToLeft property value of the control’s container changes. Inherited from Control.
OnParentVisibleChanged(EventArgs) protectedRaises the VisibleChanged event when the Visible property value of the control’s container changes. Inherited from Control.
OnPreviewKeyDown(PreviewKeyDownEventArgs) protectedRaises the PreviewKeyDown event. Inherited from Control.
OnPrint(PaintEventArgs) protectedRaises the Paint event. Inherited from Control.
OnRegionChanged(EventArgs) protectedRaises the RegionChanged event. Inherited from Control.
OnRightToLeftChanged(EventArgs) protectedRaises the RightToLeftChanged event. Inherited from Control.
OnStyleChanged(EventArgs) protectedRaises the StyleChanged event. Inherited from Control.
OnSystemColorsChanged(EventArgs) protectedRaises the SystemColorsChanged event. Inherited from Control.
OnTabIndexChanged(EventArgs) protectedRaises the TabIndexChanged event. Inherited from Control.
OnTabStopChanged(EventArgs) protectedRaises the TabStopChanged event. Inherited from Control.
OnTextChanged(EventArgs) protectedRaises the TextChanged event. Inherited from Control.
OnValidated(EventArgs) protectedRaises the Validated event. Inherited from Control.
OnValidating(CancelEventArgs) protectedRaises the Validating event. Inherited from Control.
OnVisibleChanged(EventArgs) protectedRaises 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) protectedProcesses a command key. Inherited from Control.
ProcessDialogKey(Keys) protectedProcesses a dialog key. Inherited from Control.
ProcessKeyEventArgs(Message) protectedProcesses a key message and generates the appropriate control events. Inherited from Control.
ProcessKeyMessage(Message) protectedProcesses a keyboard message. Inherited from Control.
ProcessKeyPreview(Message) protectedPreviews a keyboard message. Inherited from Control.
ProcessMnemonic(Char) protectedProcesses a mnemonic character. Inherited from Control.
RaiseDragEvent(Object, DragEventArgs) protectedRaises the appropriate drag event. Inherited from Control.
RaiseKeyEvent(Object, KeyEventArgs) protectedRaises the appropriate key event. Inherited from Control.
RaiseMouseEvent(Object, MouseEventArgs) protectedRaises the appropriate mouse event. Inherited from Control.
RaisePaintEvent(Object, PaintEventArgs) protectedRaises the appropriate paint event. Inherited from Control.
RecreateHandle() protectedForces 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) staticDetermines whether the specified Object instances are the same instance. Inherited from Object.
ReflectMessage(IntPtr, Message) protected staticReflects 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() protectedResets 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) protectedConverts the specified ContentAlignment to the appropriate ContentAlignment to support right-to-left text. Inherited from Control.
RtlTranslateAlignment(HorizontalAlignment) protectedConverts the specified HorizontalAlignment to the appropriate HorizontalAlignment to support right-to-left text. Inherited from Control.
RtlTranslateAlignment(LeftRightAlignment) protectedConverts the specified LeftRightAlignment to the appropriate LeftRightAlignment to support right-to-left text. Inherited from Control.
RtlTranslateContent(ContentAlignment) protectedConverts the specified ContentAlignment to the appropriate ContentAlignment to support right-to-left text. Inherited from Control.
RtlTranslateHorizontal(HorizontalAlignment) protectedConverts the specified HorizontalAlignment to the appropriate HorizontalAlignment to support right-to-left text. Inherited from Control.
RtlTranslateLeftRight(LeftRightAlignment) protectedConverts 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) protectedScales a control’s location, size, padding and margin. Inherited from Control.
ScaleCore(Single, Single) protectedThis method is not relevant for this class. Inherited from Control.
Select()Activates the control. Inherited from Control.
Select(Boolean, Boolean) protectedActivates 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) protectedSets 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.
SetClientSizeCore(Int32, Int32) protectedSets 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) protectedSets a specified ControlStyles flag to either true or false. Inherited from Control.
SetTopLevel(Boolean) protectedSets the control as the top-level control. Inherited from Control.
SetVisibleCore(Boolean) protectedSets 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) protectedDetermines 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() protectedUpdates the bounds of the control with the current size and location. Inherited from Control.
UpdateBounds(Int32, Int32, Int32, Int32, Int32, Int32) protectedUpdates the bounds of the control with the specified size, location, and client size. Inherited from Control.
UpdateBounds(Int32, Int32, Int32, Int32) protectedUpdates the bounds of the control with the specified size and location. Inherited from Control.
UpdateCommandUI()Refreshes the SpreadsheetControl command UI.
UpdateStyles() protectedForces the assigned styles to be reapplied to the control. Inherited from Control.
UpdateZOrder() protectedUpdates the control in its parent’s z-order. Inherited from Control.

See Also

SpreadsheetControl Class

SpreadsheetControl Members

DevExpress.XtraSpreadsheet Namespace