Spread Windows Forms 12.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 ConstructorOverloaded.   
Top
Public Properties
 NameDescription
Public PropertyGets 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 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 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 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 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 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 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 PropertyGets 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 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 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 PropertyGets 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 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 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 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 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.   
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 PropertyGets 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 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 PropertyGets, or Sets the default Skin that will be used for painting.  
Public Property (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 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 PropertyGets or sets a value indicating whether the control can respond to user interaction. (Inherited from System.Windows.Forms.Control)
Public PropertyGets or sets a value to show drag fill button and drag fill context menu.  
Public PropertyGets a value indicating whether the control has input focus. (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 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 PropertyGets 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 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 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 PropertyReturns 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 PropertySpecifies 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 PropertyGets 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 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 PropertyGets or sets padding within the control. (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 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 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 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 PropertyGets 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 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 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 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 PropertyGets or sets the tab order of the control within its container. (Inherited from System.Windows.Forms.Control)
Public PropertyGets 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 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 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 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 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 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 PropertyGets or sets a value indicating whether the control and all its child controls are displayed. (Inherited from System.Windows.Forms.Control)
Public PropertyGets 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 PropertyGets or sets the scaling factor of the display of the active sheet in this component.  
Top
Protected Properties
 NameDescription
Protected PropertyGets a value indicating whether the System.Windows.Forms.Control.ImeMode property can be set to an active value, to enable IME support. (Inherited from System.Windows.Forms.Control)
Protected PropertyDetermines if events can be raised on the control. (Inherited from System.Windows.Forms.Control)
Protected PropertyGets or sets the default cursor for the control. (Inherited from System.Windows.Forms.Control)
Protected PropertyGets the default Input Method Editor (IME) mode supported by the control. (Inherited from System.Windows.Forms.Control)
Protected PropertyGets the space, in pixels, that is specified by default between controls. (Inherited from System.Windows.Forms.Control)
Protected PropertyGets the length and height, in pixels, that is specified as the default maximum size of a control. (Inherited from System.Windows.Forms.Control)
Protected PropertyGets the length and height, in pixels, that is specified as the default minimum size of a control. (Inherited from System.Windows.Forms.Control)
Protected PropertyGets the internal spacing, in pixels, of the contents of a control. (Inherited from System.Windows.Forms.Control)
Protected PropertyOverridden. Gets the default size of the component.  
Protected PropertyGets or sets a value indicating whether this control should redraw its surface using a secondary buffer to reduce or prevent flicker. (Inherited from System.Windows.Forms.Control)
Protected Property (Inherited from System.ComponentModel.Component)
Protected PropertyGets or sets the height of the font of the control. (Inherited from System.Windows.Forms.Control)
Protected PropertyOverridden. Gets or sets IME mode base.  
Protected PropertyGets or sets a value indicating whether the control redraws itself when resized. (Inherited from System.Windows.Forms.Control)
Top
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 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 MethodCancels annotation mode.  
Public MethodCancels cell editing.  
Public MethodClears 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 MethodCreates 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 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. 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 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 MethodReturns the next System.Windows.Forms.ContainerControl up the control's chain of parent controls. (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 MethodRetrieves the size of a rectangular area into which a control can be fitted. (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 MethodConceals the control from the user. (Inherited from System.Windows.Forms.Control)
Public MethodHide drag fill context menu.  
Public MethodHides the touch keyboard.  
Public MethodPerforms 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. (Inherited from System.Windows.Forms.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 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 saved XML from a stream.  
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 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 MethodRemoves a child control from the specified sheet.  
Public MethodRemoves a user-defined custom function.  
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 MethodResets the System.Windows.Forms.Control.Text property to its default value. (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 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 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. Sets the bounds of the control to the specified location and size. (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 and operation 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 MethodDisplays the control to the user. (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 MethodCauses the control to redraw the invalidated regions within its client area. (Inherited from System.Windows.Forms.Control)
Top
Protected Methods
 NameDescription
Protected MethodCreates a new accessibility object for the control. (Inherited from System.Windows.Forms.Control)
Protected MethodCreates a new instance of the control collection for the control. (Inherited from System.Windows.Forms.Control)
Protected MethodCreates a handle for the control. (Inherited from System.Windows.Forms.Control)
Protected MethodDestroys the handle associated with the control. (Inherited from System.Windows.Forms.Control)
Protected MethodThe destructor method  
Protected MethodRetrieves the specified System.Windows.Forms.AccessibleObject. (Inherited from System.Windows.Forms.Control)
Protected MethodRetrieves a value indicating how a control will behave when its System.Windows.Forms.Control.AutoSize property is enabled. (Inherited from System.Windows.Forms.Control)
Protected MethodRetrieves the bounds within which the control is scaled. (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.ComponentModel.Component)
Protected MethodRetrieves the value of the specified control style bit for the control. (Inherited from System.Windows.Forms.Control)
Protected MethodDetermines if the control is a top-level control. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.GotFocus event for the specified control. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.LostFocus event for the specified control. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.Click event for the specified control. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.Paint event for the specified control. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the PaintBackground event for the specified control. (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. Creates a shallow copy of the current System.MarshalByRefObject object. (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 MethodRaises the System.Windows.Forms.Control.AutoSizeChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the AutoSortedColumn event.  
Protected MethodRaises the AutoSortingColumn event.  
Protected MethodRaises the System.Windows.Forms.Control.BackColorChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.BackgroundImageChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.BackgroundImageLayoutChanged event. (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 MethodRaises the System.Windows.Forms.Control.Click event. (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 MethodRaises the System.Windows.Forms.Control.ContextMenuStripChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the ControlRemoved event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.CursorChanged event. (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 MethodRaises the System.Windows.Forms.Control.DragDrop event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the DragDropBlock event.  
Protected MethodRaises the DragDropBlockCompleted event.  
Protected MethodRaises the System.Windows.Forms.Control.DragEnter event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the DragFillBlock event.  
Protected MethodRaises the DragFillBlockCompleted event.  
Protected MethodRaises the System.Windows.Forms.Control.DragLeave event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.DragOver event. (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 MethodRaises the System.Windows.Forms.Control.Enter event. (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 MethodRaises the System.Windows.Forms.Control.FontChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.ForeColorChanged event. (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 MethodRaises the System.Windows.Forms.Control.Invalidated event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.Layout event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.Leave event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the LeaveCell event.  
Protected MethodRaises the System.Windows.Forms.Control.LocationChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.MarginChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.MouseCaptureChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.MouseClick event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.MouseDoubleClick event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.Move event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.PaddingChanged event. (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 MethodRaises the System.Windows.Forms.Control.BackColorChanged event when the System.Windows.Forms.Control.BackColor property value of the control's container changes. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.BackgroundImageChanged event when the System.Windows.Forms.Control.BackgroundImage property value of the control's container changes. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.BindingContextChanged event when the System.Windows.Forms.Control.BindingContext property value of the control's container changes. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.ParentChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.CursorChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.EnabledChanged event when the System.Windows.Forms.Control.Enabled property value of the control's container changes. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.FontChanged event when the System.Windows.Forms.Control.Font property value of the control's container changes. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.ForeColorChanged event when the System.Windows.Forms.Control.ForeColor property value of the control's container changes. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.RightToLeftChanged event when the System.Windows.Forms.Control.RightToLeft property value of the control's container changes. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.VisibleChanged event when the System.Windows.Forms.Control.Visible property value of the control's container changes. (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden. Processes PreviewKeyDown event.  
Protected MethodRaises the PreviewRowFetch event.  
Protected MethodRaises the System.Windows.Forms.Control.Paint event. (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 MethodRaises the System.Windows.Forms.Control.QueryContinueDrag event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the RangeGroupStateChanged event.  
Protected MethodRaises the RangeGroupStateChanging event.  
Protected MethodRaises the System.Windows.Forms.Control.RegionChanged event. (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 MethodRaises the System.Windows.Forms.Control.SizeChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the Sorted event.  
Protected MethodRaises the Sorting event.  
Protected MethodRaises the System.Windows.Forms.Control.StyleChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the SubEditorClosed event.  
Protected MethodRaises the SubEditorOpening event.  
Protected MethodRaises the System.Windows.Forms.Control.SystemColorsChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.TabIndexChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the System.Windows.Forms.Control.TabStopChanged event. (Inherited from System.Windows.Forms.Control)
Protected MethodRaises the TapToAddSelectionChanged event.  
Protected MethodRaises the System.Windows.Forms.Control.TextChanged event. (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 MethodRaises the System.Windows.Forms.Control.Validated event. (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden. Raises the Validating event.  
Protected MethodOverridden. Raises the VisibleChanged event.  
Protected MethodForces the re-creation of the handle for the control. (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodOverloaded. Converts the specified System.Windows.Forms.HorizontalAlignment to the appropriate System.Windows.Forms.HorizontalAlignment to support right-to-left text. (Inherited from System.Windows.Forms.Control)
Protected MethodConverts the specified System.Windows.Forms.HorizontalAlignment to the appropriate System.Windows.Forms.HorizontalAlignment to support right-to-left text. (Inherited from System.Windows.Forms.Control)
Protected MethodConverts the specified System.Windows.Forms.LeftRightAlignment to the appropriate System.Windows.Forms.LeftRightAlignment to support right-to-left text. (Inherited from System.Windows.Forms.Control)
Protected MethodOverridden.   
Protected MethodSets a value indicating how a control will behave when its System.Windows.Forms.Control.AutoSize property is enabled. (Inherited from System.Windows.Forms.Control)
Protected MethodPerforms the work of setting the specified bounds of this control. (Inherited from System.Windows.Forms.Control)
Protected MethodSets the size of the client area of the control. (Inherited from System.Windows.Forms.Control)
Protected MethodSets a specified System.Windows.Forms.ControlStyles flag to either true or false. (Inherited from System.Windows.Forms.Control)
Protected MethodSets the control as the top-level control. (Inherited from System.Windows.Forms.Control)
Protected MethodSets the control to the specified visible state. (Inherited from System.Windows.Forms.Control)
Protected Method (Inherited from System.Windows.Forms.Control)
Protected MethodForces the assigned styles to be reapplied to the control. (Inherited from System.Windows.Forms.Control)
Protected MethodUpdates the control in its parent's z-order. (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 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  
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 EventOccurs 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 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 EventOccurs when the focus or keyboard user interface (UI) cues change. (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 EventOccurs when the value of the System.Windows.Forms.Control.ClientSize property changes. (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 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 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 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 Event (Inherited from System.Windows.Forms.Control)
Public Event (Inherited from System.Windows.Forms.Control)
Public EventOccurs when a drag-and-drop operation is completed. (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 EventOccurs when an object is dragged into the control's bounds. (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 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 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 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 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 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 EventOccurs when the grouping is finished.  
Public EventOccurs 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 EventOccurs 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 EventOccurs 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 EventOccurs when the user leaves a cell.  
Public EventOccurs 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 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 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 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 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 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 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 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 EventOccurs when the System.Windows.Forms.Control.Size property value changes. (Inherited from System.Windows.Forms.Control)
Public EventOccurs when spread is sorted.  
Public EventOccurs when spread is sorting.  
Public EventOccurs when the control style changes. (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 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 EventOccurs when the table changes.  
Public EventOccurs when the System.Windows.Forms.Control.TabStop property value changes. (Inherited from System.Windows.Forms.Control)
Public EventOccurs 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 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 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

Reference

FpSpread Class
FarPoint.Win.Spread Namespace

User-Task Documentation

Customizing the Appearance
Customizing the User Interaction