For a list of all members of this type, see FpSpread members.
Public Methods
| Name | Description | |
|---|---|---|
 | ApplyStyle | Copies 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) |
| ApplyStyleSheetSkin | Applies the style properties defined in the page style sheet to the control. (Inherited from System.Web.UI.Control) |
| CancelEdit | Discards the editing values in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| CopyBaseAttributes | Copies 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) |
| CreateDesignView | Overloaded. Creates a new design-time view of the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| DataBind | Overloaded. Binds a data source to the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| Dispose | Cleans up any resources being used. (Inherited from FarPoint.Web.Spread.FpSpread) |
| FindControl | Overloaded. Searches the current naming container for a server control with the specified id parameter. (Inherited from System.Web.UI.Control) |
| Focus | Sets input focus to a control. (Inherited from System.Web.UI.Control) |
| GetColumnIndex | Returns the client column index for the specified column. (Inherited from FarPoint.Web.Spread.FpSpread) |
| GetEditValue | Gets the postback value of the specified cell on the active sheet in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| GetImage | Gets the image in the component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| GetMergeCell | Gets the merged cell range at the specified cell. (Inherited from FarPoint.Web.Spread.FpSpread) |
| GetMergeCells | Gets the merged cell ranges in the specified range. (Inherited from FarPoint.Web.Spread.FpSpread) |
| GetPageIndex | Returns the page index the specified row is rendered. (Inherited from FarPoint.Web.Spread.FpSpread) |
| GetRouteUrl | Overloaded. Gets the URL that corresponds to a set of route parameters. (Inherited from System.Web.UI.Control) |
| GetRowIndex | Returns the client row index for the specified row. (Inherited from FarPoint.Web.Spread.FpSpread) |
| GetTabText | Gets the text of the sheet name tab at the specified sheet in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| GetUniqueIDRelativeTo | Returns the prefixed portion of the System.Web.UI.Control.UniqueID property of the specified control. (Inherited from System.Web.UI.Control) |
| GoalSeek | Attempt to find value for one cell that will produce desired formula result in another cell. (Inherited from FarPoint.Web.Spread.FpSpread) |
| GotoPage | Scrolls through the sheet in the component to the specified page. (Inherited from FarPoint.Web.Spread.FpSpread) |
| HasControls | Determines if the server control contains any child controls. (Inherited from System.Web.UI.Control) |
| IsExcelFile | Overloaded. Opens the specified file and determines whether it meets the minimal requirements to be considered an Excel file. (Inherited from FarPoint.Web.Spread.FpSpread) |
| IsExcelStream | Overloaded. Opens the specified file and determines whether it meets the minimal requirements to be considered an Excel-compatible stream. (Inherited from FarPoint.Web.Spread.FpSpread) |
| IsStrictMode | Determines whether the component is under strict standards-compliant mode. (Inherited from FarPoint.Web.Spread.FpSpread) |
| LoadFormulas | Loads formulas that are deserialized but not parsed yet, to be used after all sheets have been created and deserialized. (Inherited from FarPoint.Web.Spread.FpSpread) |
| MergeStyle | Copies 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) |
| Open | Overloaded. Opens a saved Spread XML file and loads it into the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OpenExcel | Overloaded. Opens an Excel file and loads the specified Excel sheet into the specified sheet of the Spread component including the specified parts. (Inherited from FarPoint.Web.Spread.FpSpread) |
| RecreateControl | Force spread to recreate its content. (Inherited from FarPoint.Web.Spread.FpSpread) |
| RenderBeginTag | Adds the CSS style atttributes to the specified HTML writer. (Inherited from FarPoint.Web.Spread.FpSpread) |
| RenderControl | Overloaded. Renders the spreadsheet component to the specified HtmlTextWriter object. (Inherited from FarPoint.Web.Spread.FpSpread) |
| RenderEndTag | Overridden. Appends the CSS style name to the specified HTML writer. |
| Reset | Resets the Spread component to its default values, removing all settings and all sheets. (Inherited from FarPoint.Web.Spread.FpSpread) |
| ResolveClientUrl | Gets a URL that can be used by the browser. (Inherited from System.Web.UI.Control) |
| ResolveUrl | Converts a URL into one that is usable on the requesting client. (Inherited from System.Web.UI.Control) |
| Save | Overloaded. Saves the contents of the Spread component to XML in the specified file. (Inherited from FarPoint.Web.Spread.FpSpread) |
| SaveChanges | Saves the changes to the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| SaveExcel | Overloaded. Saves the contents of the Spread component to the specified Excel file in a stream. (Inherited from FarPoint.Web.Spread.FpSpread) |
| SaveExcelToResponse | Overloaded. Saves the contents of the Spread component to a Response object in Excel file format with default settings. |
| SavePdf | Overloaded. Handles the export (or printing) of all the sheets to PDF as a file. (Inherited from FarPoint.Web.Spread.FpSpread) |
| SavePdfToResponse | Overloaded. Saves the contents of the Spread component to a Response object in PDF file format. |
| Search | Overloaded. Searches the text in the cells in the specified sheet for the specified string with the specified criteria. (Inherited from FarPoint.Web.Spread.FpSpread) |
| SearchHeaders | Overloaded. Searches the text in the header cells in the specified sheet for the specified string with the specified criteria. (Inherited from FarPoint.Web.Spread.FpSpread) |
| SetImage | Sets the custom image in the specified part of the Spread component interface. (Inherited from FarPoint.Web.Spread.FpSpread) |
| SetRenderMethodDelegate | Assigns an event handler delegate to render the server control and its content into its parent control. (Inherited from System.Web.UI.Control) |
| Validate | Tests to see if the value is valid for a cell in the active sheet in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
Protected Methods
| Name | Description | |
|---|---|---|
 | AddAttributesToRender | Adds 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) |
