SXFILT: PivotTable Rule Filter (F2h)

This record stores PivotTable Rule Filter options.

Record Data — BIFF8

Offset

Name

Size

Contents

4

grbit1

2

= 0001h, fRwField, field is in row area.
= 0002h, fColumnField, field is in column area.
= 0004h, fPageField, field is in page area.
= 0008h, fDataField, field is in data area.
= ffc0h, iDim.

8

grbit2

2

= 03ffh, isxvd.
= fc00h, reserved — should always be zero.

10

grbitSbt

2

= 01h, Data
= 02h, Default
= 04h, SUM
= 08h, COUNTA
= 10h, COUNT
= 20h, AVERAGE
= 40h, MAX
= 80h, MIN
= 100h, PRODUCT
= 200h, STDEV
= 400h, STDEVP
= 800h, VAR
= 1000h, VARP

12

cisxvi

2

Number of SXVI records.