Classes
| Class | Description | |
|---|---|---|
 | AggregateArgs | Represents the event data for the OnAggregate event of the data model for the sheet. |
| AggregationDataModel | Represents the aggregation data model. |
| BaseSheetAxisModel | Represents the partial (abstract) implementation of the ISheetAxisModel interface for an axis model for a sheet. |
| BaseSheetDataModel | Represents the partial (abstract) implementation of the ISheetDataModel interface for a data model for a sheet. |
| BaseSheetSelectionModel | Represents the partial (abstract) implementation of the ISheetSelectionModel interface for a selection model for a sheet. |
| BaseSheetSpanModel | Represents the partial (abstract) implementation of the ISheetSpanModel interface for a span model for a sheet. |
| BaseSheetStyleModel | Represents the partial (abstract) implementation of the ISheetStyleModel interface for a style model for a sheet. |
| CellRange | Represents a selected range of cells for a sheet. |
| CellRangeConverter | Represents a data type converter for a range of cells. |
| DefaultSheetAxisModel | Represents the full (concrete) implementation of the ISheetAxisModel interface for an axis model for a sheet, which represents rows and columns on a sheet. |
| DefaultSheetDataModel | Represents the full (concrete) implementation of the ISheetDataModel interface for a data model for a sheet, which represents tabular data on a sheet. |
| DefaultSheetSelectionModel | Represents the full (concrete) implementation of the ISheetSelectionModel interface for a selection model for a sheet, which represents cell selections. |
| DefaultSheetSpanModel | Represents the full (concrete) implementation of the ISheetSpanModel interface for a span model for a sheet, which represents cell spans. |
| DefaultSheetStyleModel | Represents the full (concrete) implementation of the ISheetSpanModel interface for a style model for a sheet, which represents cell styles. |
| GeneralFormatter | Represents the formatter object for parsing and formatting values for the general cell type. |
| Group | Represents the group of rows for the grouping display (also called Outlook-style grouping). |
| GroupDataModel | Represents the group data model. |
| GroupFooter | Represents the group footer of rows for the grouping display (also called Outlook-style grouping). |
| InvalidExternalReferenceParseException | Represents the exception that is thrown when an error is encountered which caused by invalid external reference during the parsing of a text representation of an expression. |
| MapperUpdatingEventArgs | Represents the event data for the mapper updating event of the mapper. |
| ParseException | Represents the exception that is thrown when an error is encountered during the parsing of a text representation of an expression. |
| PropertyChangingEventArgs | Represents the event data for the PropertyChanging event of the object. |
| SheetAxisModelChangingEventArgs | Represents the event data for the Changing event of the axis model for the sheet. |
| SheetAxisModelEventArgs | Represents the event data for the Changed event of the axis model for the sheet. |
| SheetAxisProperty | Represents the properties for the axis model for the sheet. |
| SheetDataModelEventArgs | Represents the event data for the Changed event of the data model for the sheet. |
| SheetGroupDataModelEventArgs | Specifies the type of Change event that has occurred in group footer. |
| SheetSelectionModelEventArgs | Represents the event data for the Changed event of the selection model for the sheet. |
| SheetSpanModelEventArgs | Represents the event data for the Changed event of the span model for the sheet. |
| SheetStyleModelEventArgs | Represents the event data for the Changed event of the style model for the sheet. |
| SpreadSerializer | Represents the serializer object for opening from and saving to a file the entire Spread component and all its data. |
Interfaces
| Interface | Description | |
|---|---|---|
 | IAggregationSupport | Interface that supports Aggregate functionality on ranges of cells in the data model. |
