Spread for ASP.NET 11 Product Documentation
FarPoint.Web.Spread Namespace
Inheritance Hierarchy
FarPoint.Web.Spread Assembly : FarPoint.Web.Spread Namespace
Provides the base classes, interface, enumerations, and delegates for the Spread spreadsheet component.
Classes
 ClassDescription
ClassRepresents a set of style information for alternating rows in the component.
ClassRepresents a one-dimensional collection of alternating rows (AlternatingRow objects).
ClassRepresents the appearance of an object.
ClassRepresents the appearance settings.
ClassRepresents the AutoFilter class which sets the filter function for the multi-column combo box cell.
ClassRepresents the event data for the AutoFilteredColumn event for the Spread component, which occurs when the column has been automatically filtered.
ClassRepresents the event data for the AutoFilteringColumn event for the Spread component, which occurs when columns are being automatically filtered.
ClassRepresents an above or below average conditional formatting rule.
ClassRepresents a background (image and gradient).
ClassRepresents the cell type class that serves as a basis for other cell type classes.
ClassRepresents the drop-down cell type class that serves as a basis for other cell type classes.
ClassRepresents the basis for a custom filter.
ClassBase class that represents sparkline data infomation.
ClassRepresents the rules that determine how best to print the columns.
ClassRepresents a conditional formatting rule that accepts or does not accept a value in a range.
ClassRepresents a conditional formatting rule that accepts blank or nonblank values.
ClassRepresents the border style of a cell.
ClassRepresents the border settings.
ClassRepresents a button cell.
ClassRepresents the set of style settings for CalendarDropDownControl instances.
ClassRepresents a cell in the Spread component.
ClassRepresents a two-dimensional collection of individual cells (Cell objects).
ClassProvides a drop-down list of cell types for a property of type ICellType in the property grid.
ClassRepresents a check box cell.
ClassProvides a ColorFilter class to filter cells using the color specified in the filter criteria.
ClassRepresents a column in the component.
ClassRepresents the column footer portion of the control.
ClassRepresents the column header portion of the component.
ClassThis celltype applies an Excel-like filter to a cell in the column header.
ClassRepresents a one-dimensional collection of individual columns (Column objects).
ClassRepresents the default column in the component.
ClassRepresents the renderer of the column sparklines.
ClassRepresents a combo box cell.
ClassRepresents information about the command bar in the Spread component.
ClassRepresents a conditional format.
ClassInternal use only.
ClassInternal use only.
ClassRepresents a conditional format.
ClassRepresents a color conditional formatting value.
ClassRepresents a collection of conditional formatting color values.
ClassRepresents a set of icons which are used for an icon conditional formatting rule.
ClassRepresents a complex value of the conditional formatting icon rule.
ClassRepresents the conditional formatting model for a sheet.
ClassRepresents the event data for the Changed event of the conditional formatting model for the sheet.
ClassRepresents the base class for conditional format rules.
ClassProvides data for the IConditionalFormatting.PropertyChanged event.
ClassRepresents a complex value of a conditional formatting rule.
ClassRepresents a collection of conditional formatting values.
ClassThe Spread context menu.
ClassThe Spread menu collection.
ClassRepresents styles for the context menu.
ClassRepresents the event data for a CreateButton event.
ClassRepresents the event data for a ChildViewCreated event.
ClassRepresents a currency cell.
ClassRepresents the format setting of a cell type in edit mode.
ClassProvides a CustomFilters class that groups custom filter elements together.
ClassRepresents the data bar conditional formatting rule.
ClassRepresents a type converter for the data field of a column.
ClassRepresents a date-time cell.
ClassRepresents the format setting of a cell type in edit mode.
ClassRepresents the default filtering of rows based on specified criteria.
ClassRepresents a default row filter that extends to implement the supported row filters.
ClassRepresents the pre-defined (default) skins.
ClassRepresents the full (concrete) implementation of the ISparklineContainer interface for a sparkline model for a sheet, which represents sparklines.
ClassRepresents a collection of default style settings.
ClassProvides a drop-down list of cell types for a property of type ICellType in the property grid.
ClassRepresents a double-precision, floating-point data type cell.
ClassRepresents the format setting of a cell type in edit mode.
ClassProvides a DynamicFilter class to filter cells based on a set of built-in definitions due to DynamicFilterType.
ClassRepresents a general cell that has no editor control (returns null from GetEditorControl).
ClassRepresents a conditional formatting rule that accepts error or nonerror values.
ClassRepresents an error form.
ClassAbstract class that represents the renderer of the Excel-like sparklines.
ClassRepresents sparkline data based on the cell range.
ClassRepresents a group of Excel-like sparklines.
ClassRepresents a setting of an Excel-like sparkline.
ClassContains information about IExpressionConsumer and the expressions corresponding to its formulas.
ClassRepresents the extra setting for the renderer to paint.
ClassRepresents the event data for FetchGroupText events in the Spread component.
ClassProvides a FilterBarInfo class that represents information about the filter bar in the Spread component.
ClassThe cell type for a cell that contains the UI controls of the filter feature.
ClassRepresents a filter column definition.
ClassRepresents a collection of filter column definitions.
ClassProvides a CustomFilter class that specifies an operator and a value.
ClassRepresents a collection of custom filters.
ClassProvides a ValueFilterItem class used as filter criteria.
ClassProvides a ValueFilterItemCollection object used as a collection of alternative ValueFilterItem elements.
ClassA class support drawn image as floating in spread.
ClassRepresents the conditional formatting rule that uses a formula to determine which cells to format before starting to paint the background.
ClassStores the formula and target control id.
ClassContains all formula controls for the extender control.
ClassRepresents the extended .net control for using formulas.
ClassThe exception that is thrown when one of the formulas provided to a rule is not valid.
ClassRepresents a Web Forms (ASP.NET) Spread spreadsheet component that displays data in rows and columns.
ClassRepresents the FarPoint Spread template replacement.
ClassRepresents a general cell that can be used for text or numbers.D:\Projects\SpreadNetJ\Spread.NET\WebForms\Projects\Spread\Chart\
ClassRepresents the grouping information.
ClassRepresents the read-only collection of GroupInfo objects.
ClassRepresents the event data for grouping events in the Spread component.
ClassRepresents the filter that hides rows based on certain criteria.
ClassRepresents information about the hierarchy bar in the Spread component.
ClassRepresents the conditional formatting rule that is used before starting to paint the background.
ClassRepresents the highlight style which applies the conditional formatting rule using highlighting.
ClassRepresents a hyperlink cell.
ClassProvides an IconFilter class to filter cells using an icon specified in the filter criteria.
ClassRepresents the rule that paints an icon in the cell.
ClassRepresents an image cell.
ClassRepresents the dimensions of margins.
ClassRepresents an integer data type cell.
ClassRepresents the format setting of a cell type in edit mode.
ClassProvides data for an event in a collection.
ClassProvides data for an event in a collection.
ClassProvides data for an event in a collection.
ClassRepresents the event data for the element in a collection that has been updated.
ClassRepresents a label cell.
ClassRepresents the rules that determine whether to print in landscape format.
ClassRepresents a layout cell in the layout template.
ClassRepresents a two-dimensional collection of layout cells.
ClassRepresents a layout column in a layout template.
ClassRepresents the layout columns in the layout template.
ClassRepresents a layout row in the layout template.
ClassRepresents a one-dimensional collection of layout row objects.
ClassRepresents a layout template for the view.
ClassRepresents the line sparkline renderer.
ClassProvides data for the System.ComponentModel.IBindingList.ListChanged event.
ClassRepresents a list box cell.
ClassRepresents an item in a combo box, list box, or radio button cell.
ClassThe event arguments for the MeasureIconSize event handler.
ClassThe Spread menu item.
ClassThe event arguments for the Spread context menu item click event.
ClassThe Spread menu item collection.
ClassRepresents a multiple-column combo box cell.
ClassProvides a Filters class to filter items using a criteria values list.
ClassRepresents a named style, an object that can be used to set style information for other objects.
ClassRepresents a collection of named styles (NamedStyle objects).
ClassRepresents the event data for the NamedStyleCollection object's Changed event.
ClassRepresents information about the page navigation aids in the Spread component.
ClassProvides a drop-down list of parent style names for the ParentStyleName property in the Cell, Column, Row, and AlternatingRow classes.
ClassRepresents a percent value data type cell.
ClassRepresents a conditional format rule that is executed before painting the cell.
ClassRepresents the executed result of a conditional formatting rule.
ClassRepresents the conditional formatting rule that is used for painting before the text is painted.
ClassRepresents the painting result of a conditional formatting rule.
ClassRepresents the preview row information.
ClassRepresents an editing template container.
ClassRepresents the event data for the PrintAbort event for the Spread component, which allows the user to discontinue the printing at any time during a print job.
ClassRepresents the event data for the PrintBackground event for the Spread component, which occurs when the background is printing.
ClassRepresents the event data for a Print event.
ClassRepresents the event data for the PrintExternalImage and PrintExternalImageEnd events for the Spread component, which allow the user to print an external image.
ClassRepresents the information to use when printing a sheet of the control.
ClassRepresents the margin for the printed page.
ClassRepresents the event data for a PrintPDF event.
ClassRepresents raising an event when the property has changed and has infomation about the current value and the previous value.
ClassRepresents a radio button list cell.
ClassKeeps the information about which cell ranges contain the elements.
ClassRepresents a regular expression cell.
ClassRepresents the event data for the FormulaChanged event, which occurs when an object that contains the sheet cell ranges notifies that formulas have been changed and that the SheetCellRange needs to be updated.
ClassRepresents a row in the component.
ClassRepresents a row edit template container.
ClassRepresents the row header portion of the component.
ClassRepresents a one-dimensional collection of individual rows (Row objects).
ClassRepresents the default row in the component.
ClassRepresents the event data for a SaveExcel event.
ClassRepresents the rules that determine how to scale the printed sheet.
ClassRepresents the corner of the control.
ClassRepresents a skin, which provides style settings for a sheet.
ClassRepresents the sheet style properties.
ClassRepresents a sheet in the Spread component.
ClassRepresents a collection of sheets (SheetView objects).
ClassRepresents the event data for the SaveOrLoadSheetState event.
ClassRepresents the rules that determine the paper size.
ClassRepresents the rules that determine how best to print.
ClassRepresents the set of rules that determine how best to print.
ClassRepresents information for sorting.
ClassRepresents a sparkline in a cell.
ClassRepresents the event data for the UpdatedCellRanges event, which occurs when a list of cell ranges are updated.
ClassRepresents the event data for any of several command events in the Spread component.
ClassRepresents a Spread ControlBuilder class.
ClassRepresents a range of data in the Spread component that can be bound to other controls.
ClassRepresents the mechanism for data-bound controls to get data from the Spread component as a data source.
ClassSpecifies the font style information applied to the text.
ClassDisplays the image object in spread.
ClassRepresents a collection of SpreadImage objects.
ClassProvides a user interface that can edit SpreadImageCollection at design time.
ClassA class support renders the image
ClassRead-only collection of default (built-in) sparkline renderers.
ClassThe state list base.
ClassHandles the state view of the child class that is derived from it.
ClassRepresents the style information for a cell with such settings as color, alignment, font, and borders.
ClassProvides a drop-down list of style names for the StyleName property in the Cell, Column, Row, and AlternatingRow classes.
ClassRepresents the filter that sets the styles of rows based on certain criteria.
ClassRepresents the information about the sheet name tabs that are displayed in the command bar at the bottom of the component.
ClassRepresents a tag cloud cell (weighted list of linked items).
ClassRepresents a text cell.
ClassRepresents the conditional formatting rule used for checking text values.
ClassRepresents the color scale conditional formatting rule with one middle value.
ClassRepresents a conditional formatting rule that accepts periods of time.
ClassRepresents information about the title bar in the Spread component.
ClassProvides a Top10Filter class to filter cells whose values are numeric.
ClassRepresents a top bottom conditional formatting rule.
ClassRepresents all touch behavior's settings.
ClassRepresents the TouchStrip class.
ClassRepresents the Spread TouchStrip collection.
ClassRepresents the TouchStripItem class.
ClassRepresents the TouchStripItemClickEventArgs class.
ClassThe Spread menu item collection.
ClassRepresents the two color scale conditional formatting rule.
ClassRepresents the conditional formatting rule that is used before starting to paint the background.
ClassRepresents a conditional formatting rule that accepts unique or duplicated values.
ClassA collection of validators.
ClassRepresents the renderer of the win/loss sparklines.
ClassRepresents a worksheet layout cell in the worksheet layout template.
ClassRepresents a two-dimensional collection of worksheet layout cells.
ClassRepresents a worksheet layout template for the view.
ClassRepresent a format for a header of a year-month calendar.
Interfaces
 InterfaceDescription
