Spread Windows Forms 17
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class
Properties Methods Events


In This Topic
    FpSpread Class Members
    In This Topic

    The following tables list the members exposed by FpSpread.

    Public Constructors
     NameDescription
    Public ConstructorFpSpread ConstructorOverloaded.   
    Top
    Public Properties
     NameDescription
    Public PropertyAboutGets the version information about the component.  
    Public PropertyAccessibilityObject (Inherited from System.Windows.Forms.Control)
    Public PropertyAccessibleDefaultActionDescription (Inherited from System.Windows.Forms.Control)
    Public PropertyAccessibleDescription (Inherited from System.Windows.Forms.Control)
    Public PropertyAccessibleName (Inherited from System.Windows.Forms.Control)
    Public PropertyAccessibleRole (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 PropertyActiveWindowlessObjectGets or sets the active windowless shape object of the component.  
    Public PropertyAllowCellContentFloatIndicates whether the content of a cell should float when the display rectangle of that cell changes.  
    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 PropertyAllowDrop (Inherited from System.Windows.Forms.Control)
    Public PropertyAllowEditorReservedLocationsGets or sets whether cell editor reserved mouse locations are allowed.  
    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 dragging and 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 PropertyAllowUserToTouchZoomGets or sets a value that indicates whether to allow the user to zoom FpSpread using touch behavior.  
    Public PropertyAllowUserZoomGets or sets whether the user can scale the display of the component using the Ctrl key and the mouse wheel.  
    Public PropertyAnchor (Inherited from System.Windows.Forms.Control)
    Public PropertyAutoAdvanceGets or sets whether the user can move to another control from the first or last cell using Shift+Tab or the Tab key.  
    Public PropertyAutoClipboardGets or sets whether the component handles the shortcut keys for Clipboard actions.  
    Public PropertyAutoFitColumnOptionsGets or sets the behavior of automatic fit when double-clicking the right edge of the column header.  
    Public PropertyAutoFitRowOptionsGets or sets the behavior of automatic fit when double-clicking the bottom edge of the row header.  
    Public PropertyAutoImeModeGets or sets whether to use the CharacterSet property in a cell that is not in edit mode.  
    Public PropertyAutoLaunchSpreadDesignerGets or sets whether Spread Designer automatically launches when a Spread component is placed on a form.  
    Public PropertyAutoScrollOffset (Inherited from System.Windows.Forms.Control)
    Public PropertyAutoScrollWhenKeyboardShowingGets or sets the automatic scroll when the keyboard is displayed.  
    Public PropertyBackColor (Inherited from System.Windows.Forms.Control)
    Public PropertyBackgroundImageOverridden. Gets or sets the image to paint in the background of the component.  
    Public PropertyBackgroundImageLayout (Inherited from System.Windows.Forms.Control)
    Public PropertyBindingContext (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 PropertyBottom (Inherited from System.Windows.Forms.Control)
    Public PropertyBoundaryFeedbackModeGets or sets the way FpSpread reacts when the manipulation has gone beyond certain boundaries.  
    Public PropertyBounds (Inherited from System.Windows.Forms.Control)
    Public PropertyButtonDrawModeGets or sets whether to display buttons in button and combo box cells in the component.  
    Public PropertyCanFocus (Inherited from System.Windows.Forms.Control)
    Public PropertyCanSelect (Inherited from System.Windows.Forms.Control)
    Public PropertyCapture (Inherited from System.Windows.Forms.Control)
    Public PropertyCausesValidation (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 PropertyCellSpanSelectionPolicyGets or sets the selection model to use with the span.  
    Public PropertyClientRectangle (Inherited from System.Windows.Forms.Control)
    Public PropertyClientSize (Inherited from System.Windows.Forms.Control)
    Public PropertyClipboardOptionsGets or sets whether the headers and the filter bar 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 PropertyCompanyName (Inherited from System.Windows.Forms.Control)
    Public PropertyContainer (Inherited from System.ComponentModel.Component)
    Public PropertyContainsFocus (Inherited from System.Windows.Forms.Control)
    Public PropertyContextMenu (Inherited from System.Windows.Forms.Control)
    Public PropertyContextMenuStripOverridden. Gets or sets the ContextMenuStrip associated with this control.  
    Public PropertyControls (Inherited from System.Windows.Forms.Control)
    Public PropertyCreated (Inherited from System.Windows.Forms.Control)
    Public PropertyCursorOverridden. Gets or sets the pointer to display in this component.  
    Public PropertyCustomFillSeriesListGets the custom list fill series.  
    Public PropertyCustomIconContainerGets the CustomIconContainer object for the current spread object.  
    Public PropertyDataBindings (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 PropertyDefaultSkinGets, or Sets the default Skin that will be used for painting.  
    Public PropertyDeviceDpi (Inherited from System.Windows.Forms.Control)
    Public PropertyDisplayRectangle (Inherited from System.Windows.Forms.Control)
    Public PropertyDisposing (Inherited from System.Windows.Forms.Control)
    Public PropertyDock (Inherited from System.Windows.Forms.Control)
    Public PropertyDocumentPropertiesGets or sets the DocumentProperties object that represents all properties of the Spread document.  
    Public PropertyDragFillDataOnlyGets or sets a value that indicates whether the drag fill action copies data only.  
    Public PropertyEditingControlGets the Control object editing the active cell, or null if the component is not in edit mode.  
    Public PropertyEditingControl2Gets the editing control, or null if the spreadsheet is not in editing mode.  
    Public PropertyEditModeGets or sets whether the active cell in the component is in edit mode.  
    Public PropertyEditMode2Gets or sets whether the spread 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 PropertyEnabled (Inherited from System.Windows.Forms.Control)
    Public PropertyEnableDragFillMenuGets or sets a value to show drag fill button and drag fill context menu.  
    Public PropertyEnhancedShapeBehaviorsGets or sets the optional behaviors of the enhanced shape engine.  
    Public PropertyFeaturesGets an IFeatures object that toggles avalable features of FpSpread.  
    Public PropertyFocused (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 PropertyHandle (Inherited from System.Windows.Forms.Control)
    Public PropertyHasChildren (Inherited from System.Windows.Forms.Control)
    Public PropertyHeaderIndicatorPositionAdjustingGets or sets the distance between the sorting and filtering indicators and the right edge of the column.  
    Public PropertyHeight (Inherited from System.Windows.Forms.Control)
    Public PropertyHorizontalScrollBarGets the horizontal scroll bar.  
    Public PropertyHorizontalScrollBarHeightGets or sets the height of horizontal scroll bars in this component.  
    Public PropertyHorizontalScrollBarModeGets or Sets horizontal scroll bar mode.  
    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.  
    Public PropertyImeSentenceModeGets or sets IME sentence mode.  
    Public PropertyInputDeviceTypeGets the input device type which indicates the current device.  
    Public PropertyInputScopeGets or sets the input scope for the Spread.  
    Public PropertyInterfaceRendererGets or sets the tab strip renderer for drawing tab strip elements.  
    Public PropertyInvokeRequired (Inherited from System.Windows.Forms.Control)
    Public PropertyIsAccessible (Inherited from System.Windows.Forms.Control)
    Public PropertyIsDisposed (Inherited from System.Windows.Forms.Control)
    Public PropertyIsHandleCreated (Inherited from System.Windows.Forms.Control)
    Public PropertyIsLayoutSuspendedReturns whether the layout is suspended in this component.  
    Public PropertyIsMirrored (Inherited from System.Windows.Forms.Control)
    Public PropertyIsProtectedStructureSpecifies whether Spread allows the user to change the structure of the sheet collection.  
    Public PropertyLayoutEngine (Inherited from System.Windows.Forms.Control)
    Public PropertyLeft (Inherited from System.Windows.Forms.Control)
    Public PropertyLeftTabGets or sets the leftmost sheet tab of the component.  
    Public PropertyLocation (Inherited from System.Windows.Forms.Control)
    Public PropertyMargin (Inherited from System.Windows.Forms.Control)
    Public PropertyMaximumSize (Inherited from System.Windows.Forms.Control)
    Public PropertyMessageBoxCaptionGets or sets the text which is used to display caption of message box.  
    Public PropertyMinimumSize (Inherited from System.Windows.Forms.Control)
    Public PropertyMinZoomFactorGets or sets a value that indicates the minimum zoom factor for the active SheetView.  
    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 PropertyName (Inherited from System.Windows.Forms.Control)
    Public PropertyNamedStylesGets or sets a pre-defined style (NamedStyleCollection object).  
    Public PropertyPadding (Inherited from System.Windows.Forms.Control)
    Public PropertyPaintActiveCellInSelectionGets or sets whether the active cell is painted in the selection.  
    Public PropertyPaintSelectionBorderGets or sets a value that indicates whether to allow the border selection to paint.  
    Public PropertyPaintSelectionHeaderGets or sets whether to allow the header selection to paint.  
    Public PropertyPanningModeGets or sets the way FpSpread reacts to touch manipulation.  
    Public PropertyParent (Inherited from System.Windows.Forms.Control)
    Public PropertyPreferredSize (Inherited from System.Windows.Forms.Control)
    Public PropertyProductName (Inherited from System.Windows.Forms.Control)
    Public PropertyProductVersion (Inherited from System.Windows.Forms.Control)
    Public PropertyRangeDragFillModeGets or sets the mode the user can use to drag and fill cells in the component using the contents of a cell or cells.  
    Public PropertyRecreatingHandle (Inherited from System.Windows.Forms.Control)
    Public PropertyRegion (Inherited from System.Windows.Forms.Control)
    Public PropertyResizeZeroIndicatorGets or sets the way FpSpread processes resizing for zero-height rows and zero-width columns.  
    Public PropertyRetainSelectionBlockGets or sets whether the selected range of cells remains highlighted when the component loses the focus.  
    Public PropertyRight (Inherited from System.Windows.Forms.Control)
    Public PropertyRightToLeft (Inherited from System.Windows.Forms.Control)
    Public PropertyRowHeaderAutoWidthMaxGets or sets the maximum auto-width of the row header.  
    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 PropertySaveNamedStylesSaves the collection of custom styles.  
    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 PropertyShowCellErrorsGets or sets whether to allow the user to display row error by icon in the component.  
    Public PropertyShowDragBandOnMovingGets or sets whether the drag band is displayed when moving the row or column.  
    Public PropertyShowGrippersInEditingStatusGets or sets whether tapping displays the gripper in edit mode.  
    Public PropertyShowOutlineGets or sets whether to show the outline (group) area.  
    Public PropertyShowRowErrorsGets or sets whether to allow the user to display the cell error using an icon or sticky note in the component.  
    Public PropertySite (Inherited from System.Windows.Forms.Control)
    Public PropertySize (Inherited from System.Windows.Forms.Control)
    Public PropertySkinGets or sets the skin for the spread.  
    Public PropertySkipMouseProcessingSets the mouse processing flag of the component.  
    Public PropertySpreadScaleModeGets or sets whether Spread controls automatic scaling with a different system dpi, Spread only supports one dimension so the application should use AutoScaleMode.Dpi for correct scaling, or else scaling uses the application width.  
    Public PropertyStatusBarGets the status bar control of spread.  
    Public PropertyStatusBarVisibleGets or sets whether the status bar is enabled.  
    Public PropertySuspendAnimationsGets or sets whether to suspend animations such as an animated focus renderer.  
    Public PropertyTabIndex (Inherited from System.Windows.Forms.Control)
    Public PropertyTableStyleCollectionGets a table style collection.  
    Public PropertyTabStop (Inherited from System.Windows.Forms.Control)
    Public PropertyTabStripGets the object that represents 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 PropertyTapToAddSelectionGets or sets whether to tap to add selection.  
    Public PropertyTextOverridden. Not supported in 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 Spread.  
    Public PropertyTop (Inherited from System.Windows.Forms.Control)
    Public PropertyTopLevelControl (Inherited from System.Windows.Forms.Control)
    Public PropertyTouchDropDownScaleGets or sets the TouchDropDownScale to specify the zoom scale value that applies to a cell type drop-down item.  
    Public PropertyTouchSelectionGripperBackColorGets or sets the touch selection gripper's backcolor.  
    Public PropertyTouchSelectionGripperLineColorGets or sets the touch selection gripper's line color.  
    Public PropertyTouchSelectionGripperThicknessGets or sets the touch selection gripper's thickness.  
    Public PropertyTouchZoomSnapDistanceGets or sets a value that indicates the minmum distance that can cause the current zoom factor to snap to a zoom factor in TouchZoomSnapPoints.  
    Public PropertyTouchZoomSnapPointsGets a zoom factor group and when the zoom ends, the final zoom factor snaps to a snap point in this group.  
    Public PropertyUndoManagerGets or sets the undo manager for this Spread component.  
    Public PropertyUseOptimizedSelectionForTouchGets or sets whether to use optimized selection for touch.  
    Public PropertyUseWaitCursor (Inherited from System.Windows.Forms.Control)
    Public PropertyVerticalScrollBarGets the vertical scroll bar.  
    Public PropertyVerticalScrollBarModeGets or Sets vertical scroll bar mode.  
    Public PropertyVerticalScrollBarPolicyGets or sets when to display the vertical scroll bars in this component.  
    Public PropertyVerticalScrollBarSmallChangeGets or sets the small increment for the vertical scrollbar.  
    Public PropertyVerticalScrollBarWidthGets or sets the width of vertical scroll bars in this component.  
    Public PropertyVisible (Inherited from System.Windows.Forms.Control)
    Public PropertyVisualStylesGets or sets whether to use visual styles when rendering objects in the component.  
    Public PropertyWidth (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 PropertyCanEnableIme (Inherited from System.Windows.Forms.Control)
    Protected PropertyCanRaiseEvents (Inherited from System.Windows.Forms.Control)
    Protected PropertyCreateParamsOverridden. Gets the required creation parameters when the component handle is created.  
    Protected PropertyDefaultCursor (Inherited from System.Windows.Forms.Control)
    Protected PropertyDefaultImeMode (Inherited from System.Windows.Forms.Control)
    Protected PropertyDefaultMargin (Inherited from System.Windows.Forms.Control)
    Protected PropertyDefaultMaximumSize (Inherited from System.Windows.Forms.Control)
    Protected PropertyDefaultMinimumSize (Inherited from System.Windows.Forms.Control)
    Protected PropertyDefaultPadding (Inherited from System.Windows.Forms.Control)
    Protected PropertyDefaultSizeOverridden. Gets the default size of the component.  
    Protected PropertyDoubleBuffered (Inherited from System.Windows.Forms.Control)
    Protected PropertyEvents (Inherited from System.ComponentModel.Component)
    Protected PropertyFontHeight (Inherited from System.Windows.Forms.Control)
    Protected PropertyImeModeBaseOverridden. Gets or sets IME mode base.  
    Protected PropertyResizeRedraw (Inherited from System.Windows.Forms.Control)
    Protected PropertyScaleChildrenOverridden. Internal use only.  
    Top
    Public Methods
     NameDescription
    Public MethodAddControlOverloaded. Adds a child control to a specified sheet at the location of the specified row and column.  
    Public MethodAddCustomFunctionAdds a user-defined custom function (GrapeCity.CalcEngine.Function object) to the model for use in formulas.  
    Public MethodAddNewSheetViewCreates a new SheetView and inserts or replaces the sheet at the specified sheet index.  
    Public MethodAddViewportOverloaded. Adds a row or column of viewports.  
    Public MethodAsWorkbookGets the coressponding GrapeCity.Spreadsheet.IWorkbook object that allows accessing to new object model and API set.  
    Public MethodAttachAttachs a FarPoint.Win.Spread.FpSpread.Workbook object to the spread control.  
    Public MethodBeginInvokeOverloaded.  (Inherited from System.Windows.Forms.Control)
    Public MethodBringToFront (Inherited from System.Windows.Forms.Control)
    Public MethodCancelAnnotationModeCancels annotation mode.  
    Public MethodCancelCellEditingCancels cell editing.  
    Public MethodClearCustomFunctionsClears all custom functions.  
    Public MethodContains (Inherited from System.Windows.Forms.Control)
    Public MethodCreateControl (Inherited from System.Windows.Forms.Control)
    Public MethodCreateGraphics (Inherited from System.Windows.Forms.Control)
    Public MethodCreateObjRef (Inherited from System.MarshalByRefObject)
    Public MethodCreateTableStyleCreates a table style based on the table style contained in the table style collection or a built-in table style.  
    Public MethodDisposeOverloaded. Overridden. Cleans up any resources being used.  
    Public MethodDoDragDrop (Inherited from System.Windows.Forms.Control)
    Public MethodDrawToBitmap (Inherited from System.Windows.Forms.Control)
    Public MethodEndInvoke (Inherited from System.Windows.Forms.Control)
    Public MethodFindForm (Inherited from System.Windows.Forms.Control)
    Public MethodFocus (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.  (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 range group.  
    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 MethodGetContainerControl (Inherited from System.Windows.Forms.Control)
    Public MethodGetCursorGets the pointer displayed over different areas of the component.  
    Public MethodGetCustomFunctionGets a user-defined custom function from the workbook.  
    Public MethodGetCustomFunctionEnumeratorGets an IEnumerable<GrapeCity.CalcEngine.Function> that enumerates through the names of the custom functions in the workbook.  
    Public Methodstatic (Shared in Visual Basic)GetExcelSheetNamesOverloaded. Gets an array of sheet names from the specified Excel stream.  
    Public MethodGetFilterBarHeaderRectangleGets the rectangle of the column header.  
    Public MethodGetFilterBarRectangleGets the rectangle of the filter bar.  
    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 MethodGetLifetimeService (Inherited from System.MarshalByRefObject)
    Public MethodGetMaximumCellOverflowWidthGets the maximum cell overflow width in pixels.  
    Public MethodGetNextControl (Inherited from System.Windows.Forms.Control)
    Public MethodGetOwnerPrintColumnPageBreaksOverloaded. Gets the column page breaks for the specified sheet under the current printing conditions.  
    Public MethodGetOwnerPrintInfoGets the printing information required to print a given sheet into the supplied rectangle.  
    Public MethodGetOwnerPrintPageCountGets the number of pages required to print a given sheet into the supplied rectangle.  
    Public MethodGetOwnerPrintRowPageBreaksOverloaded. Gets the row page breaks for the specified sheet under the current printing conditions.  
    Public MethodGetPreferredSize (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 range group.  
    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 row after the last row of the specified viewport 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 column after the rightmost column of the specified viewport 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 MethodHide (Inherited from System.Windows.Forms.Control)
    Public MethodHideDependentsOverloaded. Hides the dependents.  
    Public MethodHideDragFillPopupHide drag fill context menu.  
    Public MethodHidePrecedentsOverloaded. Hides the precedents.  
    Public MethodHideTouchKeyboardHides the touch keyboard.  
    Public MethodHitTestPerforms a hit test.  
    Public MethodInitializeLifetimeService (Inherited from System.MarshalByRefObject)
    Public MethodInvalidateOverloaded.  (Inherited from System.Windows.Forms.Control)
    Public MethodInvokeOverloaded.  (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 that contains 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 MethodLoadXmlInputMapFileOverloaded. Loads the XML input map file using the specified operation mode.  
    Public MethodLoadXmlInputMapFileWhenChildHasFocusOverloaded. Loads the XML input map file when the child has the focus.  
    Public MethodLoadXmlInputMapFileWhenShapeHasFocusOverloaded. Loads the XML input map file when the shape has the focus.  
    Public MethodLogicalToDeviceUnitsOverloaded.  (Inherited from System.Windows.Forms.Control)
    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 MethodOwnerPrintDrawOverloaded. Prints the specified page of the specified sheet to a specified graphics interface with the specified size.  
    Public MethodPerformLayoutOverloaded. Forces the component to apply layout logic to its child controls.  
    Public MethodPointToClient (Inherited from System.Windows.Forms.Control)
    Public MethodPointToScreen (Inherited from System.Windows.Forms.Control)
    Public MethodPreProcessControlMessage (Inherited from System.Windows.Forms.Control)
    Public MethodPreProcessMessageOverridden.   
    Public MethodPrintSheetOverloaded. Handles the printing of the specified sheet in a separate thread.  
    Public MethodRectangleToClient (Inherited from System.Windows.Forms.Control)
    Public MethodRectangleToScreen (Inherited from System.Windows.Forms.Control)
    Public MethodRefresh (Inherited from System.Windows.Forms.Control)
    Public MethodRemoveControlRemoves a child control from the specified sheet.  
    Public MethodRemoveCustomFunctionRemoves a user-defined custom function.  
    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 MethodResetText (Inherited from System.Windows.Forms.Control)
    Public MethodResumeLayoutOverloaded. Resumes normal layout logic.  
    Public MethodSaveOverloaded. Saves the content of the Spread component to the specified file.  
    Public MethodSaveExcelOverloaded. Saves the content of the Spread component to the specified stream.  
    Public MethodSaveXmlInputMapFileOverloaded. Saves the XML input map file.  
    Public MethodSaveXmlInputMapFileWhenChildHasFocusOverloaded. Saves the XML input map file when child has focus.  
    Public MethodSaveXmlInputMapFileWhenShapeHasFocusOverloaded. Saves the XML input map file when shape has focus.  
    Public MethodScale (Inherited from System.Windows.Forms.Control)
    Public MethodScaleBitmapLogicalToDevice (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 MethodSelectOverloaded. Overridden. Selects the Spread component.  
    Public MethodSelectNextControl (Inherited from System.Windows.Forms.Control)
    Public MethodSendToBack (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.  (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 MethodSetProtectChanges the protect structure setting with the password parameter.  
    Public MethodSetToolTipOverloaded. Sets the custom content text to the specified tooltip.  
    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 MethodShouldSerializeGroupBarTextIndicates whether the GroupBarText property should be persisted.  
    Public MethodShow (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 MethodShowCellValidatorsFormShows the form that is used to edit Cell Validators of selected range  
    Public MethodShowCollectionEditorShows the collection editor.  
    Public MethodShowColumnMoves a column of cells in the specified viewport to the specified position in the component.  
    Public MethodShowDataValidationFormShows the form that is used to edit DataValidation of selected range  
    Public MethodShowDependentsShows the dependent cells for a formula cell.  
    Public MethodShowEditFormDisplays the form used for editing custom names.  
    Public MethodShowInputMapEditorDisplays the input map editor.  
    Public MethodShowListCustomNameFormDisplays the form that contains a list of custom names.  
    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 MethodShowShapeDisplays the shape fully inside the viewport.  
    Public MethodShowTouchKeyboardDisplays the touch keyboard.  
    Public MethodStartAnnotationModeOverloaded. Starts annotation mode.  
    Public MethodStartCellEditingStarts cell editing.  
    Public MethodStartCroppingStarts cropping a specified picture.  
    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 MethodTriggerVolatileCellsThis function will notify all cells, which contains volatile functions or belong to a circuit, to recalculate.  
    Public MethodUpdate (Inherited from System.Windows.Forms.Control)
    Top
    Protected Methods
     NameDescription
    Protected MethodCreateAccessibilityInstanceOverridden. Creates a new accessibility object for the control.  
    Protected MethodCreateControlsInstance (Inherited from System.Windows.Forms.Control)
    Protected MethodCreateHandle (Inherited from System.Windows.Forms.Control)
    Protected MethodDefWndProc (Inherited from System.Windows.Forms.Control)
    Protected MethodDestroyHandle (Inherited from System.Windows.Forms.Control)
    Protected MethodFinalizeOverridden. The destructor method  
    Protected MethodGetAccessibilityObjectById (Inherited from System.Windows.Forms.Control)
    Protected MethodGetAutoSizeMode (Inherited from System.Windows.Forms.Control)
    Protected MethodGetScaledBounds (Inherited from System.Windows.Forms.Control)
    Protected MethodGetService (Inherited from System.ComponentModel.Component)
    Protected MethodGetStyle (Inherited from System.Windows.Forms.Control)
    Protected MethodGetTopLevel (Inherited from System.Windows.Forms.Control)
    Protected MethodInitLayout (Inherited from System.Windows.Forms.Control)
    Protected MethodInvokeGotFocus (Inherited from System.Windows.Forms.Control)
    Protected MethodInvokeLostFocus (Inherited from System.Windows.Forms.Control)
    Protected MethodInvokeOnClick (Inherited from System.Windows.Forms.Control)
    Protected MethodInvokePaint (Inherited from System.Windows.Forms.Control)
    Protected MethodInvokePaintBackground (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.  (Inherited from System.MarshalByRefObject)
    Protected MethodNotifyInvalidate (Inherited from System.Windows.Forms.Control)
    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 MethodOnAllowUserToTouchZoomChangedRaises the AllowUserToZoomChanged event.  
    Protected MethodOnAnnotationModeEndingRaises the AnnotationModeEnding event.  
    Protected MethodOnAnnotationModeStartingRaises the AnnotationModeStarting event.  
    Protected MethodOnAutoFilteredColumnRaises the AutoFilteredColumn event.  
    Protected MethodOnAutoFilteringColumnRaises the AutoFilteringColumn event.  
    Protected MethodOnAutoScrollWhenKeyboardShowingChangedRaises the AutoScrollWhenKeyboardShowingChanged event.  
    Protected MethodOnAutoSizeChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnAutoSortedColumnRaises the AutoSortedColumn event.  
    Protected MethodOnAutoSortingColumnRaises the AutoSortingColumn event.  
    Protected MethodOnBackColorChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnBackgroundImageChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnBackgroundImageLayoutChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnBindingContextChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnBoundaryFeedbackModeChangedRaises the BoundaryFeedbackModeChanged event.  
    Protected MethodOnButtonClickedRaises the ButtonClicked event.  
    Protected MethodOnCausesValidationChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnCellClickRaises the CellClick event.  
    Protected MethodOnCellDoubleClickRaises the CellDoubleClick event.  
    Protected MethodOnChangeRaises the Change event.  
    Protected MethodOnChangeUICues (Inherited from System.Windows.Forms.Control)
    Protected MethodOnChildControlActivatedRaises the ChildControlActivated event.  
    Protected MethodOnChildControlDeactivatedRaises the ChildControlDeactivated event.  
    Protected MethodOnChildViewCreatedRaises the ChildViewCreated event.  
    Protected MethodOnChildWorkbookCreatedRaises the ChildWorkbookCreated event.  
    Protected MethodOnCircularFormulaFpSpreadRaises the CircularFormulaFpSpread event.  
    Protected MethodOnClick (Inherited from System.Windows.Forms.Control)
    Protected MethodOnClientSizeChangedOverridden. Overrides 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 MethodOnColumnDragMoveCompletingRaises the ColumnDragMoveCompleting 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 MethodOnContextMenuChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnContextMenuStripChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnControlAdded (Inherited from System.Windows.Forms.Control)
    Protected MethodOnControlRemoved (Inherited from System.Windows.Forms.Control)
    Protected MethodOnCreateControl (Inherited from System.Windows.Forms.Control)
    Protected MethodOnCursorChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnDataColumnConfigureRaises the DataColumnConfigure event.  
    Protected MethodOnDialogCharRaises the DialogChar event.  
    Protected MethodOnDialogKeyRaises the DialogKey event.  
    Protected MethodOnDockChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnDoubleClickOverridden. Raises the DoubleClick event.  
    Protected MethodOnDpiChangedAfterParent (Inherited from System.Windows.Forms.Control)
    Protected MethodOnDpiChangedBeforeParent (Inherited from System.Windows.Forms.Control)
    Protected MethodOnDragDrop (Inherited from System.Windows.Forms.Control)
    Protected MethodOnDragDropBlockRaises the DragDropBlock event.  
    Protected MethodOnDragDropBlockCompletedRaises the DragDropBlockCompleted event.  
    Protected MethodOnDragEnter (Inherited from System.Windows.Forms.Control)
    Protected MethodOnDragFillBlockRaises the DragFillBlock event.  
    Protected MethodOnDragFillBlockCompletedRaises the DragFillBlockCompleted event.  
    Protected MethodOnDragLeave (Inherited from System.Windows.Forms.Control)
    Protected MethodOnDragOver (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 MethodOnEnter (Inherited from System.Windows.Forms.Control)
    Protected MethodOnEnterCellRaises the EnterCell event.  
    Protected MethodOnErrorRaises the Error event.  
    Protected MethodOnExpandRaises the Expand event.  
    Protected MethodOnFilterBarClickRaises the FilterBarClick event.  
    Protected MethodOnFilterBarDoubleClickRaises the FilterBarDoubleClick event.  
    Protected MethodOnFontChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnForeColorChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnGiveFeedback (Inherited from System.Windows.Forms.Control)
    Protected MethodOnGotFocusOverridden. Raises the GotFocus event.  
    Protected MethodOnGroupedRaises the Grouped event.  
    Protected MethodOnGroupingRaises the Grouping event.  
    Protected MethodOnHandleCreatedOverridden. Occurs when the handle is created.  
    Protected MethodOnHandleDestroyedOverridden. Raises the HandleDestroyed event.  
    Protected MethodOnHeaderIndicatorPositionAdjustingChangedRaises the HeaderIndicatorPositionAdjustingChanged event.  
    Protected MethodOnHelpRequestedOverridden. Occurs when help is requested.  
    Protected MethodOnHyperLinkClickedRaises the HyperLinkClicked event.  
    Protected MethodOnImeModeChangedOverridden. Occurs when IME mode is changed.  
    Protected MethodOnInputScopeChangedRaises the InputScopeChanged event.  
    Protected MethodOnInvalidated (Inherited from System.Windows.Forms.Control)
    Protected MethodOnKeyDownOverridden. Processes KeyDown events.  
    Protected MethodOnKeyPressOverridden. Processes KeyPress events.  
    Protected MethodOnKeyUpOverridden. Processes KeyUp events.  
    Protected MethodOnLayout (Inherited from System.Windows.Forms.Control)
    Protected MethodOnLeave (Inherited from System.Windows.Forms.Control)
    Protected MethodOnLeaveCellRaises the LeaveCell event.  
    Protected MethodOnLeftChangeRaises the LeftChange event. Internal use only.  
    Protected MethodOnLocationChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnLostFocusOverridden. Raises the LostFocus event.  
    Protected MethodOnMarginChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnMouseCaptureChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnMouseClick (Inherited from System.Windows.Forms.Control)
    Protected MethodOnMouseDoubleClick (Inherited from System.Windows.Forms.Control)
    Protected MethodOnMouseDownOverridden. Raises the MouseDown event.  
    Protected MethodOnMouseEnterOverridden. Raises the MouseEnter event.  
    Protected MethodOnMouseHover (Inherited from System.Windows.Forms.Control)
    Protected MethodOnMouseLeaveOverridden. Raises the MouseLeave event.  
    Protected MethodOnMouseMoveOverridden. Raises the MouseMove event.  
    Protected MethodOnMouseUpOverridden. Raises the MouseUp event.  
    Protected MethodOnMouseWheelOverridden. Raises the MouseWheel event.  
    Protected MethodOnMove (Inherited from System.Windows.Forms.Control)
    Protected MethodOnNotifyMessage (Inherited from System.Windows.Forms.Control)
    Protected MethodOnPaddingChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnPaintOverridden. Raises the Paint event.  
    Protected MethodOnPaintBackgroundOverridden. Paints the background of the component.  
    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 MethodOnPanningModeChangedRaises the PanningModeChanged event.  
    Protected MethodOnParentBackColorChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnParentBackgroundImageChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnParentBindingContextChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnParentChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnParentCursorChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnParentEnabledChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnParentFontChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnParentForeColorChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnParentRightToLeftChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnParentVisibleChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnPreviewKeyDownOverridden. Processes PreviewKeyDown event.  
    Protected MethodOnPreviewRowFetchRaises the PreviewRowFetch event.  
    Protected MethodOnPrint (Inherited from System.Windows.Forms.Control)
    Protected MethodOnPrintAbortRaises the PrintAbort event.  
    Protected MethodOnPrintBackgroundRaises the PrintBackground event.  
    Protected MethodOnPrintCancelledRaises the PrintCancelled event.  
    Protected MethodOnPrintDocumentRaises the PrintDocument event.  
    Protected MethodOnPrintHeaderFooterAreaRaises the PrintHeaderFooterArea event.  
    Protected MethodOnPrintMessageBoxRaises the PrintMessageBox event.  
    Protected MethodOnPrintPreviewShowingRaises the PrintPreviewShowing event.  
    Protected MethodOnQueryContinueDrag (Inherited from System.Windows.Forms.Control)
    Protected MethodOnRangeGroupStateChangedRaises the RangeGroupStateChanged event.  
    Protected MethodOnRangeGroupStateChangingRaises the RangeGroupStateChanging event.  
    Protected MethodOnRegionChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnResizeOverridden. Raises the Resize event.  
    Protected MethodOnResizeZeroIndicatorChangedRaises the ResizeZeroIndicatorChanged event.  
    Protected MethodOnRightToLeftChangedOverridden. Raises the RightToLeftChanged event.  
    Protected MethodOnRowDragMoveRaises the RowDragMove event.  
    Protected MethodOnRowDragMoveCompletedRaises the RowDragMoveCompleted event.  
    Protected MethodOnRowDragMoveCompletingRaises the RowDragMoveCompleting 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 MethodOnSheetDragMovedRaises the SheetDragMoved event.  
    Protected MethodOnSheetDragMovingRaises the SheetDragMoving event.  
    Protected MethodOnSheetTabClickRaises the SheetTabClick event.  
    Protected MethodOnSheetTabDoubleClickRaises the SheetTabDoubleClick event.  
    Protected MethodOnShowGrippersInEditingStatusChangedRaises the ShowGrippersInEditingStatusChanged event.  
    Protected MethodOnSizeChangedOverridden. Raises the System.Windows.Forms.Control.SizeChanged event.  
    Protected MethodOnSortedRaises the Sorted event.  
    Protected MethodOnSortingRaises the Sorting event.  
    Protected MethodOnStyleChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnSubEditorClosedRaises the SubEditorClosed event.  
    Protected MethodOnSubEditorOpeningRaises the SubEditorOpening event.  
    Protected MethodOnSystemColorsChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnTabIndexChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnTabStopChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnTapToAddSelectionChangedRaises the TapToAddSelectionChanged event.  
    Protected MethodOnTextChanged (Inherited from System.Windows.Forms.Control)
    Protected MethodOnTextTipFetchRaises the TextTipFetch event.  
    Protected MethodOnTopChangeRaises the TopChange event. Internal use only.  
    Protected MethodOnTouchDropDownScaleChangedRaises the TouchDropDownScaleChanged event.  
    Protected MethodOnTouchSelectionGripperBackColorChangedRaises the TouchSelectionGripperBackColorChanged event.  
    Protected MethodOnTouchSelectionGripperLineColorChangedRaises the TouchSelectionGripperLineColorChanged event.  
    Protected MethodOnTouchSelectionGripperThicknessChangedRaises the TouchSelectionGripperThicknessChanged event.  
    Protected MethodOnTouchStripOpeningRaises the TouchStripOpening event.  
    Protected MethodOnTouchZoomSnapDistanceChangedRaises the TouchZoomSnapDistanceChanged event.  
    Protected MethodOnUngroupedRaises the Grouped event.  
    Protected MethodOnUseOptimizedSelectionForTouchChangedRaises the UseOptimizedSelectionForTouchChanged event.  
    Protected MethodOnUserFormulaEnteredRaises the UserFormulaEntered event.  
    Protected MethodOnUserZoomingRaises the UserZooming event.  
    Protected MethodOnValidated (Inherited from System.Windows.Forms.Control)
    Protected MethodOnValidatingOverridden. Raises the Validating event.  
    Protected MethodOnVisibleChangedOverridden. Raises the VisibleChanged event.  
    Protected MethodProcessCmdKeyOverridden. Processes a command key.  
    Protected MethodProcessDialogCharOverridden. Processes the specified dialog character by the component.  
    Protected MethodProcessDialogKeyOverridden. Processes the specified dialog key by the component.  
    Protected MethodProcessKeyEventArgs (Inherited from System.Windows.Forms.Control)
    Protected MethodProcessKeyPreviewOverridden. Processes a key by the component by previewing the specified keyboard message.  
    Protected MethodRaiseDragEvent (Inherited from System.Windows.Forms.Control)
    Protected MethodRaiseKeyEvent (Inherited from System.Windows.Forms.Control)
    Protected MethodRaiseMouseEvent (Inherited from System.Windows.Forms.Control)
    Protected MethodRaisePaintEvent (Inherited from System.Windows.Forms.Control)
    Protected MethodRecreateHandle (Inherited from System.Windows.Forms.Control)
    Protected MethodRescaleConstantsForDpi (Inherited from System.Windows.Forms.Control)
    Protected MethodResetMouseEventArgs (Inherited from System.Windows.Forms.Control)
    Protected MethodRtlTranslateAlignmentOverloaded.  (Inherited from System.Windows.Forms.Control)
    Protected MethodRtlTranslateHorizontal (Inherited from System.Windows.Forms.Control)
    Protected MethodRtlTranslateLeftRight (Inherited from System.Windows.Forms.Control)
    Protected MethodScaleControlOverridden.   
    Protected MethodSetAutoSizeMode (Inherited from System.Windows.Forms.Control)
    Protected MethodSetBoundsCore (Inherited from System.Windows.Forms.Control)
    Protected MethodSetClientSizeCore (Inherited from System.Windows.Forms.Control)
    Protected MethodSetStyle (Inherited from System.Windows.Forms.Control)
    Protected MethodSetTopLevel (Inherited from System.Windows.Forms.Control)
    Protected MethodSetVisibleCore (Inherited from System.Windows.Forms.Control)
    Protected MethodShouldSerializeNamedStylesDetermines whether the named styles are serialized.  
    Protected MethodShouldSerializeSaveNamedStylesGets whether to serialize the custom styles.  
    Protected MethodSizeFromClientSize (Inherited from System.Windows.Forms.Control)
    Protected MethodUpdateStyles (Inherited from System.Windows.Forms.Control)
    Protected MethodUpdateZOrder (Inherited from System.Windows.Forms.Control)
    Protected MethodWndProcOverridden. Internal use only.  
    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 the first or last row in Spread.  
    Public EventAllowUserToTouchZoomChangedOccurs when the AllowUserToZoom property has changed.  
    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 EventAutoScrollWhenKeyboardShowingChangedOccurs when the AutoScrollWhenKeyboardShowing property is changed.  
    Public EventAutoSortedColumnOccurs when a column has just been automatically sorted.  
    Public EventAutoSortingColumnOccurs when a column is about to be automatically sorted.  
    Public EventBackColorChanged (Inherited from System.Windows.Forms.Control)
    Public EventBackgroundImageChanged (Inherited from System.Windows.Forms.Control)
    Public EventBackgroundImageLayoutChanged (Inherited from System.Windows.Forms.Control)
    Public EventBeforeRightClickOccurs when an object is right-clicked, before the default right-click action.  
    Public EventBeforeShowContextMenu  
    Public EventBindingContextChanged (Inherited from System.Windows.Forms.Control)
    Public EventBoundaryFeedbackModeChangedOccurs when the BoundaryFeedbackMode property has changed.  
    Public EventButtonClickedOccurs when the user clicks a button, check box, or hyperlink in a cell.  
    Public EventCausesValidationChanged (Inherited from System.Windows.Forms.Control)
    Public EventCellClickOccurs when the user presses the left mouse button down in a cell.  
    Public EventCellDoubleClickOccurs when the user presses the left mouse button down twice (double-clicks) in a cell.  
    Public EventCellErrorTextChangedOccurs when the cell error text has changed.  
    Public EventCellValidateInfoNeededOccurs when cell validate infomation is needed.  
    Public EventChangeOccurs after the user modifies data in a cell.  
    Public EventChangeUICues (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 EventCircularCellChangedOccurs when circular cell(s) is changed.  
    Public EventCircularFormulaOccurs when one or more circular reference is created.  
    Public EventClick (Inherited from System.Windows.Forms.Control)
    Public EventClientSizeChanged (Inherited from System.Windows.Forms.Control)
    Public EventClipboardChangedOccurs when a Clipboard change occurs that can affect the FarPoint 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 moving a column by dragging.  
    Public EventColumnDragMoveCompletingOccurs before the user finishes dragging column(s).  
    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 EventContextMenuChanged (Inherited from System.Windows.Forms.Control)
    Public EventContextMenuStripChanged (Inherited from System.Windows.Forms.Control)
    Public EventControlAdded (Inherited from System.Windows.Forms.Control)
    Public EventControlRemoved (Inherited from System.Windows.Forms.Control)
    Public EventCursorChanged (Inherited from System.Windows.Forms.Control)
    Public EventCustomNameChangedOccurs when the custom name of the data model changes.  
    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 EventDockChanged (Inherited from System.Windows.Forms.Control)
    Public EventDoubleClick (Inherited from System.Windows.Forms.Control)
    Public EventDpiChangedAfterParent (Inherited from System.Windows.Forms.Control)
    Public EventDpiChangedBeforeParent (Inherited from System.Windows.Forms.Control)
    Public EventDragDrop (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 EventDragEnter (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 EventDragLeave (Inherited from System.Windows.Forms.Control)
    Public EventDragOver (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 EventEnabledChanged (Inherited from System.Windows.Forms.Control)
    Public EventEnter (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 EventFilterBarClickOccurs when the user presses the left mouse button in a filter bar cell.  
    Public EventFilterBarDoubleClickOccurs when the user presses the left mouse button down twice (double-clicks) in a filter bar cell.  
    Public EventFilterBarDropDownSelectionChangingOccurs when the user selects a value from the drop-down list in the filter bar editor.  
    Public EventFontChanged (Inherited from System.Windows.Forms.Control)
    Public EventGiveFeedback (Inherited from System.Windows.Forms.Control)
    Public EventGotFocus (Inherited from System.Windows.Forms.Control)
    Public EventGroupedOccurs when the grouping is finished.  
    Public EventGroupingOccurs when the user performs grouping.  
    Public EventHandleCreated (Inherited from System.Windows.Forms.Control)
    Public EventHandleDestroyed (Inherited from System.Windows.Forms.Control)
    Public EventHeaderIndicatorPositionAdjustingChangedOccurs when the HeaderIndicatorPositionAdjusting property has changed.  
    Public EventHelpRequested (Inherited from System.Windows.Forms.Control)
    Public EventHyperLinkClickedOccurs when the user clicks on hyper link text.  
    Public EventImeModeChanged (Inherited from System.Windows.Forms.Control)
    Public EventInputScopeChangedOccurs when the InputScope property is changed.  
    Public EventInvalidated (Inherited from System.Windows.Forms.Control)
    Public EventKeyDown (Inherited from System.Windows.Forms.Control)
    Public EventKeyPress (Inherited from System.Windows.Forms.Control)
    Public EventKeyUp (Inherited from System.Windows.Forms.Control)
    Public EventLayout (Inherited from System.Windows.Forms.Control)
    Public EventLeave (Inherited from System.Windows.Forms.Control)
    Public EventLeaveCellOccurs when the user leaves a cell.  
    Public EventLeftChangeOccurs when the left column changes.  
    Public EventLocationChanged (Inherited from System.Windows.Forms.Control)
    Public EventLostFocus (Inherited from System.Windows.Forms.Control)
    Public EventMacroResolveOccurs when Spread binds to a function delegate by name.  
    Public EventMarginChanged (Inherited from System.Windows.Forms.Control)
    Public EventMouseCaptureChanged (Inherited from System.Windows.Forms.Control)
    Public EventMouseClick (Inherited from System.Windows.Forms.Control)
    Public EventMouseDoubleClick (Inherited from System.Windows.Forms.Control)
    Public EventMouseDown (Inherited from System.Windows.Forms.Control)
    Public EventMouseEnter (Inherited from System.Windows.Forms.Control)
    Public EventMouseHover (Inherited from System.Windows.Forms.Control)
    Public EventMouseLeave (Inherited from System.Windows.Forms.Control)
    Public EventMouseMove (Inherited from System.Windows.Forms.Control)
    Public EventMouseUp (Inherited from System.Windows.Forms.Control)
    Public EventMouseWheel (Inherited from System.Windows.Forms.Control)
    Public EventMove (Inherited from System.Windows.Forms.Control)
    Public EventPaddingChanged (Inherited from System.Windows.Forms.Control)
    Public EventPaint (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 tab strip needs painting.  
    Public EventPaintTabStripButtonOccurs when a TabStrip button needs painting.  
    Public EventPaintTabStripTabOccurs when a TabStrip tab needs painting.  
    Public EventPanningModeChangedOccurs when the PanningMode property has changed.  
    Public EventParentChanged (Inherited from System.Windows.Forms.Control)
    Public EventPreviewKeyDown (Inherited from System.Windows.Forms.Control)
    Public EventPreviewRowFetchOccurs when the user customizes the 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 EventPrintDocumentOccurs when printing a sheet.  
    Public EventPrintHeaderFooterAreaOccurs when the header or footer needs printing.  
    Public EventPrintMessageBoxOccurs before and after a print job.  
    Public EventPrintPreviewShowingOccurs before the preview dialog appears.  
    Public EventQueryAccessibilityHelp (Inherited from System.Windows.Forms.Control)
    Public EventQueryContinueDrag (Inherited from System.Windows.Forms.Control)
    Public EventQueryRecentItemsOccurs when FpSpread queries recent items.  
    Public EventRangeGroupStateChangedOccurs when the user has changed the state of the row or column outline (range group).  
    Public EventRangeGroupStateChangingOccurs before the user changes the state of row or column outlines (range group).  
    Public EventRegionChanged (Inherited from System.Windows.Forms.Control)
    Public EventResize (Inherited from System.Windows.Forms.Control)
    Public EventResizeZeroIndicatorChangedOccurs when the ResizeZeroIndicator property has changed.  
    Public EventResolveActionOccurs an Action object is created.  
    Public EventResolveCustomControlOccurs a customizable control is created.  
    Public EventRightToLeftChanged (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 moving a row by dragging.  
    Public EventRowDragMoveCompletingOccurs before the user finishes dragging row(s).  
    Public EventRowErrorTextChangedOccurs when the row error text has changed.  
    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 has 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 EventSheetDragMovedOccurs right after the user finishes drag-moving the sheet to another index.  
    Public EventSheetDragMovingOccurs when the user drag-move the sheet name tab to move sheet.  
    Public EventSheetTabClickOccurs when the user clicks the sheet tab.  
    Public EventSheetTabDoubleClickOccurs when the user double-clicks the sheet tab.  
    Public EventShowGrippersInEditingStatusChangedOccurs when the ShowGrippersInEditingStatus value is changed.  
    Public EventSizeChanged (Inherited from System.Windows.Forms.Control)
    Public EventSortedOccurs when spread is sorted.  
    Public EventSortingOccurs when spread is sorting.  
    Public EventStyleChanged (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 EventSystemColorsChanged (Inherited from System.Windows.Forms.Control)
    Public EventTabIndexChanged (Inherited from System.Windows.Forms.Control)
    Public EventTableChangedOccurs when the table changes.  
    Public EventTabStopChanged (Inherited from System.Windows.Forms.Control)
    Public EventTapToAddSelectionChangedOccurs when the TapToAddSelection property is changed.  
    Public EventTextChanged (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 EventTouchDropDownScaleChangedOccurs when the TouchDropDownScale property has changed.  
    Public EventTouchSelectionGripperBackColorChangedOccurs when the TouchSelectionGripperBackColor is changed.  
    Public EventTouchSelectionGripperLineColorChangedOccurs when TouchSelectionGripperLineColor is changed.  
    Public EventTouchSelectionGripperThicknessChangedOccurs when the TouchSelectionGripperThickness is changed.  
    Public EventTouchStripOpeningOccurs when FpSpread tries to show a FarPoint.Win.Spread.TouchStrip in a touch device.  
    Public EventTouchZoomSnapDistanceChangedOccurs when the TouchZoomSnapDistance property has changed.  
    Public EventUngroupedOccurs when all the grouping is removed.  
    Public EventUseOptimizedSelectionForTouchChangedOccurs when the UseOptimizedSelectionForTouch is changed.  
    Public EventUserFormulaEnteredOccurs when the user types a formula.  
    Public EventUserZoomingOccurs when the user zooms.  
    Public EventValidated (Inherited from System.Windows.Forms.Control)
    Public EventValidating (Inherited from System.Windows.Forms.Control)
    Public EventVisibleChanged (Inherited from System.Windows.Forms.Control)
    Top
    See Also

    Reference

    FpSpread Class
    FarPoint.Win.Spread Namespace