Spread Windows Forms 9.0 Product Documentation
FarPoint.Win.Spread.Model Namespace
Inheritance Hierarchy
Provides the classes, interfaces, enumerations, and event handlers for the models in the Spread for Windows Forms spreadsheet component.
Classes
 ClassDescription
ClassAggregateArgs Represents the event data for the OnAggregate event of the data model for the sheet.
ClassAggregationDataModel Represents the aggregation data model.
ClassBaseSheetAxisModel Represents the partial (abstract) implementation of the ISheetAxisModel interface for an axis model for a sheet.
ClassBaseSheetDataModel Represents the partial (abstract) implementation of the ISheetDataModel interface for a data model for a sheet.
ClassBaseSheetSelectionModel Represents the partial (abstract) implementation of the ISheetSelectionModel interface for a selection model for a sheet.
ClassBaseSheetSpanModel Represents the partial (abstract) implementation of the ISheetSpanModel interface for a span model for a sheet.
ClassBaseSheetStyleModel Represents the partial (abstract) implementation of the ISheetStyleModel interface for a style model for a sheet.
ClassCellRange Represents a selected range of cells for a sheet.
ClassCellRangeConverter Represents a data type converter for a range of cells.
ClassConvertTableToRangeEventArgs Represents the add event data when converting a table to a range.
ClassDefaultSheetAxisModel Represents the full (concrete) implementation of the ISheetAxisModel interface for an axis model for a sheet, which represents rows and columns on a sheet.
ClassDefaultSheetDataModel Represents the full (concrete) implementation of the ISheetDataModel interface for a data model for a sheet, which represents tabular data on a sheet.
ClassDefaultSheetDataModel.CellEventArgs /// Provides data for the Cell event of the FpSpread control.
ClassDefaultSheetDataModel.RowEventArgs Provides data for the Row event of the FpSpread control.
ClassDefaultSheetSelectionModel Represents the full (concrete) implementation of the ISheetSelectionModel interface for a selection model for a sheet, which represents cell selections.
ClassDefaultSheetSpanModel Represents the full (concrete) implementation of the ISheetSpanModel interface for a span model for a sheet, which represents cell spans.
ClassDefaultSheetStyleModel Represents the full (concrete) implementation of the ISheetSpanModel interface for a style model for a sheet, which represents cell styles.
ClassFormulaDependentInfos Represents the result which contains the information of all dependent formula containers in a sheetview that have formula references to cells in a cell range or a table.
ClassGeneralFormatter Represents the formatter object for parsing and formatting values for the general cell type.
ClassGroup Represents the group of rows for the grouping display (also called Outlook-style grouping).
ClassGroupDataModel Represents the group data model.
ClassGroupFooter Represents the group footer of rows in the grouping display (also called Outlook-style grouping).
ClassInvalidExternalReferenceParseException 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.
ClassInvalidNameException /// Represents the exception that is thrown when an error is encountered.
ClassMapperUpdatingEventArgs Represents the event data for the mapper updating event of the mapper.
ClassParseException Represents the exception that is thrown when an error is encountered during the parsing of a text representation of an expression.
ClassPropertyChangingEventArgs Represents the event data for the PropertyChanging event of the object.
ClassRequestRowVisibleStatesEventArgs Represents the event data for the RequestRowVisibleStates event of the object.
ClassSheetAxisModelChangingEventArgs Represents the event data for the Changing event of the axis model for the sheet.
ClassSheetAxisModelEventArgs Represents the event data for the Changed event of the axis model for the sheet.
ClassSheetAxisProperty Represents the properties for the axis model for the sheet.
ClassSheetDataModelEventArgs Represents the event data for the Changed event of the data model for the sheet.
ClassSheetGroupDataModelEventArgs Specifies the type of Change event that has occurred in the group footer.
ClassSheetSelectionModelEventArgs Represents the event data for the Changed event of the selection model for the sheet.
ClassSheetSpanModelChangingEventArgs Represents the event data for the Changing event of the span model for the sheet.
ClassSheetSpanModelEventArgs Represents the event data for the Changed event of the span model for the sheet.
ClassSheetStyleModelEventArgs Represents the event data for the Changed event of the style model for the sheet.
ClassSpreadSerializer Represents the serializer object for opening from and saving to a file, the entire Spread component and all its data.
ClassTableItemChangedEventArgs Represents the event data for the Changed event of the data model for the sheet.
ClassTableItemChangingEventArgs Represents the event data for the Changed event of the data model for the sheet.
ClassTableItemNameChangedEventArgs Presents changed table item data.
ClassTableItemNameChangingEventArgs Presents changing table collection data.
ClassTableNameChangedEventArgs Presents changed table name data.
ClassTableNameChangingEventArgs Presents changing table name data.
Interfaces
 InterfaceDescription
