Spread Windows Forms 11.0 Product Documentation
FpSpread Class Members
Properties  Methods  Events


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace : FpSpread Class

The following tables list the members exposed by FpSpread.

Public Constructors
 NameDescription
Public ConstructorCreates a new Spreadsheet component.  
Top
Public Properties
 NameDescription
Public PropertyGets the version information about the component.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets the active chart indicator.  
Public PropertyGets or sets the active embedded child control object of the sheet.  
Public PropertyGets or sets the active sheet in the component.  
Public PropertyGets or sets the index of the active sheet in the component.  
Public PropertyGets or sets the active windowless shape object of the component.  
Public PropertyIndicates whether the content of a cell should float when the display rectangle of that cell changes.  
Public PropertyGets or sets whether data can overflow into adjacent empty cells in the component.  
Public PropertyGets or sets whether child controls allow user actions for design.  
Public PropertyGets or sets whether to allow the user to move columns.  
Public PropertyGets or sets whether to allow the user to move multiple columns.  
Public PropertyGets or sets whether to allow the user to drag-and-drop a range of cells in the component.  
Public PropertyGets or sets whether to allow the user to drag and fill cells in the component with the contents of a cell or cells.  
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets whether cell editor reserved mouse locations are allowed.  
Public PropertyGets or sets whether data can overflow into adjacent empty cells in the component while that cell is in edit mode.  
Public PropertyGets or sets whether to allow the user to move rows.  
Public PropertyGets or sets a value that indicates whether to allow the user to move the add new row or asterisk row.  
Public PropertyGets or sets whether to allow the user to move multiple rows.  
Public PropertyGets or sets whether sheets can be moved by dragging and dropping the sheet tab.  
Public PropertyGets or sets whether to allow the user to undo edit operations.  
Public PropertyGets or sets whether to allow the user to enter formulas in a cell in the component.  
Public PropertyGets or sets a value that indicates whether to allow the user to zoom FpSpread using touch behavior.  
Public PropertyGets or sets whether the user can scale the display of the component using the Ctrl key and the mouse wheel.  
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets whether the user can move to another control from the first or last cell using Shift+Tab or the Tab key.  
Public PropertyGets or sets whether the component handles the shortcut keys for Clipboard actions.  
Public PropertyGets or sets the behavior of automatic fit when double-clicking the right edge of the column header.  
Public PropertyGets or sets the behavior of automatic fit when double-clicking the bottom edge of the row header.  
Public PropertyGets or sets whether to use the CharacterSet property in a cell that is not in edit mode.  
Public PropertyGets or sets whether Spread Designer automatically launches when a Spread component is placed on a form.  
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the automatic scroll when the keyboard is displayed.  
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyOverridden. Gets or sets the image to paint in the background of the component.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets whether adjacent cell borders are collapsed into a single line for cells in the component.  
Public PropertyGets or sets the style of the border around the component.  
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the way FpSpread reacts when the manipulation has gone beyond certain boundaries.  
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets whether to display buttons in button and combo box cells in the component.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the cell note indicator renderer for drawing the cell note indicator in the component.  
Public PropertyGets or sets whether the cell note indicator appears in cells in the component.  
Public PropertyGets or sets the selection model to use with the span.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets 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 PropertyGets or sets whether a single cell copied to the Clipboard fills the range when pasted from the Clipboard to the component.  
Public PropertyGets or sets the alignment of the column split box relative to the horizontal scroll bar for this component.  
Public PropertyGets or sets the display policy for the column split box for this component.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.ComponentModel.Component)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyOverridden.   
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyOverridden. Gets or sets the pointer to display in this component.  
Public PropertyGets the custom list fill series.  
Public PropertyGets the CustomIconContainer object for the current spread object.  
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the name of the data member that populates the active sheet in this component.  
Public PropertyGets or sets the name of the data source that populates the active sheet in this component.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the DocumentProperties object that represents all properties of the Spread document.  
Public PropertyGets or sets a value that indicates whether the drag fill action copies data only.  
Public PropertyGets the Control object editing the active cell, or null if the component is not in edit mode.  
Public PropertyGets or sets whether the active cell in the component is in edit mode.  
Public PropertyGets or sets whether edit mode remains on for any cell in the component when that cell becomes active.  
Public PropertyGets or sets whether the existing contents of a cell in the component are selected when that cell enters edit mode.  
Public PropertyEnables cross-sheet referencing for this component.  
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets a value to show drag fill button and drag fill context menu.  
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the focus indicator renderer for drawing the focus rectangle in the component.  
Public PropertyOverridden. Gets or sets the default font for sheets in the component.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the distance between the sorting and filtering indicators and the right edge of the column.  
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets the horizontal scroll bar.  
Public PropertyGets or sets the height of horizontal scroll bars in this component.  
Public PropertyGets or Sets horizontal scroll bar mode.  
Public PropertyGets or sets when to display the horizontal scroll bars in this component.  
Public PropertyGets or sets the small increment for the horizontal scrollbar.  
Public PropertyGets or sets the Input Method Editor (IME) mode of the control.  
Public PropertyGets or sets IME sentence mode.  
Public PropertyGets the input device type which indicates the current device.  
Public PropertyGets or sets the input scope for the Spread.  
Public PropertyGets or sets the tab strip renderer for drawing tab strip elements.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyReturns whether the layout is suspended in this component.  
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertySpecifies whether Spread allows the user to change the structure of the sheet collection.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the leftmost sheet tab of the component.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets a value that indicates the minimum zoom factor for the active SheetView.  
Public PropertyGets or sets whether the location of the active cell moves when the user moves the focus to the view using the mouse.  
Public PropertyGets or sets the name of the Spread component.  
Public PropertyGets or sets a pre-defined style (NamedStyleCollection object).  
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets whether the active cell is painted in the selection.  
Public PropertyGets or sets a value that indicates whether to allow the border selection to paint.  
Public PropertyGets or sets whether to allow the header selection to paint.  
Public PropertyGets or sets the way FpSpread reacts to touch manipulation.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets 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 Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the way FpSpread processes resizing for zero-height rows and zero-width columns.  
Public PropertyGets or sets whether the selected range of cells remains highlighted when the component loses the focus.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the alignment of the row split box relative to the vertical scroll bar for this component.  
Public PropertyGets or sets the display policy of the row split box in this component.  
Public PropertyGets or sets whether the scroll bar aligns with the last row and column of the active sheet in the component.  
Public PropertyGets or sets whether the displayed scroll bars are based on the entire number of columns and rows in the sheet.  
Public PropertyGets or sets whether the sheet in the component scrolls when the user moves the scroll box.  
Public PropertyGets or sets whether scroll tips appear when the user moves the scroll box in the component.  
Public PropertyGets the dialog associated with searching for text in a cell of a sheet in this component.  
Public PropertyGets or sets which type of selections in the component the user can make.  
Public PropertyGets or sets the selection renderer for drawing selections in the component.  
Public PropertyGets the sheets (SheetView objects) in the component.  
Public PropertyGets or sets whether to allow the user to display row error by icon in the component.  
Public PropertyGets or sets whether the drag band is displayed when moving the row or column.  
Public PropertyGets or sets whether tapping displays the gripper in edit mode.  
Public PropertyGets or sets whether to allow the user to display the cell error using an icon or sticky note in the component.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the skin for the spread.  
Public PropertyGets 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 PropertyGets the status bar control of spread.  
Public PropertyGets or sets whether the status bar is enabled.  
Public PropertyGets or sets whether to suspend animations such as an animated focus renderer.  
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets a table style collection.  
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets the object that represents the tab strip for this component.  
Public PropertyGets or sets whether a special tab is displayed to allow inserting new sheets.  
Public PropertyGets or sets the tabstrip insert tab image.  
Public PropertyGets or sets the location of the tab strip.  
Public PropertyGets or sets the display policy for the sheet tab strip for this component.  
Public PropertyGets or sets the width of the tab strip for this component expressed as a percentage of the overall horizontal scroll bar width.  
Public PropertyGets or sets extra data for the application for this component.  
Public PropertyGets or sets whether to tap to add selection.  
Public PropertyGets or sets the appearance of text tips in the view.  
Public PropertyGets or sets the time (in milliseconds) the component waits before displaying the text tip for the cell or header under the pointer.  
Public PropertyGets or sets whether to display text tips and cell notes and the location of the tips and notes in this component.  
Public PropertyGets or sets the collection of title information objects for Spread.  
Public Property (Inherited from System.Windows.Forms.Control)
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the TouchDropDownScale to specify the zoom scale value that applies to a cell type drop-down item.  
Public PropertyGets or sets the touch selection gripper's backcolor.  
Public PropertyGets or sets the touch selection gripper's line color.  
Public PropertyGets or sets the touch selection gripper's thickness.  
Public PropertyGets 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 PropertyGets a zoom factor group and when the zoom ends, the final zoom factor snaps to a snap point in this group.  
Public PropertyGets or sets the undo manager for this Spread component.  
Public PropertyGets or sets whether to use optimized selection for touch.  
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets the vertical scroll bar.  
Public PropertyGets or Sets vertical scroll bar mode.  
Public PropertyGets or sets when to display the vertical scroll bars in this component.  
Public PropertyGets or sets the small increment for the horizontal scrollbar.  
Public PropertyGets or sets the width of vertical scroll bars in this component.  
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets whether to use visual styles when rendering objects in the component.  
Public Property (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets the scaling factor of the display of the active sheet in this component.  
Top
Protected Properties
Public Methods
 NameDescription
Public MethodOverloaded. Adds a child control to a specified sheet at the location of the specified row and column.  
Public MethodAdds a user-defined custom function (GrapeCity.CalcEngine.Function object) to the model for use in formulas.  
Public MethodCreates a new SheetView and inserts or replaces the sheet at the specified sheet index.  
Public MethodOverloaded. Adds a row or column of viewports.  
Public MethodOverloaded.  (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodCancels annotation mode.  
Public MethodCancels cell editing.  
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodCreates a table style based on the table style contained in the table style collection or a built-in table style.  
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodGets the action map, that maps action identifiers (for keystrokes) to particular actions.  
Public MethodOverloaded. Gets the index of the active viewport column for the active sheet.  
Public MethodOverloaded. Gets the index of the active viewport row for the active sheet.  
Public MethodGets the row and column indexes of the cell at the specified pointer location.  
Public MethodGets the rectangle of the cell.  
Public MethodOverloaded.  (Inherited from System.Windows.Forms.Control)
Public MethodGets the rectangle of the column header.  
Public MethodOverloaded. Gets the column page breaks for the specified sheet under the current printing conditions.  
Public MethodGets the height of the column range group.  
Public MethodGets the rectangle of the column split bar.  
Public MethodGets the rectangle of the column split box.  
Public MethodOverloaded. Gets the number of viewport columns in the active sheet.  
Public MethodGets the index of the viewport column for the specified coordinate for the active sheet.  
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodGets the pointer displayed over different areas of the component.  
Public Methodstatic (Shared in Visual Basic)Overloaded. Gets an array of sheet names from the specified Excel stream.  
Public MethodGets the rectangle of the column header.  
Public MethodGets the rectangle of the filter bar.  
Public MethodGets the rectangle of the horizontal scroll bar.  
Public MethodOverloaded. Gets the input map defined for the specified focus mode.  
Public MethodGets the input map when a child control has keyboard focus.  
Public MethodGets the input map when a shape has keyboard focus.  
Public MethodGets the maximum cell overflow width in pixels.  
Public MethodOverloaded. Gets the column page breaks for the specified sheet under the current printing conditions.  
Public MethodGets the printing information required to print a given sheet into the supplied rectangle.  
Public MethodGets the number of pages required to print a given sheet into the supplied rectangle.  
Public MethodOverloaded. Gets the row page breaks for the specified sheet under the current printing conditions.  
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodGets the number of pages required to print the specified sheet.  
Public MethodGets the print preview dialog.  
Public MethodGets the main workbook associated with the Spread component.  
Public MethodGets the rectangle of the row header.  
Public MethodOverloaded. Gets the row page breaks for the specified sheet under the current printing conditions.  
Public MethodGets the width of the row range group.  
Public MethodGets the rectangle of the row split bar.  
Public MethodGets the rectangle of the row split box.  
Public MethodOverloaded. Gets the number of viewport rows.  
Public MethodGets the index of the viewport row for the specified coordinate for the active sheet.  
Public MethodGets a sheet with a specific tag.  
Public MethodGets the rectangle of the tab associated with a sheet.  
Public MethodGets the rectangle of the split box on the tab strip.  
Public MethodGets the rectangle of the tab strip.  
Public MethodGets the rectangle of the vertical scroll bar.  
Public MethodOverloaded. Gets the bottom row of cells of the specified viewport row for the active sheet.  
Public MethodOverloaded. Gets the leftmost column of cells of the specified viewport column for the active sheet.  
Public MethodOverloaded. Gets the maximum height of the viewport row for the active sheet.  
Public MethodOverloaded. Gets the maximum width of the specified viewport column.  
Public MethodGets the rectangle of the viewport.  
Public MethodOverloaded. Gets the rightmost column of cells of the specified viewport column for the active sheet.  
Public MethodOverloaded. Gets the top row of cells of the specified viewport row for the specified sheet.  
Public MethodAttempts to find the value for one cell that produces the desired formula result in another cell.  
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodHides the touch keyboard.  
Public MethodPerforms a hit test.  
Public MethodOverloaded.  (Inherited from System.Windows.Forms.Control)
Public MethodOverloaded.  (Inherited from System.Windows.Forms.Control)
Public MethodReturns whether the cell at the specified location is visible in the specified view.  
Public MethodOverloaded. Opens the specified file and determines whether it meets the minimal requirements to be considered an Excel file.  
Public MethodOverloaded. Opens the specified file and determines whether it meets the minimal requirements to be considered a stream that contains an Excel workbook.  
Public MethodOpens the specified file and determines whether it meets the minimal requirements to be considered a Spread SS file.  
Public MethodOpens the specified file and determines whether it meets the minimal requirements to be considered a Spread XML file.  
Public MethodLoads formulas that are deserialized but not parsed yet, to be used after all sheets have been created and deserialized.  
Public MethodOverloaded. Loads the XML input map file using the specified operation mode.  
Public MethodOverloaded. Loads the XML input map file when the child has the focus.  
Public MethodOverloaded. Loads the XML input map file when the shape has the focus.  
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodRaises the ClipboardChanging event.  
Public MethodOverloaded. Opens a saved XML file.  
Public MethodOverloaded. Opens an Excel Compound Document File and loads it into Spread.  
Public MethodOpens a saved Spread file.  
Public MethodOverloaded. Prints the specified page of the specified sheet to a specified graphics interface with the specified size.  
Public MethodOverloaded. Forces the Spread component to apply layout logic to its child controls.  
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodOverloaded. Handles the printing of the specified sheet in a separate thread.  
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodRemoves a child control from the specified sheet.  
Public MethodOverloaded. Removes a row or column of viewports.  
Public MethodResets the component to its original state.  
Public MethodResets the focus renderer to its original state.  
Public MethodResets the focus renderer to its original state.  
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodOverloaded. Resumes normal layout logic.  
Public MethodOverloaded. Saves the content of the Spread component to the specified file.  
Public MethodOverloaded. Saves the content of the Spread component to the specified stream.  
Public MethodOverloaded. Saves the XML input map file.  
Public MethodOverloaded. Saves the XML input map file when child has focus.  
Public MethodOverloaded. Saves the XML input map file when shape has focus.  
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodOverloaded. Searches the text in the specified range of cells in the specified sheet for the specified string with the specified criteria.  
Public MethodOverloaded. Searches the text in the header cells in the specified sheet for the specified string.  
Public MethodOverloaded. Searches the text in the cells of the active sheet for the search string with the default criteria using a provided search dialog.  
Public MethodOverloaded. Searches the text in the cells of the sheets for the search string with the default criteria using a provided advanced search dialog.  
Public Method (Inherited from System.Windows.Forms.Control)
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodSets the action map, that maps action identifiers (for keystrokes) to particular actions.  
Public MethodOverloaded. Sets the active viewport for the active sheet.  
Public MethodOverloaded.  (Inherited from System.Windows.Forms.Control)
Public MethodSets the pointer displayed over different areas of the component.  
Public MethodOverloaded. Sets the input map for the specified focus mode.  
Public MethodSets the input map when a child control has keyboard focus.  
Public MethodSets the input map when a shape has keyboard focus.  
Public MethodSets the custom image displayed on the insert sheet tab.  
Public MethodSets the maximum cell overflow width in pixels.  
Public MethodSets the PrintInfo object for the specfied sheet.  
Public MethodSets the print preview dialog.  
Public MethodChanges the protect structure setting with the password parameter.  
Public MethodOverloaded. Sets the leftmost column of cells of the specified viewport column for the active sheet.  
Public MethodOverloaded. Sets the maximum height of the specified viewport row for the active sheet.  
Public MethodOverloaded. Sets the maximum width of the specified viewport column for the active sheet.  
Public MethodOverloaded. Sets the top row of cells of the specified viewport row for the active sheet.  
Public Method (Inherited from System.Windows.Forms.Control)
Public MethodMoves the active cell to the specified position in the component.  
Public MethodMoves the specified cell in the specified viewport to the specified position in the component.  
Public MethodShows the form that is used to edit Cell Validators of selected range  
Public MethodShows the collection editor.  
Public MethodMoves a column of cells in the specified viewport to the specified position in the component.  
Public MethodShows the form that is used to edit DataValidation of selected range  
Public MethodShows the dependent cells for a formula cell.  
Public MethodDisplays the form used for editing custom names.  
Public MethodDisplays the input map editor.  
Public MethodDisplays the form that contains a list of custom names.  
Public MethodOverloaded. Shows the page setup dialog with the specified buttons for the specified sheet.  
Public MethodShows the cells that are referred to by formulas in other cells.  
Public MethodMoves a row in the specified viewport to the specified position in the component.  
Public MethodDisplays the touch keyboard.  
Public MethodOverloaded. Starts annotation mode.  
Public MethodStarts cell editing.  
Public MethodOverloaded. Starts ink notation in the active viewport if the Microsoft.Ink assembly is found in the GAC.  
Public MethodStops annotation mode.  
Public MethodStops cell editing.  
Public MethodTemporarily suspends the layout logic for this component.  
Public Method (Inherited from System.ComponentModel.Component)
Public MethodThis function will notify all cells, which contains volatile functions or belong to a circuit, to recalculate.  
Public Method (Inherited from System.Windows.Forms.Control)
Top
Protected Methods
 NameDescription
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodThe destructor method  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.ComponentModel.Component)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden. Determines whether the specified character is an input character that the component can handle without preprocessing.  
Protected MethodOverridden. Determines whether the specified key is an input key that the component can handle without preprocessing.  
Protected MethodOverloaded.  (Inherited from System.MarshalByRefObject)
Protected MethodRaises the ActiveSheetChanged event.  
Protected MethodRaises the ActiveSheetChanging event.  
Protected MethodRaises the ActiveSpreadViewChanged event.  
Protected MethodRaises the ActiveSpreadViewChanging event.  
Protected MethodRaises the Advance event.  
Protected MethodRaises the AllowUserToZoomChanged event.  
Protected MethodRaises the AnnotationModeEnding event.  
Protected MethodRaises the AnnotationModeStarting event.  
Protected MethodRaises the AutoFilteredColumn event.  
Protected MethodRaises the AutoFilteringColumn event.  
Protected MethodRaises the AutoScrollWhenKeyboardShowingChanged event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the AutoSortedColumn event.  
Protected MethodRaises the AutoSortingColumn event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the BoundaryFeedbackModeChanged event.  
Protected MethodRaises the ButtonClicked event.  
Protected MethodRaises the CellClick event.  
Protected MethodRaises the CellDoubleClick event.  
Protected MethodRaises the Change event.  
Protected MethodRaises the ChildControlActivated event.  
Protected MethodRaises the ChildControlDeactivated event.  
Protected MethodRaises the ChildViewCreated event.  
Protected MethodRaises the ChildWorkbookCreated event.  
Protected MethodRaises the CircularFormulaFpSpread event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden. Overrides to adjust the client area.  
Protected MethodRaises the ClipboardChanged event.  
Protected MethodRaises the ClipboardPasted event.  
Protected MethodRaises the ClipboardPasting event.  
Protected MethodRaises the ColumnDragMove event.  
Protected MethodRaises the ColumnDragMoveCompleted event.  
Protected MethodRaises the ColumnViewportWidthChanged event.  
Protected MethodRaises the ColumnWidthChanged event.  
Protected MethodRaises the ColumnWidthChanging event.  
Protected MethodRaises the ComboCloseUp event.  
Protected MethodRaises the ComboDropDown event.  
Protected MethodRaises the ComboSelChange event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the ControlRemoved event. (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the DataColumnConfigure event.  
Protected MethodRaises the DialogChar event.  
Protected MethodRaises the DialogKey event.  
Protected MethodOverridden. Raises the DoubleClick event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the DragDropBlock event.  
Protected MethodRaises the DragDropBlockCompleted event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the DragFillBlock event.  
Protected MethodRaises the DragFillBlockCompleted event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the EditChange event.  
Protected MethodRaises the EditError event.  
Protected MethodRaises the EditModeOff event.  
Protected MethodRaises the EditModeOn event.  
Protected MethodRaises the EditModeStarting event.  
Protected MethodRaises the EditorFocused event.  
Protected MethodOverridden. Raises the EnableChanged event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the EnterCell event.  
Protected MethodRaises the Error event.  
Protected MethodRaises the EnterCell event.  
Protected MethodRaises the FilterBarClick event.  
Protected MethodRaises the FilterBarDoubleClick event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the Grouped event.  
Protected MethodRaises the Grouping event.  
Protected MethodRaises the HeaderIndicatorPositionAdjustingChanged event.  
Protected MethodRaises the HyperLinkClicked event.  
Protected MethodRaises the InputScopeChanged event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the LeaveCell event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the PaintGrayArea event.  
Protected MethodRaises the PaintGroupBarBackground event.  
Protected MethodRaises the PaintTabStrip event.  
Protected MethodRaises the PaintTabStripButton event.  
Protected MethodRaises the PaintTabStripTab event.  
Protected MethodRaises the PanningModeChanged event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden. Processes PreviewKeyDown event.  
Protected MethodRaises the PreviewRowFetch event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the PrintAbort event.  
Protected MethodRaises the PrintBackground event.  
Protected MethodRaises the PrintCancelled event.  
Protected MethodRaises the PrintDocument event.  
Protected MethodRaises the PrintHeaderFooterArea event.  
Protected MethodRaises the PrintMessageBox event.  
Protected MethodRaises the PrintPreviewShowing event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the RangeGroupStateChanged event.  
Protected MethodRaises the RangeGroupStateChanging event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden. Raises the Resize event.  
Protected MethodRaises the ResizeZeroIndicatorChanged event.  
Protected MethodOverridden. Raises the RightToLeftChanged event.  
Protected MethodRaises the RowDragMove event.  
Protected MethodRaises the RowDragMoveCompleted event.  
Protected MethodRaises the RowHeightChanged event.  
Protected MethodRaises the RowHeightChanging event.  
Protected MethodRaises the RowViewportHeightChanged event.  
Protected MethodRaises the ScrollTipFetch event.  
Protected MethodRaises the SearchDialogClosing event.  
Protected MethodRaises the SelectionChanged event.  
Protected MethodRaises the SelectionChanging event.  
Protected MethodRaises the ShapeActivated event.  
Protected MethodRaises the ShapeDeactivated event.  
Protected MethodRaises the SheetDragMoved event.  
Protected MethodRaises the SheetDragMoving event.  
Protected MethodRaises the SheetTabClick event.  
Protected MethodRaises the SheetTabDoubleClick event.  
Protected MethodRaises the ShowGrippersInEditingStatusChanged event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the Sorted event.  
Protected MethodRaises the Sorting event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the SubEditorClosed event.  
Protected MethodRaises the SubEditorOpening event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the TapToAddSelectionChanged event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the TextTipFetch event.  
Protected MethodRaises the TopChange event.  
Protected MethodRaises the TouchDropDownScaleChanged event.  
Protected MethodRaises the TouchSelectionGripperBackColorChanged event.  
Protected MethodRaises the TouchSelectionGripperLineColorChanged event.  
Protected MethodRaises the TouchSelectionGripperThicknessChanged event.  
Protected MethodRaises the TouchStripOpening event.  
Protected MethodRaises the TouchZoomSnapDistanceChanged event.  
Protected MethodRaises the Grouped event.  
Protected MethodRaises the UseOptimizedSelectionForTouchChanged event.  
Protected MethodRaises the UserFormulaEntered event.  
Protected MethodRaises the UserZooming event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden. Raises the Validating event.  
Protected MethodOverridden. Raises the VisibleChanged event.  
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverloaded.  (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden.   
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Top
Public Events
 NameDescription
Public EventOccurs when the user has changed the active sheet.  
Public EventOccurs when the user changes the active sheet.  
Public EventOccurs when the user has changed the active SpreadView.  
Public EventOccurs when the user changes the active SpreadView.  
Public EventOccurs when the user tries to advance from the first or last row in Spread.  
Public EventOccurs when the AllowUserToZoom property has changed.  
Public EventOccurs when the user ends annotation mode.  
Public EventOccurs when the user begins annotation mode.  
Public EventOccurs when a column has just been automatically filtered.  
Public EventOccurs when a column is about to be automatically filtered.  
Public EventOccurs when the AutoScrollWhenKeyboardShowing property is changed.  
Public EventOccurs when a column has just been automatically sorted.  
Public EventOccurs when a column is about to be automatically sorted.  
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the BoundaryFeedbackMode property has changed.  
Public EventOccurs when the user clicks a button, check box, or hyperlink in a cell.  
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the user presses the left mouse button down in a cell.  
Public EventOccurs when the user presses the left mouse button down twice (double-clicks) in a cell.  
Public EventOccurs when the cell error text has changed.  
Public EventOccurs when cell validate infomation is needed.  
Public EventOccurs after the user modifies data in a cell.  
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the chart indicator is activated.  
Public EventOccurs when the chart indicator is deactivated.  
Public EventOccurs when a child control is activated.  
Public EventOccurs when a child control is deactivated.  
Public EventOccurs when a child view of the Spread component is created.  
Public EventOccurs when a child workbook of the Spread component is created.  
Public EventOccurs when one or more circular reference is created.  
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when a Clipboard change occurs that can affect the FarPoint Spread component.  
Public EventOccurs when the Clipboard is changing through a Spread action.  
Public EventOccurs when the user pastes from the clipboard.  
Public EventOccurs when the user pastes from the clipboard.  
Public EventOccurs when AllowColumnMove is true and the user drags to move a column.  
Public EventOccurs when the user finishes moving a column by dragging.  
Public EventOccurs when a viewport column width has changed.  
Public EventOccurs when the column width has changed.  
Public EventOccurs when the column width is changing.  
Public EventOccurs when the user closes a combo box in a cell.  
Public EventOccurs when the user drops down a combo box in a cell.  
Public EventOccurs when the user changes the selection in a combo box in a cell.  
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the custom name of the data model changes.  
Public EventOccurs when the sheet is binding a column to a data source after it has been initialized.  
Public EventOccurs during message preprocessing of dialog characters.  
Public EventOccurs during message preprocessing of dialog keys.  
Public Event (Inherited from System.ComponentModel.Component)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the user drags and drops a range of cells.  
Public EventOccurs at the completion of the user dragging and dropping a range of cells.  
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the user drags to fill a range of cells.  
Public EventOccurs at the completion of the user dragging to fill a range of cells.  
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the user changes the text in a cell in edit mode.  
Public EventOccurs when the user performs an invalid input operation.  
Public EventOccurs when edit mode is stopped.  
Public EventOccurs when edit mode is started.  
Public EventOccurs when edit mode is about to start in the active sheet's active cell.  
Public EventOccurs when the editing control gets focus.  
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the user enters a cell.  
Public EventOccurs when the user performs an invalid operation.  
Public EventOccurs when a row is expanded or collapsed.  
Public EventOccurs when the user presses the left mouse button in a filter bar cell.  
Public EventOccurs when the user presses the left mouse button down twice (double-clicks) in a filter bar cell.  
Public EventOccurs when the user selects a value from the drop-down list in the filter bar editor.  
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the grouping is finished.  
Public EventOccurs when the user performs grouping.  
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the HeaderIndicatorPositionAdjusting property has changed.  
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the user clicks on hyper link text.  
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the InputScope property is changed.  
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the user leaves a cell.  
Public EventOccurs when the left column changes.  
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the gray area needs painting.  
Public EventOccurs when the group bar background is painted.  
Public EventOccurs when the tab strip needs painting.  
Public EventOccurs when a TabStrip button needs painting.  
Public EventOccurs when a TabStrip tab needs painting.  
Public EventOccurs when the PanningMode property has changed.  
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the user customizes the preview row of the Spread component.  
Public EventOccurs continually as printing occurs in order to give the user the opportunity to discontinue a print job.  
Public EventOccurs before each page is printed.  
Public EventOccurs when a print job is discontinued by the user.  
Public EventOccurs when printing a sheet.  
Public EventOccurs when the header or footer needs printing.  
Public EventOccurs before and after a print job.  
Public EventOccurs before the preview dialog appears.  
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the user has changed the state of the row or column outline (range group).  
Public EventOccurs before the user changes the state of row or column outlines (range group).  
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the ResizeZeroIndicator property has changed.  
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when AllowRowMove is true and the user drags to move a row.  
Public EventOccurs when the user finishes moving a row by dragging.  
Public EventOccurs when the row error text has changed.  
Public EventOccurs when the row height has changed.  
Public EventOccurs when the column width is changing.  
Public EventOccurs when a viewport row height has changed.  
Public EventOccurs when the user scrolls the Spread component.  
Public EventOccurs when the search form is closing.  
Public EventOccurs when the selection of cells on the sheet has changed.  
Public EventOccurs when the selection of cells on the sheet is changing.  
Public EventOccurs when the user changes the active shape object.  
Public EventOccurs when the user deactivates the active shape object.  
Public EventOccurs right after the user finishes drag-moving the sheet to another index.  
Public EventOccurs when the user drag-move the sheet name tab to move sheet.  
Public EventOccurs when the user clicks the sheet tab.  
Public EventOccurs when the user double-clicks the sheet tab.  
Public EventOccurs when the ShowGrippersInEditingStatus value is changed.  
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when spread is sorted.  
Public EventOccurs when spread is sorting.  
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when a subeditor is closed for a cell.  
Public EventOccurs when a subeditor is about to be displayed.  
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the table changes.  
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when the TapToAddSelection property is changed.  
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs 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 EventOccurs when the top row changes.  
Public EventOccurs when the TouchDropDownScale property has changed.  
Public EventOccurs when the TouchSelectionGripperBackColor is changed.  
Public EventOccurs when TouchSelectionGripperLineColor is changed.  
Public EventOccurs when the TouchSelectionGripperThickness is changed.  
Public EventOccurs when FpSpread tries to show a FarPoint.Win.Spread.TouchStrip in a touch device.  
Public EventOccurs when the TouchZoomSnapDistance property has changed.  
Public EventOccurs when all the grouping is removed.  
Public EventOccurs when the UseOptimizedSelectionForTouch is changed.  
Public EventOccurs when the user types a formula.  
Public EventOccurs when the user zooms.  
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Top
See Also

Reference

FpSpread Class
FarPoint.Win.Spread Namespace

User-Task Documentation

Customizing the Appearance
Customizing the User Interaction