SXEX: PivotTable View Extended Information (F1h)

This record follows the SXVIEW record and contains information about additional features added to PivotTables in Microsoft Excel 97.

Record Data — BIFF8

Offset

Name

Size

Contents

4

csxformat

2

Number of SXFORMAT records to follow

6

cchErrorString

2

Number of characters for DisplayErrorString string

8

cchNullString

2

Number of characters for DisplayNullString string

10

cchTag

2

Number of characters in Tag string

12

csxselect

2

Number of RTSXSELECT records to follow

14

crwPage

2

Number of page field per row

16

ccolPage

2

Number of page field per column

18

grbit1

2

= 01h, fAcrossPageLay
= 1eh, cWrapPage
= 20h, fPreserveFormattingNow
= 40h, fManualUpdate

20

grbit2

2

= 01h, fEnableWizard
= 02h, fEnableDrilldown
= 04h, fEnableFieldDialog
= 08h, fPreserveFormatting
= 10h, fMergeLabels
= 20h, fDisplayErrorString
= 40h, fDisplayNullString
= 80h, fSubtotalHiddenPageItems

22

cchPageFieldStyle

2

Number of characters for page field style string

24

cchTableStyle

2

Number of characters for table style string

26

cchVacateStyle

2

Number of characters for vacate style string

28

rgb

(var)

Array of characters for ErrorString, NullString, Tag, PageFieldStyle, TableStyle, VacateStyle