[]
Represents the aggregation data model.
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
| 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. |
| 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. |
| 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. |
| Name | Description |
|---|---|
| NameChanged | Occurs when the name of the data model changes. |