Spread for ASP.NET 12 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 MethodCopies any nonblank elements of the specified style to the Web control, overwriting any existing style elements of the control. This method is primarily used by control developers. (Inherited from System.Web.UI.WebControls.WebControl)
Public MethodApplies the style properties defined in the page style sheet to the control. (Inherited from System.Web.UI.Control)
Public MethodDiscards the editing values in the Spread component.  
Public MethodCopies the properties not encapsulated by the System.Web.UI.WebControls.WebControl.Style object from the specified Web server control to the Web server control that this method is called from. This method is used primarily by control developers. (Inherited from System.Web.UI.WebControls.WebControl)
Public MethodOverloaded. Creates a new design-time view of the Spread component.  
Public MethodOverloaded. Overridden. Binds a data source to the Spread component.  
Public MethodOverridden. Cleans up any resources being used.  
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 MethodSets input focus to a control. (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. Gets the URL that corresponds to a set of route parameters. (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 MethodReturns the prefixed portion of the System.Web.UI.Control.UniqueID property of the specified control. (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 MethodDetermines if the server control contains any child controls. (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 MethodCopies any nonblank elements of the specified style to the Web control, but will not overwrite any existing style elements of the control. This method is used primarily by control developers. (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 MethodOverridden. Adds the CSS style atttributes to the specified HTML writer.  
Public MethodOverloaded. Renders the spreadsheet component to the specified HtmlTextWriter object.  
Public MethodOverridden. Appends the CSS style name to the specified HTML writer.  
Public MethodResets the Spread component to its default values, removing all settings and all sheets.  
Public MethodGets a URL that can be used by the browser. (Inherited from System.Web.UI.Control)
Public MethodConverts a URL into one that is usable on the requesting client. (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 MethodAssigns an event handler delegate to render the server control and its content into its parent control. (Inherited from System.Web.UI.Control)
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 MethodAdds HTML attributes and styles that need to be rendered to the specified System.Web.UI.HtmlTextWriterTag. This method is used primarily by control developers. (Inherited from System.Web.UI.WebControls.WebControl)
Protected MethodOverridden. Handles the event when a DIRECT child control is added to Spread Controls collection. Changes its ClientIDMode to ClientIDMode.Predictable to make spread client script run correctly in NET40 or above environment.  
Protected MethodOverridden. Adds the Spread component to the child control collection.  
Protected MethodGathers information about the server control and delivers it to the System.Web.UI.Page.Trace property to be displayed when tracing is enabled for the page. (Inherited from System.Web.UI.Control)
Protected MethodSets the cached System.Web.UI.Control.ClientID value to a null reference (Nothing in Visual Basic). (Inherited from System.Web.UI.Control)
Protected MethodDeletes the control-state information for the server control's child controls. (Inherited from System.Web.UI.Control)
Protected MethodDeletes the view-state and control-state information for all the server control's child controls. (Inherited from System.Web.UI.Control)
Protected MethodDeletes the view-state information for all the server control's child controls. (Inherited from System.Web.UI.Control)
Protected MethodSets the System.Web.UI.Control.ClientIDMode property of the current control instance and of any child controls to System.Web.UI.ClientIDMode.Inherit. (Inherited from System.Web.UI.Control)
Protected MethodOverridden. Creates the child controls.  
Protected MethodCreates a new System.Web.UI.ControlCollection object to hold the child controls (both literal and server) of the server control. (Inherited from System.Web.UI.Control)
Protected MethodCreates the style object that is used internally by the System.Web.UI.WebControls.WebControl class to implement all style related properties. This method is used primarily by control developers. (Inherited from System.Web.UI.WebControls.WebControl)
Protected MethodBinds a data source to the server control's child controls. (Inherited from System.Web.UI.Control)
Protected MethodDetermines whether the server control contains child controls. If it does not, it creates child controls. (Inherited from System.Web.UI.Control)
Protected MethodCreates an identifier for controls that do not have an identifier assigned. (Inherited from System.Web.UI.Control)
Protected MethodFlushes the data.  
Protected MethodGets design-time data for a control. (Inherited from System.Web.UI.Control)
Protected MethodGroups the rows in the specified column.  
Protected MethodReturns a value indicating whether events are registered for the control or any child controls. (Inherited from System.Web.UI.Control)
Protected MethodDetermines if the server control holds only literal content. (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 MethodProcesses the Add command in the Spread component.  
Protected MethodDetermines whether the event for the server control is passed up the page's UI server control hierarchy. (Inherited from System.Web.UI.Control)
Protected MethodProcesses the specified button command for the cell at the specified row and column in the Spread component.  
Protected MethodProcesses the Cancel command in the Spread component.  
Protected MethodProcesses the click on a cell at the specified row and column in the Spread component.  
Protected MethodDisplays the specified child view in the Spread component.  
Protected MethodProcesses a click on a column header cell at the specified row and column in the Spread component.  
Protected MethodRaises the System.Web.UI.Control.DataBinding event. (Inherited from System.Web.UI.Control)
Protected MethodProcesses the Delete command in the Spread component.  
Protected MethodProcesses the Edit command in the Spread component.  
Protected MethodDisplays the child view in the component at the specified row.  
Protected MethodOccurs when the first page is reached.  
Protected MethodOverridden. Initializes the Spread component.  
Protected MethodProcesses the Insert command at the specified row in the Spread component.  
Protected MethodOccurs when the last page is reached.  
Protected MethodOverridden. Occurs when the Load event is raised.  
Protected MethodOccurs when an incremental load to the client occurs for load on demand.  
Protected MethodRaises the MenuItemClicked event.  
Protected MethodProcesses the Next Page command in the Spread component.  
Protected MethodProcesses the Page command for the Spread component.  
Protected MethodOverridden. Pre-renders the Spread component and creates the child controls.  
Protected MethodProcesses the Previous Page command in the Spread component.  
Protected MethodProcesses the Print command in the Spread component.  
Protected MethodOverloaded. Processes the PrintPDF command in the Spread component.  
Protected MethodProcesses a click on a row header cell at the specified row and column in the Spread component.  
Protected MethodProcesses the SaveExcel command in the Spread component.  
Protected MethodSelects the specified row in the Spread component.  
Protected MethodSwitches to a different sheet in the Spread component.  
Protected MethodProcesses the Column Sort command for the specified column in the Spread component.  
Protected MethodScrolls the tabs to the right in the Spread component.  
Protected MethodScrolls the tabs to the left in the Spread component.  
Protected MethodRaises the TouchStripItemClicked event.  
Protected MethodProcesses the Update command and updates the Spread component.  
Protected MethodProcesses the Update command for a down-level browser and updates the Spread component.  
Protected MethodProcesses the Update command for the RenderEditors mode in the Spread component.  
Protected MethodHandles the update of the editing template.  
Protected MethodHandles the Update command (and updates the Spread component) for the up-level browser (IE5.5 or above).  
Protected MethodAssigns any sources of the event and its information to the control's parent. (Inherited from System.Web.UI.Control)
Protected MethodRearranges the order of grouping based on the movement of the specified column.  
Protected MethodOverridden. Called after a child control is removed from the System.Web.UI.Control.Controls collection of the System.Web.UI.Control object.  
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 MethodGets the control adapter responsible for rendering the specified control. (Inherited from System.Web.UI.Control)
Protected MethodOverridden. Saves the view state of the component.  
Protected MethodSets design-time data for a control. (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