InterfaceUpdates spread using the delegate method.
InterfaceInterface that supports validating data using custom validator controls on the server side.
InterfaceInterface that supports automatic postback.
InterfaceInterface for resolving custom formulas.
InterfaceInterface that supports the cell types.
InterfaceInterface that supports conditional formatting of cells on a sheet.
InterfaceInterface that supports conditional formatting of cells on a sheet.
InterfaceRepresents an interface which provides supported requirements for a conditional formatting rule.
InterfaceRepresents the conditional formatting model for a sheet.
InterfaceRepresents a conditional formatting rule.
InterfaceRepresents an interface that works with DateTime values.
InterfaceInterface that supports printing to PDF, which supports extended features.
InterfaceInterface that defines the methods and properties required by objects used as enhanced renderers which supports extended features. Renderers are responsible for painting cells.
InterfaceProvides a unified way of converting types of values to a value used for Excel export.
InterfaceInterface that supports the ability to extend objects by adding arbitrary properties (called expando properties).
InterfaceInterface that supports style filters in the style model for filtering rows on a sheet.
InterfaceInterface that supports the creation of custom row filters for filtering rows on a sheet.
InterfaceInterface that supports row filters for filtering rows on a sheet.
InterfaceInterface that extends IConditionalFormattingRule functions to support IFilterItem.
InterfaceInterface that notifies Spread when the item is changed.
InterfaceInterface that notifies Spread when the item is changed.
InterfaceInterface that supports additional optimization in the conditional formatting model beyond IOptimizedFilterConditionalFormattingModel.
InterfaceInterface that supports additional optimization for retrieval of styles in the style model beyond IOptimizedFilterStyleModel.
InterfaceInterface that supports the PDF printing of the border.
InterfaceRepresents the conditional formatting rule that is used for painting to PDF before the text is painted.
InterfaceInterface that supports printing to PDF (Portable Document Format).
InterfaceRepresents the conditional formatting rule that is used before starting to paint the background.
InterfaceRepresents the conditional formatting rule that is used for painting before the text is painted.
InterfaceInterface for notifying Spread when the property changes from the previous value.
InterfaceInterface that supports row filters for filtering rows on a sheet.
InterfaceInterface that supports a row filter combo box in Web Forms.
InterfaceInterface for supporting optional filtering of frozen rows.
InterfaceInterface that supports row filters for filtering rows on a sheet. It provides better performance and uses less memory than the original IRowFilter.
InterfaceInterface that causes the SheetCellRange container to reevaluate the SheetCellRange when the formula changes.
InterfaceInterface that supports the creation of custom row filters for filtering rows on a sheet. The filtered result is always sorted in ascending order.
InterfaceInterface that supports creating a sparkline.
InterfaceInterface that supports creating a model that represents a sparkline.
InterfaceInterface that supports creating a group of sparklines.
InterfaceInterface that supports creating a renderer for painting sparklines.
InterfaceInterface that supports creating a setting for sparklines.
InterfaceRepresents APIs which support sparklines in Spread ASP.NET.
InterfaceRepresents the conditional formatting rule that is used before starting to paint the background and can stop all following conditional formatting rules.
InterfaceRepresents APIs which support sparklines in Spread ASP.NET.
InterfaceInterface that supports the wrapable renderer controls.
Structures
 StructureDescription
