Spread for ASP.NET 8.0 Product Documentation
FpSpread Class Members
Properties  Methods  Events


The following tables list the members exposed by FpSpread.

Public Constructors
 NameDescription
Public ConstructorFpSpread ConstructorInitializes a new instance of the FpSpread class.  
Top
Public Properties
 NameDescription
Public PropertyAboutGets the read-only string that contains version information about the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyAccessKeyGets or sets the access key that allows you to quickly navigate to the Web server control. (Inherited from System.Web.UI.WebControls.WebControl)
Public PropertyActiveSheetViewGets the currently selected sheet for the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyActiveSheetViewIndexGets or sets the currently selected sheet in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyAllowClientUnlockGets or sets whether the user can unlock a cell from the client side. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyAllowHeaderResizeGets or sets whether to allow the user to resize the headers. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyAllowLoadOnDemandGets or sets whether to allow incremental loads to the client on demand when the user is scrolling. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyAppRelativeTemplateSourceDirectoryGets or sets the application-relative virtual directory of the System.Web.UI.Page or System.Web.UI.UserControl object that contains this control. (Inherited from System.Web.UI.Control)
Public PropertyAttributesGets the collection of arbitrary attributes (for rendering only) that do not correspond to properties on the control. (Inherited from System.Web.UI.WebControls.WebControl)
Public PropertyBackColorGets the background color of the active sheet in the Spread component. To change the background color, please use the BackColor property of the SheetView class. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyBorderColorGets or sets the border color of the Web control. (Inherited from System.Web.UI.WebControls.WebControl)
Public PropertyBorderStyleGets or sets the border style of the Web server control. (Inherited from System.Web.UI.WebControls.WebControl)
Public PropertyBorderWidthGets or sets the border width of the Web server control. (Inherited from System.Web.UI.WebControls.WebControl)
Public PropertyCellsGets the cells in the client area of the active sheet in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyClientAutoCalculationGets or sets whether to perform automatic re-calculation on the client-side data in support of AJAX applications. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyClientAutoSizeGets or sets whether to resize the spread automatically. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyClientAutoSizeMaxHeightGets or sets the maximum height of Spread when the ClientAutoSize property is True. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyClientAutoSizeMaxWidthGets or sets the maximum width of Spread when the ClientAutoSize property is True. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyClientIDGets the control ID for HTML markup that is generated by ASP.NET. (Inherited from System.Web.UI.Control)
Public PropertyColumnFooterGets the column footers in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyColumnHeaderGets the column headers in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyColumnsGets the columns in the client area of the active sheet in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyCommandBarGets the command bar information for the component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyCommandBarOnBottomGets or sets whether to display the command bar at the bottom of the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyContextMenusGets the context menus. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyControlsGets the controls. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyControlStyleGets the style of the Web server control. This property is used primarily by control developers. (Inherited from System.Web.UI.WebControls.WebControl)
Public PropertyControlStyleCreatedGets a value indicating whether a System.Web.UI.WebControls.Style object has been created for the System.Web.UI.WebControls.WebControl.ControlStyle property. This property is primarily used by control developers. (Inherited from System.Web.UI.WebControls.WebControl)
Public PropertyCssClassGets or sets the Cascading Style Sheet (CSS) class rendered by the Web server control on the client. (Inherited from System.Web.UI.WebControls.WebControl)
Public PropertyCurrentPageGets or sets the current page. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyDataMemberGets or sets the name of the data member that populates the active sheet for the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyDataSourceGets or sets the name of the data source that populates the active sheet for the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyDataSourceIDGets or sets the unique identifier of the data source for the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyDocumentModeIndicates which mode is used to render content properly. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyDragColumnCssClassGets or sets the CSS class for the column being dragged during grouping. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyEditModePermanentGets or sets whether edit mode remains on for any cell in the component when that cell becomes active. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyEditModeReplaceGets or sets whether the existing text in a cell is selected when the cell enters edit mode. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyEnableAjaxCallGets or sets whether to enable an AJAX call for certain actions. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyEnableClientScriptGets or sets whether the Spread component can use client-side JavaScript for up-level browsers. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyEnableContextMenuGets or sets a value that indicates whether to enable the context menu. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyEnableCrossSheetReferenceGets or sets whether to enable cross-sheet referencing for the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyEnabledGets or sets a value indicating whether the Web server control is enabled. (Inherited from System.Web.UI.WebControls.WebControl)
Public PropertyEnablejQueryThemeGets or Sets whether Spread should apply the jQuery theme on client side. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyEnableThemingGets or sets a value indicating whether themes apply to this control. (Inherited from System.Web.UI.WebControls.WebControl)
Public PropertyEnableViewStateGets or sets a value indicating whether the server control persists its view state, and the view state of any child controls it contains, to the requesting client. (Inherited from System.Web.UI.Control)
Public PropertyEncodeValueGets or sets whether the Spread component encodes the values from the data model and the user's input using the HtmlEncode method. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyExpandIconOnRightGets or sets the position of the expand and collapse image in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyFocusRectangleBorderColorGets or sets the color of the border for the focus rectangle. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyFocusRectangleBorderStyleGets or sets the style of the border for the focus rectangle. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyFpSpreadAdapterCall DynamicDataManager's RegisterControl method against this property to register spread with the DynamicDataManager. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyGroupColumnHeaderCssClassGets or sets the CSS class for the column headers on the group bar. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyGroupingPolicyGets or sets grouping policy to collapse or expand rows when grouping occurs. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyHasAttributesGets a value indicating whether the control has attributes set. (Inherited from System.Web.UI.WebControls.WebControl)
Public PropertyHeaderIndicatorPositionAdjustingGets or sets the distance between the sorting and filtering indicators and the right edge of the column. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyHeightGets or sets the height of the Web server control. (Inherited from System.Web.UI.WebControls.WebControl)
Public PropertyHierarchicalViewGets or sets whether to display the child sheets in the Spread component hierarchically. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyHierBarGets the hierarchy bar information for the component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyHorizontalScrollBarPolicyGets or sets whether and how the Spread component displays the horizontal scroll bar. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyIDGets or sets the programmatic identifier assigned to the server control. (Inherited from System.Web.UI.Control)
Public PropertyIsPrintDetermines whether the FarPoint component creates the print output. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyLoadInitRowCountGets or sets the number of rows to load initially to the client. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyLoadRowIncrementGets or sets the number of rows to include in incremental loads on demand. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyNamedStylesGets a collection of styles for the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyNamingContainerGets a reference to the server control's naming container, which creates a unique namespace for differentiating between server controls with the same System.Web.UI.Control.ID property value. (Inherited from System.Web.UI.Control)
Public PropertyNonEditModeValidationGets or sets whether to perform validation when Spread in non-editing state. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyPageGets a reference to the System.Web.UI.Page instance that contains the server control. (Inherited from System.Web.UI.Control)
Public PropertyPagerGets the page navigation information for the component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyParallelGets or sets a value that indicates whether Spread supports multi-threading. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyParentGets a reference to the server control's parent control in the page control hierarchy. (Inherited from System.Web.UI.Control)
Public PropertyProcessTabGets or sets whether to process the Tab key as a way of advancing to the next active cell in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyRenderCSSClassGets or sets whether the Spread component should render the styles by using CSS styles or by using in-line style attributes. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyRenderingCompatibilityGets a value that specifies the ASP.NET version that rendered HTML will be compatible with. (Inherited from System.Web.UI.Control)
Public PropertyResetIfNoFilteredRowGets or sets a value that indicates whether the filtered row list will be reset if there is no filtered row. Set this property to False to be compatible with version 6 or earlier. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyRetainSelectionBlockGets or sets whether the selected range of cells remains highlighted when the component loses the focus. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyRowEditTemplateGets the row edit template. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyRowHeaderGets the row headers in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyRowsGets the rows in the client area of the active sheet in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertySaveViewStateToSessionWhen this property is true, the spread will save its view state to the Session object. If you do not want to save the spread view state to the Session object, you should set this property to false. The default value is true. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyScrollBar3DLightColorGets or sets the color of the top and left edges of the scroll box and scroll arrows of a scroll bar in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyScrollBarArrowColorGets or sets the color for the arrows (when active) in the scroll bars in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyScrollBarBaseColorGets or sets the base color of the scroll boxes, scroll tracks, and scroll arrows in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyScrollBarDarkShadowColorGets or sets the color of the gutter of the scroll bars in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyScrollBarFaceColorGets or sets the color of the scroll box and scroll arrows in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyScrollBarHighlightColorGets or sets the color of the top and left edges of the scroll box and scroll arrows of the scroll bars in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyScrollBarShadowColorGets or sets the color of the bottom and right edges of the scroll box and scroll arrows of the scroll bars in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyScrollBarTrackColorGets or sets the color of the track element of the scroll bars in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertySelectionBlockOptionsGets or sets which types of selections the user can make in the view. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertySheetCornerGets the sheet corner in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertySheetsGets a collection of sheets for the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyShowFocusRectangleGets or sets whether to display the focus rectangle. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyShowHeaderSelectionGets or sets whether to highlight the header cells when the cells in the row or column are selected. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertySiteGets information about the container that hosts the current control when rendered on a design surface. (Inherited from System.Web.UI.Control)
Public PropertySkinIDGets or sets the skin to apply to the control. (Inherited from System.Web.UI.WebControls.WebControl)
Public PropertyStyleGets a collection of text attributes that will be rendered as a style attribute on the outer tag of the Web server control. (Inherited from System.Web.UI.WebControls.WebControl)
Public PropertySupportsDisabledAttributeGets a value that indicates whether the control should set the disabled attribute of the rendered HTML element to "disabled" when the control's System.Web.UI.WebControls.WebControl.IsEnabled property is false. (Inherited from System.Web.UI.WebControls.WebControl)
Public PropertyTabGets the sheet tab name information for the component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyTemplateControlGets or sets a reference to the template that contains this control. (Inherited from System.Web.UI.Control)
Public PropertyTemplateSourceDirectoryGets the virtual directory of the System.Web.UI.Page or System.Web.UI.UserControl that contains the current server control. (Inherited from System.Web.UI.Control)
Public PropertyTitleInfoGets the title information. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyToolTipGets or sets the text displayed when the mouse pointer hovers over the Web server control. (Inherited from System.Web.UI.WebControls.WebControl)
Public PropertyTouchInfoGets a TouchInfo object that determines touch behavior for Spread. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyTouchStripsThe TouchStrip collection of Spread. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyUIVirtualizationGets or sets whether to use UI virtualization. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyUniqueIDGets the unique, hierarchically qualified identifier for the server control. (Inherited from System.Web.UI.Control)
Public PropertyUseClipboardGets or sets whether to access the Clipboard with client-side scripting. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyValidateRequestModeGets or sets a value that indicates whether the control checks client input from the browser for potentially dangerous values. (Inherited from System.Web.UI.Control)
Public PropertyValidationErrorMessageGets or sets the validation error message. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyVerticalScrollBarPolicyGets or sets whether and how the Spread component displays the vertical scroll bar. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyViewStateModeGets or sets the view-state mode of this control. (Inherited from System.Web.UI.Control)
Public PropertyVisibleGets or sets a value that indicates whether a server control is rendered as UI on the page. (Inherited from System.Web.UI.Control)
Public PropertyWaitMessageGets or sets the Wait Message for load on demand. (Inherited from FarPoint.Web.Spread.FpSpread)
Public PropertyWidthGets or sets the width of the Web server control. (Inherited from System.Web.UI.WebControls.WebControl)
Top
Protected Properties
 NameDescription
