Spread Windows Forms 11.0 Product Documentation
FpSpread Class Methods


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

For a list of all members of this type, see FpSpread members.

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
See Also

Reference

FpSpread Class
FarPoint.Win.Spread Namespace

User-Task Documentation

Customizing the Appearance
Customizing the User Interaction