InterfaceIAggregationSupport Interface that supports the Aggregate functionality on ranges of cells in the data model.
InterfaceIArraySupport Interface that supports arrays of values in a range of cells in the data model.
InterfaceIAutoFilterIndexSupport Interface for supporting setting a specific column header row index in which to display the column automatic filter indicator.
InterfaceIAutoSortIndexSupport Interface for supporting setting a specific column header row index in which to display the column automatic sort indicator.
InterfaceICalculationSupport Interface that supports recalculation of formulas in the cells in the data model.
InterfaceIChartSupport Interface that supports notifying that the data model has changed.
InterfaceIChildModelSupport Interface that supports a child data model in the data model.
InterfaceIClearDataSupport Interface that supports clearing data from the specified range.
InterfaceIClearFormulasSupport Interface that supports clearing formulas from the specified range.
InterfaceICustomFunctionSupport Interface that supports user-defined functions in formulas in the data model.
InterfaceICustomFunctionSupport2 Interface that supports user-defined functions in formulas in the data model.
InterfaceICustomNameSupport Interface that supports user-defined names in formulas in the data model.
InterfaceICustomNameSupport2 Interface that supports user-defined names in formulas in the data model.
InterfaceICustomNameSupport3 Interface that supports user-defined names in formulas in the data model.
InterfaceIDataSourceSupport Interface that supports data binding and data relations in the data model.
InterfaceIDataSourceSupport1 Interfaces that support ignore data source position changed event.
InterfaceIDisjointSelections Interface that supports an ordered array of cell ranges, from largest to smallest, containing the selected cells with minimal overlap between the ranges.
InterfaceIEditableObjectSupport Defines the interface for objects that are editable data rows in a data set.
InterfaceIEnhancedCustomNameSupport Interface that supports enhanced methods for user-defined names in formulas in the data model.
InterfaceIEnhancedCustomNameSupport2 Interface that supports enhanced methods for user-defined names in formulas in the data model.
InterfaceIErrorTextSupport Interface that supports creating a model that represents the error icon.
InterfaceIExpressionConsumer Interface that supports a class to bind its formulas to the data model.
InterfaceIExpressionSupport Interface that supports formulas as values and as expressions in the data model.
InterfaceIExpressionSupport2 Interface that supports additional formula functionality in the data model including conditional cell formats.
InterfaceIFindRowsVisibleStateSupport Interface that supports getting the row's visible state.
InterfaceIGroupFooterSupport Interface that supports the footer.
InterfaceIGroupSupport Interface that supports grouping.
InterfaceIGroupSupport2 Interface that supports grouping.
InterfaceIItemTypeSupport Interface that supports data binding to collections.
InterfaceIIterationSupport Interface that supports recursive formulas (with circular references) in the data model.
InterfaceIMapper Interface that supports mapping between the group view and target model.
InterfaceIMapperSupport Provides an interface that allows mapping
InterfaceIMovable Interface that supports arranging the items in an object in the data model.
InterfaceINamedStyleSupport Interface that supports collections of custom styles in the style model.
InterfaceINameSupport Interface that supports a name of a data model.
InterfaceINameSupport2 Interface that supports a name of a data model. Notifies the NameChanging event.
InterfaceINonEmptyCells Interface that supports determining the number of columns and rows with data in the data model.
InterfaceINotifySelectionChanged Represents a selection model with group operations, that returns a result indicating whether the selection has changed.
InterfaceINotifySheetAxisModelChanging Interface that supports notifying that the axis model is going to change.
InterfaceIObjectExpressionSupport Interface that enables the class to support objects to bind their formulas to its instance.
InterfaceIOptimizedEnumerationSupport Interface that supports optimization for retrieval of data in the data model.
InterfaceIOptimizedEnumerationSupport2 Interface that supports additional optimization for retrieval of data in the data model beyond IOptimizedEnumerationSupport.
InterfaceIOptimizedEnumerationSupport3 Interface that supports additional optimization for retrieval of data in the data model beyond IOptimizedEnumerationSupport2.
InterfaceIOptimizedEnumerationSupport5 Interface that supports additional optimization for retrieval of data in the data model beyond IOptimizedEnumerationSupport3.
InterfaceIOptimizedEnumerationSupport6 Interface that supports additional optimization for retrieval of data in the data model beyond IOptimizedEnumerationSupport5.
InterfaceIOptimizedEnumerationSupport7 Interface that supports additional optimization for retrieval of data in the data model.
InterfaceIOptimizedSheetAxisModelSupport Interface that supports optimizing for axis model to return visible element count.
InterfaceIOptimizedSheetAxisModelSupport2 Interface that supports optimizing for axis model to return visible element count.
InterfaceIOptimizedSheetAxisModelSupport3 Interface that supports optimizing for axis model to return index visible element .
InterfaceIOptimizedSheetAxisModelSupport4 Interface that supports optimizing for axis model.
InterfaceIParentStyleModelSupport Interface that supports a parent style model for composing styles.
InterfaceIParseFormatSupport Interface that supports format strings and providers for the style model for the sheet.
InterfaceIQuerySelection Interface that supports querying an extended selection in the selection model for the sheet.
InterfaceIRangeSupport Interface that supports operations on ranges of cells in the data model.
InterfaceIReceiveRowsVisibleStateChangedNotificationSupport 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.
InterfaceISheetAxisModel Interface that supports creating a model that represents column and row information.
InterfaceISheetDataModel Interface that supports creating a model that represents tabular data.
InterfaceISheetSelectionModel Interface that supports creating a model that represents cell selection.
InterfaceISheetSpanModel Interface that supports creating a model that represents cell spans.
InterfaceISheetSpanModelChangingEventSupport Interface that supports the Changing event in span model.
InterfaceISheetStyleModel Interface that supports creating a model that represents cell style information for a sheet.
InterfaceISupportFindFormulaDependent Interface that enables the class to find all the formula containers that have formula references to cells or tables.
InterfaceISuspendFormulaParsing Interface that supports suspension of formula parsing during deserialization.
InterfaceITableColumn Provides an interface for a table column.
InterfaceITableColumnCollection Interface that supports iterating through ITableColumn items.
InterfaceITableColumnExpressionConsumer Interface that supports a table that binds its formulas to the data model.
InterfaceITableDataColumn Provides an interface that presents data for a table column.
InterfaceITableModelSupport Represent an ITableModelSupport interface.
InterfaceITableRange Represents an ITableRange interface.
InterfaceITableRangeManager Represent an ITableRangeManager interface.
InterfaceIUnboundRowAddNewRowSupport Supports the operation on DataAddNew for an unbound row.
InterfaceIUnboundRowSupport Interface that supports unbound rows when the model is bound to a data source.
Structures
 StructureDescription
