Classes
| Class | Description | |
|---|---|---|
 | AggregateArgs | Represents the event data for the OnAggregate event of the data model for the sheet. |
| 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. |
| DefaultSheetDataModel.DefaultSheetDataModelEnumerator | Internal use only. Represents the object enumerator for the default sheet data model. |
| 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. |
| 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. |
| Serializer | Represents the serializer object for opening from and saving to a file. |
| 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. |
| 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. |
| ICalculationSupport | Interface that supports recalculation of formulas in the cells in the data model. |
| ICanSerializeXml | Interface that supports serialization to XML of objects that might not be able to save the entire object from the models. |
| 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. |
| IDataKeySupport | Interface that supports data keys in the data model. |
| IDataSourceSupport | Interface to support data binding and data relations. |
| 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. |
| 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. |
| IMovable | Interface that defines methods to arrange the data in an object. |
| 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. |
| 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. |
| 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. |
| IParseFormatSupport2 | Interface that supports checking whether the format string and provider are existed. |
| 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. |
| ISerializeData | Interface that supports serialization to XML of data from the models. |
| ISerializePresentation | Interface that supports serialization to XML of presentations from the models. |
| ISerializeSettings | Interface that supports serialization to XML of settings from the models. |
| ISerializeStyles | Interface that supports serialization to XML of styles from the models. |
| ISerializeSupport | Interface that supports serialization to XML of objects from the models. |
| ISerializeSupport2 | Interface that supports saving to XML with short names. |
| ISheetAxisModel | Interface for creating a model that represents column and row information. |
| ISheetDataModel | Interface for creating model that represents tabular data. |
| ISheetSelectionModel | Interface for creating a model that represents cell selection. |
| ISheetSpanModel | Interface for creating a model that represents cell spans. |
| ISheetStyleModel | Interface for creating a model that represents sheet style information. |
| 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. |
| 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 | Represents a defined method that handles the ISheetAxisModel Changed event. |
| SheetDataModelEventHandler | Represents a defined method that handles the ISheetDataModel Changed event. |
| SheetSelectionModelEventHandler | Handles the Changed event in the selection model of the sheet. |
Enumerations
| Enumeration | Description | |
|---|---|---|
 | AggregationType | Specifies the type of Aggregation on ranges of cells. |
| DefaultSheetDataModel.DataModelEnumeratorType | Internal use only. Specifies the type of data model enumerator. |
| 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. |
| 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. |
| 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. |
| SortIndicator | Specifies the display of the sort indicator. |