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


The following tables list the members exposed by FpSpread.

Public Constructors
 NameDescription
Public ConstructorFpSpread ConstructorOverloaded.   
Top
Public Fields
 NameDescription
Public FieldCollapseImageSpecifies the identifier for the image for the collapse icon in hierarchical displays in the component.  
Public FieldExpandImageSpecifies the identifier for the image for the expand icon in hierarchical displays in the component.  
Public FieldFrozenIndicatorImageSpecifies the identifier for the image for the frozen indicator.  
Public FieldSortAscendingImageSpecifies the identifier for the image for the sort indicator (for ascending sorts) in the component.  
Public FieldSortDescendingImageSpecifies the identifier for the image for the sort indicator (for descending sorts) in the component.  
Public Fieldstatic (Shared in Visual Basic)UnchangedRepresents the unchanged property of the cell contents.  
Top
Public Properties
 NameDescription
Public PropertyAboutGets the read-only string that contains version information about the Spread component.  
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.  
Public PropertyActiveSheetViewIndexGets or sets the currently selected sheet in the Spread component.  
Public PropertyAllowClientUnlockGets or sets whether the user can unlock a cell from the client side.  
Public PropertyAllowGetAllHiddenValueGets or sets whether Spread should support getting or setting a value from any hidden cell in the sheet.  
Public PropertyAllowHeaderResizeGets or sets whether to allow the user to resize the headers.  
Public PropertyAllowLoadOnDemandGets or sets whether to allow incremental loads to the client on demand when the user is scrolling.  
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 PropertyBackColorOverridden. Gets 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.  
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.  
Public PropertyClientAutoCalculationGets or sets whether to perform automatic re-calculation on the client-side data in support of AJAX applications.  
Public PropertyClientAutoSizeGets or sets whether to resize the spread automatically.  
Public PropertyClientAutoSizeMaxHeightGets or sets the maximum height of Spread when the ClientAutoSize property is True.  
Public PropertyClientAutoSizeMaxWidthGets or sets the maximum width of Spread when the ClientAutoSize property is True.  
Public PropertyClientIDGets the control ID for HTML markup that is generated by ASP.NET. (Inherited from System.Web.UI.Control)
Public PropertyClientIDModeGets or sets the algorithm that is used to generate the value of the System.Web.UI.Control.ClientID property. (Inherited from System.Web.UI.Control)
Public PropertyColumnFooterGets the column footers in the Spread component.  
Public PropertyColumnHeaderGets the column headers in the Spread component.  
Public PropertyColumnsGets the columns in the client area of the active sheet in the Spread component.  
Public PropertyCommandBarGets the command bar information for the component.  
Public PropertyCommandBarOnBottomGets or sets whether to display the command bar at the bottom of the Spread component.  
Public PropertyContextMenusGets the context menus.  
Public PropertyControlsOverridden. Gets the controls.  
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.  
Public PropertyDataMemberGets or sets the name of the data member that populates the active sheet for the Spread component.  
Public PropertyDataSourceGets or sets the name of the data source that populates the active sheet for the Spread component.  
Public PropertyDataSourceIDGets or sets the unique identifier of the data source for the Spread component.  
Public PropertyDeleteMethodGets or sets the name of the method to call to delete data.  
Public PropertyDocumentModeIndicates which mode is used to render content properly.  
Public PropertyDragColumnCssClassGets or sets the CSS class for the column being dragged during grouping.  
Public PropertyEditModePermanentGets or sets whether edit mode remains on for any cell in the component when that cell becomes active.  
Public PropertyEditModeReplaceGets or sets whether the existing text in a cell is selected when the cell enters edit mode.  
Public PropertyEnableAjaxCallGets or sets whether to enable an AJAX call for certain actions.  
Public PropertyEnableClientScriptGets or sets whether the Spread component can use client-side JavaScript for up-level browsers.  
Public PropertyEnableContextMenuGets or sets a value that indicates whether to enable the context menu.  
Public PropertyEnableCrossSheetReferenceGets or sets whether to enable cross-sheet referencing for the Spread component.  
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 the client-side.  
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.  
Public PropertyExpandIconOnRightGets or sets the position of the expand and collapse image in the Spread component.  
Public PropertyFocusRectangleBorderColorGets or sets the color of the border for the focus rectangle.  
Public PropertyFocusRectangleBorderStyleGets or sets the style of the border for the focus rectangle.  
Public PropertyFpSpreadAdapterCall DynamicDataManager's RegisterControl method against this property to register spread with the DynamicDataManager.  
Public PropertyGroupColumnHeaderCssClassGets or sets the CSS class for the column headers on the group bar.  
Public PropertyGroupingPolicyGets or sets grouping policy to collapse or expand rows when grouping occurs.  
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.  
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.  
Public PropertyHierBarGets the hierarchy bar information for the component.  
Public PropertyHorizontalScrollBarPolicyGets or sets whether and how the Spread component displays the horizontal scroll bar.  
Public PropertyIDGets or sets the programmatic identifier assigned to the server control. (Inherited from System.Web.UI.Control)
Public PropertyInsertMethodGets or sets the name of the method to call to insert data.  
Public PropertyIsPrintDetermines whether the FarPoint component creates the print output.  
Public PropertyIsProtectedStructureSpecifies whether Spread allows the user to change the structure of the sheet collection.  
Public PropertyItemTypeGets or sets the name of the data item type for strongly typed data binding.  
Public PropertyLoadInitRowCountGets or sets the number of rows to load initially to the client.  
Public PropertyLoadRowIncrementGets or sets the number of rows to include in incremental loads on demand.  
Public PropertyMoveToNextCellThenControlGets or sets whether to process the Tab key as a way of advancing to the next control when tabbing from the last cell.  
Public PropertyMoveToPreviousCellThenControlGets or sets whether to process the Tab key as a way of advancing to the previous control when tabbing from the first cell.  
Public PropertyNamedStylesGets a collection of styles for the Spread component.  
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.  
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.  
Public PropertyParallelGets or sets a value that indicates whether Spread supports multi-threading.  
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.  
Public PropertyRenderCSSClassGets or sets whether the Spread component should render the styles by using CSS styles or by using in-line style attributes.  
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.  
Public PropertyRetainSelectionBlockGets or sets whether the selected range of cells remains highlighted when the component loses the focus.  
Public PropertyRowEditTemplateGets the row edit template.  
Public PropertyRowHeaderGets the row headers in the Spread component.  
Public PropertyRowsGets the rows in the client area of the active sheet in the Spread component.  
Public PropertySaveViewStateToSessionWhen this property is true, the spread will save its view state to the Session object. And, the SaveOrLoadSheetState event will not be fired. 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.  
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.  
Public PropertyScrollBarArrowColorGets or sets the color for the arrows (when active) in the scroll bars in the Spread component.  
Public PropertyScrollBarBaseColorGets or sets the base color of the scroll boxes, scroll tracks, and scroll arrows in the Spread component.  
Public PropertyScrollBarDarkShadowColorGets or sets the color of the gutter of the scroll bars in the Spread component.  
Public PropertyScrollBarFaceColorGets or sets the color of the scroll box and scroll arrows in the Spread component.  
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.  
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.  
Public PropertyScrollBarTrackColorGets or sets the color of the track element of the scroll bars in the Spread component.  
Public PropertySelectionBlockOptionsGets or sets which types of selections the user can make in the view.  
Public PropertySelectMethodGets or sets the name of the method to call to read data.  
Public PropertySheetCornerGets the sheet corner in the Spread component.  
Public PropertySheetsGets a collection of sheets for the Spread component.  
Public PropertyShowFocusRectangleGets or sets whether to display the focus rectangle.  
Public PropertyShowHeaderSelectionGets or sets whether to highlight the header cells when the cells in the row or column are selected.  
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.  
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.  
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.  
Public PropertyTouchStripsThe TouchStrip collection of Spread.  
Public PropertyUIVirtualizationGets or sets whether to use UI virtualization.  
Public PropertyUniqueIDGets the unique, hierarchically qualified identifier for the server control. (Inherited from System.Web.UI.Control)
Public PropertyUpdateMethodGets or sets the name of the method to call to update data.  
Public PropertyUseClipboardGets or sets whether to access the Clipboard with client-side scripting.  
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.  
Public PropertyVerticalScrollBarPolicyGets or sets whether and how the Spread component displays the vertical scroll bar.  
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.  
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.  
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 MethodDataBindOverloaded. Overridden. Binds a data source to the Spread component.  
Public MethodFindControlOverloaded. 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 MethodFocusSets input focus to a control. (Inherited from System.Web.UI.Control)
Public MethodGetColumnIndexReturns the client column index for the specified column.  
Public MethodGetEditValueGets the postback value of the specified cell on the active sheet in the Spread component.  
Public Methodstatic (Shared in Visual Basic)GetExcelSheetNamesOverloaded. Gets an array of sheet names from the specified Excel file from a stream.  
Public MethodGetImageGets the image in the component.  
Public MethodGetMergeCellGets the merged cell range at the specified cell.  
Public MethodGetMergeCellsGets the merged cell ranges in the specified range.  
Public MethodGetPageIndexReturns the page index the specified row is rendered in.  
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.  
Public MethodGetTabTextGets the text of the sheet name tab at the specified sheet in the Spread component.  
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.  
Public MethodGotoPageScrolls through the sheet in the component to the specified page.  
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.  
Public MethodIsExcelStreamOverloaded. Opens the specified file and determines whether it meets the minimal requirements to be considered an Excel-compatible stream.  
Public MethodIsStrictModeDetermines whether the component is under strict standards-compliant mode.  
Public MethodLoadFormulasLoads formulas that are deserialized, but not parsed yet, to be used after all sheets have been created and deserialized.  
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.  
Public MethodOpenExcelOverloaded. Opens an Excel stream into the Spread component keeping track of warnings.  
Public MethodRecreateControlForces spread to recreate its content.  
Public MethodResetResets the Spread component to its default values, removing all settings and all sheets.  
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.  
Public MethodSaveChangesSaves the changes to the Spread component.  
Public MethodSaveExcelOverloaded. Saves the contents of the Spread component to the specified Excel file in a stream.  
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.  
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.  
Public MethodSearchHeadersOverloaded. Searches the text in the header cells in the specified sheet for the specified string with the specified criteria.  
Public MethodSetImageSets the custom image in the specified part of the Spread component interface.  
Public MethodSetProtectChanges the protect structure setting with the password parameter.  
Public MethodValidateTests to see if the value is valid for a cell in the active sheet in the Spread component.  
Top
Protected Methods
 NameDescription
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 MethodCreateChildControlsOverridden. Creates the child controls.  
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.  
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.  
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 MethodOnMenuItemClickedRaises the MenuItemClicked event.  
Protected MethodOnPrintPDFOverloaded. Processes the PrintPDF command in the Spread component.  
Protected MethodOnTouchStripItemClickedRaises the TouchStripItemClicked event.  
Protected MethodRegroupRearranges the order of grouping based on the movement of the specified column.  
Protected MethodRemoveGroupRemoves the grouping for the specified column and moves the column to the specified location.  
Protected MethodRenderOverridden. Renders the Spread component in HTML.  
Protected MethodRenderChildrenOverridden. 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 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 MethodTrackViewStateOverridden. Invokes child IStateManager object TrackViewState() method to start tracking.  
Protected MethodUpdateViewUpdates the column width and the row height.  
Top
Public Events
 NameDescription