StructureFormulaDependentInfos.Cell Represents a cell.
Delegates
 DelegateDescription
DelegateAggregateEventHandler Handles the data aggregate in the data model of the sheet.
DelegateDefaultSheetDataModel.DataModelCellErrorTextEventHandler Represents a defined method that handles the ErrorTextChange event for the Spread component.
DelegateDefaultSheetDataModel.DataModelRowErrorTextEventHandler Represents a defined method that handles the RowErrorTextChange event for the Spread component.
DelegateGroupFooterEventHandler Handles the Changed event in the data model of the group footer.
DelegateMapperUpdatingEventHandler Handles the updating event of the mapper.
DelegatePropertyChangingEventHandler Handles the Changed event in the data model of the sheet.
DelegateReferenceStyleEventHandle Handles the changed ReferenceStyleEventHandle event in the data model of the sheet.
DelegateRequestRowVisibleStatesEventHandler Handles RequestRowVisibleStates event.
DelegateSheetAxisModelChangingEventHandler Handles the Changing event for the axis model for the sheet.
DelegateSheetAxisModelEventHandler Handles the Changed event for the axis model for the sheet.
DelegateSheetDataModelEventHandler Handles the Changed event in the data model of the sheet.
DelegateSheetSelectionModelEventHandler Handles the Changed event in the selection model of the sheet.
DelegateSheetSpanModelChangingEventHandler Handles the Changing event in the span model of the sheet.
DelegateSheetSpanModelEventHandler Handles the Changed event in the span model of the sheet.
DelegateSheetStyleModelEventHandler Handles the Changed event in the style model of the sheet.
DelegateTableItemChangedEventHandler Handles the TableCollectionItemChanged event in the ITableRangeManager.
DelegateTableItemChangingEventHandler Handles the table item changed event.
DelegateTableItemNameChangedEventHandler Handles the TableCollectionItemNameChanged event.
DelegateTableItemNameChangingEventHandler Handles the TableCollectionItemNameChanging event.
DelegateTableNameChangedEventHandler Handles the TableNameChanged event.
DelegateTableNameChangingEventHandler Handles the TableNameChanging event.
Enumerations
 EnumerationDescription
