FarPoint.Web.Spread.Model Namespace

In This Topic

Provides the base classes, interfaces, and enumerations for the underlying models.

Classes

	Class	Description
	AggregateArgs	Represents the event data for the OnAggregate event of the data model for the sheet.
	AutoFilterIndexChangedEventArgs	Represents the event data for the AutoFilterIndexChanged event for the IAutoFilterIndexSupport model, which occurs when the automatic filter index has been changed.
	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 in the grouping display (also called Outlook-style grouping).
	InvalidExternalReferenceParseException	Represents the exception that is thrown when an error is encountered which is caused by an 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.
	RequestRowVisibleStatesEventArgs	Represents the event data for the RequestRowVisibleStates 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 the group footer.
	SheetSelectionModelEventArgs	Represents the event data for the Changed event of the selection 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 the 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 automatic filter indicator.
	IAutoFilterIndexSupport2	Interface for supporting setting a specific column header row index in which to display the column automatic filter indicator.
	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.
	IDataSourceSupport2	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 minimal overlap between the ranges.
	IEditableObjectSupport	Defines the interface for objects that are editable data rows in a data set.
	IExpressionConsumer	Interface that supports a class to bind its formulas to the data model.
	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.
	IFindRowsVisibleStateSupport	Interface that supports getting the row's visible state.
	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. Notifies the 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.
	IObjectExpressionSupport	Interface that enables the class to support objects to bind their formulas to its instance.
	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.
	IOptimizedEnumerationSupport7	Interface that supports additional optimization for retrieval of data in the data model.
	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.
	IPageBreakSupport	Interface that supports pagination at the specified rows and columns when printing to PDF or a printer on the client.
	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 exist.
	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.
	IReceiveRowsVisibleStateChangedNotificationSupport	Interface that supports the data model receiving notification about the change of the rows visible state and supports the data model getting the rows' visible states with the RequestRowVisibleStates event.
	ISerializeData	Interface that supports serialization to XML of data from the models.
	ISerializePresentation	Interface that supports serialization of presentations from the models to XML.
	ISerializeSettings	Interface that supports serialization to XML of settings from the models.
	ISerializeStyles	Interface that supports serialization of styles from the models to XML.
	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.
	ISheetStyleModel2	Interface that supports creating a model that represents cell style information for a sheet.
	ISheetStyleModel3	Interface that supports creating a model that represents cell style information for a sheet and gets composite of filtered style setting
	ISuspendFormulaParsing	Interface that supports suspension of formula parsing during deserialization.
	IUnboundRowAddNewRowSupport	Supports the operation on DataAddNew for an 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.
	AutoFilterIndexChangedEventHandler	Represents a defined method that handles the AutoFilterIndexChanged event for the IAutoFilterIndexSupport model.
	GroupFooterEventHandler	Handles the Changed event in the data model of the group footer.
	PropertyChangingEventHandler	Handles the Changed event in the data model of the sheet.
	RequestRowVisibleStatesEventHandler	Handles RequestRowVisibleStates event.
	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.
	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.
	DefaultSheetDataModel.DataModelEnumeratorType	Internal use only. Specifies the type of data model enumerator.
	ExcludeContents	Specifies a value that indicates whether a property is ignored when iterating through rows via the next non-empty logic.
	FormulaChangedType	Provides information about change related to the formula of the IExpressionConsumer.
	FormulaContextType	Specifies the type of a formula.
	FormulaRestrictedCondition	The restrictions of formulas.
	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.
	SheetStyleModelEventType	Specifies the type of Change event that has occurred for a style model for the sheet.
	SortIndicator	Specifies the display of the sort indicator.

Reference

FarPoint.Web.Spread Assembly

User-Task Documentation

Using the Sheet Models