Protected PropertyAdapterGets the browser-specific adapter for the control. (Inherited from System.Web.UI.Control)
Protected PropertyChildControlsCreatedGets a value that indicates whether the server control's child controls have been created. (Inherited from System.Web.UI.Control)
Protected PropertyClientIDSeparatorGets a character value representing the separator character used in the System.Web.UI.Control.ClientID property. (Inherited from System.Web.UI.Control)
Protected PropertyEventsGets a list of event handler delegates for the control. This property is read-only. (Inherited from System.Web.UI.Control)
Protected PropertyHasChildViewStateGets a value indicating whether the current server control's child controls have any saved view-state settings. (Inherited from System.Web.UI.Control)
Protected PropertyIdSeparatorGets the character used to separate control identifiers. (Inherited from System.Web.UI.Control)
Protected PropertyIsTrackingViewStateGets a value that indicates whether the server control is saving changes to its view state. (Inherited from System.Web.UI.Control)
Protected PropertyLoadViewStateByIDGets a value indicating whether the control participates in loading its view state by System.Web.UI.Control.ID instead of index. (Inherited from System.Web.UI.Control)
Protected PropertyTagKeyGets the System.Web.UI.HtmlTextWriterTag value that corresponds to this Web server control. This property is used primarily by control developers. (Inherited from System.Web.UI.WebControls.WebControl)
Protected PropertyTagNameGets the name of the control tag. This property is used primarily by control developers. (Inherited from System.Web.UI.WebControls.WebControl)
Protected PropertyViewStateGets a dictionary of state information that allows you to save and restore the view state of a server control across multiple requests for the same page. (Inherited from System.Web.UI.Control)
Protected PropertyViewStateIgnoresCaseGets a value that indicates whether the System.Web.UI.StateBag object is case-insensitive. (Inherited from System.Web.UI.Control)
Top
Public Methods
 NameDescription
