The following tables list the members exposed by DefaultSheetDataModel.
Public Constructors
| Name | Description | |
|---|---|---|
 | DefaultSheetDataModel Constructor | Overloaded. |
Public Properties
| Name | Description | |
|---|---|---|
 | AutoCalculation | Gets or sets whether the control automatically recalculates each formula in the sheet when the contents of dependent cells change. |
| AutoGenerateColumns | Gets or sets whether to generate the columns automatically based on the data source. |
| CanSerializeXml | Gets whether the object in its entirety can be rendered with XML without losing any information. |
| ChildRelationCount | Gets the number of the child data relations for a hierarchical display of data. |
| ColumnCount | Overridden. Gets or sets the number of columns in the model. |
| DataMember | Gets or sets the data member (table name) to use for data. |
| DataSource | Gets or sets the data source. |
| EnumErrorText | Internal use only. Specifies the enumerator error text. |
| EnumRowErrorText | Internal use only. Specifies the enumerator row error text. |
| IgnoreFormula | Gets or sets a value that indicates whether to ignore the formula. |
| ItemType | Gets or sets the type of the object in the list for the list data source. |
| Iteration | Gets or sets whether circular references are evaluated. |
| MaximumChange | Gets or sets the maximum amount of change below which to stop iterating for caclulations with circular references. |
| MaximumIterations | Gets or sets the maximum number of iterations for calculations with circular references. |
| Name | Gets or sets the name of the data model. |
| NonEmptyColumnCount | Overridden. Gets the number of columns in the model that contain data (bound or unbound). |
| NonEmptyRowCount | Overridden. Gets the number of rows in the model that contain data (bound or unbound). |
| Parent | Gets or sets the parent data source support object. |
| ParentRelationName | Gets the name of the data relation being used for a hierarchical display of data. |
| ParentRowIndex | Gets the index of the row in the parent data model associated with this child data model. |
| ReferenceStyle | Gets or sets the cell reference style for cells with formulas. |
| RowCount | Overridden. Gets or sets the number of rows in the model. |
| UnionedChangeCellRange | Gets or sets whether the changed event occurs for each cell or for the union range. TRUE fires the event for the union range. |
Public Methods
| Name | Description | |
|---|---|---|
 | AddColumn | Overloaded. Adds a column to the data model. |
