Spread for ASP.NET 11 Product Documentation
DefaultSheetDataModel Class Members
Properties  Methods  Events


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace : DefaultSheetDataModel Class

The following tables list the members exposed by DefaultSheetDataModel.

Public Constructors
 NameDescription
Public ConstructorOverloaded.   
Top
Public Properties
 NameDescription
Public PropertyGets or sets whether the control automatically recalculates each formula in the sheet when the contents of dependent cells change.  
Public PropertyGets or sets whether to generate the columns automatically based on the data source.  
Public PropertyGets whether the object in its entirety can be rendered with XML without losing any information.  
Public PropertyGets the number of the child data relations for a hierarchical display of data.  
Public PropertyOverridden. Gets or sets the number of columns in the model.  
Public PropertyGets or sets a row identifier.  
Public PropertyGets or sets the data member (table name) to use for data.  
Public PropertyGets or sets the data source.  
Public PropertyGets or sets whether to ignore the DataSourceViewChanged event.  
Public PropertyGets or sets a value that indicates whether to ignore the formula.  
Public PropertyGets or sets the type of the object in the list for the list data source.  
Public PropertyGets or sets whether circular references are evaluated.  
Public PropertyGets or sets the maximum amount of change below which to stop iterating for caclulations with circular references.  
Public PropertyGets or sets the maximum number of iterations for calculations with circular references.  
Public PropertyGets or sets the name of the data model.  
Public PropertyOverridden. Gets the number of columns in the model that contain data (bound or unbound).  
Public PropertyOverridden. Gets the number of rows in the model that contain data (bound or unbound).  
Public PropertyGets or sets the parent data source support object.  
Public PropertyGets the name of the data relation being used for a hierarchical display of data.  
Public PropertyGets the index of the row in the parent data model associated with this child data model.  
Public PropertyGets or sets the cell reference style for cells with formulas.  
Public PropertyOverridden. Gets or sets the number of rows in the model.  
Public PropertyGets whether the GetKey method generates a key for a row.  
Top
Public Methods
 NameDescription