Public EventActiveRowChangedOccurs when the user sets the operation mode to row mode and moves the focus to a new row.  
Public EventActiveSheetChangedOccurs when the user changes the active sheet.  
Public EventAggregateOccurs when the data model aggregates.  
Public EventAutoFilteredColumnOccurs when the user is done filtering.  
Public EventAutoFilteringColumnOccurs when the user is filtering.  
Public EventButtonCommandOccurs when a user clicks a button cell on a sheet.  
Public EventCancelCommandOccurs when the user clicks the Cancel button on the component.  
Public EventCellClickOccurs when the user clicks a cell using the left mouse button.  
Public EventChildViewCreatedOccurs when the user creates a child sheet.  
Public EventColumnHeaderClickOccurs when the user clicks a cell in the column header using the left mouse button.  
Public EventCreateButtonOccurs when the user clicks on the Create button.  
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.  
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.  
Public EventErrorCommandOccurs when the use of a command button causes an error.  
Public EventFetchGroupTextOccurs when spread creates the group bar.  
Public EventGroupedOccurs when the user is done grouping.  
Public EventGroupingOccurs when the user is grouping.  
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.  
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.  
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.  
Public EventPrintBackgroundOccurs before each page is printed.  
Public EventPrintExternalImageRepresents a defined method that handles the PrintExternalImage event for the Spread component.  
Public EventPrintExternalImageEndRepresents a defined method that handles the PrintExternalImageEnd event for the Spread component.  
Public EventPrintPDFOccurs before printing spread to PDF.  
Public EventPrintSheetOccurs when a sheet is printed.  
Public EventRowHeaderClickOccurs when the user clicks a cell in the row header using the left mouse button.  
Public EventSaveOrLoadSheetStateOccurs when the user saves or loads a view state of a sheet.  
Public EventSortColumnCommandOccurs when the user sorts a column.  
Public EventTopRowChangedOccurs when the user changes the top row of a sheet.  
Public EventTouchStripItemClickedOccurs when the TouchStrip item is clicked.  
Public EventUngroupedOccurs when the user is done grouping.  
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.  
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

 

 


Copyright © GrapeCity, inc. All rights reserved.