SXRULE: PivotTable Rule Data (F0h)

This record stores PivotTable rule data.

Record Data — BIFF8

Offset

Name

Size

Contents

4

iDim

1

Position of current field in axis.

5

isxvd

1

Current field.

6

grbit

2

= 0001h, current field is in row area.
= 0002h, current field is in column area.
= 0004h, current field is in page area.
= 0008h, current field is in data area.
= 00f0h, sxrtype:
= 0100h, reserved.
= 0200h, fNoHeader — header is not selected.
= 0400h, fNoData — data is not selected.
= 0800h, fGrandRw — row grandtotal is selected.
= 1000h, fGrandCol — column grandtotal is selected.
= 2000h, fGrandRwSav.
= 4000h, fCacheBased.
= 8000h, fGrandColSav.

8

unused

2

10

csxfilt

2

Number of SXFILT records following this record.