Public MethodOverloaded. Adds a column to the data model after the last column.  
Public MethodAdds one or more columns to the data model at the specified position.  
Public MethodAdds a new user-defined custom function to the model for use in formulas.  
Public MethodOverloaded. Adds a named expression to the model for use in formulas.  
Public MethodOverloaded. Adds a row to the data model after the last row.  
Public MethodAdds rows to the data model at the specified position.  
Public MethodAdds the unbound row to the data source.  
Public MethodAdds unbound rows to the data model.  
Public MethodRemoves all the data and formulas from the specified range of cells.  
Public MethodRemoves all user-defined custom functions from the model.  
Public MethodRemoves all named expressions from the model.  
Public MethodRemoves all the data from the specified range of cells.  
Public MethodRemoves all of the formulas from the specified range of cells.  
Public MethodGets whether two expressions are equal.  
Public MethodCopies the data from a range of cells to a specified range of cells.  
Public MethodLoads the object from XML.  
Public MethodEvaluates the expression in the cell at the specified row and column and returns the resulting object.  
Public MethodCalculates the value based on the aggregation type and formats the value with the aggregation format.  
Public MethodGets the AggregationType, as a string value, at the specified column.  
Public MethodOverloaded. Gets an object array from a specified range of cells.  
Public MethodGets the data model (ISheetDataModel object) for the specified row and data relation.  
Public MethodGets the name of the child data relation at the specified position.  
Public MethodGets the index of the column specified by name.  
Public MethodGets a user-defined custom function from the model.  
Public MethodGets an IEnumerator that enumerates through the names of the custom functions in the model.  
Public MethodOverloaded. Gets a named expression from the model with the specified base index for relative cell references.  
Public MethodGets an IEnumerator that enumerates through the names of the named expressions in the model.  
Public MethodGets the column caption at the specified position.  
Public MethodGets the data source column index for the specified column in the model.  
Public MethodGets the column name at the specified position.  
Public MethodGets the column data type at the specified position.  
Public MethodGets the view of a specified row of data.  
Public MethodGets the data source row index for the specified row in the model.  
Public MethodGets the data table associated with this model.  
Public MethodOverloaded. Gets the DataView object associated with this model.  
Public MethodGets the formula, as an expression value, for the cell of the specified row and column.  
Public MethodGets the formula, as a string value, for the cell of the specified row and column.  
Public MethodReturns the IEditableObject from a row that is data bound to a DataView or ListSource.  
Public MethodGets a key for the specified row or column.  
Public MethodGets the column in the model for the specified data source column.  
Public MethodGets the row in the model for the specified data source row.  
Public MethodGets the number of columns that contain notes.  
Public MethodGets the number of rows that contain notes.  
Public MethodOverridden. Gets a user-defined note value for the cell of the specified row and column.  
Public MethodOverridden. Gets an application-defined tag value for the cell of the specified row and column.  
Public MethodGets the unbound value for the cell for the specified row and column.  
Public MethodOverridden. Gets the value of the cell for the specified row and column.  
Public MethodAttempts to find a value for one cell that produces the desired formula result in another cell.  
Public MethodDetermines whether the specified column is bound to a data source column.  
Public MethodOverridden. Determines whether the value in the cell of the specified row and column can be edited.  
Public MethodOverridden. Determines whether the data model is empty.  
Public MethodDetermines whether the specified row is bound to a data source row.  
Public MethodOverridden. Determines whether the specified row is not empty.  
Public MethodLoads formulas that are deserialized, but not parsed yet, to be used after all sheets have been created and deserialized.  
Public MethodMoves the data from a range of cells to the specified location.  
Public MethodOverridden. Gets the index of the next column in a specified row that contains data.  
Public MethodOverridden. Gets the index of the next non-empty row after the specified row index.  
Public MethodParses the string value and returns the expression for the cell at the specified row and column.  
Public MethodEvaluates the formulas in the sheet that have changed since the last calculation cycle.  
Public MethodEvaluates all the formulas in the entire sheet (including those that have not changed since the last calculation cycle).  
Public MethodRemoves a column at the specified position.  
Public MethodRemoves one or more columns starting with the column at the specified position.  
Public MethodRemoves a user-defined custom function from the model.  
Public MethodRemoves a named expression from the model.  
Public MethodRemoves a row at the specified position.  
Public MethodRemoves one or more rows, starting with the specified row.  
Public MethodOverloaded. Saves the object to XML.  
Public MethodSaves the object to XML.  
Public MethodSets the AggregationType, as an enumeration value, at the specified column. If you pass null, it clears the AggregationType from that column.  
Public MethodOverloaded. Sets an object array into a specified range of cells  
Public MethodSets the formula, as an expression value, for the cell of the specified row and column.  
Public MethodSets the formula, as a string value, for the cell of the specified row and column. If you pass null, it clears the expression from that cell.  
Public MethodOverloaded. Binds the model column to a specified data source column.  
Public MethodOverridden. Sets a user-defined note value for the cell at the specified row and column.  
Public MethodOverridden. Sets an application-defined tag value for the cell of the specified row and column.  
Public MethodOverridden. Sets the value for the cell of the specified row and column.  
Public MethodSwaps the specified ranges of cells.  
Public MethodGets the formula, as a string value, from the specified expression for the cell at the specified row and column.  
Top
Protected Methods
 NameDescription
Protected MethodReturns the IList data source for this model or null if the data source is not an IList.  
Protected MethodRaises the Changed event, and permits derived classes to handle the event without attaching a delegate.  
Top
Public Events
 NameDescription
Public EventOccurs when the data model aggregates.  
Public EventOccurs when the user makes a change to the model that affects the data of the sheet. (Inherited from FarPoint.Web.Spread.Model.BaseSheetDataModel)
Public EventOccurs when the name of the data model changes.  
Public EventOccurs when the name of the data model is changing.  
Top
See Also

Reference

DefaultSheetDataModel Class
FarPoint.Web.Spread.Model Namespace
ISheetDataModel interface