Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.Model Namespace / DefaultSheetDataModel Class
Properties Methods Events

In This Topic
    DefaultSheetDataModel Class Members
    In This Topic

    The following tables list the members exposed by DefaultSheetDataModel.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded.   
    Top
    Public Properties
     NameDescription
    Public Property Gets or sets whether the control automatically recalculates each formula in the sheet when the contents of dependent cells change.  
    Public Property Gets or sets whether to generate the columns automatically based on the data source.  
    Public Property Gets whether the object in its entirety can be rendered with XML without losing any information.  
    Public Property Gets 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 Property Gets or sets the data member (table name) to use for data.  
    Public Property Gets or sets the data source.  
    Public Property Internal use only. Specifies the enumerator error text.  
    Public Property Internal use only. Specifies the enumerator row error text.  
    Public Property Gets or sets a value that indicates whether to ignore the formula.  
    Public Property Gets or sets the type of the object in the list for the list data source.  
    Public Property Gets or sets whether circular references are evaluated.  
    Public Property Gets or sets the maximum amount of change below which to stop iterating for caclulations with circular references.  
    Public Property Gets or sets the maximum number of iterations for calculations with circular references.  
    Public Property Gets 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 Property Gets or sets the parent data source support object.  
    Public Property Gets the name of the data relation being used for a hierarchical display of data.  
    Public Property Gets the index of the row in the parent data model associated with this child data model.  
    Public Property Gets or sets the cell reference style for cells with formulas.  
    Public PropertyOverridden.  Gets or sets the number of rows in the model.  
    Public Property Gets or sets whether the changed event occurs for each cell range or for the union range. True fires the event for the union range.  
    Top
    Public Methods
     NameDescription
    Public MethodOverloaded. Adds a column to the data model.  
    Public Method Adds one or more columns to the data model at the specified position.  
    Public MethodOverloaded. 

    Adds a custom name to the model using the specified value.

     
    Public Method Adds a custom name to the model scope.  
    Public MethodOverloaded. 

    Adds a row to the data model.

     
    Public Method Adds rows to the data model at the specified position.  
    Public Method Adds the unbound row to the data source.  
    Public Method Adds unbound rows to the data model.  
    Public Method 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.  
    Public Method Checks if the specified name is one of the common scope custom names of this data model and returns the name of the custom name in the data model.  
    Public Method Removes all the data and formulas from the specified range of cells.  
    Public Method Removes all user-defined custom functions from the model.  
    Public Method Removes all named expressions from the model.  
    Public Method Removes all the data from the specified range of cells.  
    Public Method Removes all of the formulas from the specified range of cells.  
    Public Method Removes all named expressions from the model scope.  
    Public Method Gets whether two expressions are equal.  
    Public Method Copies the data from a range of cells to a specified range of cells.  
    Public Method Loads the object from XML.  
    Public Method Evaluates the expression in the cell at the specified row and column and returns the resulting object.  
    Public MethodOverloaded.  Gets an object array from a specified range of cells.  
    Public Method Gets a user-defined note value for the cell of the specified row and column.  
    Public Method Gets the data model (ISheetDataModel object) for the specified row and data relation.  
    Public Method Gets the name of the child data relation at the specified position.  
    Public Method Gets the index of the column specified by name.  
    Public Method Gets a named expression from the model with the specified base index for relative cell references.  
    Public Method Gets a comment for a common custom name.  
    Public Method Gets an IEnumerator that enumerates through the names of the named expressions in the model.  
    Public Method Gets the column caption at the specified position.  
    Public Method Gets the data source column index for the specified column in the model.  
    Public Method Gets the column name at the specified position.  
    Public Method Gets the column data type at the specified position.  
    Public Method Gets the view of a specified row of data.  
    Public Method Gets the data source row index for the specified row in the model.  
    Public Method Gets the data table associated with this model.  
    Public MethodOverloaded. Gets the DataView object for this model.  
    Public Method Gets the formula, as a string value, for the cell of the specified row and column.  
    Public Method Returns the IEditableObject from a row that is data bound to a DataView or ListSource.  
    Public Method Gets the column in the model for the specified data source column.  
    Public Method Gets the row in the model for the specified data source row.  
    Public Method Gets a named expression from the model with the specified base index for relative cell references.  
    Public Method Gets the comment from a custom name.  
    Public Method Gets an IEnumerator that enumerates through the names of the named expressions in the model.  
    Public Method Gets the number of columns that contain notes.  
    Public Method Gets the number of rows that contain notes.  
    Public Method Gets the number of columns that contain notes.  
    Public Method Gets 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 Method Gets a user-defined error value for the cell of the specified row.  
    Public MethodOverridden.  Gets an application-defined tag value for the cell of the specified row and column.  
    Public Method Gets 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 Method Attempts to find a value for one cell that produces the desired formula result in another cell.  
    Public Method Determines 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 Method Determines whether the specified row is bound to a data source row.  
    Public Method Specifies whether the row uses a formula, tag, or note.  
    Public Method Loads formulas that are deserialized, but not parsed yet, to be used after all sheets have been created and deserialized.  
    Public Method Changes the name of the shared custom name.  
    Public Method Modifies the name of a model scope custom name.  
    Public Method Moves the data from a range of cells to the specified location.  
    Public Method Returns the next non-empty column with a formula.  
    Public MethodOverridden.  Gets the index of the next column in a specified row that contains data.  
    Public Method Returns the index of the next row that has data.  
    Public Method Parses the string value and returns the expression for the cell at the specified row and column.  
    Public MethodOverloaded.  Gets the previous non-empty column in the row.  
    Public MethodOverloaded.  Gets the previous nonempty row.  
    Public Method Evaluates the formulas in the sheet that have changed since the last calculation cycle.  
    Public Method Evaluates all the formulas in the entire sheet (including those that have not changed since the last calculation cycle).  
    Public Method Removes a column at the specified position.  
    Public Method Removes one or more columns starting with the column at the specified position.  
    Public Method Removes a named expression from the model.  
    Public Method Removes a custom name in the model scope.  
    Public Method Removes a row at the specified position.  
    Public Method Removes one or more rows, starting with the specified row.  
    Public Method Resumes parsing of formulas and parses all formulas set while parsing was suspended.  
    Public MethodOverloaded. Saves the object to an XmlTextWriter object.  
    Public MethodOverloaded.  Sets an object array into a specified range of cells.  
    Public Method Sets a user-defined note value for the cell at the specified row and column.  
    Public Method Sets a comment for a common custom name.  
    Public Method Sets 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 the specified data source column.  
    Public Method Sets a custom name comment.  
    Public MethodOverridden.  Sets a user-defined note value for the cell at the specified row and column.  
    Public Method Internal method to set row expression without triggering auto calculation.  
    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 Method Suspends parsing of formulas.  
    Public Method Swaps the specified ranges of cells.  
    Public Method Gets the formula, as a string value, from the specified expression for the cell at the specified row and column.  
    Top
    Public Events
     NameDescription
    Public Event Occurs when the data model aggregates.  
    Public Event Occurs when the user makes a change to the model that affects the data of the sheet.  
    Public Event Occurs when the user makes a change to the model that affects the data of the sheet. (Inherited from FarPoint.Win.Spread.Model.BaseSheetDataModel)
    Public Event Occurs when the custom name of the data model changes.  
    Public Event Occurs when the name of the data model changes.  
    Public Event Occurs when the name of the data model is changing.  
    Public Event Occurs when the reference style of the data model changes.  
    Public Event Occurs when the user makes a change to the model that affects the data of the sheet.  
    Top
    See Also