| IArraySupport | Interface that supports arrays of values in a range of cells in the data model. |
| IAutoFilterIndexSupport | Interface for supporting setting a specific column header row index in which to display the column auto filter indicator. |
| IAutoSortIndexSupport | Interface for supporting setting a specific column header row index in which to display the column auto sort indicator. |
| ICalculationSupport | Interface that supports recalculation of formulas in the cells in the data model. |
| IChartSupport | Interface that supports notifying that the data model has changed. |
| IChildModelSupport | Interface that supports a child data model in the data model. |
| IClearDataSupport | Interface that supports clearing data from the specified range. |
| IClearFormulasSupport | Interface that supports clearing formulas from the specified range. |
| ICustomFunctionSupport | Interface that supports user-defined functions in formulas in the data model. |
| ICustomFunctionSupport2 | Interface that supports user-defined functions in formulas in the data model. |
| ICustomNameSupport | Interface that supports user-defined names in formulas in the data model. |
| ICustomNameSupport2 | Interface that supports user-defined names in formulas in the data model. |
| IDataSourceSupport | Interface that supports data binding and data relations in the data model. |
| IDisjointSelections | Interface that supports an ordered array of cell ranges, from largest to smallest, containing the selected cells with the minimal overlap between the ranges. |
| IEditableObjectSupport | Defines the interface for objects that are editable data rows in a data set. |
| IExpressionSupport | Interface that supports formulas as values and as expressions in the data model. |
| IExpressionSupport2 | Interface that supports additional formula functionality in the data model including conditional cell formats. |
| IGroupFooterSupport | Interface that supports footer |
| IGroupSupport | Interface that supports grouping. |
| IItemTypeSupport | Interface that supports data binding to collections. |
| IIterationSupport | Interface that supports recursive formulas (with circular references) in the data model. |
| IMapper | Interface that support mapping between group view and target model |
| IMapperSupport | Provides an interface that allows mapping |
| IMovable | Interface that supports arranging the items in an object in the data model. |
| INamedStyleSupport | Interface that supports collections of custom styles in the style model. |
| INameSupport | Interface that supports a name of a data model. |
| INameSupport2 | Interface that supports a name of a data model. Including notify NameChanging event |
| INonEmptyCells | Interface that supports determining the number of columns and rows with data in the data model. |
| INotifySelectionChanged | Represents a selection model with a group operations, which will return a result indicating whether the selection is changed. |
| INotifySheetAxisModelChanging | Interface that supports notifying that the axis model is going to change. |
| IOptimizedEnumerationSupport | Interface that supports optimization for retrieval of data in the data model. |
| IOptimizedEnumerationSupport2 | Interface that supports additional optimization for retrieval of data in the data model beyond IOptimizedEnumerationSupport. |
| IOptimizedEnumerationSupport3 | Interface that supports additional optimization for retrieval of data in the data model beyond IOptimizedEnumerationSupport2. |
| IOptimizedEnumerationSupport5 | Interface that supports additional optimization for retrieval of data in the data model beyond IOptimizedEnumerationSupport3. |
| IOptimizedSheetAxisModelSupport | Interface that supports optimizing for axis model to return visible element count. |
| IOptimizedSheetAxisModelSupport2 | Interface that supports optimizing for axis model to return visible element count. |
| IParentStyleModelSupport | Interface that supports a parent style model for composing styles. |
| IParseFormatSupport | Interface that supports format strings and providers for the style model for the sheet. |
| IQuerySelection | Interface that supports querying an extended selection in the selection model for the sheet. |
| IRangeSupport | Interface that supports operations on ranges of cells in the data model. |
| ISheetAxisModel | Interface that supports creating a model that represents column and row information. |
| ISheetDataModel | Interface that supports creating a model that represents tabular data. |
| ISheetSelectionModel | Interface that supports creating a model that represents cell selection. |
| ISheetSpanModel | Interface that supports creating a model that represents cell spans. |
| ISheetStyleModel | Interface that supports creating a model that represents cell style information for a sheet. |
| ISuspendFormulaParsing | Interface that supports suspension of formula parsing during deserialization. |
| IUnboundRowAddNewRowSupport | Support operation on DataAddNew Unbound row |
| IUnboundRowSupport | Interface that supports unbound rows when the model is bound to a data source. |
Delegates
| Delegate | Description | |
|---|---|---|
 | AggregateEventHandler | Handles the data aggregate in the data model of the sheet. |
| GroupFooterEventHandler | Handles the Changed event in the data model of group footer. |
| MapperUpdatingEventHandler | Handles the updating event of the mapper. |
| PropertyChangingEventHandler | Handles the Changed event in the data model of the sheet. |
| SheetAxisModelChangingEventHandler | Handles the Changing event for the axis model for the sheet. |
| SheetAxisModelEventHandler | Handles the Changed event for the axis model for the sheet. |
| SheetDataModelEventHandler | Handles the Changed event in the data model of the sheet. |
| SheetSelectionModelEventHandler | Handles the Changed event in the selection model of the sheet. |
| SheetSpanModelEventHandler | Handles the Changed event in the span model of the sheet. |
| SheetStyleModelEventHandler | Handles the Changed event in the style model of the sheet. |
Enumerations
| Enumeration | Description | |
|---|---|---|
 | AggregationType | Specifies the type of Aggregation on ranges of cells. |
| GroupingPolicy | Specifies a grouping policy to collapse or expand rows when grouping occurs in the Spread component. |
| IncludeHeaders | Specifies which spreadsheet headers should be included. |
| MapperUpdatingEventType | Specifies the type of mapper updating event that has occurred for the mapper. |
| MergePolicy | Specifies how the control handles automatic merging of cells based on the values in the cells. |
| ReferenceStyle | Specifies the reference style in formulas and custom names in the sheet. |
| SelectionPolicy | Specifies how users can select items in the control. |
| SelectionUnit | Specifies the smallest unit users or the application can select. |
| SheetAxisModelEventType | Specifies the type of Change event that has occurred for an axis model for the sheet. |
| SheetAxisOrientation | Specifies the orientation for the layout information, whether by row or column, for the axis model for the sheet. |
| SheetDataModelEventType | Specifies the type of Change event that has occurred for an axis model for the sheet. |
| SheetSpanModelEventType | Specifies the type of Change event that has occurred for a span model for the sheet. |
| SheetStyleModelEventType | Specifies the type of Change event that has occurred for an style model for the sheet. |
| SortIndicator | Specifies the display of the sort indicator. |
Remarks
For more information about how to use the models, refer to Using Models.
For a list of the namespaces of this assembly, refer to the FarPoint.Win.Spread assembly.