SXVI: View Item (B2h)

This record contains information about a PivotTable item.

Record Data

Offset

Name

Size

Contents

4

itmtype

2

Item type:
= FEh, Page
= FFh, Null
= 00h, Data
= 01h, Default
= 02h, SUM
= 03h, COUNTA
= 04h, COUNT
= 05h, AVERAGE
= 06h, MAX
= 07h, MIN
= 08h, PRODUCT
= 09h, STDEV
= 0Ah, STDEVP
= 0Bh, VAR
= 0Ch, VARP
= 0Dh, Grand total

6

grbit

2

Option flags.

8

iCache

2

Index to the PivotTable cache.

10

cchName

2

Length of the name; if the name = FFFFh, rgch is null and the name in the cache is used.

12

rgch

var

Name.


The grbit field contains the option flags listed in the following table.

Offset

Bits

Mask

Name

Contents

0

0

01h

fHidden

= 1 if the item is hidden.

1

02h

fHideDetail

= 1 if detail is hidden.

2

04h

fFormula

= 1 if item is a calculated item.

3

08h

fMissing

= 2 if item is an item that does not exist in any records.

7–4

F0h

(Reserved)

Reserved, must be 0 (zero).

1

7–0

FFh

(Reserved)

Reserved, must be 0 (zero).