Public MethodApplyStyleCopies 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 MethodApplyStyleSheetSkinApplies the style properties defined in the page style sheet to the control. (Inherited from System.Web.UI.Control)
Public MethodCancelEditDiscards the editing values in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodCopyBaseAttributesCopies 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 MethodCreateDesignViewOverloaded. Creates a new design-time view of the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodDataBindOverloaded. Binds a data source to the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodFindControlOverloaded. Searches the current naming container for a server control with the specified id and an 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. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodFocusSets input focus to a control. (Inherited from System.Web.UI.Control)
Public MethodGetColumnIndexReturns the client column index for the specified column. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodGetEditValueGets the postback value of the specified cell on the active sheet in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodGetImageGets the image in the component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodGetMergeCellGets the merged cell range at the specified cell. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodGetMergeCellsGets the merged cell ranges in the specified range. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodGetPageIndexReturns the page index the specified row is rendered in. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodGetRouteUrlOverloaded. Gets the URL that corresponds to a set of route parameters. (Inherited from System.Web.UI.Control)
Public MethodGetRowIndexReturns the client row index for the specified row. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodGetTabTextGets the text of the sheet name tab at the specified sheet in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodGetUniqueIDRelativeToReturns the prefixed portion of the System.Web.UI.Control.UniqueID property of the specified control. (Inherited from System.Web.UI.Control)
Public MethodGoalSeekAttempts to find values for one cell that will produce the desired formula result in another cell. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodGotoPageScrolls through the sheet in the component to the specified page. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodHasControlsDetermines if the server control contains any child controls. (Inherited from System.Web.UI.Control)
Public MethodIsExcelFileOverloaded. Opens the specified file and determines whether it meets the minimal requirements to be considered an Excel file. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodIsExcelStreamOverloaded. 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)
Public MethodIsStrictModeDetermines whether the component is under strict standards-compliant mode. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodLoadFormulasLoads 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)
Public MethodMergeStyleCopies 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 MethodOpenOverloaded. Opens a saved Spread XML file and loads it into the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodOpenExcelOverloaded. Opens an Excel file and loads it into the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodRecreateControlForces spread to recreate its content. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodRenderEndTagOverridden. Appends the CSS style name to the specified HTML writer.  
Public MethodResetResets the Spread component to its default values, removing all settings and all sheets. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodResolveClientUrlGets a URL that can be used by the browser. (Inherited from System.Web.UI.Control)
Public MethodResolveUrlConverts a URL into one that is usable on the requesting client. (Inherited from System.Web.UI.Control)
Public MethodSaveOverloaded. Saves the contents of the Spread component to XML in the specified file. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodSaveChangesSaves the changes to the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodSaveExcelOverloaded. Saves the contents of the Spread component to the specified Excel file in a stream. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodSaveExcelToResponseOverloaded. Saves the contents of the Spread component to a Response object in Excel file format with default settings.  
Public MethodSavePdfOverloaded. Handles the export (or printing) of all the sheets to PDF as a file. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodSavePdfToResponseOverloaded. Saves the contents of the Spread component to a Response object in PDF file format.  
Public MethodSearchOverloaded. Searches the text in the cells in the specified sheet for the specified string with the specified criteria. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodSearchHeadersOverloaded. 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)
Public MethodSetImageSets the custom image in the specified part of the Spread component interface. (Inherited from FarPoint.Web.Spread.FpSpread)
Public MethodSetRenderMethodDelegateAssigns an event handler delegate to render the server control and its content into its parent control. (Inherited from System.Web.UI.Control)
Public MethodValidateTests to see if the value is valid for a cell in the active sheet in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Top
Protected Methods
 NameDescription
