2.2.5.4.10.1 Location and Body

Office

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 rfxGeom.colFirstData, 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.rwFirstcRwPage – 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

Show: