Spread Windows Forms 6.0 Product Documentation
FpSpread Class Members
See Also  Properties  Methods  Events Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace : FpSpread Class


Glossary Item Box

The following tables list the members exposed by FpSpread.

Public Constructors

 NameDescription
Public ConstructorFpSpread ConstructorCreates a new Spreadsheet component.  
Top

Public Properties

 NameDescription
Public PropertyAboutGets the version information about the component.  
Public PropertyAccessibilityObjectGets the System.Windows.Forms.AccessibleObject assigned to the control. (Inherited from System.Windows.Forms.Control)
Public PropertyAccessibleDefaultActionDescriptionGets or sets the default action description of the control for use by accessibility client applications. (Inherited from System.Windows.Forms.Control)
Public PropertyAccessibleDescriptionGets or sets the description of the control used by accessibility client applications. (Inherited from System.Windows.Forms.Control)
Public PropertyAccessibleNameGets or sets the name of the control used by accessibility client applications. (Inherited from System.Windows.Forms.Control)
Public PropertyAccessibleRoleGets or sets the accessible role of the control (Inherited from System.Windows.Forms.Control)
Public PropertyActiveChartIndicatorGets the active chart indicator.  
Public PropertyActiveChildControlGets or sets the active embedded child control object of the sheet.  
Public PropertyActiveSheetGets or sets the active sheet in the component.  
Public PropertyActiveSheetIndexGets or sets the index of the active sheet in the component.  
Public PropertyAllowCellOverflowGets or sets whether data can overflow into adjacent empty cells in the component.  
Public PropertyAllowChildControlDesignGets or sets whether child controls allow user actions for design.  
Public PropertyAllowColumnMoveGets or sets whether to allow the user to move columns.  
Public PropertyAllowColumnMoveMultipleGets or sets whether to allow the user to move multiple columns.  
Public PropertyAllowDragDropGets or sets whether to allow the user to drag-and-drop a range of cells in the component.  
Public PropertyAllowDragFillGets or sets whether to allow the user to drag and fill cells in the component with the contents of a cell or cells.  
Public PropertyAllowDropGets or sets a value indicating whether the control can accept data that the user drags onto it. (Inherited from System.Windows.Forms.Control)
Public PropertyAllowEditorReservedLocations  
Public PropertyAllowEditOverflowGets or sets whether data can overflow into adjacent empty cells in the component while that cell is in edit mode.  
Public PropertyAllowRowMoveGets or sets whether to allow the user to move rows.  
Public PropertyAllowRowMoveDataAllowAddNewGets or sets a value that indicates whether to allow the user to move the add new row or asterisk row.  
Public PropertyAllowRowMoveMultipleGets or sets whether to allow the user to move multiple rows.  
Public PropertyAllowSheetMoveGets or sets whether sheets can be moved by drag-dropping the sheet tab.  
Public PropertyAllowUndoGets or sets whether to allow the user to undo edit operations.  
Public PropertyAllowUserFormulasGets or sets whether to allow the user to enter formulas in a cell in the component.  
Public PropertyAllowUserZoomGets or sets whether the user can scale the display of the component using the Ctrl key and the mouse wheel.  
Public PropertyAnchorGets 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 System.Windows.Forms.Control)
Public PropertyAutoClipboardGets or sets whether the component handles the shortcut keys for Clipboard actions.  
Public PropertyAutoLaunchSpreadDesignerGets or sets whether Spread Designer automatically launches when a Spread component is placed on a form.  
Public PropertyAutoScrollOffsetGets or sets where this control is scrolled to in System.Windows.Forms.ScrollableControl.ScrollControlIntoView(System.Windows.Forms.Control). (Inherited from System.Windows.Forms.Control)
Public PropertyBackColorGets or sets the background color for the control. (Inherited from System.Windows.Forms.Control)
Public PropertyBackgroundImageOverridden. Gets or sets the image to paint in the background of the component.  
Public PropertyBackgroundImageLayoutGets or sets the background image layout as defined in the System.Windows.Forms.ImageLayout enumeration. (Inherited from System.Windows.Forms.Control)
Public PropertyBindingContextGets or sets the System.Windows.Forms.BindingContext for the control. (Inherited from System.Windows.Forms.Control)
Public PropertyBorderCollapseGets or sets whether adjacent cell borders are collapsed into a single line for cells in the component.  
Public PropertyBorderStyleGets or sets the style of the border around the component.  
Public PropertyBottomGets the distance, in pixels, between the bottom edge of the control and the top edge of its container's client area. (Inherited from System.Windows.Forms.Control)
Public PropertyBoundsGets or sets the size and location of the control including its nonclient elements, in pixels, relative to the parent control. (Inherited from System.Windows.Forms.Control)
Public PropertyButtonDrawModeGets or sets whether to display buttons in button and combo box cells in the component.  
Public PropertyCanFocusGets a value indicating whether the control can receive focus. (Inherited from System.Windows.Forms.Control)
Public PropertyCanSelectGets a value indicating whether the control can be selected. (Inherited from System.Windows.Forms.Control)
Public PropertyCaptureGets or sets a value indicating whether the control has captured the mouse. (Inherited from System.Windows.Forms.Control)
Public PropertyCausesValidationGets 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 System.Windows.Forms.Control)
Public PropertyCellNoteIndicatorRendererGets or sets the cell note indicator renderer for drawing the cell note indicator in the component.  
Public PropertyCellNoteIndicatorVisibleGets or sets whether the cell note indicator appears in cells in the component.  
Public PropertyClientRectangleGets the rectangle that represents the client area of the control. (Inherited from System.Windows.Forms.Control)
Public PropertyClientSizeGets or sets the height and width of the client area of the control. (Inherited from System.Windows.Forms.Control)
Public PropertyClipboardOptionsGets or sets whether headers are included when data is copied to or pasted from the Clipboard in the component.  
Public PropertyClipboardPasteToFillGets or sets whether a single cell copied to the Clipboard fills the range when pasted from the Clipboard to the component.  
Public PropertyColumnSplitBoxAlignmentGets or sets the alignment of the column split box relative to the horizontal scroll bar for this component.  
Public PropertyColumnSplitBoxPolicyGets or sets the display policy for the column split box for this component.  
Public PropertyCompanyNameGets the name of the company or creator of the application containing the control. (Inherited from System.Windows.Forms.Control)
Public PropertyContainer (Inherited from System.ComponentModel.Component)
Public PropertyContainsFocusGets a value indicating whether the control, or one of its child controls, currently has the input focus. (Inherited from System.Windows.Forms.Control)
Public PropertyContextMenuGets or sets the shortcut menu associated with the control. (Inherited from System.Windows.Forms.Control)
Public PropertyContextMenuStripGets or sets the System.Windows.Forms.ContextMenuStrip associated with this control. (Inherited from System.Windows.Forms.Control)
Public PropertyControlsGets the collection of controls contained within the control. (Inherited from System.Windows.Forms.Control)
Public PropertyCreatedGets a value indicating whether the control has been created. (Inherited from System.Windows.Forms.Control)
Public PropertyCursorOverridden. Gets or sets the pointer to display in this component.  
Public PropertyDataBindingsGets the data bindings for the control. (Inherited from System.Windows.Forms.Control)
Public PropertyDataMemberGets or sets the name of the data member that populates the active sheet in this component.  
Public PropertyDataSourceGets or sets the name of the data source that populates the active sheet in this component.  
Public PropertyDisplayRectangleGets the rectangle that represents the display area of the control. (Inherited from System.Windows.Forms.Control)
Public PropertyDisposingGets a value indicating whether the base System.Windows.Forms.Control class is in the process of disposing. (Inherited from System.Windows.Forms.Control)
Public PropertyDockGets or sets which control borders are docked to its parent control and determines how a control is resized with its parent. (Inherited from System.Windows.Forms.Control)
Public PropertyEditingControlGets the Control object editing the active cell, or null if the component is not in edit mode.  
Public PropertyEditModeGets or sets whether the active cell in the component is in edit mode.  
Public PropertyEditModePermanentGets or sets whether edit mode remains on for any cell in the component when that cell becomes active.  
Public PropertyEditModeReplaceGets or sets whether the existing contents of a cell in the component are selected when that cell enters edit mode.  
Public PropertyEnableCrossSheetReferenceEnables cross-sheet referencing for this component.  
Public PropertyEnabledGets or sets a value indicating whether the control can respond to user interaction. (Inherited from System.Windows.Forms.Control)
Public PropertyFocusedGets a value indicating whether the control has input focus. (Inherited from System.Windows.Forms.Control)
Public PropertyFocusRendererGets or sets the focus indicator renderer for drawing the focus rectangle in the component.  
Public PropertyFontOverridden. Gets or sets the default Font for sheets in the component.  
Public PropertyHandleGets the window handle that the control is bound to. (Inherited from System.Windows.Forms.Control)
Public PropertyHasChildrenGets a value indicating whether the control contains one or more child controls. (Inherited from System.Windows.Forms.Control)
Public PropertyHeightGets or sets the height of the control. (Inherited from System.Windows.Forms.Control)
Public PropertyHorizontalScrollBarGets horizontal scroll bar.  
Public PropertyHorizontalScrollBarHeightGets or sets the height of horizontal scroll bars in this component.  
Public PropertyHorizontalScrollBarPolicyGets or sets when to display the horizontal scroll bars in this component.  
Public PropertyHorizontalScrollBarSmallChangeGets or sets the small increment for the horizontal scrollbar.  
Public PropertyImeModeGets or sets the Input Method Editor (IME) mode of the control. (Inherited from System.Windows.Forms.Control)
Public PropertyInterfaceRendererGets or sets the tab strip renderer for drawing tab strip elements.  
Public PropertyInvokeRequiredGets 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 System.Windows.Forms.Control)
Public PropertyIsAccessibleGets or sets a value indicating whether the control is visible to accessibility applications. (Inherited from System.Windows.Forms.Control)
Public PropertyIsDisposedGets a value indicating whether the control has been disposed of. (Inherited from System.Windows.Forms.Control)
Public PropertyIsHandleCreatedGets a value indicating whether the control has a handle associated with it. (Inherited from System.Windows.Forms.Control)
Public PropertyIsLayoutSuspendedReturns whether the layout is suspended in this component.  
Public PropertyIsMirroredGets a value indicating whether the control is mirrored. (Inherited from System.Windows.Forms.Control)
Public PropertyLayoutEngineGets a cached instance of the control's layout engine. (Inherited from System.Windows.Forms.Control)
Public PropertyLeftGets 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 System.Windows.Forms.Control)
Public PropertyLeftTabGets or sets the leftmost sheet tab of the component.  
Public PropertyLocationGets or sets the coordinates of the upper-left corner of the control relative to the upper-left corner of its container. (Inherited from System.Windows.Forms.Control)
Public PropertyMarginGets or sets the space between controls. (Inherited from System.Windows.Forms.Control)
Public PropertyMaximumSizeGets or sets the size that is the upper limit that System.Windows.Forms.Control.GetPreferredSize(System.Drawing.Size) can specify. (Inherited from System.Windows.Forms.Control)
Public PropertyMinimumSizeGets or sets the size that is the lower limit that System.Windows.Forms.Control.GetPreferredSize(System.Drawing.Size) can specify. (Inherited from System.Windows.Forms.Control)
Public PropertyMoveActiveOnFocusGets or sets whether the location of the active cell moves when the user moves the focus to the view using the mouse.  
Public PropertyNameGets or sets the name of the Spread component.  
Public PropertyNamedStylesGets or sets a pre-defined style (NamedStyleCollection object).  
Public PropertyPaddingGets or sets padding within the control. (Inherited from System.Windows.Forms.Control)
Public PropertyParentGets or sets the parent container of the control. (Inherited from System.Windows.Forms.Control)
Public PropertyPreferredSizeGets the size of a rectangular area into which the control can fit. (Inherited from System.Windows.Forms.Control)
Public PropertyProductNameGets the product name of the assembly containing the control. (Inherited from System.Windows.Forms.Control)
Public PropertyProductVersionGets the version of the assembly containing the control. (Inherited from System.Windows.Forms.Control)
Public PropertyRecreatingHandleGets a value indicating whether the control is currently re-creating its handle. (Inherited from System.Windows.Forms.Control)
Public PropertyRegionGets or sets the window region associated with the control. (Inherited from System.Windows.Forms.Control)
Public PropertyRetainSelectionBlockGets or sets whether the selected range of cells remains highlighted when the component loses the focus.  
Public PropertyRightGets the distance, in pixels, between the right edge of the control and the left edge of its container's client area. (Inherited from System.Windows.Forms.Control)
Public PropertyRightToLeftGets or sets a value indicating whether control's elements are aligned to support locales using right-to-left fonts. (Inherited from System.Windows.Forms.Control)
Public PropertyRowSplitBoxAlignmentGets or sets the alignment of the row split box relative to the vertical scroll bar for this component.  
Public PropertyRowSplitBoxPolicyGets or sets the display policy of the row split box in this component.  
Public PropertyScrollBarMaxAlignGets or sets whether the scroll bar aligns with the last row and column of the active sheet in the component.  
Public PropertyScrollBarShowMaxGets or sets whether the displayed scroll bars are based on the entire number of columns and rows in the sheet.  
Public PropertyScrollBarTrackPolicyGets or sets whether the sheet in the component scrolls when the user moves the scroll box.  
Public PropertyScrollTipPolicyGets or sets whether scroll tips appear when the user moves the scroll box in the component.  
Public PropertySearchDialogGets the dialog associated with searching for text in a cell of a sheet in this component.  
Public PropertySelectionBlockOptionsGets or sets which type of selections in the component the user can make.  
Public PropertySelectionRendererGets or sets the selection renderer for drawing selections in the component.  
Public PropertySheetsGets the sheets (SheetView objects) in the component.  
Public PropertySiteGets or sets the site of the control. (Inherited from System.Windows.Forms.Control)
Public PropertySizeGets or sets the height and width of the control. (Inherited from System.Windows.Forms.Control)
Public PropertySkinGets or sets the skin for the spread.  
Public PropertySuspendAnimationsGets or sets whether to suspend animations such as an animated focus renderer.  
Public PropertyTabIndexGets or sets the tab order of the control within its container. (Inherited from System.Windows.Forms.Control)
Public PropertyTabStopGets or sets a value indicating whether the user can give the focus to this control using the TAB key. (Inherited from System.Windows.Forms.Control)
Public PropertyTabStripGets the object representing the tab strip for this component.  
Public PropertyTabStripInsertTabGets or sets whether a special tab is displayed to allow inserting new sheets.  
Public PropertyTabStripInsertTabImageGets or sets the tabstrip insert-tab image.  
Public PropertyTabStripPlacementGets or sets the location of the tab strip.  
Public PropertyTabStripPolicyGets or sets the display policy for the sheet tab strip for this component.  
Public PropertyTabStripRatioGets or sets the width of the tab strip for this component expressed as a percentage of the overall horizontal scroll bar width.  
Public PropertyTagGets or sets extra data for the application for this component.  
Public PropertyTextTipAppearanceGets or sets the appearance of text tips in the view.  
Public PropertyTextTipDelayGets or sets the time (in milliseconds) the component waits before displaying the text tip for the cell or header under the pointer.  
Public PropertyTextTipPolicyGets or sets whether to display text tips and cell notes and the location of the tips and notes in this component.  
Public PropertyTitleInfoGets or sets the collection of title information objects for the Spread  
Public PropertyTopGets 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 System.Windows.Forms.Control)
Public PropertyTopLevelControlGets the parent control that is not parented by another Windows Forms control. Typically, this is the outermost System.Windows.Forms.Form that the control is contained in. (Inherited from System.Windows.Forms.Control)
Public PropertyUndoManagerGets or sets the undo manager for this Spread component.  
Public PropertyUseWaitCursorGets or sets a value indicating whether to use the wait cursor for the current control and all child controls. (Inherited from System.Windows.Forms.Control)
Public PropertyVerticalScrollBarGets vertical scroll bar.  
Public PropertyVerticalScrollBarPolicyGets or sets when to display the vertical scroll bars in this component.  
Public PropertyVerticalScrollBarSmallChangeGets or sets the small increment for the horizontal scrollbar.  
Public PropertyVerticalScrollBarWidthGets or sets the width of vertical scroll bars in this component.  
Public PropertyVisibleGets or sets a value indicating whether the control and all its child controls are displayed. (Inherited from System.Windows.Forms.Control)
Public PropertyVisualStylesGets or sets whether to use visual styles when rendering objects in the component.  
Public PropertyWidthGets or sets the width of the control. (Inherited from System.Windows.Forms.Control)
Public PropertyZoomFactorGets or sets the scaling factor of the display of the active sheet in this component.  
Top

