AggregateOption Enumeration

In This Topic

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

Syntax

'Declaration
 
Public Enum AggregateOption 
   Inherits System.Enum

'Usage
 
Dim instance As AggregateOption

public enum AggregateOption : System.Enum

Members

Member	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.

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.CalcEngine.AggregateOption