GrapeCity.Documents.Excel.ConsolidationFunction

Enum ConsolidationFunction

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Specifies the subtotal function.

public enum ConsolidationFunction

Fields

Average = 10

Specifies the average.

Count = 9

Specifies the count.

CountNums = 8

Specifies to count numerical values only.

DistinctCount = 11

Specifies to count using distinct count analysis.

Max = 7

Specifies the maximum.

Min = 6

Specifies the minimum.

Product = 5

Specifies to multiply.

StdDev = 4

Specifies the standard deviation, based on a sample.

StdDevp = 3

Specifies the standard deviation, based on the entire population.

Sum = 0

Specifies the sum.

Unknown = 12

Specifies that no subtotal function is specified.

Var = 2

Specifies the variation, based on a sample.

Varp = 1

Specifies the variation, based on the entire population.