Protected Properties

 NameDescription
Protected PropertyCanEnableImeGets a value indicating whether the System.Windows.Forms.Control.ImeMode property can be set to an active value, to enable IME support. (Inherited from System.Windows.Forms.Control)
Protected PropertyCanRaiseEventsDetermines if events can be raised on the control. (Inherited from System.Windows.Forms.Control)
Protected PropertyDefaultCursorGets or sets the default cursor for the control. (Inherited from System.Windows.Forms.Control)
Protected PropertyDefaultImeModeGets the default Input Method Editor (IME) mode supported by the control. (Inherited from System.Windows.Forms.Control)
Protected PropertyDefaultMarginGets the space, in pixels, that is specified by default between controls. (Inherited from System.Windows.Forms.Control)
Protected PropertyDefaultMaximumSizeGets the length and height, in pixels, that is specified as the default maximum size of a control. (Inherited from System.Windows.Forms.Control)
Protected PropertyDefaultMinimumSizeGets the length and height, in pixels, that is specified as the default minimum size of a control. (Inherited from System.Windows.Forms.Control)
Protected PropertyDefaultPaddingGets the internal spacing, in pixels, of the contents of a control. (Inherited from System.Windows.Forms.Control)
Protected PropertyDefaultSizeOverridden. Gets the default size of the component.  
Protected PropertyDoubleBufferedGets or sets a value indicating whether this control should redraw its surface using a secondary buffer to reduce or prevent flicker. (Inherited from System.Windows.Forms.Control)
Protected PropertyEvents (Inherited from System.ComponentModel.Component)
Protected PropertyFontHeightGets or sets the height of the font of the control. (Inherited from System.Windows.Forms.Control)
Protected PropertyImeModeBaseGets or sets the IME mode of a control. (Inherited from System.Windows.Forms.Control)
Protected PropertyResizeRedrawGets or sets a value indicating whether the control redraws itself when resized. (Inherited from System.Windows.Forms.Control)
Top