StructureRepresent a range in one-dimension which is defined by the start index and end index.
StructureEnumerates the elements of a ListBase<T>.
Delegates
 DelegateDescription
DelegateRepresents a defined method that handles the AutoFilteredColumn event for the Spread component.
DelegateRepresents a defined method that handles the AutoFilteringColumn event for the Spread component.
DelegateRepresents the method that handles an event after the group is cleared.
DelegateUpdates the spread UI.
DelegateRepresents a defined method that handles the CreateButton event in the Spread component.
DelegateRepresents a defined method that handles the ChildViewCreated event in the Spread component.
DelegateRepresents a defined method that handles the FetchGroupText event in the Spread component.
DelegateRepresents a defined method that handles the Grouping event in the Spread component.
DelegateRepresents the method that handles an event after the item is operated on.
DelegateRepresents the method that handles an event after the item is operated on.
DelegateRepresents the method that will handle the ListBase<T>.ListChanged event of the ListBase<T> class.
DelegateThe delegate for measuring size of an icon for the icon conditional formatting rule in a cell.
DelegateRepresents the menu item click handler.
DelegateRepresents a defined method that handles the NamedStyleCollection Changed event.
DelegateRepresents a defined method that handles the PrintAbort event for the Spread component.
DelegateRepresents a defined method that handles the PrintBackground event for the Spread component.
DelegateRepresents a defined method that handles the PrintSheet event in the Spread component.
DelegateRepresents a defined method that handles the PrintExternalImage event for the Spread component.
DelegateRepresents a defined method that handles the PrintPDF event in the Spread component.
DelegateRepresents an event handler which is raised when the property has changed and has infomation about the current value and the previous value.
DelegateRepresents the event handler for the FormulaChanged event, which occurs when an object that contains the sheet cell ranges notifies that formulas have been changed and that the SheetCellRange needs to be updated.
DelegateRepresents a defined method that handles the SaveExcel event in the Spread component.
DelegateRepresents a defined method that handles the SaveOrLoadSheetState event in the Spread component.
DelegateRepresents the event handler for the UpdatedCellRanges event, which occurs when an object that contains the sheet cell ranges notifies that formulas have been changed and that the SheetCellRange needs to be updated.
DelegateRepresents a defined method that handles the Spread command events.
DelegateRepresents the TouchStripItemClickedHandler delegate.
Enumerations
 EnumerationDescription