EnumerationAggregationType Specifies the type of aggregation on ranges of cells.
EnumerationExcludeContents Specifies a value that indicates whether a property is ignored when iterating through rows via the next non-empty logic.
EnumerationFormulaChangedType Provides information about change related to the formula of the IExpressionConsumer.
EnumerationFormulaContextType Specifies the type of a formula.
EnumerationFormulaRestrictedCondition The restrictions of formulas.
EnumerationGroupingPolicy Specifies a grouping policy to collapse or expand rows when grouping occurs in the Spread component.
EnumerationIncludeHeaders Specifies which spreadsheet headers should be included.
EnumerationMapperUpdatingEventType Specifies the type of mapper updating event that has occurred for the mapper.
EnumerationMergePolicy Specifies how the control handles automatic merging of cells based on the values in the cells.
EnumerationReferenceStyle Specifies the reference style in formulas and custom names in the sheet.
EnumerationSelectionPolicy Specifies how users can select items in the control.
EnumerationSelectionUnit Specifies the smallest unit users or the application can select.
EnumerationSheetAxisModelEventType Specifies the type of Change event that has occurred for an axis model for the sheet.
EnumerationSheetAxisOrientation Specifies the orientation for the layout information, whether by row or column, for the axis model for the sheet.
EnumerationSheetDataModelEventType Specifies the type of Change event that has occurred for an axis model for the sheet.
EnumerationSheetSpanModelChangingEventType Specifies the type of Changing event that is going to occur for a span model for the sheet.
EnumerationSheetSpanModelEventType Specifies the type of Change event that has occurred for a span model for the sheet.
EnumerationSheetStyleModelEventType Specifies the type of Change event that has occurred for a style model for the sheet.
EnumerationSortIndicator Specifies the display of the sort indicator.
EnumerationTableChangeEventType Specifies the table changed type.
EnumerationTableChangeType Specifies the table change type.
EnumerationTableItemChangeEventType Specifies the 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.

See Also

Reference

FarPoint.Win.Spread Assembly

User-Task Documentation

Using Sheet Models

 

 


Copyright © GrapeCity, inc. All rights reserved.