GrapeCity.Documents.Excel.ConsolidationFunction

ConsolidationFunction Enum

Specifies the subtotal function.

Use this enumeration to control how values are summarized in features such as Subtotal(int, ConsolidationFunction, IEnumerable<int>, bool, bool, SummaryRow) and PivotTable data fields.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum ConsolidationFunction

Public Enum ConsolidationFunction

Examples

object[,] sourceData = {
    {"Region", "Amount"},
    {"East", 120},
    {"East", 80},
    {"West", 90}
};
worksheet.Range["A1:B4"].Value = sourceData;
worksheet.Range["A1:B4"].Subtotal(1, ConsolidationFunction.Sum, new int[] {2});

Fields

Name	Description
Average	Specifies the average.
Count	Specifies the count.
CountNums	Specifies to count numerical values only.
DistinctCount	Specifies to count using distinct count analysis.
Max	Specifies the maximum.
Min	Specifies the minimum.
Product	Specifies to multiply.
StdDev	Specifies the standard deviation, based on a sample.
StdDevp	Specifies the standard deviation, based on the entire population.
Sum	Specifies the sum.
Unknown	Specifies that no subtotal function is specified.
Var	Specifies the variation, based on a sample.
Varp	Specifies the variation, based on the entire population.