AggregationDataModel Class

public class AggregationDataModel : BaseSheetDataModel, ISheetDataModel, INonEmptyCells, IOptimizedEnumerationSupport2, IOptimizedEnumerationSupport, IChartSupport, IAggregationSupport, IRangeSupport, IExpressionSupport, IGroupFooterStyleSupport, IDisposable, ISerializable, ISuspendFormulaParsing, ICanSerializeXml, ISerializeSupport, INameSupport

Public Class AggregationDataModel
    Inherits BaseSheetDataModel
    Implements ISheetDataModel, INonEmptyCells, IOptimizedEnumerationSupport2, IOptimizedEnumerationSupport, IChartSupport, IAggregationSupport, IRangeSupport, IExpressionSupport, IGroupFooterStyleSupport, IDisposable, ISerializable, ISuspendFormulaParsing, ICanSerializeXml, ISerializeSupport, INameSupport

Constructors

Name	Description
AggregationDataModel()	Creates a new aggregation data model.
AggregationDataModel(Group)	Creates a new aggregation data model for the specified group.
AggregationDataModel(ISheetDataModel)	Creates a new aggregation data model for the specified sheet data model.
AggregationDataModel(SerializationInfo, StreamingContext)	Creates a AggregationDataModel object from serialization.

Properties

Name	Description
CanSerializeXml	Gets a value that indicates whether the specified AggregationDataModel object can serialize to XML.
ColumnCount	Gets the number of columns in the group.
Name	Gets or sets the name of the aggregation model.
NonEmptyColumnCount	Gets the number of columns in the model that contain data (bound or unbound).
NonEmptyRowCount	Gets the number of rows in the model that contain data (bound or unbound).
ReferenceStyle	Gets or sets the cell reference style for cells with formulas.
RowCount	Gets or sets the number of rows in the group.
TargetModel	Gets the sheet data model for the aggregation target.
UnionedChangeCellRange	Gets or sets whether the changed event occurs for each cell range or for the union range. Works only if initialized from DefaultSheetDataModel. True if event occurs for union range.

Methods

Name	Description
AddColumns(int, int)	Adds one or more columns to the data model at the specified position.
AddRows(int, int)	Adds rows to the data model at the specified position.
Clear(int, int, int, int)	Removes all the data and formulas from the specified range of cells.
Copy(int, int, int, int, int, int)	Copies the data from a range of cells to a specified range of cells.
Deserialize(XmlNodeReader)	Loads the settings from XML.
Dispose()	Disposes this object.
GetCelAggregationType(int, int)	Gets the formula of the cell of the specified row and column.
GetCellAggregationFormat(int, int)	Sets the format of the cell of the specified row and column.
GetFormula(int, int)	Gets the formula, as a string value, for the cell of the specified row and column.
GetNote(int, int)	Gets a user-defined note value for the cell of the specified row and column.
GetObjectData(SerializationInfo, StreamingContext)	Serializes the AggregationDataModel to the SerializationInfo.
GetTag(int, int)	Gets an application-defined tag value for the cell of the specified row and column.
GetValue(int, int)	Gets the value from the cell in the group.
IsEditable(int, int)	Determines whether the cell in the group is editable.
IsEmpty()	Determines whether the data model is empty.
IsRowUsed(int)	Determines whether the specified row has data (is not empty).
LoadFormulas()	Loads formulas that are deserialized but not parsed yet, to be used after all sheets have been created and deserialized or shared with the calculation controller.
Move(int, int, int, int, int, int)	Moves the data from a range of cells to the specified location.
NextNonEmptyColumnInRow(int, int)	Gets the index of the next column in a specified row that contains data.
NextNonEmptyRow(int)	Gets the index of the next row that contains data.
RemoveColumns(int, int)	Removes one or more columns starting with the column at the specified position.
RemoveRows(int, int)	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(XmlTextWriter)	Saves the settings to XML.
SetCellAggregationFormat(int, int, string)	Sets the format for the cell of the specified row and column.
SetCellAggregationType(int, int, AggregationType)	Sets the formula for the cell of the specified row and column.
SetFormula(int, int, string)	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.
SetNote(int, int, string)	Sets a user-defined note value for the cell at the specified row and column.
SetTag(int, int, object)	Sets an application-defined tag value for the cell of the specified row and column.
SetValue(int, int, object)	Sets the value of the cell in the group.
SuspendFormulaParsing()	Suspends parsing of formulas.
Swap(int, int, int, int, int, int)	Swaps the specified ranges of cells.

Events

Name	Description
NameChanged	Occurs when the name of the data model changes.