| AddColumns | Adds one or more columns to the data model at the specified position. |
| AddCustomFunction | Adds a new user-defined custom function to the model for use in formulas. |
| AddCustomName | Overloaded. Adds a custom name to the model using the specified value. |
| AddModelScopeCustomName | Overloaded. Adds a custom name to the model scope. |
| AddRow | Overloaded. Adds a row to the data model. |
| AddRows | Adds rows to the data model at the specified position. |
| AddRowToDataSource | Adds the unbound row to the data source. |
| AddUnboundRows | Adds unbound rows to the data model. |
| CheckModelScopeName | Checks if the specified name is one of the model scope custom names of this data model and returns the name of the custom name in the data model. |
| CheckName | Checks if the specified name is one of the common scope custom names of this data model and returns the name of custom name in the data model. |
| Clear | Removes all the data and formulas from the specified range of cells. |
| ClearCustomFunctions | Removes all user-defined custom functions from the model. |
| ClearCustomNames | Removes all named expressions from the model. |
| ClearData | Removes all the data from the specified range of cells. |
| ClearFormulas | Removes all of the formulas from the specified range of cells. |
| ClearModelScopeCustomName | Removes all named expressions from the model scope. |
| CompareExpression | Gets whether two expressions are equal. |
| Copy | Copies the data from a range of cells to a specified range of cells. |
| Deserialize | Loads the object from XML. |
| EvaluateExpression | Evaluates the expression in the cell at the specified row and column and returns the resulting object. |
| GetAggregationResult | Calculates the value based on the aggregation type and formats the value with the aggregation format. |
| GetAggregationType | Gets the AggregationType, as a string value, at the specified column. |
| GetArray | Overloaded. Gets an object array from a specified range of cells. |
| GetCellErrorText | Gets a user-defined note value for the cell of the specified row and column. |
| GetChildDataModel | Gets the data model (ISheetDataModel object) for the specified row and data relation. |
| GetChildRelation | Gets the name of the child data relation at the specified position. |
| GetColumnIndex | Gets the index of the column specified by name. |
| GetCustomFunction | Gets a user-defined custom function from the model. |
| GetCustomFunctionEnumerator | Gets an IEnumerator that enumerates through the names of the custom functions in the model. |
| GetCustomName | Overloaded. Gets a named expression from the model with the specified base index for relative cell references. |
| GetCustomNameComment | Gets a comment for a common custom name. |
| GetCustomNameEnumerator | Gets an IEnumerator that enumerates through the names of the named expressions in the model. |
| GetDataColumnCaption | Gets the column caption at the specified position. |
| GetDataColumnFromModelColumn | Gets the data source column index for the specified column in the model. |
| GetDataColumnName | Gets the column name at the specified position. |
| GetDataColumnType | Gets the column data type at the specified position. |
| GetDataRow | Gets the view of a specified row of data. |
| GetDataRowFromModelRow | Gets the data source row index for the specified row in the model. |
| GetDataTable | Gets the data table associated with this model. |
| GetDataView | Overloaded. Gets the DataView object for this model. |
| GetExpression | Gets the formula, as an expression value, for the cell of the specified row and column. |
| GetFormula | Gets the formula, as a string value, for the cell of the specified row and column. |
| GetItem | Returns the IEditableObject from a row that is data bound to a DataView or ListSource. |
| GetModelColumnFromDataColumn | Gets the column in the model for the specified data source column. |
| GetModelRowFromDataRow | Gets the row in the model for the specified data source row. |
| GetModelScopeCustomName | Overloaded. Gets a named expression from the model with the specified base index for relative cell references. |
| GetModelScopeCustomNameComment | Gets the comment from a custom name. |
| GetModelScopeNameEnumerator | Gets an IEnumerator that enumerates through the names of the named expressions in the model. |
| GetNonEmptyErrorTextsColumnCount | Gets the number of columns that contain notes. |
| GetNonEmptyErrorTextsRowCount | Gets the number of rows that contain notes. |
| GetNonEmptyNotesColumnCount | Gets the number of columns that contain notes. |
| GetNonEmptyNotesRowCount | Gets the number of rows that contain notes. |
| GetNote | Overridden. Gets a user-defined note value for the cell of the specified row and column. |
| GetRowErrorText | Gets a user-defined error value for the cell of the specified row. |
| GetTag | Overridden. Gets an application-defined tag value for the cell of the specified row and column. |
| GetUnboundValue | Gets the unbound value for the cell for the specified row and column. |
| GetValue | Overridden. Gets the value of the cell for the specified row and column. |
| GoalSeek | Attempts to find a value for one cell that produces the desired formula result in another cell. |
| IsColumnBound | Determines whether the specified column is bound to a data source column. |
| IsEditable | Overridden. Determines whether the value in the cell of the specified row and column can be edited. |
| IsEmpty | Overridden. Determines whether the data model is empty. |
| IsRowBound | Determines whether the specified row is bound to a data source row. |
| IsRowUsed | Overloaded. Specifies whether the row uses a formula, tag, or note. |
| LoadFormulas | Loads formulas that are deserialized, but not parsed yet, to be used after all sheets have been created and deserialized. |
| ModifyCustomName | Changes the name of the shared custom name. |
| ModifyModelScopeCustomName | Modifies the name of a model scope custom name. |
| Move | Moves the data from a range of cells to the specified location. |
| NextNonEmptyColumnFormula | Returns the next non-empty column with a formula. |
| NextNonEmptyColumnInRow | Overloaded. Overridden. Gets the index of the next column in a specified row that contains data. |
| NextNonEmptyRow | Overloaded. Overridden. Gets the index of the next non-empty row after the specified row index. |
| NextNonEmptyRowFormula | Returns the next non-empty row with a formula. |
| ParseFormula | Parses the string value and returns the expression for the cell at the specified row and column. |
| PreviousNonEmptyColumnInRow | Overloaded. Gets the previous non-empty column in the row. |
| PreviousNonEmptyRow | Overloaded. Returns the previous non-empty row. |
| Recalculate | Evaluates the formulas in the sheet that have changed since the last calculation cycle. |
| RecalculateAll | Evaluates all the formulas in the entire sheet (including those that have not changed since the last calculation cycle). |
| RemoveColumn | Removes a column at the specified position. |
| RemoveColumns | Removes one or more columns starting with the column at the specified position. |
| RemoveCustomFunction | Removes a user-defined custom function from the model. |
| RemoveCustomName | Removes a named expression from the model. |
| RemoveModelScopeCustomName | Removes a custom name in the model scope. |
| RemoveRow | Removes a row at the specified position. |
| RemoveRows | Removes one or more rows, starting with the specified row. |
| ResumeFormulaParsing | Resumes parsing of formulas and parses all formulas set while parsing was suspended. |
| Serialize | Overloaded. Saves the object to an XmlTextWriter object. |
| SetAggregationType | Sets the AggregationType, as an enumeration value, at the specified column. If you pass null, it clears the AggregationType from that column. |
| SetArray | Overloaded. Sets an object array into a specified range of cells. |
| SetCellErrorText | Sets a user-defined note value for the cell at the specified row and column. |
| SetCustomNameComment | Sets a comment for a common custom name. |
| SetExpression | Sets the formula, as an expression value, for the cell of the specified row and column. |
| SetFormula | Sets the formula, as a string value, for the cell of the specified row and column. If you pass null, it will clear the expression from that cell. |
| SetModelDataColumn | Overloaded. Binds the model column to the specified data source column. |
| SetModelScopeCustomNameComment | Sets a custom name comment. |
| SetNote | Overridden. Sets a user-defined note value for the cell at the specified row and column. |
| SetRowErrorText | Internal method to set row expression without triggering auto calculation. |
| SetTag | Overridden. Sets an application-defined tag value for the cell of the specified row and column. |
| SetValue | Overridden. Sets the value for the cell of the specified row and column. |
| SuspendFormulaParsing | Suspends parsing of formulas. |
| Swap | Swaps the specified ranges of cells. |
| UnparseFormula | Gets the formula, as a string value, from the specified expression for the cell at the specified row and column. |
Protected Methods
| Name | Description | |
|---|---|---|
 | GetListSource | Gets the IList data source for this model. |
| OnAggregate | Raises the Changed event, and permits derived classes to handle the event without attaching a delegate. |
| OnChanged | Overridden. Raises the Changed event, and permits derived classes to handle the event without attaching a delegate. |
Public Events
| Name | Description | |
|---|---|---|
 | Aggregate | Occurs when the data model aggregates. |
| CellErrorTextChanged | Occurs when the user makes a change to the model that affects the data of the sheet. |
| Changed | Occurs when the user makes a change to the model that affects the data of the sheet. (Inherited from FarPoint.Win.Spread.Model.BaseSheetDataModel) |
| CustomNameChanged | Occurs when the custom name of the data model changes. |
| NameChanged | Occurs when the name of the data model changes. |
| NameChanging | Occurs when the name of the data model is changing. |
| ReferenceStyleChanged | Occurs when the reference style of the data model changes. |
| RowErrorTextChanged | Occurs when the user makes a change to the model that affects the data of the sheet. |
See Also