[]
        
(Showing Draft Content)

GrapeCity.CalcEngine.AggregateOption

AggregateOption Enum

Represents a options that determines which values to ignore in the evaluation range for the function.

Namespace: GrapeCity.CalcEngine
Assembly: GrapeCity.Spreadsheet.dll
Syntax
public enum AggregateOption : byte
Public Enum AggregateOption As Byte

Fields

Name Description
IgnoreError

Ignore error values.

IgnoreErrorNestedAggregation

Ignore error values, nested SUBTOTAL and AGGREGATE functions.

IgnoreHidden

Ignore hidden rows.

IgnoreHiddenError

Ignore hidden rows and error values.

IgnoreHiddenErrorNestedAggregation

Ignore hidden rows, error values, nested SUBTOTAL and AGGREGATE functions.

IgnoreHiddenNestedAggregation

Ignore hidden rows, nested SUBTOTAL and AGGREGATE functions.

IgnoreNestedAggregation

Ignore nested SUBTOTAL and AGGREGATE functions.

IgnoreNothing

Ignore nothing.