Protected MethodAddAttributesToRenderAdds 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 MethodBuildProfileTreeGathers 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 MethodClearCachedClientIDSets the cached System.Web.UI.Control.ClientID value to null. (Inherited from System.Web.UI.Control)
Protected MethodClearChildControlStateDeletes the control-state information for the server control's child controls. (Inherited from System.Web.UI.Control)
Protected MethodClearChildStateDeletes the view-state and control-state information for all the server control's child controls. (Inherited from System.Web.UI.Control)
Protected MethodClearChildViewStateDeletes the view-state information for all the server control's child controls. (Inherited from System.Web.UI.Control)
Protected MethodClearEffectiveClientIDModeSets 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 MethodCreateChildControlsCreates the child controls. (Inherited from FarPoint.Web.Spread.FpSpread)
Protected MethodCreateControlCollectionCreates 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 MethodCreateControlStyleCreates 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 MethodDataBindChildrenBinds a data source to the server control's child controls. (Inherited from System.Web.UI.Control)
Protected MethodEnsureChildControlsDetermines whether the server control contains child controls. If it does not, it creates child controls. (Inherited from System.Web.UI.Control)
Protected MethodEnsureIDCreates an identifier for controls that do not have an identifier assigned. (Inherited from System.Web.UI.Control)
Protected MethodGetDesignModeStateGets design-time data for a control. (Inherited from System.Web.UI.Control)
Protected MethodGroupGroups the rows in the specified column. (Inherited from FarPoint.Web.Spread.FpSpread)
Protected MethodHasEventsReturns a value indicating whether events are registered for the control or any child controls. (Inherited from System.Web.UI.Control)
Protected MethodIsLiteralContentDetermines if the server control holds only literal content. (Inherited from System.Web.UI.Control)
Protected MethodLoadViewStateOverridden. Loads the view state of the Spread component.  
Protected MethodMoveColumnMoves the column from one location to another as specified. (Inherited from FarPoint.Web.Spread.FpSpread)
Protected MethodOnBubbleEventDetermines whether the event for the server control is passed up the page's UI server control hierarchy. (Inherited from System.Web.UI.Control)
Protected MethodOnDataBindingRaises the System.Web.UI.Control.DataBinding event. (Inherited from System.Web.UI.Control)
Protected MethodOnInitOverridden. Initializes the Spread component.  
Protected MethodOnMenuItemClickedRaises the MenuItemClicked event. (Inherited from FarPoint.Web.Spread.FpSpread)
Protected MethodOnPreRenderOverridden. Pre-renders the Spread component and creates the child controls.  
Protected MethodOnPrintPDFProcesses the PrintPDF command in the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Protected MethodOnTouchStripItemClickedRaises the TouchStripItemClicked event. (Inherited from FarPoint.Web.Spread.FpSpread)
Protected MethodRaiseBubbleEventAssigns any sources of the event and its information to the control's parent. (Inherited from System.Web.UI.Control)
Protected MethodRegroupRearranges the order of grouping based on the movement of the specified column. (Inherited from FarPoint.Web.Spread.FpSpread)
Protected MethodRemoveGroupRemoves the grouping for the specified column and moves the column to the specified location. (Inherited from FarPoint.Web.Spread.FpSpread)
Protected MethodRenderOverridden. Renders the Spread component in HTML.  
Protected MethodRenderChildrenOutputs 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. (Inherited from FarPoint.Web.Spread.FpSpread)
Protected MethodResolveAdapterGets the control adapter responsible for rendering the specified control. (Inherited from System.Web.UI.Control)
Protected MethodSaveViewStateOverridden. Saves the view state of the component.  
Protected MethodSetDesignModeStateSets design-time data for a control. (Inherited from System.Web.UI.Control)
Protected MethodTrackViewStateInvokes child IStateManager object TrackViewState() method to start tracking. (Inherited from FarPoint.Web.Spread.FpSpread)
Protected MethodUpdateViewUpdates the column width and the row height. (Inherited from FarPoint.Web.Spread.FpSpread)
Top
Public Events
 NameDescription
