Name | Description | |
---|---|---|
FpSpread Constructor | Overloaded. |
The following tables list the members exposed by FpSpread.
Name | Description | |
---|---|---|
FpSpread Constructor | Overloaded. |
Name | Description | |
---|---|---|
CollapseImage | Specifies the identifier for the image for the collapse icon in hierarchical displays in the component. | |
ExpandImage | Specifies the identifier for the image for the expand icon in hierarchical displays in the component. | |
FrozenIndicatorImage | Specifies the identifier for the image for the frozen indicator. | |
SortAscendingImage | Specifies the identifier for the image for the sort indicator (for ascending sorts) in the component. | |
SortDescendingImage | Specifies the identifier for the image for the sort indicator (for descending sorts) in the component. | |
Unchanged | Represents the unchanged property of the cell contents. |
Name | Description | |
---|---|---|
About | Gets the read-only string that contains version information about the Spread component. | |
AccessKey | (Inherited from System.Web.UI.WebControls.WebControl) | |
ActiveSheetView | Gets the currently selected sheet for the Spread component. | |
ActiveSheetViewIndex | Gets or sets the currently selected sheet in the Spread component. | |
AllowClientUnlock | Gets or sets whether the user can unlock a cell from the client side. | |
AllowGenerateHiddenData | Gets or sets whether to allow generate data of hidden rows/columns. | |
AllowGetAllHiddenValue | Gets or sets whether Spread should support getting or setting a value from any hidden cell in the sheet. | |
AllowHeaderResize | Gets or sets whether to allow the user to resize the headers. | |
AllowLoadOnDemand | Gets or sets whether to allow incremental loads to the client on demand when the user is scrolling. | |
AppRelativeTemplateSourceDirectory | (Inherited from System.Web.UI.Control) | |
Attributes | (Inherited from System.Web.UI.WebControls.WebControl) | |
BackColor | Overridden. 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. | |
BorderColor | (Inherited from System.Web.UI.WebControls.WebControl) | |
BorderStyle | (Inherited from System.Web.UI.WebControls.WebControl) | |
BorderWidth | (Inherited from System.Web.UI.WebControls.WebControl) | |
Cells | Gets the cells in the client area of the active sheet in the Spread component. | |
ClientAutoCalculation | Gets or sets whether to perform automatic re-calculation on the client-side data in support of AJAX applications. | |
ClientAutoSize | Gets or sets whether to resize the spread automatically. | |
ClientAutoSizeMaxHeight | Gets or sets the maximum height of Spread when the ClientAutoSize property is True. | |
ClientAutoSizeMaxWidth | Gets or sets the maximum width of Spread when the ClientAutoSize property is True. | |
ClientID | (Inherited from System.Web.UI.Control) | |
ClientIDMode | (Inherited from System.Web.UI.Control) | |
ColumnFooter | Gets the column footers in the Spread component. | |
ColumnHeader | Gets the column headers in the Spread component. | |
Columns | Gets the columns in the client area of the active sheet in the Spread component. | |
CommandBar | Gets the command bar information for the component. | |
CommandBarOnBottom | Gets or sets whether to display the command bar at the bottom of the Spread component. | |
ContextMenus | Gets the context menus. | |
Controls | Overridden. Gets the controls. | |
ControlStyle | (Inherited from System.Web.UI.WebControls.WebControl) | |
ControlStyleCreated | (Inherited from System.Web.UI.WebControls.WebControl) | |
CssClass | (Inherited from System.Web.UI.WebControls.WebControl) | |
CurrentPage | Gets or sets the current page. | |
DataMember | Gets or sets the name of the data member that populates the active sheet for the Spread component. | |
DataSource | Gets or sets the name of the data source that populates the active sheet for the Spread component. | |
DataSourceID | Gets or sets the unique identifier of the data source for the Spread component. | |
DeleteMethod | Gets or sets the name of the method to call to delete data. | |
DocumentMode | Indicates which mode is used to render content properly. | |
DragColumnCssClass | Gets or sets the CSS class for the column being dragged during grouping. | |
DragRowCssClass | Gets or sets the CSS class for the row being dragged during grouping. | |
EditModePermanent | Gets or sets whether edit mode remains on for any cell in the component when that cell becomes active. | |
EditModeReplace | Gets or sets whether the existing text in a cell is selected when the cell enters edit mode. | |
EnableAjaxCall | Gets or sets whether to enable an AJAX call for certain actions. | |
EnableClientScript | Gets or sets whether the Spread component can use client-side JavaScript for up-level browsers. | |
EnableContextMenu | Gets or sets a value that indicates whether to enable the context menu. | |
EnableCrossSheetReference | Gets or sets whether to enable cross-sheet referencing for the Spread component. | |
Enabled | (Inherited from System.Web.UI.WebControls.WebControl) | |
EnablejQueryTheme | Gets or sets whether Spread should apply the jQuery theme on the client-side. | |
EnableTheming | (Inherited from System.Web.UI.WebControls.WebControl) | |
EnableViewState | (Inherited from System.Web.UI.Control) | |
EncodeValue | Gets or sets whether the Spread component encodes the values from the data model and the user's input using the HtmlEncode method. | |
ExpandIconOnRight | Gets or sets the position of the expand and collapse image in the Spread component. | |
FocusRectangleBorderColor | Gets or sets the color of the border for the focus rectangle. | |
FocusRectangleBorderStyle | Gets or sets the style of the border for the focus rectangle. | |
FpSpreadAdapter | Call DynamicDataManager's RegisterControl method against this property to register spread with the DynamicDataManager. | |
GroupColumnHeaderCssClass | Gets or sets the CSS class for the column headers on the group bar. | |
GroupingPolicy | Gets or sets grouping policy to collapse or expand rows when grouping occurs. | |
HasAttributes | (Inherited from System.Web.UI.WebControls.WebControl) | |
HeaderIndicatorPositionAdjusting | Gets or sets the distance between the sorting and filtering indicators and the right edge of the column. | |
Height | (Inherited from System.Web.UI.WebControls.WebControl) | |
HierarchicalView | Gets or sets whether to display the child sheets in the Spread component hierarchically. | |
HierBar | Gets the hierarchy bar information for the component. | |
HorizontalScrollBarPolicy | Gets or sets whether and how the Spread component displays the horizontal scroll bar. | |
ID | (Inherited from System.Web.UI.Control) | |
InsertMethod | Gets or sets the name of the method to call to insert data. | |
IsPrint | Determines whether the FarPoint component creates the print output. | |
IsProtectedStructure | Specifies whether Spread allows the user to change the structure of the sheet collection. | |
ItemType | Gets or sets the name of the data item type for strongly typed data binding. | |
LoadInitRowCount | Gets or sets the number of rows to load initially to the client. | |
LoadRowIncrement | Gets or sets the number of rows to include in incremental loads on demand. | |
MoveToNextCellThenControl | Gets or sets whether to process the Tab key as a way of advancing to the next control when tabbing from the last cell. | |
MoveToPreviousCellThenControl | Gets or sets whether to process the Tab key as a way of advancing to the previous control when tabbing from the first cell. | |
NamedStyles | Gets a collection of styles for the Spread component. | |
NamingContainer | (Inherited from System.Web.UI.Control) | |
NonEditModeValidation | Gets or sets whether to perform validation when Spread in non-editing state. | |
Page | (Inherited from System.Web.UI.Control) | |
Pager | Gets the page navigation information for the component. | |
Parallel | Gets or sets a value that indicates whether Spread supports multi-threading. | |
Parent | (Inherited from System.Web.UI.Control) | |
ProcessTab | Gets or sets whether to process the Tab key as a way of advancing to the next active cell in the Spread component. | |
RenderCSSClass | Gets or sets whether the Spread component should render the styles by using CSS styles or by using in-line style attributes. | |
RenderingCompatibility | (Inherited from System.Web.UI.Control) | |
ResetIfNoFilteredRow | Gets 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. | |
RetainSelectionBlock | Gets or sets whether the selected range of cells remains highlighted when the component loses the focus. | |
RowEditTemplate | Gets the row edit template. | |
RowHeader | Gets the row headers in the Spread component. | |
Rows | Gets the rows in the client area of the active sheet in the Spread component. | |
SaveViewStateToSession | When 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. | |
ScrollBar3DLightColor | Gets 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. | |
ScrollBarArrowColor | Gets or sets the color for the arrows (when active) in the scroll bars in the Spread component. | |
ScrollBarBaseColor | Gets or sets the base color of the scroll boxes, scroll tracks, and scroll arrows in the Spread component. | |
ScrollBarDarkShadowColor | Gets or sets the color of the gutter of the scroll bars in the Spread component. | |
ScrollBarFaceColor | Gets or sets the color of the scroll box and scroll arrows in the Spread component. | |
ScrollBarHighlightColor | Gets 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. | |
ScrollBarShadowColor | Gets 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. | |
ScrollBarTrackColor | Gets or sets the color of the track element of the scroll bars in the Spread component. | |
SelectionBlockOptions | Gets or sets which types of selections the user can make in the view. | |
SelectMethod | Gets or sets the name of the method to call to read data. | |
SheetCorner | Gets the sheet corner in the Spread component. | |
Sheets | Gets a collection of sheets for the Spread component. | |
ShowFocusRectangle | Gets or sets whether to display the focus rectangle. | |
ShowHeaderSelection | Gets or sets whether to highlight the header cells when the cells in the row or column are selected. | |
Site | (Inherited from System.Web.UI.Control) | |
SkinID | (Inherited from System.Web.UI.WebControls.WebControl) | |
Style | (Inherited from System.Web.UI.WebControls.WebControl) | |
SupportsDisabledAttribute | (Inherited from System.Web.UI.WebControls.WebControl) | |
Tab | Gets the sheet tab name information for the component. | |
TemplateControl | (Inherited from System.Web.UI.Control) | |
TemplateSourceDirectory | (Inherited from System.Web.UI.Control) | |
TitleInfo | Gets the title information. | |
ToolTip | (Inherited from System.Web.UI.WebControls.WebControl) | |
TouchInfo | Gets a TouchInfo object that determines touch behavior for Spread. | |
TouchStrips | The TouchStrip collection of Spread. | |
UIVirtualization | Gets or sets whether to use UI virtualization. | |
UniqueID | (Inherited from System.Web.UI.Control) | |
UpdateMethod | Gets or sets the name of the method to call to update data. | |
UseClipboard | Gets or sets whether to access the Clipboard with client-side scripting. | |
ValidateRequestMode | (Inherited from System.Web.UI.Control) | |
ValidationErrorMessage | Gets or sets the validation error message. | |
VerticalScrollBarPolicy | Gets or sets whether and how the Spread component displays the vertical scroll bar. | |
ViewStateMode | (Inherited from System.Web.UI.Control) | |
Visible | (Inherited from System.Web.UI.Control) | |
WaitMessage | Gets or sets the Wait Message for load on demand. | |
Width | (Inherited from System.Web.UI.WebControls.WebControl) |
Name | Description | |
---|---|---|
Adapter | (Inherited from System.Web.UI.Control) | |
ChildControlsCreated | (Inherited from System.Web.UI.Control) | |
ClientIDSeparator | (Inherited from System.Web.UI.Control) | |
Events | (Inherited from System.Web.UI.Control) | |
HasChildViewState | (Inherited from System.Web.UI.Control) | |
IdSeparator | (Inherited from System.Web.UI.Control) | |
IsTrackingViewState | (Inherited from System.Web.UI.Control) | |
LoadViewStateByID | (Inherited from System.Web.UI.Control) | |
TagKey | (Inherited from System.Web.UI.WebControls.WebControl) | |
TagName | (Inherited from System.Web.UI.WebControls.WebControl) | |
ViewState | (Inherited from System.Web.UI.Control) | |
ViewStateIgnoresCase | (Inherited from System.Web.UI.Control) |
Name | Description | |
---|---|---|
ApplyStyle | (Inherited from System.Web.UI.WebControls.WebControl) | |
ApplyStyleSheetSkin | (Inherited from System.Web.UI.Control) | |
CancelEdit | Discards the editing values in the Spread component. | |
CopyBaseAttributes | (Inherited from System.Web.UI.WebControls.WebControl) | |
DataBind | Overloaded. Overridden. Binds a data source to the Spread component. | |
FindControl | Overloaded. 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. | |
Focus | (Inherited from System.Web.UI.Control) | |
GetColumnIndex | Returns the client column index for the specified column. | |
GetEditValue | Gets the postback value of the specified cell on the active sheet in the Spread component. | |
GetExcelSheetNames | Overloaded. Gets an array of sheet names from the specified Excel file from a stream. | |
GetImage | Gets the image in the component. | |
GetMergeCell | Gets the merged cell range at the specified cell. | |
GetMergeCells | Gets the merged cell ranges in the specified range. | |
GetPageIndex | Returns the page index the specified row is rendered in. | |
GetRouteUrl | Overloaded. (Inherited from System.Web.UI.Control) | |
GetRowIndex | Returns the client row index for the specified row. | |
GetTabText | Gets the text of the sheet name tab at the specified sheet in the Spread component. | |
GetUniqueIDRelativeTo | (Inherited from System.Web.UI.Control) | |
GoalSeek | Attempts to find values for one cell that will produce the desired formula result in another cell. | |
GotoPage | Scrolls through the sheet in the component to the specified page. | |
HasControls | (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. | |
IsExcelStream | Overloaded. Opens the specified file and determines whether it meets the minimal requirements to be considered an Excel-compatible stream. | |
IsStrictMode | Determines whether the component is under strict standards-compliant mode. | |
LoadFormulas | Loads formulas that are deserialized, but not parsed yet, to be used after all sheets have been created and deserialized. | |
MergeStyle | (Inherited from System.Web.UI.WebControls.WebControl) | |
Open | Overloaded. Opens a saved Spread XML file and loads it into the Spread component. | |
OpenExcel | Overloaded. Opens an Excel stream and loads the specified Excel sheet into the specified sheet of the Spread component including the specified parts. | |
RecreateControl | Forces spread to recreate its content. | |
Reset | Resets the Spread component to its default values, removing all settings and all sheets. | |
ResolveClientUrl | (Inherited from System.Web.UI.Control) | |
ResolveUrl | (Inherited from System.Web.UI.Control) | |
Save | Overloaded. Saves the contents of the Spread component to XML in the specified file. | |
SaveChanges | Saves the changes to the Spread component. | |
SaveExcel | Overloaded. Saves the contents of the Spread component to the specified Excel file in a stream. | |
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 the specified sheet to PDF as a stream. | |
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. | |
SearchHeaders | Overloaded. Searches the text in the header cells in the specified sheet for the specified string with the specified criteria. | |
SetImage | Sets the custom image in the specified part of the Spread component interface. | |
SetProtect | Changes the protect structure setting with the password parameter. | |
Validate | Tests to see if the value is valid for a cell in the active sheet in the Spread component. |
Name | Description | |
---|---|---|
ClearCachedClientID | (Inherited from System.Web.UI.Control) | |
ClearChildControlState | (Inherited from System.Web.UI.Control) | |
ClearChildState | (Inherited from System.Web.UI.Control) | |
ClearChildViewState | (Inherited from System.Web.UI.Control) | |
ClearEffectiveClientIDMode | (Inherited from System.Web.UI.Control) | |
CreateChildControls | Overridden. Creates the child controls. | |
CreateControlCollection | (Inherited from System.Web.UI.Control) | |
CreateControlStyle | (Inherited from System.Web.UI.WebControls.WebControl) | |
DataBindChildren | (Inherited from System.Web.UI.Control) | |
EnsureChildControls | (Inherited from System.Web.UI.Control) | |
EnsureID | (Inherited from System.Web.UI.Control) | |
GetDesignModeState | (Inherited from System.Web.UI.Control) | |
Group | Groups the rows in the specified column. | |
HasEvents | (Inherited from System.Web.UI.Control) | |
IsLiteralContent | (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. | |
MoveRow | Moves the row from one location to another as specified. | |
OnBubbleEvent | (Inherited from System.Web.UI.Control) | |
OnMenuItemClicked | Raises the MenuItemClicked event. | |
OnPrintPDF | Overloaded. Processes the PrintPDF command in the Spread component. | |
OnSaveExcel | Processes the SaveExcel command in the Spread component. | |
OnTouchStripItemClicked | Raises the TouchStripItemClicked event. | |
Regroup | Rearranges the order of grouping based on the movement of the specified column. | |
RemoveGroup | Removes the grouping for the specified column and moves the column to the specified location. | |
Render | Overridden. Renders the Spread component in HTML. | |
RenderChildren | Overridden. 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. | |
ResolveAdapter | (Inherited from System.Web.UI.Control) | |
SaveViewState | Overridden. Saves the view state of the component. | |
SetDesignModeState | (Inherited from System.Web.UI.Control) | |
TrackViewState | Overridden. Invokes child IStateManager object TrackViewState() method to start tracking. | |
UpdateView | Updates the column width and the row height. |
Name | Description | |
---|---|---|
ActiveRowChanged | Occurs when the user sets the operation mode to row mode and moves the focus to a new row. | |
ActiveSheetChanged | Occurs when the user changes the active sheet. | |
Aggregate | Occurs when the data model aggregates. | |
AutoFilteredColumn | Occurs when the user is done filtering. | |
AutoFilteringColumn | Occurs when the user is filtering. | |
ButtonCommand | Occurs when a user clicks a button cell on a sheet. | |
CancelCommand | Occurs when the user clicks the Cancel button on the component. | |
CellClick | Occurs when the user clicks a cell using the left mouse button. | |
ChildViewCreated | Occurs when the user creates a child sheet. | |
ColumnHeaderClick | Occurs when the user clicks a cell in the column header using the left mouse button. | |
CreateButton | Occurs when the user clicks on the Create button. | |
DataBinding | (Inherited from System.Web.UI.Control) | |
DeleteColumnCommand | Occurs when the user clicks/touches on the DeleteColumn button on the component and deletes column(s) in the active sheet. | |
DeleteCommand | Occurs when the user clicks the Delete button on the component. | |
DeleteRowCommand | Occurs when the user clicks/touches on the DeleteRow button on the component and deletes row(s) in the active sheet. | |
Disposed | (Inherited from System.Web.UI.Control) | |
EditCommand | Occurs when the user clicks the Edit button on the component. | |
ErrorCommand | Occurs when the use of a command button causes an error. | |
ExportExcel | Occurs before saving Spread to Excel. | |
FetchGroupText | Occurs when spread creates the group bar. | |
Grouped | Occurs when the user is done grouping. | |
Grouping | Occurs when the user is grouping. | |
HideColumnCommand | Occurs when the user clicks/touches on the HideColumn button on the component and hides column(s) in the active sheet. | |
HideRowCommand | Occurs when the user clicks/touches on the HideRow button on the component and hides row(s) in the active sheet. | |
Init | (Inherited from System.Web.UI.Control) | |
InsertColumnCommand | Occurs when the user clicks/touches on the InsertColumn button on the component and inserts column(s) in the active sheet. | |
InsertCommand | Occurs when the user clicks on the Insert button on the component and inserts a new row in the active sheet. | |
InsertRowCommand | Occurs when the user clicks/touches on the InsertRow button on the component and inserts row(s) in the active sheet. | |
Load | (Inherited from System.Web.UI.Control) | |
MenuItemClicked | Occurs when the Spread context menu item is clicked. | |
PreRender | (Inherited from System.Web.UI.Control) | |
PrintAbort | Occurs continually as printing occurs in order to give the user the opportunity to discontinue a print job. | |
PrintBackground | Occurs before each page is printed. | |
PrintExternalImage | Represents a defined method that handles the PrintExternalImage event for the Spread component. | |
PrintExternalImageEnd | Represents a defined method that handles the PrintExternalImageEnd event for the Spread component. | |
PrintPDF | Occurs before printing spread to PDF. | |
PrintSheet | Occurs when a sheet is printed. | |
RowHeaderClick | Occurs when the user clicks a cell in the row header using the left mouse button. | |
SaveOrLoadSheetState | Occurs when the user saves or loads a view state of a sheet. | |
SortColumnCommand | Occurs when the user sorts a column. | |
TopRowChanged | Occurs when the user changes the top row of a sheet. | |
TouchStripItemClicked | Occurs when the TouchStrip item is clicked. | |
Ungrouped | Occurs when the user is done grouping. | |
UnhideColumnCommand | Occurs when the user clicks/touches on the UnhideColumn button on the component and un-hides column(s) in the active sheet. | |
UnhideRowCommand | Occurs when the user clicks/touches on the UnhideRow button on the component and un-hides row(s) in the active sheet. | |
Unload | (Inherited from System.Web.UI.Control) | |
UpdateCommand | Occurs when the user clicks the Update button on the component. |