2.2.5.3.8.1 Location and Body
The column (1) area is located immediately above the data area (section 2.2.5.3.8.1.4). The cell in the column (1) area containing the pivot item (section 2.2.5.3.3) caption or data item (section 2.2.5.3.7.5.1) caption to the farthest logical left is in the same column (1) as the logical top-left cell of the data area.
The row area is located immediately to the logical left of the data area. The cell in the row area containing the top-most pivot item caption or data item caption is in the same row as the logical top-left cell of the data area (section 2.2.5.3.8.1.4).
The PivotTable (section 2.2.5) report body is the rectangular area defined by the union of the row area, column (1) area, and data area.
The page area (section 2.2.5.3.8.1.3), if it is not empty, is located above the PivotTable report body. There is one row between the top-most cell of the PivotTable report body and the bottom-most cell of the page area.
The PivotTable report is a non-contiguous range containing the union of the PivotTable report body and the page area.
A BrtBeginSXLocation (section 2.4.254) record specifies details about the location in the sheet and sizes of the areas of the PivotTable report as specified by the following.
The column (1) area of the PivotTable (section 2.2.5) report is a range of cells as specified in the following table.
|
Column area |
Row or column index |
|---|---|
|
Top row |
rfxGeom.rwFirst |
|
Bottom row |
rwFirstData – 1 |
|
Logical left column (1) |
colFirstData |
|
Logical right column (1) |
rfxGeom.colLast |
If colFirstData is greater than rfxGeom.colLast, the column (1) area does not exist for this PivotTable report.
The row area of the PivotTable (section 2.2.5) report is a range of cells as specified in the following table.
|
Row area |
Row or column index |
|---|---|
|
Top row |
rwFirstData |
|
Bottom row |
rfxGeom.rwLast |
|
Logical left column (1) |
rfxGeom.colFirst |
|
Logical right column (1) |
colFirstData – 1 |
If colFirstData – 1 is less than rfxGeom.colFirstData, the row area does not exist for this PivotTable report.
The data area (section 2.2.5.3.8.1.4) of the PivotTable (section 2.2.5) report is a range of cells as specified in the following table.
|
Data Area |
Row or Column Index |
|---|---|
|
Top row |
rwFirstData |
|
Bottom row |
rfxGeom.rwLast |
|
Logical left column (1) |
colFirstData |
|
Logical right column (1) |
rfxGeom.colLast |
If the row area or the column (1) area does not exist for this PivotTable report, the data area (section 2.2.5.3.8.1.4) does not exist for this PivotTable report.
The page area (section 2.2.5.3.8.1.3) of the PivotTable (section 2.2.5) report is a range of cells as specified in the following table.
|
Page area |
Row or column index |
|---|---|
|
Top row |
rfxGeom.rwFirst – crwPage – 1 |
|
Bottom row |
rfxGeom.rwFirst – 2 |
|
Logical left column (1) |
rfxGeom.colFirst |
|
Logical right column (1) |
rfxGeom.colFirst + cColPage – 1 |
If cRwPage is equal to 0 and the fNewDropZones field of the BrtBeginSXView (section 2.4.275) record is equal to 1 the page area does not exist for this PivotTable report. If cRwPage is equal to 0 and the fNewDropZones field of the BrtBeginSXView (section 2.4.275) record is equal to 0, then the page area (section 2.2.5.3.8.1.3) of the PivotTable report is a range of cells as specified in the following table.
-
Page area
Row or column index
Top row
rfxGeom.rwFirst - 2
Bottom row
rfxGeom.rwFirst - 2
Logical left column (1)
rfxGeom.colFirst
Logical right column (1)
rfxGeom.colLast