Spread for ASP.NET 11 Product Documentation
FpSpread Class Methods


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

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

Public Methods
 NameDescription
Public Method (Inherited from System.Web.UI.WebControls.WebControl)
Public Method (Inherited from System.Web.UI.Control)
Public MethodDiscards the editing values in the Spread component.  
Public Method (Inherited from System.Web.UI.WebControls.WebControl)
Public MethodOverloaded. Overridden. Binds a data source to the Spread component.  
Public MethodOverloaded. Overridden. Searches the current naming container for a server control with the specified id and integer, specified in the pathOffset parameter, which aids in the search. You should not override this version of the Overload:System.Web.UI.Control.FindControl method.  
Public Method (Inherited from System.Web.UI.Control)
Public MethodReturns the client column index for the specified column.  
Public MethodGets the postback value of the specified cell on the active sheet in the Spread component.  
Public Methodstatic (Shared in Visual Basic)Overloaded. Gets an array of sheet names from the specified Excel file from a stream.  
Public MethodGets the image in the component.  
Public MethodGets the merged cell range at the specified cell.  
Public MethodGets the merged cell ranges in the specified range.  
Public MethodReturns the page index the specified row is rendered in.  
Public MethodOverloaded.  (Inherited from System.Web.UI.Control)
Public MethodReturns the client row index for the specified row.  
Public MethodGets the text of the sheet name tab at the specified sheet in the Spread component.  
Public Method (Inherited from System.Web.UI.Control)
Public MethodAttempts to find values for one cell that will produce the desired formula result in another cell.  
Public MethodScrolls through the sheet in the component to the specified page.  
Public Method (Inherited from System.Web.UI.Control)
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 an Excel-compatible stream.  
Public MethodDetermines whether the component is under strict standards-compliant mode.  
Public MethodLoads formulas that are deserialized, but not parsed yet, to be used after all sheets have been created and deserialized.  
Public Method (Inherited from System.Web.UI.WebControls.WebControl)
Public MethodOverloaded. Opens a saved Spread XML file and loads it into the Spread component.  
Public MethodOverloaded. Opens an Excel stream and loads the specified Excel sheet into the specified sheet of the Spread component including the specified parts.  
Public MethodForces spread to recreate its content.  
Public MethodResets the Spread component to its default values, removing all settings and all sheets.  
Public Method (Inherited from System.Web.UI.Control)
Public Method (Inherited from System.Web.UI.Control)
Public MethodOverloaded. Saves the contents of the Spread component to XML in the specified file.  
Public MethodSaves the changes to the Spread component.  
Public MethodOverloaded. Saves the contents of the Spread component to the specified Excel file in a stream.  
Public MethodOverloaded. Saves the contents of the Spread component to a Response object in Excel file format with default settings.  
Public MethodOverloaded. Handles the export (or printing) of the specified sheet to PDF as a stream.  
Public MethodOverloaded. Saves the contents of the Spread component to a Response object in PDF file format.  
Public MethodOverloaded. Searches the text in the 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 with the specified criteria.  
Public MethodSets the custom image in the specified part of the Spread component interface.  
Public MethodChanges the protect structure setting with the password parameter.  
Public MethodTests to see if the value is valid for a cell in the active sheet in the Spread component.  
Top
Protected Methods
 NameDescription
Protected Method (Inherited from System.Web.UI.Control)
Protected Method (Inherited from System.Web.UI.Control)
Protected Method (Inherited from System.Web.UI.Control)
Protected Method (Inherited from System.Web.UI.Control)
Protected Method (Inherited from System.Web.UI.Control)
Protected MethodOverridden. Creates the child controls.  
Protected Method (Inherited from System.Web.UI.Control)
Protected Method (Inherited from System.Web.UI.WebControls.WebControl)
Protected Method (Inherited from System.Web.UI.Control)
Protected Method (Inherited from System.Web.UI.Control)
Protected Method (Inherited from System.Web.UI.Control)
Protected Method (Inherited from System.Web.UI.Control)
Protected MethodGroups the rows in the specified column.  
Protected Method (Inherited from System.Web.UI.Control)
Protected Method (Inherited from System.Web.UI.Control)
Protected MethodOverridden. Loads the view state of the Spread component.  
Protected MethodMoves the column from one location to another as specified.  
Protected MethodMoves the row from one location to another as specified.  
Protected Method (Inherited from System.Web.UI.Control)
Protected MethodRaises the MenuItemClicked event.  
Protected MethodOverloaded. Processes the PrintPDF command in the Spread component.  
Protected MethodProcesses the SaveExcel command in the Spread component.  
Protected MethodRaises the TouchStripItemClicked event.  
Protected MethodRearranges the order of grouping based on the movement of the specified column.  
Protected MethodRemoves the grouping for the specified column and moves the column to the specified location.  
Protected MethodOverridden. Renders the Spread component in HTML.  
Protected MethodOverridden. Outputs the content of a server control's children to a provided System.Web.UI.HtmlTextWriter object, which writes the content to be rendered on the client.  
Protected Method (Inherited from System.Web.UI.Control)
Protected MethodOverridden. Saves the view state of the component.  
Protected Method (Inherited from System.Web.UI.Control)
Protected MethodOverridden. Invokes child IStateManager object TrackViewState() method to start tracking.  
Protected MethodUpdates the column width and the row height.  
Top
See Also

Reference

FpSpread Class
FarPoint.Web.Spread Namespace

User-Task Documentation

Customizing the Appearance of the Overall Control
Customizing the Interaction of the Overall Component
Customizing Interaction Based on Events