Public EventActiveRowChangedOccurs when the user sets the operation mode to row mode and moves the focus to a new row. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventActiveSheetChangedOccurs when the user changes the active sheet. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventAggregateOccurs when the data model aggregate. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventAutoFilteredColumnOccurs when the user is done filtering. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventAutoFilteringColumnOccurs when the user is filtering. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventButtonCommandOccurs when a user clicks a button cell on a sheet. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventCancelCommandOccurs when the user clicks the Cancel button on the component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventCellClickOccurs when the user clicks a cell using the left mouse button. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventChildViewCreatedOccurs when the user creates a child sheet. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventColumnHeaderClickOccurs when the user clicks a cell in the column header using the left mouse button. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventCreateButtonOccurs when the user clicks on the Create button. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventDataBindingOccurs when the server control binds to a data source. (Inherited from System.Web.UI.Control)
Public EventDeleteCommandOccurs when the user clicks the Delete button on the component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventDisposedOccurs when a server control is released from memory, which is the last stage of the server control lifecycle when an ASP.NET page is requested. (Inherited from System.Web.UI.Control)
Public EventEditCommandOccurs when the user clicks the Edit button on the component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventErrorCommandOccurs when the use of a command button causes an error. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventFetchGroupTextOccurs when spread creates the group bar. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventGroupedOccurs when the user is done grouping. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventGroupingOccurs when the user is grouping. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventInitOccurs when the server control is initialized, which is the first step in its lifecycle. (Inherited from System.Web.UI.Control)
Public EventInsertCommandOccurs when the user clicks on the Insert button on the component and inserts a new row in the active sheet. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventLoadOccurs when the server control is loaded into the System.Web.UI.Page object. (Inherited from System.Web.UI.Control)
Public EventMenuItemClickedOccurs when the Spread context menu item is clicked. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventPreRenderOccurs after the System.Web.UI.Control object is loaded but prior to rendering. (Inherited from System.Web.UI.Control)
Public EventPrintAbortOccurs continually as printing occurs in order to give the user the opportunity to discontinue a print job. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventPrintBackgroundOccurs before each page is printed. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventPrintExternalImageRepresents a defined method that handles the PrintExternalImage event for the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventPrintExternalImageEndRepresents a defined method that handles the PrintExternalImageEnd event for the Spread component. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventPrintPDFOccurs before printing spread to PDF. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventPrintSheetOccurs when a sheet is printed. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventRowHeaderClickOccurs when the user clicks a cell in the row header using the left mouse button. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventSaveOrLoadSheetStateOccurs when the user saves or loads a view state of a sheet. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventSortColumnCommandOccurs when the user sorts a column. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventTopRowChangedOccurs when the user changes the top row of a sheet. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventTouchStripItemClickedOccurs when the TouchStrip item is clicked. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventUngroupedOccurs when the user is done grouping. (Inherited from FarPoint.Web.Spread.FpSpread)
Public EventUnloadOccurs when the server control is unloaded from memory. (Inherited from System.Web.UI.Control)
Public EventUpdateCommandOccurs when the user clicks the Update button on the component. (Inherited from FarPoint.Web.Spread.FpSpread)
Top
See Also

Reference

FpSpread Class
FarPoint.Mvc.Spread Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.