Spread Windows Forms 7.0 Product Documentation
DefaultSheetDataModel Class Members
See Also Properties Methods Events Support Options

	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.

	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.

	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.

	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.

Public Constructors

Public Properties

Public Methods

Protected Methods

Public Events

See Also

Reference

User-Task Documentation