SxRng

SxRng class

Represents Group Range in a PivotField.

Properties

NameTypeDescription
IsAutoStartObjectSpecifies a boolean value that indicates whether the application will use the source data to set the beginning range val
IsAutoEndObjectSpecifies a boolean value that indicates whether the application will use the source data to set the end range value.
StartObjectRepresents the start object for the group range.
EndObjectRepresents the end object for the group range.
ByObjectRepresents the interval object for the group range.
GroupByTypesboolean[]Represents the group type for the group range. rangeofvalue Seconds Minutes Hours Days Months Quarters Years

SxRng.IsAutoStart property

Specifies a boolean value that indicates whether the application will use the source data to set the beginning range value.

Type: Object

SxRng.IsAutoEnd property

Specifies a boolean value that indicates whether the application will use the source data to set the end range value.

Type: Object

SxRng.Start property

Represents the start object for the group range.

Type: Object

SxRng.End property

Represents the end object for the group range.

Type: Object

SxRng.By property

Represents the interval object for the group range.

Type: Object

SxRng.GroupByTypes property

Represents the group type for the group range. rangeofvalue Seconds Minutes Hours Days Months Quarters Years

Type: boolean[]