SXVDEX: Extended PivotTable View Fields (100h)

This record contains extended PivotTable view fields information.

Record Data — BIFF8

Offset

Name

Size

Contents

4

grbit1

4

= 0001h, fShowAllItems — show all items for this field.
= 0002h, fDragToRow — user can drag field to row area.
= 0004h, fDragToColumn — user can drag field to column area.
= 0008h, fDragToPage — user can drag field to page area.
= 0010h, fDragToHide — user can remove field from view.
= 0060h, reserved.
= 0080h, fServerBased — this field is a server-based field in the page area.
= 0100h, reserved.
= 0200h, fAutoSort — autosort is enabled.
= 0400h, fAscendSort — autosort ascending.
= 0800h, fAutoShow — autoshow is enabled.
= 1000h, fAscendShow — show top values.
= 2000h, fCalculatedField — calculated field.
= c000h, reserved.

8

Reserved

1

9

citmShow

1

Number of items to show for AutoShow, default is 10.

10

isxdiSort

2

0-based index of data field that AutoSort is based on or
– 1 for current field.

12

isxdiShow

2

0-based index of data field that AutoShow is based on.

14

ifmt

2

Number format of field or 0 if none.