| AddParsedSubObject | Adds the Spread component to the child control collection. (Inherited from FarPoint.Web.Spread.FpSpread) |
| BuildProfileTree | Gathers 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) |
| ClearCachedClientID | Sets the cached System.Web.UI.Control.ClientID value to null. (Inherited from System.Web.UI.Control) |
| ClearChildControlState | Deletes the control-state information for the server control's child controls. (Inherited from System.Web.UI.Control) |
| ClearChildState | Deletes the view-state and control-state information for all the server control's child controls. (Inherited from System.Web.UI.Control) |
| ClearChildViewState | Deletes the view-state information for all the server control's child controls. (Inherited from System.Web.UI.Control) |
| ClearEffectiveClientIDMode | Sets 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) |
| CreateChildControls | Creates the child controls. (Inherited from FarPoint.Web.Spread.FpSpread) |
| CreateControlCollection | Creates 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) |
| CreateControlStyle | Creates 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) |
| DataBindChildren | Binds a data source to the server control's child controls. (Inherited from System.Web.UI.Control) |
| EnsureChildControls | Determines whether the server control contains child controls. If it does not, it creates child controls. (Inherited from System.Web.UI.Control) |
| EnsureID | Creates an identifier for controls that do not have an identifier assigned. (Inherited from System.Web.UI.Control) |
| FlushData | Flushes the data. (Inherited from FarPoint.Web.Spread.FpSpread) |
| GetDesignModeState | Gets design-time data for a control. (Inherited from System.Web.UI.Control) |
| Group | Groups the rows in the specified column. (Inherited from FarPoint.Web.Spread.FpSpread) |
| HasEvents | Returns a value indicating whether events are registered for the control or any child controls. (Inherited from System.Web.UI.Control) |
| IsLiteralContent | Determines if the server control holds only literal content. (Inherited from System.Web.UI.Control) |
| LoadViewState | Overridden. Loads the view state of the Spread component. |
| MoveColumn | Moves the column from one location to another as specified. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnAdd | Processes the Add command in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnBubbleEvent | Determines whether the event for the server control is passed up the page's UI server control hierarchy. (Inherited from System.Web.UI.Control) |
| OnButtonCmd | Processes the specified button command for the cell at the specified row and column in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnCancel | Processes the Cancel command in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnCellClick | Processes the click on a cell at the specified row and column in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnChildView | Displays the specified child view in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnColumnHeaderClick | Processes a click on a column header cell at the specified row and column in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnDataBinding | Raises the System.Web.UI.Control.DataBinding event. (Inherited from System.Web.UI.Control) |
| OnDelete | Processes the Delete command in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnEdit | Processes the Edit command in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnExpandView | Displays the child view in the component at the specified row. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnFirstPage | Occurs when the first page is reached. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnInit | Overridden. Initializes the Spread component. |
| OnInsert | Processes the Insert command at the specified row in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnLastPage | Occurs when the last page is reached. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnLoad | Occurs when the Load event is raised. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnLoadOnDemand | Occurs when an incremental load to the client occurs for load on demand. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnNextPage | Processes the Next Page command in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnPage | Processes the Page command for the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnPreRender | Overridden. |
| OnPrevPage | Processes the Previous Page command in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnPrint | Processes the Print command in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnPrintPDF | Processes the PrintPDF command in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnRowHeaderClick | Processes a click on a row header cell at the specified row and column in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnSelect | Selects the specified row in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnSelectView | Switches to a different sheet in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnSortColumn | Processes the Column Sort command for the specified column in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnTabLeft | Scrolls the tabs to the right in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnTabRight | Scrolls the tabs to the left in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnUpdate | Processes the Update command and updates the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnUpdateDownLevel | Processes the Update command for a down-level browser and updates the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnUpdateRenderEditors | Processes the Update command for the RenderEditors mode in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnUpdateRowEditTemplate | Handles the update of the editing template. (Inherited from FarPoint.Web.Spread.FpSpread) |
| OnUpdateUpperLevel | Handles the Update command (and updates the Spread component) for the up-level browser (IE5.5 or above). (Inherited from FarPoint.Web.Spread.FpSpread) |
| RaiseBubbleEvent | Assigns any sources of the event and its information to the control's parent. (Inherited from System.Web.UI.Control) |
| Regroup | Rearrange the order of grouping based on the movement of the specified column. (Inherited from FarPoint.Web.Spread.FpSpread) |
| RemoveGroup | Removes the grouping for the specified column and moves the column to the specified location. (Inherited from FarPoint.Web.Spread.FpSpread) |
| Render | Overridden. Renders the Spread component in HTML. |
| ResolveAdapter | Gets the control adapter responsible for rendering the specified control. (Inherited from System.Web.UI.Control) |
| SaveViewState | Overridden. Saves the view state of the component. |
| SetDesignModeState | Sets design-time data for a control. (Inherited from System.Web.UI.Control) |
| TrackViewState | Causes the control to track changes to its view state so they can be stored in the object's System.Web.UI.Control.ViewState property. (Inherited from System.Web.UI.WebControls.WebControl) |
| UpdateView | Updates the column width and the row height. (Inherited from FarPoint.Web.Spread.FpSpread) |