2.2.5.4.10.1 Location and Body

Article
02/15/2022

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

2.2.5.4.10.1 Location and Body

Additional resources