EnumerationProvides data for the FarPoint.Win.Spread.SheetView.AutoFilterMode property.
EnumerationSpecifies how the buttons are displayed in the command bar of the Spread component.
EnumerationThe enum represents calendar type.
EnumerationSpecifices the type of centering for the printed page.
EnumerationSpecifies the operator for conditional formats.
EnumerationSpecifies the ConditionalFormatting dialog that can get by method GetConditionalFormatDialog of util class ConditionalFormattingUtils.
EnumerationRepresents the predefined icon for conditional formatting.
EnumerationRepresents the style of the icon set.
EnumerationSpecifies the type of Change event that has occurred for a conditional formatting model for the sheet.
EnumerationRepresents the value type of the conditional formatting.
EnumerationThe Spread menu types.
EnumerationSpecifies the type of cursor.
EnumerationSpecifies the operator for custom filtering.
EnumerationRepresents the axis position for the data bar.
EnumerationSpecifies how to display the DatePicker control in the filter bar.
EnumerationSpecifies the limit of the items to display in the tag cloud.
EnumerationDetermines how the Spread control renders content for a specific browser mode.
EnumerationSpecifies a value that indicates the type of dynamic filter.
EnumerationSpecifies how the filter context menu is loaded.
EnumerationSpecifies how the row filter behaves.
EnumerationSpecifies the match methods used in the automatic filter.
EnumerationSpecifies the data column in the combo box to search for a match when using the automatic filter.
EnumerationSpecifies the type of filter menu in the filter bar.
EnumerationSpecifies the style of the border for the focus rectangle of the Spread component.
EnumerationSpecifies which, if any, automatic text appears in column or row headers.
EnumerationSpecifies appearance style for the image button in the Spread component.
EnumerationSpecifies the state of an Input Method Editor (IME) for using a Western keyboard for entering East Asian characters.
EnumerationSpecifies how the item changed
EnumerationIndicates the mode of loading the next rows (standard or in background).
EnumerationSpecifies the method for loading the next set of rows (after a period of time or after the user scrolls to the row at the SheetView.LoadOffsetFromBottom position).
EnumerationSpecifies the NamedStyleCollection Changed event.
EnumerationSpecifies how the sheet responds to user interaction and how selection behaves.
EnumerationSpecifies whether the overline font style is applied to the text.
EnumerationSpecifies which type of page navigation aids are shown in the Spread component.
EnumerationSpecifies in which tool bars the page navigation aids are displayed in the Spread component.
EnumerationSpecifies which areas to execute in parallel.
EnumerationSpecifies whether the header is printed.
EnumerationSpecifies how cell notes are printed.
EnumerationSpecifies the page orientation used to print the sheet.
EnumerationSpecifies the order in which pages are printed.
EnumerationSpecifies whether the title is printed.
EnumerationSpecifies the type of print range used to print the sheet.
EnumerationSpecifies whether regular, bold, or italic font styles are applied to the text.
EnumerationSpecifies the type of replacement.
EnumerationSpecifies whether the rules or a particular rule should reset before testing the next rule.
EnumerationSpecifies a value that indicates whether the text appears from right to left, such as when using Hebrew or Arabic fonts.
EnumerationSpecifies how scroll bars (if at all) are displayed in the Spread component.
EnumerationSpecifies where the search string is found.
EnumerationSpecifies the backcolor style for the display of selected cells.
EnumerationSpecifies which part of the sheet can be selected by the user.
EnumerationSpecifies the type of layout mode.
EnumerationSpecifies how to show the frozen indicator.
EnumerationSpecifies the order of sorting for the items in the tag cloud.
EnumerationAn enumeration that specifies information about how the vertical axis minimum or maximum is computed for this sparkline group.
EnumerationRepresents the type of sparkline.
EnumerationRepresents identifiers for custom images in the component.
EnumerationSpecifies how Spread reacts to touch manipulation.
EnumerationSpecifies whether the strikeout font style is applied to the text.
EnumerationSpecifies how (if at all) sheet name tabs are displayed in the command bar in the Spread component.
EnumerationRepresents operators applied for text conditional formatting.
EnumerationSpecifies if text in the tag cloud item is decorated with additional formatting.
EnumerationRepresents a time period which is used in a date conditional formatting rule. These are dynamic time periods, which change based on the date when the conditional formatting rule is refreshed or applied.
EnumerationSpecifies what area requires the TouchStrip popup.
EnumerationRepresents the unary comparison operator.
EnumerationSpecifies whether the underline font style is applied to the text.
See Also

Reference

FarPoint.Web.Spread Assembly