Public Methods

 NameDescription
Public MethodAddControlOverloaded. Adds a child control to a specified sheet at the location of the specified row and column.  
Public MethodAddViewportOverloaded. Adds a row or column of viewports.  
Public MethodBeginInvokeOverloaded. Executes the specified delegate asynchronously on the thread that the control's underlying handle was created on. (Inherited from System.Windows.Forms.Control)
Public MethodBringToFrontBrings the control to the front of the z-order. (Inherited from System.Windows.Forms.Control)
Public MethodCancelAnnotationModeCancels annotation mode.  
Public MethodCancelCellEditingCancels cell editing.  
Public MethodContainsRetrieves a value indicating whether the specified control is a child of the control. (Inherited from System.Windows.Forms.Control)
Public MethodCreateControlForces the creation of the visible control, including the creation of the handle and any visible child controls. (Inherited from System.Windows.Forms.Control)
Public MethodCreateGraphicsCreates the System.Drawing.Graphics for the control. (Inherited from System.Windows.Forms.Control)
Public MethodDrawToBitmapSupports rendering to the specified bitmap. (Inherited from System.Windows.Forms.Control)
Public MethodEndInvokeRetrieves the return value of the asynchronous operation represented by the System.IAsyncResult passed. (Inherited from System.Windows.Forms.Control)
Public MethodFindFormRetrieves the form that the control is on. (Inherited from System.Windows.Forms.Control)
Public MethodFocusSets input focus to the control. (Inherited from System.Windows.Forms.Control)
Public MethodGetActionMapGets the action map, that maps action identifiers (for keystrokes) to particular actions.  
Public MethodGetActiveColumnViewportIndexOverloaded. Gets the index of the active viewport column for the active sheet.  
Public MethodGetActiveRowViewportIndexOverloaded. Gets the index of the active viewport row for the active sheet.  
Public MethodGetCellFromPixelGets the row and column indexes of the cell at the specified pointer location.  
Public MethodGetCellRectangleGets the rectangle of the cell.  
Public MethodGetChildAtPointOverloaded. Retrieves the child control that is located at the specified coordinates, specifying whether to ignore child controls of a certain type. (Inherited from System.Windows.Forms.Control)
Public MethodGetColumnHeaderRectangleGets the rectangle of the column header.  
Public MethodGetColumnPageBreaksOverloaded. Gets the column page breaks for the specified sheet under the current printing conditions.  
Public MethodGetColumnRangeGroupHeightGets the height of the Column RangeGroup.  
Public MethodGetColumnSplitBarRectangleGets the rectangle of the column split bar.  
Public MethodGetColumnSplitBoxRectangleGets the rectangle of the column split box.  
Public MethodGetColumnViewportCountOverloaded. Gets the number of viewport columns in the active sheet.  
Public MethodGetColumnViewportIndexFromXGets the index of the viewport column for the specified coordinate for the active sheet.  
Public MethodGetContainerControlReturns the next System.Windows.Forms.ContainerControl up the control's chain of parent controls. (Inherited from System.Windows.Forms.Control)
Public MethodGetCursorGets the pointer displayed over different areas of the component.  
Public Methodstatic (Shared in Visual Basic)GetExcelSheetNamesOverloaded. Gets an array of sheet names from the specified Excel stream.  
Public MethodGetHorizontalScrollBarRectangleGets the rectangle of the horizontal scroll bar.  
Public MethodGetInputMapOverloaded. Gets the input map defined for the specified focus mode.  
Public MethodGetInputMapWhenChildHasFocusGets the input map when a child control has keyboard focus.  
Public MethodGetInputMapWhenShapeHasFocusGets the input map when a shape has keyboard focus.  
Public MethodGetMaximumCellOverflowWidthGets the maximum cell overflow width in pixels.  
Public MethodGetOwnerPrintColumnPageBreaksGets the column page breaks for the specified sheet under the current printing conditions.  
Public MethodGetOwnerPrintPageCountGets the number of pages required to print a given sheet into the supplied rectangle.  
Public MethodGetOwnerPrintRowPageBreaksGets the row page breaks for the specified sheet under the current printing conditions.  
Public MethodGetPreferredSizeRetrieves the size of a rectangular area into which a control can be fitted. (Inherited from System.Windows.Forms.Control)
Public MethodGetPrintPageCountGets the number of pages required to print the specified sheet.  
Public MethodGetPrintPreviewGets the print preview dialog.  
Public MethodGetRootWorkbookGets the main workbook associated with the Spread component.  
Public MethodGetRowHeaderRectangleGets the rectangle of the row header.  
Public MethodGetRowPageBreaksOverloaded. Gets the row page breaks for the specified sheet under the current printing conditions.  
Public MethodGetRowRangeGroupWidthGets the width of the Row RangeGroup.  
Public MethodGetRowSplitBarRectangleGets the rectangle of the row split bar.  
Public MethodGetRowSplitBoxRectangleGets the rectangle of the row split box.  
Public MethodGetRowViewportCountOverloaded. Gets the number of viewport rows.  
Public MethodGetRowViewportIndexFromYGets the index of the viewport row for the specified coordinate for the active sheet.  
Public MethodGetSheetFromTagGets a sheet with a specific tag.  
Public MethodGetSheetTabRectangleGets the rectangle of the tab associated with a sheet.  
Public MethodGetTabSplitBoxRectangleGets the rectangle of the split box on the tab strip.  
Public MethodGetTabStripRectangleGets the rectangle of the tab strip.  
Public MethodGetVerticalScrollBarRectangleGets the rectangle of the vertical scroll bar.  
Public MethodGetViewportBottomRowOverloaded. Gets the bottom row of cells of the specified viewport row for the active sheet.  
Public MethodGetViewportLeftColumnOverloaded. Gets the leftmost column of cells of the specified viewport column for the active sheet.  
Public MethodGetViewportPreferredHeightOverloaded. Gets the maximum height of the viewport row for the active sheet.  
Public MethodGetViewportPreferredWidthOverloaded. Gets the maximum width of the specified viewport column.  
Public MethodGetViewportRectangleGets the rectangle of the viewport.  
Public MethodGetViewportRightColumnOverloaded. Gets the rightmost column of cells of the specified viewport column for the active sheet.  
Public MethodGetViewportTopRowOverloaded. Gets the top row of cells of the specified viewport row for the specified sheet.  
Public MethodGoalSeekAttempts to find the value for one cell that produces the desired formula result in another cell.  
Public MethodHideConceals the control from the user. (Inherited from System.Windows.Forms.Control)
Public MethodHitTestPerforms a hit test.  
Public MethodInvalidateOverloaded. 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 System.Windows.Forms.Control)
Public MethodInvokeOverloaded. Executes the specified delegate on the thread that owns the control's underlying window handle. (Inherited from System.Windows.Forms.Control)
Public MethodIsCellInViewReturns whether the cell at the specified location is visible in the specified view.  
Public MethodIsExcelFileOverloaded. Opens the specified file and determines whether it meets the minimal requirements to be considered an Excel file.  
Public MethodIsExcelStreamOverloaded. Opens the specified file and determines whether it meets the minimal requirements to be considered a stream containing an Excel workbook.  
Public MethodIsSpreadSSFileOpens the specified file and determines whether it meets the minimal requirements to be considered a Spread SS file.  
Public MethodIsSpreadXmlFileOpens the specified file and determines whether it meets the minimal requirements to be considered a Spread XML file.  
Public MethodLoadFormulasLoads formulas that are deserialized but not parsed yet, to be used after all sheets have been created and deserialized.  
Public MethodOnClipboardChangingRaises the ClipboardChanging event.  
Public MethodOpenOverloaded. Opens a saved XML file.  
Public MethodOpenExcelOverloaded. Opens an Excel Compound Document File and loads it into Spread.  
Public MethodOpenSpreadFileOpens a saved Spread file.  
Public MethodOwnerPrintDrawPrints the specified page of the specified sheet to a specified graphics interface with the specified size.  
Public MethodPerformLayoutOverloaded. Forces the Spread component to apply layout logic to its child controls.  
Public MethodPointToClientComputes the location of the specified screen point into client coordinates. (Inherited from System.Windows.Forms.Control)
Public MethodPointToScreenComputes the location of the specified client point into screen coordinates. (Inherited from System.Windows.Forms.Control)
Public MethodPreProcessControlMessagePreprocesses keyboard or input messages within the message loop before they are dispatched. (Inherited from System.Windows.Forms.Control)
Public MethodPrintSheetOverloaded. Handles the printing of the specified sheet in a separate thread.  
Public MethodRectangleToClientComputes the size and location of the specified screen rectangle in client coordinates. (Inherited from System.Windows.Forms.Control)
Public MethodRectangleToScreenComputes the size and location of the specified client rectangle in screen coordinates. (Inherited from System.Windows.Forms.Control)
Public MethodRefreshForces the control to invalidate its client area and immediately redraw itself and any child controls. (Inherited from System.Windows.Forms.Control)
Public MethodRemoveControlRemoves a child control from the specified sheet.  
Public MethodRemoveViewportOverloaded. Removes a row or column of viewports.  
Public MethodResetResets the component to its original state.  
Public MethodResetCellNoteIndicatorRendererResets the focus renderer to its original state.  
Public MethodResetFocusRendererResets the focus renderer to its original state.  
Public MethodResetTextResets the System.Windows.Forms.Control.Text property to its default value. (Inherited from System.Windows.Forms.Control)
Public MethodResumeLayoutOverloaded. Resumes normal layout logic.  
Public MethodSaveOverloaded. Saves the contents of the Spread component to the specified file.  
Public MethodSaveExcelOverloaded. Saves the contents of the Spread component to the specified stream.  
Public MethodScale (Inherited from System.Windows.Forms.Control)
Public MethodSearchOverloaded. Searches the text in the specified range of cells in the specified sheet for the specified string with the specified criteria.  
Public MethodSearchHeadersOverloaded. Searches the text in the header cells in the specified sheet for the specified string.  
Public MethodSearchWithDialogOverloaded. Searches the text in the cells of the active sheet for the search string with the default criteria using a provided search dialog.  
Public MethodSearchWithDialogAdvancedOverloaded. Searches the text in the cells of the sheets for the search string with the default criteria using a provided advanced search dialog.  
Public MethodSelectNextControlActivates the next control. (Inherited from System.Windows.Forms.Control)
Public MethodSendToBackSends the control to the back of the z-order. (Inherited from System.Windows.Forms.Control)
Public MethodSetActionMapSets the action map, that maps action identifiers (for keystrokes) to particular actions.  
Public MethodSetActiveViewportOverloaded. Sets the active viewport for the active sheet.  
Public MethodSetBoundsOverloaded. Sets the bounds of the control to the specified location and size. (Inherited from System.Windows.Forms.Control)
Public MethodSetCursorSets the pointer displayed over different areas of the component.  
Public MethodSetInputMapOverloaded. Sets the input map for the specified focus mode.  
Public MethodSetInputMapWhenChildHasFocusSets the input map when a child control has keyboard focus.  
Public MethodSetInputMapWhenShapeHasFocusSets the input map when a shape has keyboard focus.  
Public MethodSetInsertSheetImageSets the custom image displayed on the insert sheet tab.  
Public MethodSetMaximumCellOverflowWidthSets the maximum cell overflow width in pixels.  
Public MethodSetPrintInfoSets the PrintInfo object for the specfied sheet.  
Public MethodSetPrintPreviewSets the print preview dialog.  
Public MethodSetViewportLeftColumnOverloaded. Sets the leftmost column of cells of the specified viewport column for the active sheet.  
Public MethodSetViewportPreferredHeightOverloaded. Sets the maximum height of the specified viewport row for the active sheet.  
Public MethodSetViewportPreferredWidthOverloaded. Sets the maximum width of the specified viewport column for the active sheet.  
Public MethodSetViewportTopRowOverloaded. Sets the top row of cells of the specified viewport row for the active sheet.  
Public MethodShowDisplays the control to the user. (Inherited from System.Windows.Forms.Control)
Public MethodShowActiveCellMoves the active cell to the specified position in the component.  
Public MethodShowCellMoves the specified cell in the specified viewport to the specified position in the component.  
Public MethodShowCollectionEditorShows the collection editor.  
Public MethodShowColumnMoves a column of cells in the specified viewport to the specified position in the component.  
Public MethodShowDependentsShows the dependent cells for a formula cell.  
Public MethodShowPageSetupOverloaded. Shows the page setup dialog with the specified buttons for the specified sheet.  
Public MethodShowPrecedentsShows the cells that are referred to by formulas in other cells.  
Public MethodShowRowMoves a row in the specified viewport to the specified position in the component.  
Public MethodStartAnnotationModeOverloaded. Starts annotation mode.  
Public MethodStartCellEditingStarts cell editing.  
Public MethodStartInkNotationOverloaded. Starts ink notation in the active viewport if the Microsoft.Ink assembly is found in the GAC.  
Public MethodStopAnnotationModeStops annotation mode.  
Public MethodStopCellEditingStops cell editing.  
Public MethodSuspendLayoutTemporarily suspends the layout logic for this component.  
Public MethodToString (Inherited from System.ComponentModel.Component)
Public MethodUpdateCauses the control to redraw the invalidated regions within its client area. (Inherited from System.Windows.Forms.Control)
Top

