Spread Windows Forms 13.0 Product Documentation
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 ConstructorOverloaded.   
    Top
    Public Properties
     NameDescription
    Public Property Gets the version information about the component.  
    Public PropertyGets the System.Windows.Forms.AccessibleObject assigned to the control. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets the default action description of the control for use by accessibility client applications. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets the description of the control used by accessibility client applications. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets the name of the control used by accessibility client applications. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets the accessible role of the control (Inherited from System.Windows.Forms.Control)
    Public Property Gets the active chart indicator.  
    Public Property Gets or sets the active embedded child control object of the sheet.  
    Public Property Gets or sets the active sheet in the component.  
    Public Property Gets or sets the index of the active sheet in the component.  
    Public Property Gets or sets the active windowless shape object of the component.  
    Public Property Indicates whether the content of a cell should float when the display rectangle of that cell changes.  
    Public Property Gets or sets whether data can overflow into adjacent empty cells in the component.  
    Public Property Gets or sets whether child controls allow user actions for design.  
    Public Property Gets or sets whether to allow the user to move columns.  
    Public Property Gets or sets whether to allow the user to move multiple columns.  
    Public Property Gets or sets whether to allow the user to drag-and-drop a range of cells in the component.  
    Public Property Gets or sets whether to allow the user to drag and fill cells in the component with the contents of a cell or cells.  
    Public PropertyGets or sets a value indicating whether the control can accept data that the user drags onto it. (Inherited from System.Windows.Forms.Control)
    Public Property Gets or sets whether cell editor reserved mouse locations are allowed.  
    Public Property Gets or sets whether data can overflow into adjacent empty cells in the component while that cell is in edit mode.  
    Public Property Gets or sets whether to allow the user to move rows.  
    Public Property Gets or sets a value that indicates whether to allow the user to move the add new row or asterisk row.  
    Public Property Gets or sets whether to allow the user to move multiple rows.  
    Public Property Gets or sets whether sheets can be moved by dragging and dropping the sheet tab.  
    Public Property Gets or sets whether to allow the user to undo edit operations.  
    Public Property Gets or sets whether to allow the user to enter formulas in a cell in the component.  
    Public Property Gets or sets a value that indicates whether to allow the user to zoom FpSpread using touch behavior.  
    Public Property Gets or sets whether the user can scale the display of the component using the Ctrl key and the mouse wheel.  
    Public PropertyGets or sets the edges of the container to which a control is bound and determines how a control is resized with its parent. (Inherited from System.Windows.Forms.Control)
    Public Property Gets or sets whether the user can move to another control from the first or last cell using Shift+Tab or the Tab key.  
    Public Property Gets or sets whether the component handles the shortcut keys for Clipboard actions.  
    Public Property Gets or sets the behavior of automatic fit when double-clicking the right edge of the column header.  
    Public Property Gets or sets the behavior of automatic fit when double-clicking the bottom edge of the row header.  
    Public Property Gets or sets whether to use the CharacterSet property in a cell that is not in edit mode.  
    Public Property Gets or sets whether Spread Designer automatically launches when a Spread component is placed on a form.  
    Public PropertyGets or sets where this control is scrolled to in System.Windows.Forms.ScrollableControl.ScrollControlIntoView(System.Windows.Forms.Control). (Inherited from System.Windows.Forms.Control)
    Public Property Gets or sets the automatic scroll when the keyboard is displayed.  
    Public PropertyGets or sets the background color for the control. (Inherited from System.Windows.Forms.Control)
    Public PropertyOverridden.  Gets or sets the image to paint in the background of the component.  
    Public PropertyGets or sets the background image layout as defined in the System.Windows.Forms.ImageLayout enumeration. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets the System.Windows.Forms.BindingContext for the control. (Inherited from System.Windows.Forms.Control)
    Public Property Gets or sets whether adjacent cell borders are collapsed into a single line for cells in the component.  
    Public Property Gets or sets the style of the border around the component.  
    Public PropertyGets the distance, in pixels, between the bottom edge of the control and the top edge of its container's client area. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets the way FpSpread reacts when the manipulation has gone beyond certain boundaries.  
    Public PropertyGets or sets the size and location of the control including its nonclient elements, in pixels, relative to the parent control. (Inherited from System.Windows.Forms.Control)
    Public Property Gets or sets whether to display buttons in button and combo box cells in the component.  
    Public PropertyGets a value indicating whether the control can receive focus. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets a value indicating whether the control can be selected. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets a value indicating whether the control has captured the mouse. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets a value indicating whether the control causes validation to be performed on any controls that require validation when it receives focus. (Inherited from System.Windows.Forms.Control)
    Public Property Gets or sets the cell note indicator renderer for drawing the cell note indicator in the component.  
    Public Property Gets or sets whether the cell note indicator appears in cells in the component.  
    Public Property Gets or sets the selection model to use with the span.  
    Public PropertyGets the rectangle that represents the client area of the control. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets the height and width of the client area of the control. (Inherited from System.Windows.Forms.Control)
    Public Property Gets 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 Property Gets or sets whether a single cell copied to the Clipboard fills the range when pasted from the Clipboard to the component.  
    Public Property Gets or sets the alignment of the column split box relative to the horizontal scroll bar for this component.  
    Public Property Gets or sets the display policy for the column split box for this component.  
    Public PropertyGets the name of the company or creator of the application containing the control. (Inherited from System.Windows.Forms.Control)
    Public Property (Inherited from System.ComponentModel.Component)
    Public PropertyGets a value indicating whether the control, or one of its child controls, currently has the input focus. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets the shortcut menu associated with the control. (Inherited from System.Windows.Forms.Control)
    Public PropertyOverridden. Gets or sets the ContextMenuStrip associated with this control.  
    Public PropertyGets the collection of controls contained within the control. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets a value indicating whether the control has been created. (Inherited from System.Windows.Forms.Control)
    Public PropertyOverridden.  Gets or sets the pointer to display in this component.  
    Public Property Gets the custom list fill series.  
    Public PropertyGets the CustomIconContainer object for the current spread object.  
    Public PropertyGets the data bindings for the control. (Inherited from System.Windows.Forms.Control)
    Public Property Gets or sets the name of the data member that populates the active sheet in this component.  
    Public Property Gets or sets the name of the data source that populates the active sheet in this component.  
    Public Property Gets, or Sets the default Skin that will be used for painting.  
    Public PropertyGets the DPI value for the display device where the control is currently being displayed. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets the rectangle that represents the display area of the control. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets a value indicating whether the base System.Windows.Forms.Control class is in the process of disposing. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets which control borders are docked to its parent control and determines how a control is resized with its parent. (Inherited from System.Windows.Forms.Control)
    Public Property Gets or sets the DocumentProperties object that represents all properties of the Spread document.  
    Public Property Gets or sets a value that indicates whether the drag fill action copies data only.  
    Public Property Gets the Control object editing the active cell, or null if the component is not in edit mode.  
    Public Property Gets or sets whether the active cell in the component is in edit mode.  
    Public Property Gets or sets whether edit mode remains on for any cell in the component when that cell becomes active.  
    Public Property Gets or sets whether the existing contents of a cell in the component are selected when that cell enters edit mode.  
    Public Property Enables cross-sheet referencing for this component.  
    Public PropertyGets or sets a value indicating whether the control can respond to user interaction. (Inherited from System.Windows.Forms.Control)
    Public Property Gets or sets a value to show drag fill button and drag fill context menu.  
    Public Property Gets or sets the optional behaviors of the enhanced shape engine.  
    Public PropertyGets an IFeatures object that toggles avalable features of FpSpread.  
    Public PropertyGets a value indicating whether the control has input focus. (Inherited from System.Windows.Forms.Control)
    Public Property Gets 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 PropertyGets the window handle that the control is bound to. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets a value indicating whether the control contains one or more child controls. (Inherited from System.Windows.Forms.Control)
    Public Property Gets or sets the distance between the sorting and filtering indicators and the right edge of the column.  
    Public PropertyGets or sets the height of the control. (Inherited from System.Windows.Forms.Control)
    Public Property Gets the horizontal scroll bar.  
    Public Property Gets or sets the height of horizontal scroll bars in this component.  
    Public Property Gets or Sets horizontal scroll bar mode.  
    Public Property Gets or sets when to display the horizontal scroll bars in this component.  
    Public Property Gets or sets the small increment for the horizontal scrollbar.  
    Public Property Gets or sets the Input Method Editor (IME) mode of the control.  
    Public Property Gets or sets IME sentence mode.  
    Public Property Gets the input device type which indicates the current device.  
    Public Property Gets or sets the input scope for the Spread.  
    Public Property Gets or sets the tab strip renderer for drawing tab strip elements.  
    Public PropertyGets a value indicating whether the caller must call an invoke method when making method calls to the control because the caller is on a different thread than the one the control was created on. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets a value indicating whether the control is visible to accessibility applications. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets a value indicating whether the control has been disposed of. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets a value indicating whether the control has a handle associated with it. (Inherited from System.Windows.Forms.Control)
    Public Property Returns whether the layout is suspended in this component.  
    Public PropertyGets a value indicating whether the control is mirrored. (Inherited from System.Windows.Forms.Control)
    Public Property Specifies whether Spread allows the user to change the structure of the sheet collection.  
    Public PropertyGets a cached instance of the control's layout engine. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets the distance, in pixels, between the left edge of the control and the left edge of its container's client area. (Inherited from System.Windows.Forms.Control)
    Public Property Gets or sets the leftmost sheet tab of the component.  
    Public PropertyGets or sets the coordinates of the upper-left corner of the control relative to the upper-left corner of its container. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets the space between controls. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets the size that is the upper limit that System.Windows.Forms.Control.GetPreferredSize(System.Drawing.Size) can specify. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets the size that is the lower limit that System.Windows.Forms.Control.GetPreferredSize(System.Drawing.Size) can specify. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets a value that indicates the minimum zoom factor for the active SheetView.  
    Public Property Gets or sets whether the location of the active cell moves when the user moves the focus to the view using the mouse.  
    Public Property Gets or sets the name of the Spread component.  
    Public PropertyGets or sets a pre-defined style (NamedStyleCollection object).  
    Public PropertyGets or sets padding within the control. (Inherited from System.Windows.Forms.Control)
    Public Property Gets or sets whether the active cell is painted in the selection.  
    Public Property Gets or sets a value that indicates whether to allow the border selection to paint.  
    Public Property Gets or sets whether to allow the header selection to paint.  
    Public PropertyGets or sets the way FpSpread reacts to touch manipulation.  
    Public PropertyGets or sets the parent container of the control. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets the size of a rectangular area into which the control can fit. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets the product name of the assembly containing the control. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets the version of the assembly containing the control. (Inherited from System.Windows.Forms.Control)
    Public Property Gets 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 PropertyGets a value indicating whether the control is currently re-creating its handle. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets the window region associated with the control. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets the way FpSpread processes resizing for zero-height rows and zero-width columns.  
    Public Property Gets or sets whether the selected range of cells remains highlighted when the component loses the focus.  
    Public PropertyGets the distance, in pixels, between the right edge of the control and the left edge of its container's client area. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets a value indicating whether control's elements are aligned to support locales using right-to-left fonts. (Inherited from System.Windows.Forms.Control)
    Public Property Gets or sets the maximum auto-width of the row header.  
    Public Property Gets or sets the alignment of the row split box relative to the vertical scroll bar for this component.  
    Public Property Gets or sets the display policy of the row split box in this component.  
    Public Property Gets or sets whether the scroll bar aligns with the last row and column of the active sheet in the component.  
    Public Property Gets or sets whether the displayed scroll bars are based on the entire number of columns and rows in the sheet.  
    Public Property Gets or sets whether the sheet in the component scrolls when the user moves the scroll box.  
    Public Property Gets or sets whether scroll tips appear when the user moves the scroll box in the component.  
    Public Property Gets the dialog associated with searching for text in a cell of a sheet in this component.  
    Public Property Gets or sets which type of selections in the component the user can make.  
    Public Property Gets or sets the selection renderer for drawing selections in the component.  
    Public PropertyGets the sheets (SheetView objects) in the component.  
    Public Property Gets or sets whether to allow the user to display row error by icon in the component.  
    Public Property Gets or sets whether the drag band is displayed when moving the row or column.  
    Public Property Gets or sets whether tapping displays the gripper in edit mode.  
    Public Property Gets or sets whether to allow the user to display the cell error using an icon or sticky note in the component.  
    Public PropertyGets or sets the site of the control. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets the height and width of the control. (Inherited from System.Windows.Forms.Control)
    Public Property Gets or sets the skin for the spread.  
    Public Property Gets 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 Property Gets the status bar control of spread.  
    Public Property Gets or sets whether the status bar is enabled.  
    Public Property Gets or sets whether to suspend animations such as an animated focus renderer.  
    Public PropertyGets or sets the tab order of the control within its container. (Inherited from System.Windows.Forms.Control)
    Public Property Gets a table style collection.  
    Public PropertyGets or sets a value indicating whether the user can give the focus to this control using the TAB key. (Inherited from System.Windows.Forms.Control)
    Public Property Gets the object that represents the tab strip for this component.  
    Public Property Gets or sets whether a special tab is displayed to allow inserting new sheets.  
    Public Property Gets or sets the tabstrip insert tab image.  
    Public Property Gets or sets the location of the tab strip.  
    Public Property Gets or sets the display policy for the sheet tab strip for this component.  
    Public Property Gets or sets the width of the tab strip for this component expressed as a percentage of the overall horizontal scroll bar width.  
    Public Property Gets or sets extra data for the application for this component.  
    Public Property Gets or sets whether to tap to add selection.  
    Public Property Gets or sets the appearance of text tips in the view.  
    Public Property Gets or sets the time (in milliseconds) the component waits before displaying the text tip for the cell or header under the pointer.  
    Public Property Gets or sets whether to display text tips and cell notes and the location of the tips and notes in this component.  
    Public Property Gets or sets the collection of title information objects for Spread.  
    Public PropertyGets or sets the distance, in pixels, between the top edge of the control and the top edge of its container's client area. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets the parent control that is not parented by another Windows Forms control. Typically, this is the outermost System.Windows.Forms.Form that the control is contained in. (Inherited from System.Windows.Forms.Control)
    Public PropertyGets or sets the TouchDropDownScale to specify the zoom scale value that applies to a cell type drop-down item.  
    Public Property Gets or sets the touch selection gripper's backcolor.  
    Public Property Gets or sets the touch selection gripper's line color.  
    Public Property Gets 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 Property Gets a zoom factor group and when the zoom ends, the final zoom factor snaps to a snap point in this group.  
    Public Property Gets or sets the undo manager for this Spread component.  
    Public Property Gets or sets whether to use optimized selection for touch.  
    Public PropertyGets or sets a value indicating whether to use the wait cursor for the current control and all child controls. (Inherited from System.Windows.Forms.Control)
    Public Property Gets the vertical scroll bar.  
    Public Property Gets or Sets vertical scroll bar mode.  
    Public Property Gets or sets when to display the vertical scroll bars in this component.  
    Public Property Gets or sets the small increment for the horizontal scrollbar.  
    Public Property Gets or sets the width of vertical scroll bars in this component.  
    Public PropertyGets or sets a value indicating whether the control and all its child controls are displayed. (Inherited from System.Windows.Forms.Control)
    Public Property Gets or sets whether to use visual styles when rendering objects in the component.  
    Public PropertyGets or sets the width of the control. (Inherited from System.Windows.Forms.Control)
    Public Property Gets or sets the scaling factor of the display of the active sheet in this component.  
    Top
    Public Methods
     NameDescription
    Public MethodOverloaded.  Adds a child control to a specified sheet at the location of the specified row and column.  
    Public Method Adds a user-defined custom function (GrapeCity.CalcEngine.Function object) to the model for use in formulas.  
    Public Method Creates a new SheetView and inserts or replaces the sheet at the specified sheet index.  
    Public MethodOverloaded.  Adds a row or column of viewports.  
    Public MethodGets the coressponding GrapeCity.Spreadsheet.IWorkbook object that allows accessing to new object model and API set.  
    Public MethodAttachs a Workbook object to the spread control.  
    Public MethodOverloaded. Executes the specified delegate asynchronously on the thread that the control's underlying handle was created on. (Inherited from System.Windows.Forms.Control)
    Public MethodBrings the control to the front of the z-order. (Inherited from System.Windows.Forms.Control)
    Public Method Cancels annotation mode.  
    Public Method Cancels cell editing.  
    Public Method Clears all custom functions.  
    Public MethodRetrieves a value indicating whether the specified control is a child of the control. (Inherited from System.Windows.Forms.Control)
    Public MethodForces the creation of the visible control, including the creation of the handle and any visible child controls. (Inherited from System.Windows.Forms.Control)
    Public MethodCreates the System.Drawing.Graphics for the control. (Inherited from System.Windows.Forms.Control)
    Public Method Creates a table style based on the table style contained in the table style collection or a built-in table style.  
    Public MethodSupports rendering to the specified bitmap. (Inherited from System.Windows.Forms.Control)
    Public MethodRetrieves the return value of the asynchronous operation represented by the System.IAsyncResult passed. (Inherited from System.Windows.Forms.Control)
    Public MethodRetrieves the form that the control is on. (Inherited from System.Windows.Forms.Control)
    Public MethodSets input focus to the control. (Inherited from System.Windows.Forms.Control)
    Public Method Gets 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 Method Gets the row and column indexes of the cell at the specified pointer location.  
    Public Method Gets the rectangle of the cell.  
    Public MethodOverloaded. Retrieves the child control that is located at the specified coordinates, specifying whether to ignore child controls of a certain type. (Inherited from System.Windows.Forms.Control)
    Public Method Gets the rectangle of the column header.  
    Public MethodOverloaded.  Gets the column page breaks for the specified sheet under the current printing conditions.  
    Public Method Gets the height of the column range group.  
    Public Method Gets the rectangle of the column split bar.  
    Public Method Gets the rectangle of the column split box.  
    Public MethodOverloaded.  Gets the number of viewport columns in the active sheet.  
    Public Method Gets the index of the viewport column for the specified coordinate for the active sheet.  
    Public MethodReturns the next System.Windows.Forms.ContainerControl up the control's chain of parent controls. (Inherited from System.Windows.Forms.Control)
    Public Method Gets the pointer displayed over different areas of the component.  
    Public Method Gets a user-defined custom function from the workbook.  
    Public Method  
    Public Methodstatic (Shared in Visual Basic)Overloaded.  Gets an array of sheet names from the specified Excel stream.  
    Public Method Gets the rectangle of the column header.  
    Public Method Gets the rectangle of the filter bar.  
    Public Method Gets the rectangle of the horizontal scroll bar.  
    Public MethodOverloaded.  Gets the input map defined for the specified focus mode.  
    Public Method Gets the input map when a child control has keyboard focus.  
    Public Method Gets the input map when a shape has keyboard focus.  
    Public Method Gets the maximum cell overflow width in pixels.  
    Public MethodOverloaded.  Gets the column page breaks for the specified sheet under the current printing conditions.  
    Public Method Gets the printing information required to print a given sheet into the supplied rectangle.  
    Public Method Gets 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 MethodRetrieves the size of a rectangular area into which a control can be fitted. (Inherited from System.Windows.Forms.Control)
    Public Method Gets the number of pages required to print the specified sheet.  
    Public Method Gets the print preview dialog.  
    Public Method Gets the main workbook associated with the Spread component.  
    Public Method Gets the rectangle of the row header.  
    Public MethodOverloaded.  Gets the row page breaks for the specified sheet under the current printing conditions.  
    Public Method Gets the width of the row range group.  
    Public Method Gets the rectangle of the row split bar.  
    Public Method Gets the rectangle of the row split box.  
    Public MethodOverloaded.  Gets the number of viewport rows.  
    Public Method Gets the index of the viewport row for the specified coordinate for the active sheet.  
    Public Method Gets a sheet with a specific tag.  
    Public Method Gets the rectangle of the tab associated with a sheet.  
    Public Method Gets the rectangle of the split box on the tab strip.  
    Public Method Gets the rectangle of the tab strip.  
    Public Method Gets 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 Method Gets 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 Method Attempts to find the value for one cell that produces the desired formula result in another cell.  
    Public MethodConceals the control from the user. (Inherited from System.Windows.Forms.Control)
    Public Method Hide drag fill context menu.  
    Public Method Hides the touch keyboard.  
    Public Method Performs a hit test.  
    Public MethodOverloaded. Invalidates the specified region of the control (adds it to the control's update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control.  
    Public MethodOverloaded. Executes the specified delegate on the thread that owns the control's underlying window handle. (Inherited from System.Windows.Forms.Control)
    Public Method Returns 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 Method Opens the specified file and determines whether it meets the minimal requirements to be considered a Spread SS file.  
    Public Method Opens the specified file and determines whether it meets the minimal requirements to be considered a Spread XML file.  
    Public Method Loads 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 MethodOverloaded. Converts a Logical DPI value to its equivalent DeviceUnit DPI value. (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 Method Opens 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 MethodComputes the location of the specified screen point into client coordinates. (Inherited from System.Windows.Forms.Control)
    Public MethodComputes the location of the specified client point into screen coordinates. (Inherited from System.Windows.Forms.Control)
    Public MethodPreprocesses keyboard or input messages within the message loop before they are dispatched. (Inherited from System.Windows.Forms.Control)
    Public MethodOverloaded.  Handles the printing of the specified sheet in a separate thread.  
    Public MethodComputes the size and location of the specified screen rectangle in client coordinates. (Inherited from System.Windows.Forms.Control)
    Public MethodComputes the size and location of the specified client rectangle in screen coordinates. (Inherited from System.Windows.Forms.Control)
    Public MethodForces the control to invalidate its client area and immediately redraw itself and any child controls. (Inherited from System.Windows.Forms.Control)
    Public Method Removes a child control from the specified sheet.  
    Public Method Removes a user-defined custom function.  
    Public MethodOverloaded.  Removes a row or column of viewports.  
    Public Method Resets the component to its original state.  
    Public Method Resets the focus renderer to its original state.  
    Public Method Resets the focus renderer to its original state.  
    Public MethodResets the System.Windows.Forms.Control.Text property to its default value (System.String.Empty). (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 MethodScales a logical bitmap value to it's equivalent device unit value when a DPI change occurs. (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 MethodActivates the next control. (Inherited from System.Windows.Forms.Control)
    Public MethodSends the control to the back of the z-order. (Inherited from System.Windows.Forms.Control)
    Public Method Sets the action map, that maps action identifiers (for keystrokes) to particular actions.  
    Public MethodOverloaded.  Sets the active viewport for the active sheet.  
    Public MethodOverloaded. Sets the bounds of the control to the specified location and size. (Inherited from System.Windows.Forms.Control)
    Public Method Sets the pointer displayed over different areas of the component.  
    Public MethodOverloaded.  Sets the input map for the specified focus mode.  
    Public Method Sets the input map when a child control has keyboard focus.  
    Public Method Sets the input map when a shape has keyboard focus.  
    Public Method Sets the custom image displayed on the insert sheet tab.  
    Public Method Sets the maximum cell overflow width in pixels.  
    Public MethodSets the PrintInfo object for the specfied sheet.  
    Public Method Sets the print preview dialog.  
    Public Method Changes 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 MethodDisplays the control to the user. (Inherited from System.Windows.Forms.Control)
    Public Method Moves the active cell to the specified position in the component.  
    Public Method Moves the specified cell in the specified viewport to the specified position in the component.  
    Public Method Shows the form that is used to edit Cell Validators of selected range  
    Public Method Shows the collection editor.  
    Public Method Moves a column of cells in the specified viewport to the specified position in the component.  
    Public Method Shows the form that is used to edit DataValidation of selected range  
    Public Method Shows the dependent cells for a formula cell.  
    Public Method Displays the form used for editing custom names.  
    Public Method Displays the input map editor.  
    Public Method Displays 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 Method Shows the cells that are referred to by formulas in other cells.  
    Public Method Moves a row in the specified viewport to the specified position in the component.  
    Public Method Displays the touch keyboard.  
    Public MethodOverloaded.  Starts annotation mode.  
    Public Method Starts cell editing.  
    Public MethodOverloaded.  Starts ink notation in the active viewport if the Microsoft.Ink assembly is found in the GAC.  
    Public Method Stops annotation mode.  
    Public Method Stops cell editing.  
    Public Method Temporarily suspends the layout logic for this component.  
    Public Method (Inherited from System.ComponentModel.Component)
    Public Method This function will notify all cells, which contains volatile functions or belong to a circuit, to recalculate.  
    Public MethodCauses the control to redraw the invalidated regions within its client area. (Inherited from System.Windows.Forms.Control)
    Top
    Public Events
     NameDescription
    Public Event Occurs when the user has changed the active sheet.  
    Public Event Occurs when the user changes the active sheet.  
    Public Event Occurs when the user has changed the active SpreadView.  
    Public Event Occurs when the user changes the active SpreadView.  
    Public Event Occurs when the user tries to advance from the first or last row in Spread.  
    Public EventOccurs when the AllowUserToZoom property has changed.  
    Public Event Occurs when the user ends annotation mode.  
    Public Event Occurs when the user begins annotation mode.  
    Public Event Occurs when a column has just been automatically filtered.  
    Public Event Occurs when a column is about to be automatically filtered.  
    Public Event Occurs when the AutoScrollWhenKeyboardShowing property is changed.  
    Public Event Occurs when a column has just been automatically sorted.  
    Public Event Occurs when a column is about to be automatically sorted.  
    Public EventOccurs when the value of the System.Windows.Forms.Control.BackColor property changes. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the value of the System.Windows.Forms.Control.BackgroundImage property changes. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the System.Windows.Forms.Control.BackgroundImageLayout property changes. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when an object is right-clicked, before the default right-click action.  
    Public Event  
    Public EventOccurs when the value of the System.Windows.Forms.BindingContext property changes. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the BoundaryFeedbackMode property has changed.  
    Public Event Occurs when the user clicks a button, check box, or hyperlink in a cell.  
    Public EventOccurs when the value of the System.Windows.Forms.Control.CausesValidation property changes. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when the user presses the left mouse button down in a cell.  
    Public Event Occurs when the user presses the left mouse button down twice (double-clicks) in a cell.  
    Public Event Occurs when the cell error text has changed.  
    Public Event Occurs when cell validate infomation is needed.  
    Public Event Occurs after the user modifies data in a cell.  
    Public EventOccurs when the focus or keyboard user interface (UI) cues change. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when the chart indicator is activated.  
    Public Event Occurs when the chart indicator is deactivated.  
    Public Event Occurs when a child control is activated.  
    Public Event Occurs when a child control is deactivated.  
    Public Event Occurs when a child view of the Spread component is created.  
    Public Event Occurs when a child workbook of the Spread component is created.  
    Public Event Occurs when circular cell(s) is changed.  
    Public Event Occurs when one or more circular reference is created.  
    Public EventOccurs when the value of the System.Windows.Forms.Control.ClientSize property changes. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when a Clipboard change occurs that can affect the FarPoint Spread component.  
    Public Event Occurs when the Clipboard is changing through a Spread action.  
    Public Event Occurs when the user pastes from the clipboard.  
    Public Event Occurs when the user pastes from the clipboard.  
    Public EventOccurs when AllowColumnMove is true and the user drags to move a column.  
    Public Event Occurs when the user finishes moving a column by dragging.  
    Public Event Occurs when a viewport column width has changed.  
    Public Event Occurs when the column width has changed.  
    Public Event Occurs when the column width is changing.  
    Public Event Occurs when the user closes a combo box in a cell.  
    Public Event Occurs when the user drops down a combo box in a cell.  
    Public Event Occurs when the user changes the selection in a combo box in a cell.  
    Public EventOccurs when the value of the System.Windows.Forms.Control.ContextMenu property changes. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the value of the System.Windows.Forms.Control.ContextMenuStrip property changes. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when a new control is added to the System.Windows.Forms.Control.ControlCollection. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when a control is removed from the System.Windows.Forms.Control.ControlCollection. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the value of the System.Windows.Forms.Control.Cursor property changes. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when the custom name of the data model changes.  
    Public Event Occurs when the sheet is binding a column to a data source after it has been initialized.  
    Public Event Occurs during message preprocessing of dialog characters.  
    Public Event Occurs during message preprocessing of dialog keys.  
    Public Event (Inherited from System.ComponentModel.Component)
    Public EventOccurs when the value of the System.Windows.Forms.Control.Dock property changes. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the control is double-clicked. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the DPI setting for a control is changed programmatically after the DPI of its parent control or form has changed. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the DPI setting for a control is changed programmatically before a DPI change event for its parent control or form has occurred. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when a drag-and-drop operation is completed. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when the user drags and drops a range of cells.  
    Public Event Occurs at the completion of the user dragging and dropping a range of cells.  
    Public EventOccurs when an object is dragged into the control's bounds. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when the user drags to fill a range of cells.  
    Public Event Occurs at the completion of the user dragging to fill a range of cells.  
    Public EventOccurs when an object is dragged out of the control's bounds. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when an object is dragged over the control's bounds. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when the user changes the text in a cell in edit mode.  
    Public Event Occurs when the user performs an invalid input operation.  
    Public Event Occurs when edit mode is stopped.  
    Public Event Occurs when edit mode is started.  
    Public Event Occurs when edit mode is about to start in the active sheet's active cell.  
    Public Event Occurs when the editing control gets focus.  
    Public EventOccurs when the System.Windows.Forms.Control.Enabled property value has changed. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the control is entered. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when the user enters a cell.  
    Public Event Occurs when the user performs an invalid operation.  
    Public Event Occurs when a row is expanded or collapsed.  
    Public Event Occurs when the user presses the left mouse button in a filter bar cell.  
    Public Event Occurs when the user presses the left mouse button down twice (double-clicks) in a filter bar cell.  
    Public Event Occurs when the user selects a value from the drop-down list in the filter bar editor.  
    Public EventOccurs when the System.Windows.Forms.Control.Font property value changes. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs during a drag operation. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the control receives focus. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when the grouping is finished.  
    Public Event Occurs when the user performs grouping.  
    Public EventOccurs when a handle is created for the control. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the control's handle is in the process of being destroyed. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the HeaderIndicatorPositionAdjusting property has changed.  
    Public EventOccurs when the user requests help for a control. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when the user clicks on hyper link text.  
    Public EventOccurs when the System.Windows.Forms.Control.ImeMode property has changed. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when the InputScope property is changed.  
    Public EventOccurs when a control's display requires redrawing. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when a key is pressed while the control has focus. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when a character. space or backspace key is pressed while the control has focus. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when a key is released while the control has focus. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when a control should reposition its child controls. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the input focus leaves the control. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when the user leaves a cell.  
    Public Event Occurs when the left column changes.  
    Public EventOccurs when the System.Windows.Forms.Control.Location property value has changed. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the control loses focus. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the control's margin changes. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the control loses mouse capture. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the control is clicked by the mouse. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the control is double clicked by the mouse. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the mouse pointer is over the control and a mouse button is pressed. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the mouse pointer enters the control. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the mouse pointer rests on the control. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the mouse pointer leaves the control. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the mouse pointer is moved over the control. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the mouse pointer is over the control and a mouse button is released. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the mouse wheel moves while the control has focus. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the control is moved. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the control's padding changes. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the control is redrawn. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when the gray area needs painting.  
    Public Event Occurs when the group bar background is painted.  
    Public Event Occurs when the tab strip needs painting.  
    Public Event Occurs when a TabStrip button needs painting.  
    Public Event Occurs when a TabStrip tab needs painting.  
    Public EventOccurs when the PanningMode property has changed.  
    Public EventOccurs when the System.Windows.Forms.Control.Parent property value changes. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs before the System.Windows.Forms.Control.KeyDown event when a key is pressed while focus is on this control. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when the user customizes the preview row of the Spread component.  
    Public Event Occurs continually as printing occurs in order to give the user the opportunity to discontinue a print job.  
    Public Event Occurs before each page is printed.  
    Public Event Occurs when a print job is discontinued by the user.  
    Public Event Occurs when printing a sheet.  
    Public Event Occurs when the header or footer needs printing.  
    Public Event Occurs before and after a print job.  
    Public Event Occurs before the preview dialog appears.  
    Public EventOccurs when System.Windows.Forms.AccessibleObject is providing help to accessibility applications. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs during a drag-and-drop operation and enables the drag source to determine whether the drag-and-drop operation should be canceled. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when the user has changed the state of the row or column outline (range group).  
    Public Event Occurs before the user changes the state of row or column outlines (range group).  
    Public EventOccurs when the value of the System.Windows.Forms.Control.Region property changes. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the control is resized. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the ResizeZeroIndicator property has changed.  
    Public EventOccurs when the System.Windows.Forms.Control.RightToLeft property value changes. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when AllowRowMove is true and the user drags to move a row.  
    Public Event Occurs when the user finishes moving a row by dragging.  
    Public Event Occurs when the row error text has changed.  
    Public Event Occurs when the row height has changed.  
    Public Event Occurs when the column width is changing.  
    Public Event Occurs when a viewport row height has changed.  
    Public Event Occurs when the user scrolls the Spread component.  
    Public Event Occurs when the search form is closing.  
    Public Event Occurs when the selection of cells on the sheet has changed.  
    Public Event Occurs when the selection of cells on the sheet is changing.  
    Public Event Occurs when the user changes the active shape object.  
    Public Event Occurs when the user deactivates the active shape object.  
    Public Event Occurs right after the user finishes drag-moving the sheet to another index.  
    Public Event Occurs when the user drag-move the sheet name tab to move sheet.  
    Public Event Occurs when the user clicks the sheet tab.  
    Public Event Occurs when the user double-clicks the sheet tab.  
    Public Event Occurs when the ShowGrippersInEditingStatus value is changed.  
    Public EventOccurs when the System.Windows.Forms.Control.Size property value changes. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when spread is sorted.  
    Public Event Occurs when spread is sorting.  
    Public EventOccurs when the control style changes. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when a subeditor is closed for a cell.  
    Public Event Occurs when a subeditor is about to be displayed.  
    Public EventOccurs when the system colors change. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the System.Windows.Forms.Control.TabIndex property value changes. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when the table changes.  
    Public EventOccurs when the System.Windows.Forms.Control.TabStop property value changes. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs when the TapToAddSelection property is changed.  
    Public EventOccurs when the System.Windows.Forms.Control.Text property value changes. (Inherited from System.Windows.Forms.Control)
    Public Event Occurs 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 Event Occurs when the top row changes.  
    Public EventOccurs when the TouchDropDownScale property has changed.  
    Public Event Occurs when the TouchSelectionGripperBackColor is changed.  
    Public Event Occurs when TouchSelectionGripperLineColor is changed.  
    Public Event Occurs 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 Event Occurs when all the grouping is removed.  
    Public Event Occurs when the UseOptimizedSelectionForTouch is changed.  
    Public Event Occurs when the user types a formula.  
    Public Event Occurs when the user zooms.  
    Public EventOccurs when the control is finished validating. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the control is validating. (Inherited from System.Windows.Forms.Control)
    Public EventOccurs when the System.Windows.Forms.Control.Visible property value changes. (Inherited from System.Windows.Forms.Control)
    Top
    See Also