GrapeCity.Documents.Excel.PivotFieldNumberGroupOptions

PivotFieldNumberGroupOptions Class

Represents the settings used to group a PivotField into numeric ranges.

Use this class to configure the numeric range and interval used by Group(PivotFieldNumberGroupOptions). By default, the group range is determined from the PivotCache and the interval is 1.

Inheritance

object

PivotFieldNumberGroupOptions

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public class PivotFieldNumberGroupOptions

Public Class PivotFieldNumberGroupOptions

Examples

PivotFieldNumberGroupOptions options = new PivotFieldNumberGroupOptions
{
    Start = 10348,
    End = 10407,
    AutoStart = false,
    AutoEnd = false,
    Interval = 20
};
orderIdField.Group(options);

Constructors

Name	Description
PivotFieldNumberGroupOptions()

Properties

Name	Description
AutoEnd	Gets or sets whether the last number is determined from the PivotCache instead of End. When this value is false, End must be set when grouping is applied.
AutoStart	Gets or sets whether the first number is determined from the PivotCache instead of Start. When this value is false, Start must be set when grouping is applied.
End	Gets or sets the ending number used to derive the grouped range. Generated buckets are left-closed and right-open. When AutoEnd is true, this value is ignored and the last number is determined from the PivotCache.
Interval	Gets or sets the numeric interval used to create each generated group. The interval must be greater than 0 and finite when grouping is applied. The effective start value must also be less than the effective end value. The default value is 1.
Start	Gets or sets the first number included in the grouped range. When AutoStart is true, this value is ignored and the first number is determined from the PivotCache.