FarPoint.Win.Spread.Model Namespace

Provides the classes, interfaces, enumerations, and event handlers for the models in the Spread for Windows Forms spreadsheet component.

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.
	ConvertTableToRangeEventArgs	Represent the adding event data when convert table to range
	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.CellEventArgs	/// Provides data for the Cell event of the FpSpread control.
	DefaultSheetDataModel.RowEventArgs	Provides data for the Row event of the FpSpread control.
	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.
	FormulaDependentInfos	Represents the result which contain the information of all dependent formula containers in a sheetview that have formula reference to cells in a cellrange or a table.
	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.
	InvalidNameException	/// Represents the exception that is thrown when an error is encountered
	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.
	RequestRowVisibleStatesEventArgs	Represents the event data for the RequestRowVisibleStates 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 the group footer.
	SheetSelectionModelEventArgs	Represents the event data for the Changed event of the selection model for the sheet.
	SheetSpanModelChangingEventArgs	Represents the event data for the Changing event of the span 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.
	TableItemChangedEventArgs	Represents the event data for the Changed event of the data model for the sheet.
	TableItemChangingEventArgs	Represents the event data for the Changed event of the data model for the sheet.
	TableItemNameChangedEventArgs	Presents changed table item data.
	TableItemNameChangingEventArgs	Presents changing table collection data.
	TableNameChangedEventArgs	Presents changed table name data.
	TableNameChangingEventArgs	Presents changing table name 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.
	IAutoSortIndexSupport	Interface for supporting setting a specific column header row index in which to display the column automatic 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.
	ICustomNameSupport3	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.
	IDataSourceSupport1
	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.
	IEnhancedCustomNameSupport	Interface that supports enhanced methods for user-defined names in formulas in the data model.
	IEnhancedCustomNameSupport2	Interface that supports enhanced methods for user-defined names in formulas in the data model.
	IErrorTextSupport	Interface that supports creating a model that represents the error icon.
	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 support get row's visible state.
	IGroupFooterSupport	Interface that supports the footer.
	IGroupSupport	Interface that supports grouping.
	IGroupSupport2	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 supports mapping between the 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. Notifies the 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 group operations, that returns a result indicating whether the selection has changed.
	INotifySheetAxisModelChanging	Interface that supports notifying that the axis model is going to change.
	IObjectExpressionSupport	Interface that enable 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.
	IOptimizedEnumerationSupport5	Interface that supports additional optimization for retrieval of data in the data model beyond IOptimizedEnumerationSupport3.
	IOptimizedEnumerationSupport6	Interface that supports additional optimization for retrieval of data in the data model beyond IOptimizedEnumerationSupport5.
	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.
	IOptimizedSheetAxisModelSupport3	Interface that supports optimizing for axis model to return index visible element .
	IOptimizedSheetAxisModelSupport4	Interface that supports optimizing for axis model.
	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.
	IReceiveRowsVisibleStateChangedNotificationSupport	Interface that support datamodel receive notification about the change of rows visible states and support data model get the rows' visible states through RequestRowVisibleStates event.
	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.
	ISheetSpanModelChangingEventSupport	Interface that supports Changing event in span model.
	ISheetStyleModel	Interface that supports creating a model that represents cell style information for a sheet.
	ISupportFindFormulaDependent	Interface that enable the class to support find all the formula containers that have formula reference to cells or table
	ISuspendFormulaParsing	Interface that supports suspension of formula parsing during deserialization.
	ITableColumn	Provides an interface that present for a table column.
	ITableColumnCollection	Interface that supports to iterate through ITableColumn items.
	ITableColumnExpressionConsumer	Interface that supports a table to bind its formulas to the data model.
	ITableDataColumn	Provides an interface that presents data for a table column.
	ITableModelSupport	Represent a ITableModelSupport interface.
	ITableRange	Represents an ITableRange interface.
	ITableRangeManager	Represent a ITableRangeManager interface.
	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.

Structures

	Structure	Description
	FormulaDependentInfos.Cell	Represents a cell

Delegates

	Delegate	Description
	AggregateEventHandler	Handles the data aggregate in the data model of the sheet.
	DefaultSheetDataModel.DataModelCellErrorTextEventHandler	Represents a defined method that handles the ErrorTextChange event for the Spread component.
	DefaultSheetDataModel.DataModelRowErrorTextEventHandler	Represents a defined method that handles the RowErrorTextChange event for the Spread component.
	GroupFooterEventHandler	Handles the Changed event in the data model of the group footer.
	MapperUpdatingEventHandler	Handles the updating event of the mapper.
	PropertyChangingEventHandler	Handles the Changed event in the data model of the sheet.
	ReferenceStyleEventHandle	Handles the changed ReferenceStyleEventHandle 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	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.
	SheetSpanModelChangingEventHandler	Handles the Changing event in the span 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.
	TableItemChangedEventHandler	Handles the TableCollectionItemChanged event in the ITableRangeManager.
	TableItemChangingEventHandler
	TableItemNameChangedEventHandler	Handles TableCollectionItemNameChanged event.
	TableItemNameChangingEventHandler	handles TableCollectionItemNameChanging event.
	TableNameChangedEventHandler	Handles the TableNameChanged event.
	TableNameChangingEventHandler	Handles TableNameChanging event.

Enumerations

	Enumeration	Description
	AggregationType	Specifies the type of aggregation on ranges of cells.
	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.
	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.
	SheetSpanModelChangingEventType	Specifies the type of Changing event that is going to occur for a span 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 a style model for the sheet.
	SortIndicator	Specifies the display of the sort indicator.
	TableChangeEventType	Table changed type.
	TableChangeType	Table change type
	TableItemChangeEventType	Table item change type.

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.

Reference

FarPoint.Win.Spread Assembly

User-Task Documentation

Using Sheet Models