2.2.5.4.10.1 Location and Body
The column area (section 2.2.5.4.10.1.2) is located immediately above the data area (section 2.2.5.4.10.1.4). The cell in the column area (section 2.2.5.4.10.1.2) containing the pivot item (section 2.2.5.4.4) caption or data item (section 2.2.5.4.9.5.1) caption to the farthest logical left is in the same column as the logical top-left cell of the data area (section 2.2.5.4.10.1.4).
The row area (section 2.2.5.4.10.1.1) is located immediately to the logical left of the data area (section 2.2.5.4.10.1.4). The cell in the row area (section 2.2.5.4.10.1.1) containing the top-most pivot item (section 2.2.5.4.4) caption or data item (section 2.2.5.4.9.5.1) caption is in the same row as the logical top-left cell of the data area (section 2.2.5.4.10.1.4).
The PivotTable report (section 2.2.5) body is the rectangular area defined by the union of the row area (section 2.2.5.4.10.1.1), column area (section 2.2.5.4.10.1.2), and data area (section 2.2.5.4.10.1.4).
The page area (section 2.2.5.4.10.1.3), if it is not empty, is located above the PivotTable report (section 2.2.5) body. There is one row between the top-most cell of the PivotTable report (section 2.2.5) body and the bottom-most cell of the page area (section 2.2.5.4.10.1.3).
The PivotTable report (section 2.2.5) is a non-contiguous range containing the union of the PivotTable report (section 2.2.5) body and the page area (section 2.2.5.4.10.1.3).
An SxView record and the SXEx record (section 2.4.282) specify details about the location of the PivotTable report (section 2.2.5) in the sheet and the sizes of the areas of the PivotTable report (section 2.2.5) as specified by the following. All fields are of the SxView record (section 2.4.313) unless otherwise specified.
The column area (section 2.2.5.4.10.1.2) of the PivotTable report (section 2.2.5) is specified to be the following range of cells:
-
Column Area
Row or Column Index
Top row
ref.rwFirst
Bottom row
rwFirstData – 1
Logical left column
colFirstData
Logical right column
ref.colLast
If colFirstData is greater than ref.colLast, the column area (section 2.2.5.4.10.1.2) does not exist for this PivotTable report (section 2.2.5).
The row area (section 2.2.5.4.10.1.1) of the PivotTable report (section 2.2.5) is specified to be the following range of cells:
-
Row Area
Row or Column Index
Top row
rwFirstData
Bottom row
ref.rwLast
Logical left column
ref.colFirst
Logical right column
colFirstData – 1
If colFirstData – 1 is less than ref.colFirst, the row area (section 2.2.5.4.10.1.1) does not exist for this PivotTable report (section 2.2.5).
The data area (section 2.2.5.4.10.1.4) of the PivotTable report (section 2.2.5) is specified to be the following range of cells:
-
Data Area
Row or Column Index
Top row
rwFirstData
Bottom row
ref.rwLast
Logical left column
colFirstData
Logical right column
ref.colLast
If the row area (section 2.2.5.4.10.1.1) or the column area (section 2.2.5.4.10.1.2) does not exist for this PivotTable report (section 2.2.5), the data area (section 2.2.5.4.10.1.4) does not exist for this PivotTable report (section 2.2.5).
The page area (section 2.2.5.4.10.1.3) of the PivotTable report (section 2.2.5) is specified to be the following range of cells. The cRwPage field and the cColPage field are of the SXEx record (section 2.4.282):
-
Page Area
Row or Column Index
Top row
ref.rwFirst – cRwPage – 1
Bottom row
ref.rwFirst – 2
Logical left column
ref.colFirst
Logical right column
ref.colFirst + cColPage – 1
If the cRwPage field of the SXEx record (section 2.4.282) is equal to 0 and the fNewDropZones field of the SXAddl_SXCView_SXDVer12Info record (section 2.4.273.109) is equal to 1 the page area (section 2.2.5.4.10.1.3) does not exist for this PivotTable report (section 2.2.5).
If the cRwPage field is equal to 0 and the fNewDropZones field is equal to 0, then the page area (section 2.2.5.4.10.1.3) of the PivotTable report (section 2.2.5) is specified to be the following range of cells:
-
Page Area
Row or Column Index
Top row
ref.rwFirst - 2
Bottom row
ref.rwFirst - 2
Logical left column
ref.colFirst
Logical right column
ref.colLast