Protected Methods

 NameDescription
Protected MethodCreateAccessibilityInstanceCreates a new accessibility object for the control. (Inherited from System.Windows.Forms.Control)
Protected MethodCreateControlsInstanceCreates a new instance of the control collection for the control. (Inherited from System.Windows.Forms.Control)
Protected MethodCreateHandleCreates a handle for the control. (Inherited from System.Windows.Forms.Control)
Protected MethodDestroyHandleDestroys the handle associated with the control. (Inherited from System.Windows.Forms.Control)
Protected MethodFinalizeThe destructor method  
Protected MethodGetAccessibilityObjectByIdRetrieves the specified System.Windows.Forms.AccessibleObject. (Inherited from System.Windows.Forms.Control)
Protected MethodGetAutoSizeModeRetrieves a value indicating how a control will behave when its System.Windows.Forms.Control.AutoSize property is enabled. (Inherited from System.Windows.Forms.Control)
Protected MethodGetScaledBoundsRetrieves the bounds within which the control is scaled. (Inherited from System.Windows.Forms.Control)
Protected MethodGetService (Inherited from System.ComponentModel.Component)
Protected MethodGetStyleRetrieves the value of the specified control style bit for the control. (Inherited from System.Windows.Forms.Control)
Protected MethodGetTopLevelDetermines if the control is a top-level control. (Inherited from System.Windows.Forms.Control)
Protected MethodInvokeGotFocusRaises the System.Windows.Forms.Control.GotFocus event for the specified control. (Inherited from System.Windows.Forms.Control)
Protected MethodInvokeLostFocusRaises the System.Windows.Forms.Control.LostFocus event for the specified control. (Inherited from System.Windows.Forms.Control)
Protected MethodInvokeOnClickRaises the System.Windows.Forms.Control.Click event for the specified control. (Inherited from System.Windows.Forms.Control)
Protected MethodInvokePaintRaises the System.Windows.Forms.Control.Paint event for the specified control. (Inherited from System.Windows.Forms.Control)
Protected MethodInvokePaintBackgroundRaises the PaintBackground event for the specified control. (Inherited from System.Windows.Forms.Control)
Protected MethodIsInputCharOverridden. Determines whether the specified character is an input character that the component can handle without preprocessing.  
Protected MethodIsInputKeyOverridden. Determines whether the specified key is an input key that the component can handle without preprocessing.  
Protected MethodMemberwiseCloneOverloaded. Creates a shallow copy of the current System.MarshalByRefObject object. (Inherited from System.MarshalByRefObject)
Protected MethodOnActiveSheetChangedRaises the ActiveSheetChanged event.  
Protected MethodOnActiveSheetChangingRaises the ActiveSheetChanging event.  
Protected MethodOnActiveSpreadViewChangedRaises the ActiveSpreadViewChanged event.  
Protected MethodOnActiveSpreadViewChangingRaises the ActiveSpreadViewChanging event.  
Protected MethodOnAdvanceRaises the Advance event.  
Protected MethodOnAnnotationModeEndingRaises the AnnotationModeEnding event.  
Protected MethodOnAnnotationModeStartingRaises the AnnotationModeStarting event.  
Protected MethodOnAutoFilteredColumnRaises the AutoFilteredColumn event.  
Protected MethodOnAutoFilteringColumnRaises the AutoFilteringColumn event.  
Protected MethodOnAutoSizeChangedRaises the System.Windows.Forms.Control.AutoSizeChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnAutoSortedColumnRaises the AutoSortedColumn event.  
Protected MethodOnAutoSortingColumnRaises the AutoSortingColumn event.  
Protected MethodOnBackColorChangedRaises the System.Windows.Forms.Control.BackColorChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnBackgroundImageChangedRaises the System.Windows.Forms.Control.BackgroundImageChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnBackgroundImageLayoutChangedRaises the System.Windows.Forms.Control.BackgroundImageLayoutChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnButtonClickedRaises the ButtonClicked event.  
Protected MethodOnCellClickRaises the CellClick event.  
Protected MethodOnCellDoubleClickRaises the CellDoubleClick event.  
Protected MethodOnChangeRaises the Change event.  
Protected MethodOnChildControlActivatedRaises the ChildControlActivated event.  
Protected MethodOnChildControlDeactivatedRaises the ChildControlDeactivated event.  
Protected MethodOnChildViewCreatedRaises the ChildViewCreated event.  
Protected MethodOnChildWorkbookCreatedRaises the ChildWorkbookCreated event.  
Protected MethodOnClickRaises the System.Windows.Forms.Control.Click event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnClientSizeChangedOverridden. Override to adjust the client area  
Protected MethodOnClipboardChangedRaises the ClipboardChanged event.  
Protected MethodOnClipboardPastedRaises the ClipboardPasted event.  
Protected MethodOnClipboardPastingRaises the ClipboardPasting event.  
Protected MethodOnColumnDragMoveRaises the ColumnDragMove event.  
Protected MethodOnColumnDragMoveCompletedRaises the ColumnDragMoveCompleted event.  
Protected MethodOnColumnViewportWidthChangedRaises the ColumnViewportWidthChanged event.  
Protected MethodOnColumnWidthChangedRaises the ColumnWidthChanged event.  
Protected MethodOnColumnWidthChangingRaises the ColumnWidthChanging event.  
Protected MethodOnComboCloseUpRaises the ComboCloseUp event.  
Protected MethodOnComboDropDownRaises the ComboDropDown event.  
Protected MethodOnComboSelChangeRaises the ComboSelChange event.  
Protected MethodOnContextMenuStripChangedRaises the System.Windows.Forms.Control.ContextMenuStripChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnControlRemovedRaises the ControlRemoved event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnCursorChangedRaises the System.Windows.Forms.Control.CursorChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnDataColumnConfigureRaises the DataColumnConfigure event.  
Protected MethodOnDialogCharRaises the DialogChar event.  
Protected MethodOnDialogKeyRaises the DialogKey event.  
Protected MethodOnDoubleClickOverridden. Raises the DoubleClick event.  
Protected MethodOnDragDropRaises the System.Windows.Forms.Control.DragDrop event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnDragDropBlockRaises the DragDropBlock event.  
Protected MethodOnDragDropBlockCompletedRaises the DragDropBlockCompleted event.  
Protected MethodOnDragEnterRaises the System.Windows.Forms.Control.DragEnter event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnDragFillBlockRaises the DragFillBlock event.  
Protected MethodOnDragFillBlockCompletedRaises the DragFillBlockCompleted event.  
Protected MethodOnDragLeaveRaises the System.Windows.Forms.Control.DragLeave event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnDragOverRaises the System.Windows.Forms.Control.DragOver event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnEditChangeRaises the EditChange event.  
Protected MethodOnEditErrorRaises the EditError event.  
Protected MethodOnEditModeOffRaises the EditModeOff event.  
Protected MethodOnEditModeOnRaises the EditModeOn event.  
Protected MethodOnEditModeStartingRaises the EditModeStarting event.  
Protected MethodOnEditorFocusedRaises the EditorFocused event.  
Protected MethodOnEnabledChangedOverridden. Raises the EnableChanged event.  
Protected MethodOnEnterRaises the System.Windows.Forms.Control.Enter event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnEnterCellRaises the EnterCell event.  
Protected MethodOnErrorRaises the Error event.  
Protected MethodOnExpandRaises the EnterCell event.  
Protected MethodOnFontChangedRaises the System.Windows.Forms.Control.FontChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnForeColorChangedRaises the System.Windows.Forms.Control.ForeColorChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnGroupedRaises the Grouped event.  
Protected MethodOnGroupingRaises the Grouping event.  
Protected MethodOnHyperLinkClickedRaises the HyperLinkClicked event.  
Protected MethodOnInvalidatedRaises the System.Windows.Forms.Control.Invalidated event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnLayoutRaises the System.Windows.Forms.Control.Layout event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnLeaveRaises the System.Windows.Forms.Control.Leave event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnLeaveCellRaises the LeaveCell event.  
Protected MethodOnLocationChangedRaises the System.Windows.Forms.Control.LocationChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnMarginChangedRaises the System.Windows.Forms.Control.MarginChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnMouseCaptureChangedRaises the System.Windows.Forms.Control.MouseCaptureChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnMouseClickRaises the System.Windows.Forms.Control.MouseClick event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnMouseDoubleClickRaises the System.Windows.Forms.Control.MouseDoubleClick event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnMoveRaises the System.Windows.Forms.Control.Move event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnPaddingChangedRaises the System.Windows.Forms.Control.PaddingChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnPaintGrayAreaRaises the PaintGrayArea event.  
Protected MethodOnPaintGroupBarBackgroundRaises the PaintGroupBarBackground event.  
Protected MethodOnPaintTabStripRaises the PaintTabStrip event.  
Protected MethodOnPaintTabStripButtonRaises the PaintTabStripButton event.  
Protected MethodOnPaintTabStripTabRaises the PaintTabStripTab event.  
Protected MethodOnParentBackColorChangedRaises the System.Windows.Forms.Control.BackColorChanged event when the System.Windows.Forms.Control.BackColor property value of the control's container changes. (Inherited from System.Windows.Forms.Control)
Protected MethodOnParentBackgroundImageChangedRaises the System.Windows.Forms.Control.BackgroundImageChanged event when the System.Windows.Forms.Control.BackgroundImage property value of the control's container changes. (Inherited from System.Windows.Forms.Control)
Protected MethodOnParentBindingContextChangedRaises the System.Windows.Forms.Control.BindingContextChanged event when the System.Windows.Forms.Control.BindingContext property value of the control's container changes. (Inherited from System.Windows.Forms.Control)
Protected MethodOnParentChangedRaises the System.Windows.Forms.Control.ParentChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnParentCursorChangedRaises the System.Windows.Forms.Control.CursorChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnParentEnabledChangedRaises the System.Windows.Forms.Control.EnabledChanged event when the System.Windows.Forms.Control.Enabled property value of the control's container changes. (Inherited from System.Windows.Forms.Control)
Protected MethodOnParentFontChangedRaises the System.Windows.Forms.Control.FontChanged event when the System.Windows.Forms.Control.Font property value of the control's container changes. (Inherited from System.Windows.Forms.Control)
Protected MethodOnParentForeColorChangedRaises the System.Windows.Forms.Control.ForeColorChanged event when the System.Windows.Forms.Control.ForeColor property value of the control's container changes. (Inherited from System.Windows.Forms.Control)
Protected MethodOnParentRightToLeftChangedRaises the System.Windows.Forms.Control.RightToLeftChanged event when the System.Windows.Forms.Control.RightToLeft property value of the control's container changes. (Inherited from System.Windows.Forms.Control)
Protected MethodOnParentVisibleChangedRaises the System.Windows.Forms.Control.VisibleChanged event when the System.Windows.Forms.Control.Visible property value of the control's container changes. (Inherited from System.Windows.Forms.Control)
Protected MethodOnPreviewKeyDownRaises the System.Windows.Forms.Control.PreviewKeyDown event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnPreviewRowFetchRaises the PreviewRowFetch event.  
Protected MethodOnPrintRaises the System.Windows.Forms.Control.Paint event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnPrintAbortRaises the PrintAbort event.  
Protected MethodOnPrintBackgroundRaises the PrintBackground event.  
Protected MethodOnPrintCancelledRaises the PrintCancelled event.  
Protected MethodOnPrintHeaderFooterAreaRaises the PrintHeaderFooterArea event.  
Protected MethodOnPrintMessageBoxRaises the PrintMessageBox event.  
Protected MethodOnPrintPreviewShowingRaises the PrintPreviewShowing event.  
Protected MethodOnQueryContinueDragRaises the System.Windows.Forms.Control.QueryContinueDrag event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnRangeGroupStateChangedRaises the RangeGroupStateChanged event.  
Protected MethodOnRangeGroupStateChangingRaises the RangeGroupStateChanging event.  
Protected MethodOnRegionChangedRaises the System.Windows.Forms.Control.RegionChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnResizeOverridden. Raises the Resize event.  
Protected MethodOnRightToLeftChangedOverridden. Raises the RightToLeftChanged event.  
Protected MethodOnRowDragMoveRaises the RowDragMove event.  
Protected MethodOnRowDragMoveCompletedRaises the RowDragMoveCompleted event.  
Protected MethodOnRowHeightChangedRaises the RowHeightChanged event.  
Protected MethodOnRowHeightChangingRaises the RowHeightChanging event.  
Protected MethodOnRowViewportHeightChangedRaises the RowViewportHeightChanged event.  
Protected MethodOnScrollTipFetchRaises the ScrollTipFetch event.  
Protected MethodOnSearchDialogClosingRaises the SearchDialogClosing event.  
Protected MethodOnSelectionChangedRaises the SelectionChanged event.  
Protected MethodOnSelectionChangingRaises the SelectionChanging event.  
Protected MethodOnShapeActivatedRaises the ShapeActivated event.  
Protected MethodOnShapeDeactivatedRaises the ShapeDeactivated event.  
Protected MethodOnSheetTabClickRaises the SheetTabClick event.  
Protected MethodOnSheetTabDoubleClickRaises the SheetTabDoubleClick event.  
Protected MethodOnSizeChangedRaises the System.Windows.Forms.Control.SizeChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnStyleChangedRaises the System.Windows.Forms.Control.StyleChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnSubEditorClosedRaises the SubEditorClosed event.  
Protected MethodOnSubEditorOpeningRaises the SubEditorOpening event.  
Protected MethodOnSystemColorsChangedRaises the System.Windows.Forms.Control.SystemColorsChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnTabIndexChangedRaises the System.Windows.Forms.Control.TabIndexChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnTabStopChangedRaises the System.Windows.Forms.Control.TabStopChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnTextChangedRaises the System.Windows.Forms.Control.TextChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnTextTipFetchRaises the TextTipFetch event.  
Protected MethodOnTopChangeRaises the TopChange event.  
Protected MethodOnUngroupedRaises the Grouped event.  
Protected MethodOnUserFormulaEnteredRaises the UserFormulaEntered event.  
Protected MethodOnUserZoomingRaises the UserZooming event.  
Protected MethodOnValidatedRaises the System.Windows.Forms.Control.Validated event. (Inherited from System.Windows.Forms.Control)
Protected MethodOnValidatingOverridden. Raises the Validating event.  
Protected MethodOnVisibleChangedOverridden. Raises the VisibleChanged event.  
Protected MethodRecreateHandleForces the re-creation of the handle for the control. (Inherited from System.Windows.Forms.Control)
Protected MethodRtlTranslateAlignmentOverloaded. Converts the specified System.Windows.Forms.HorizontalAlignment to the appropriate System.Windows.Forms.HorizontalAlignment to support right-to-left text. (Inherited from System.Windows.Forms.Control)
Protected MethodRtlTranslateHorizontalConverts the specified System.Windows.Forms.HorizontalAlignment to the appropriate System.Windows.Forms.HorizontalAlignment to support right-to-left text. (Inherited from System.Windows.Forms.Control)
Protected MethodRtlTranslateLeftRightConverts the specified System.Windows.Forms.LeftRightAlignment to the appropriate System.Windows.Forms.LeftRightAlignment to support right-to-left text. (Inherited from System.Windows.Forms.Control)
Protected MethodScaleControl (Inherited from System.Windows.Forms.Control)
Protected MethodSetAutoSizeModeSets a value indicating how a control will behave when its System.Windows.Forms.Control.AutoSize property is enabled. (Inherited from System.Windows.Forms.Control)
Protected MethodSetBoundsCorePerforms the work of setting the specified bounds of this control. (Inherited from System.Windows.Forms.Control)
Protected MethodSetClientSizeCoreSets the size of the client area of the control. (Inherited from System.Windows.Forms.Control)
Protected MethodSetStyleSets a specified System.Windows.Forms.ControlStyles flag to either true or false. (Inherited from System.Windows.Forms.Control)
Protected MethodSetTopLevelSets the control as the top-level control. (Inherited from System.Windows.Forms.Control)
Protected MethodSetVisibleCoreSets the control to the specified visible state. (Inherited from System.Windows.Forms.Control)
Protected MethodSizeFromClientSize (Inherited from System.Windows.Forms.Control)
Protected MethodUpdateStylesForces the assigned styles to be reapplied to the control. (Inherited from System.Windows.Forms.Control)
Protected MethodUpdateZOrderUpdates the control in its parent's z-order. (Inherited from System.Windows.Forms.Control)
Top

