2.4.254 BrtBeginSXLocation

  • Article

The BrtBeginSXLocation record specifies the location of a PivotTable view (section 2.2.5.3) in a sheet, and specifies the beginning of an empty collection of records as defined by the PivotTable (section 2.1.7.40) part ABNF.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

rfxGeom (16 bytes)

...

...

rwFirstHead

rwFirstData

colFirstData

crwPage

ccolPage

rfxGeom (16 bytes): An UncheckedRfX (section 2.5.154) that specifies the location of the PivotTable view body in a sheet. For more details about the PivotTable view body, see Location and Body (section 2.2.5.3.8.1).

rwFirstHead (4 bytes): An UncheckedRw (section 2.5.155) that specifies first row in a PivotTable report body that contains pivot item (section 2.2.5.3.3) captions, data item (section 2.2.5.3.7.5.1) captions, or data values. For more details about the PivotTable view body, see Location and Body (section 2.2.5.3.8.1). If no row area and no column (1) area exists, this value MUST be equal to rfxGeom.rwFirst + 1, and MUST be ignored. The value of this field MUST be less than or equal to rwFirstData.

rwFirstData (4 bytes):  An UncheckedRw that specifies the location of the topmost row of the PivotTable view body, where cells containing values of data items will appear. For more details about the PivotTable view body, see Location and Body (section 2.2.5.3.8.1).

colFirstData (4 bytes): An UncheckedCol that specifies the location of the first column (1) of the PivotTable view body, where cells containing values of data items will appear. For more details about the PivotTable view body, see Location and Body (section 2.2.5.3.8.1).

crwPage (4 bytes): A DRw (section 2.5.35) that specifies the number of rows with cells containing data for pivot fields (section 2.2.5) on the page axis (section 2.2.5.3.7.1) of the PivotTable view.

ccolPage (4 bytes):  A DCol (section 2.5.32) that specifies the number of columns (1) with cells containing data for pivot fields on the page axis of the PivotTable view.