Share via

2.4.9 BrtBeginAutoSortScope

  • Article

The BrtBeginAutoSortScope record specifies the beginning of a collection of records as specified by the PivotTable (section 2.1.7.40) part ABNF. The collection specifies pivot field sorting (section 2.2.5.3.2.1) properties.

If the value of the PRFilter.isxvd field in the first BrtBeginPRFilter (section 2.4.179) record followed by this record is -2, then sorting is specified to be by values, otherwise sorting is specified to be by member property captions.

When sorting by values, the collection of records specifies the row or column (1) that contains the values by which the pivot items (section 2.2.5.3.3) of this pivot field (section 2.2.5.3.2) are sorted.

When sorting by member property captions, the collection of records specifies a member property pivot field on the row axis or the column (1) axis of the PivotTable view (section 2.2.5.3). The pivot items of this pivot field are sorted by the pivot item captions of the specified member property pivot field.

The BrtBeginPRFilters (section 2.4.181) collection followed by this record MUST be sorted by the PRFilter.isxvd field in the BrtBeginPRFilter (section 2.4.179) in ascending order.

If this record exists, the fAutoSort field of the BrtBeginSXVD (section 2.4.272) record immediately preceding this record MUST be 1.