Public Events

 NameDescription
Public EventActiveSheetChangedOccurs when the user has changed the active sheet.  
Public EventActiveSheetChangingOccurs when the user changes the active sheet.  
Public EventActiveSpreadViewChangedOccurs when the user has changed the active SpreadView.  
Public EventActiveSpreadViewChangingOccurs when the user changes the active SpreadView.  
Public EventAdvanceOccurs when the user tries to advance from first or last row in Spread.  
Public EventAnnotationModeEndingOccurs when the user ends annotation mode.  
Public EventAnnotationModeStartingOccurs when the user begins annotation mode.  
Public EventAutoFilteredColumnOccurs when a column has just been automatically filtered.  
Public EventAutoFilteringColumnOccurs when a column is about to be automatically filtered.  
Public EventAutoSortedColumnOccurs when a column has just been automatically sorted.  
Public EventAutoSortingColumnOccurs when a column is about to be automatically sorted.  
Public EventBackColorChangedOccurs when the value of the System.Windows.Forms.Control.BackColor property changes. (Inherited from System.Windows.Forms.Control)
Public EventBackgroundImageChangedOccurs when the value of the System.Windows.Forms.Control.BackgroundImage property changes. (Inherited from System.Windows.Forms.Control)
Public EventBackgroundImageLayoutChangedOccurs when the System.Windows.Forms.Control.BackgroundImageLayout property changes. (Inherited from System.Windows.Forms.Control)
Public EventBindingContextChangedOccurs when the value of the System.Windows.Forms.BindingContext property changes. (Inherited from System.Windows.Forms.Control)
Public EventButtonClickedOccurs when the user clicks a button, check box, or hyperlink in a cell.  
Public EventCausesValidationChangedOccurs when the value of the System.Windows.Forms.Control.CausesValidation property changes. (Inherited from System.Windows.Forms.Control)
Public EventCellClickOccurs when the user presses down the left mouse button in a cell.  
Public EventCellDoubleClickOccurs when the user presses down the left mouse button twice (double clicks) in a cell.  
Public EventChangeOccurs after the user modifies data in a cell.  
Public EventChangeUICuesOccurs when the focus or keyboard user interface (UI) cues change. (Inherited from System.Windows.Forms.Control)
Public EventChartIndicatorActivatedOccurs when the chart indicator is activated.  
Public EventChartIndicatorDeactivatedOccurs when the chart indicator is deactivated.  
Public EventChildControlActivatedOccurs when a child control is activated.  
Public EventChildControlDeactivatedOccurs when a child control is deactivated.  
Public EventChildViewCreatedOccurs when a child view of the Spread component is created.  
Public EventChildWorkbookCreatedOccurs when a child workbook of the Spread component is created.  
Public EventClientSizeChangedOccurs when the value of the System.Windows.Forms.Control.ClientSize property changes. (Inherited from System.Windows.Forms.Control)
Public EventClipboardChangedOccurs when a Clipboard change occurs that can affect the Spread component.  
Public EventClipboardChangingOccurs when the Clipboard is changing through a Spread action.  
Public EventClipboardPastedOccurs when the user pastes from the clipboard.  
Public EventClipboardPastingOccurs when the user pastes from the clipboard.  
Public EventColumnDragMoveOccurs when AllowColumnMove is true and the user drags to move a column.  
Public EventColumnDragMoveCompletedOccurs when the user finishes dragging to move a column.  
Public EventColumnViewportWidthChangedOccurs when a viewport column width has changed.  
Public EventColumnWidthChangedOccurs when the column width has changed.  
Public EventColumnWidthChangingOccurs when the column width is changing.  
Public EventComboCloseUpOccurs when the user closes a combo box in a cell.  
Public EventComboDropDownOccurs when the user drops down a combo box in a cell.  
Public EventComboSelChangeOccurs when the user changes the selection in a combo box in a cell.  
Public EventContextMenuChangedOccurs when the value of the System.Windows.Forms.Control.ContextMenu property changes. (Inherited from System.Windows.Forms.Control)
Public EventContextMenuStripChangedOccurs when the value of the System.Windows.Forms.Control.ContextMenuStrip property changes. (Inherited from System.Windows.Forms.Control)
Public EventControlAddedOccurs when a new control is added to the System.Windows.Forms.Control.ControlCollection. (Inherited from System.Windows.Forms.Control)
Public EventControlRemovedOccurs when a control is removed from the System.Windows.Forms.Control.ControlCollection. (Inherited from System.Windows.Forms.Control)
Public EventCursorChangedOccurs when the value of the System.Windows.Forms.Control.Cursor property changes. (Inherited from System.Windows.Forms.Control)
Public EventDataColumnConfigureOccurs when the sheet is binding a column to a data source after it has been initialized.  
Public EventDialogCharOccurs during message preprocessing of dialog characters.  
Public EventDialogKeyOccurs during message preprocessing of dialog keys.  
Public EventDisposed (Inherited from System.ComponentModel.Component)
Public EventDockChangedOccurs when the value of the System.Windows.Forms.Control.Dock property changes. (Inherited from System.Windows.Forms.Control)
Public EventDoubleClickOccurs when the control is double-clicked. (Inherited from System.Windows.Forms.Control)
Public EventDragDropOccurs when a drag-and-drop operation is completed. (Inherited from System.Windows.Forms.Control)
Public EventDragDropBlockOccurs when the user drags and drops a range of cells.  
Public EventDragDropBlockCompletedOccurs at the completion of the user dragging and dropping a range of cells.  
Public EventDragEnterOccurs when an object is dragged into the control's bounds. (Inherited from System.Windows.Forms.Control)
Public EventDragFillBlockOccurs when the user drags to fill a range of cells.  
Public EventDragFillBlockCompletedOccurs at the completion of the user dragging to fill a range of cells.  
Public EventDragLeaveOccurs when an object is dragged out of the control's bounds. (Inherited from System.Windows.Forms.Control)
Public EventDragOverOccurs when an object is dragged over the control's bounds. (Inherited from System.Windows.Forms.Control)
Public EventEditChangeOccurs when the user changes the text in a cell in edit mode.  
Public EventEditErrorOccurs when the user performs an invalid input operation.  
Public EventEditModeOffOccurs when edit mode is stopped.  
Public EventEditModeOnOccurs when edit mode is started.  
Public EventEditModeStartingOccurs when edit mode is about to start in the active sheet's active cell.  
Public EventEditorFocusedOccurs when the editing control gets focus.  
Public EventEnabledChangedOccurs when the System.Windows.Forms.Control.Enabled property value has changed. (Inherited from System.Windows.Forms.Control)
Public EventEnterOccurs when the control is entered. (Inherited from System.Windows.Forms.Control)
Public EventEnterCellOccurs when the user enters a cell.  
Public EventErrorOccurs when the user performs an invalid operation.  
Public EventExpandOccurs when a row is expanded or collapsed.  
Public EventFontChangedOccurs when the System.Windows.Forms.Control.Font property value changes. (Inherited from System.Windows.Forms.Control)
Public EventGiveFeedbackOccurs during a drag operation. (Inherited from System.Windows.Forms.Control)
Public EventGotFocusOccurs when the control receives focus. (Inherited from System.Windows.Forms.Control)
Public EventGroupedOccurs when the grouping is finished.  
Public EventGroupingOccurs when the user performs grouping.  
Public EventHandleCreatedOccurs when a handle is created for the control. (Inherited from System.Windows.Forms.Control)
Public EventHandleDestroyedOccurs when the control's handle is in the process of being destroyed. (Inherited from System.Windows.Forms.Control)
Public EventHelpRequestedOccurs when the user requests help for a control. (Inherited from System.Windows.Forms.Control)
Public EventHyperLinkClickedOccurs when the user clicks on text of hyper link.  
Public EventImeModeChangedOccurs when the System.Windows.Forms.Control.ImeMode property has changed. (Inherited from System.Windows.Forms.Control)
Public EventInvalidatedOccurs when a control's display requires redrawing. (Inherited from System.Windows.Forms.Control)
Public EventKeyDownOccurs when a key is pressed while the control has focus. (Inherited from System.Windows.Forms.Control)
Public EventKeyPressOccurs when a key is pressed while the control has focus. (Inherited from System.Windows.Forms.Control)
Public EventKeyUpOccurs when a key is released while the control has focus. (Inherited from System.Windows.Forms.Control)
Public EventLayoutOccurs when a control should reposition its child controls. (Inherited from System.Windows.Forms.Control)
Public EventLeaveOccurs when the input focus leaves the control. (Inherited from System.Windows.Forms.Control)
Public EventLeaveCellOccurs when the user leaves a cell.  
Public EventLeftChangeOccurs when left column changes.  
Public EventLocationChangedOccurs when the System.Windows.Forms.Control.Location property value has changed. (Inherited from System.Windows.Forms.Control)
Public EventLostFocusOccurs when the control loses focus. (Inherited from System.Windows.Forms.Control)
Public EventMarginChangedOccurs when the control's margin changes. (Inherited from System.Windows.Forms.Control)
Public EventMouseCaptureChangedOccurs when the control loses mouse capture. (Inherited from System.Windows.Forms.Control)
Public EventMouseClickOccurs when the control is clicked by the mouse. (Inherited from System.Windows.Forms.Control)
Public EventMouseDoubleClickOccurs when the control is double clicked by the mouse. (Inherited from System.Windows.Forms.Control)
Public EventMouseDownOccurs when the mouse pointer is over the control and a mouse button is pressed. (Inherited from System.Windows.Forms.Control)
Public EventMouseEnterOccurs when the mouse pointer enters the control. (Inherited from System.Windows.Forms.Control)
Public EventMouseHoverOccurs when the mouse pointer rests on the control. (Inherited from System.Windows.Forms.Control)
Public EventMouseLeaveOccurs when the mouse pointer leaves the control. (Inherited from System.Windows.Forms.Control)
Public EventMouseMoveOccurs when the mouse pointer is moved over the control. (Inherited from System.Windows.Forms.Control)
Public EventMouseUpOccurs when the mouse pointer is over the control and a mouse button is released. (Inherited from System.Windows.Forms.Control)
Public EventMouseWheelOccurs when the mouse wheel moves while the control has focus. (Inherited from System.Windows.Forms.Control)
Public EventMoveOccurs when the control is moved. (Inherited from System.Windows.Forms.Control)
Public EventPaddingChangedOccurs when the control's padding changes. (Inherited from System.Windows.Forms.Control)
Public EventPaintOccurs when the control is redrawn. (Inherited from System.Windows.Forms.Control)
Public EventPaintGrayAreaOccurs when the gray area needs painting.  
Public EventPaintGroupBarBackgroundOccurs when the group bar background is painted.  
Public EventPaintTabStripOccurs when the TabStrip needs painting.  
Public EventPaintTabStripButtonOccurs when a TabStrip button needs painting.  
Public EventPaintTabStripTabOccurs when a TabStrip tab needs painting.  
Public EventParentChangedOccurs when the System.Windows.Forms.Control.Parent property value changes. (Inherited from System.Windows.Forms.Control)
Public EventPreviewKeyDownOccurs before the System.Windows.Forms.Control.KeyDown event when a key is pressed while focus is on this control. (Inherited from System.Windows.Forms.Control)
Public EventPreviewRowFetchOccurs when the user custom preview row of the Spread component.  
Public EventPrintAbortOccurs continually as printing occurs in order to give the user the opportunity to discontinue a print job.  
Public EventPrintBackgroundOccurs before each page is printed.  
Public EventPrintCancelledOccurs when a print job is discontinued by the user.  
Public EventPrintHeaderFooterAreaOccurs when header or footer needs printing.  
Public EventPrintMessageBoxOccurs before and after a print job.  
Public EventPrintPreviewShowingOccurs before preview dialog appears.  
Public EventQueryAccessibilityHelpOccurs when System.Windows.Forms.AccessibleObject is providing help to accessibility applications. (Inherited from System.Windows.Forms.Control)
Public EventQueryContinueDragOccurs during a drag-and-drop operation and enables the drag source to determine whether the drag-and-drop operation should be canceled. (Inherited from System.Windows.Forms.Control)
Public EventRangeGroupStateChangedOccurs when the user changed the state of some outline (range group) of rows or columns.  
Public EventRangeGroupStateChangingOccurs before user changes the state of some outline (range group) of rows or columns.  
Public EventRegionChangedOccurs when the value of the System.Windows.Forms.Control.Region property changes. (Inherited from System.Windows.Forms.Control)
Public EventResizeOccurs when the control is resized. (Inherited from System.Windows.Forms.Control)
Public EventRightToLeftChangedOccurs when the System.Windows.Forms.Control.RightToLeft property value changes. (Inherited from System.Windows.Forms.Control)
Public EventRowDragMoveOccurs when AllowRowMove is true and the user drags to move a row.  
Public EventRowDragMoveCompletedOccurs when the user finishes dragging to move a row.  
Public EventRowHeightChangedOccurs when the row height has changed.  
Public EventRowHeightChangingOccurs when the column width is changing.  
Public EventRowViewportHeightChangedOccurs when a viewport row height has changed.  
Public EventScrollTipFetchOccurs when the user scrolls the Spread component.  
Public EventSearchDialogClosingOccurs when the search form is closing.  
Public EventSelectionChangedOccurs when the selection of cells on the sheet is changed.  
Public EventSelectionChangingOccurs when the selection of cells on the sheet is changing.  
Public EventShapeActivatedOccurs when the user changes the active shape object.  
Public EventShapeDeactivatedOccurs when the user deactivates the active shape object.  
Public EventSheetTabClickOccurs when the user clicks the sheet tab.  
Public EventSheetTabDoubleClickOccurs when the user double clicks the sheet tab.  
Public EventSizeChangedOccurs when the System.Windows.Forms.Control.Size property value changes. (Inherited from System.Windows.Forms.Control)
Public EventStyleChangedOccurs when the control style changes. (Inherited from System.Windows.Forms.Control)
Public EventSubEditorClosedOccurs when a subeditor is closed for a cell.  
Public EventSubEditorOpeningOccurs when a subeditor is about to be displayed.  
Public EventSystemColorsChangedOccurs when the system colors change. (Inherited from System.Windows.Forms.Control)
Public EventTabIndexChangedOccurs when the System.Windows.Forms.Control.TabIndex property value changes. (Inherited from System.Windows.Forms.Control)
Public EventTabStopChangedOccurs when the System.Windows.Forms.Control.TabStop property value changes. (Inherited from System.Windows.Forms.Control)
Public EventTextChangedOccurs when the System.Windows.Forms.Control.Text property value changes. (Inherited from System.Windows.Forms.Control)
Public EventTextTipFetchOccurs when the pointer (cursor) is over a cell and the text tip or cell note should be displayed (the TextTip property is set to a value other than Off).  
Public EventTopChangeOccurs when the top row changes.  
Public EventUngroupedOccurs when all the grouping is removed.  
Public EventUserFormulaEnteredOccurs when the user types a formula.  
Public EventUserZoomingOccurs when the user zooms.  
Public EventValidatedOccurs when the control is finished validating. (Inherited from System.Windows.Forms.Control)
Public EventValidatingOccurs when the control is validating. (Inherited from System.Windows.Forms.Control)
Public EventVisibleChangedOccurs when the System.Windows.Forms.Control.Visible property value changes. (Inherited from System.Windows.Forms.Control)
Top

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.