This record contains top-level PivotTable information.
Record Data
Offset |
Name |
Size |
Contents |
4 |
rwFirst |
2 |
First row of the PivotTable |
6 |
rwLast |
2 |
Last row of the PivotTable |
8 |
colFirst |
2 |
First column of the PivotTable |
10 |
colLast |
2 |
Last column of the PivotTable |
12 |
rwFirstHead |
2 |
First row containing PivotTable headings |
14 |
rwFirstData |
2 |
First row containing PivotTable data |
16 |
colFirstData |
2 |
First column containing PivotTable data |
18 |
iCache |
2 |
Index to the cache |
20 |
(Reserved) |
2 |
Reserved; must be 0 (zero) |
22 |
sxaxis4Data |
2 |
Default axis for a data field |
24 |
ipos4Data |
2 |
Default position for a data field |
26 |
cDim |
2 |
Number of fields |
28 |
cDimRw |
2 |
Number of row fields |
30 |
cDimCol |
2 |
Number of column fields |
32 |
cDimPg |
2 |
Number of page fields |
34 |
cDimData |
2 |
Number of data fields |
36 |
cRw |
2 |
Number of data rows |
38 |
cCol |
2 |
Number of data columns |
40 |
grbit |
2 |
Option flags |
42 |
itblAutoFmt |
2 |
Index to the PivotTable autoformat |
44 |
cchName |
2 |
Length of the PivotTable name |
46 |
cchData |
2 |
Length of the data field name |
48 |
rgch |
var |
PivotTable name, followed by the name of a data field |
The grbit field contains the option flags listed in the following table.
Offset |
Bits |
Mask |
Name |
Contents |
0 |
0 |
0001h |
fRwGrand |
= 1 if the PivotTable contains grand totals for rows |
1 |
0002h |
fColGrand |
= 1 if the PivotTable contains grand totals for columns | |
2 |
0004h |
(Reserved) |
Reserved; must be 0 (zero) | |
3 |
0008h |
fAutoFormat |
= 1 if the PivotTable has an autoformat applied | |
4 |
0010h |
fWH |
= 1 if the width/height autoformat is applied | |
5 |
0020h |
fFont |
= 1 if the font autoformat is applied | |
6 |
0040h |
fAlign |
= 1 if the alignment autoformat is applied | |
7 |
0080h |
fBorder |
= 1 if the border autoformat is applied | |
8 |
0100h |
fPattern |
= 1 if the pattern autoformat is applied | |
9 |
0200h |
fNumber |
= 1 if the number autoformat is applied | |
15–10 |
FC00h |
(Reserved) |
Reserved; must be 0 (zero) |