SXVIEW: View Definition (B0h)

This record contains top-level PivotTable information.

Record Data

Offset

Name

Size

Contents

4

rwFirst

2

First row of the PivotTable

6

rwLast

2

Last row of the PivotTable

8

colFirst

2

First column of the PivotTable

10

colLast

2

Last column of the PivotTable

12

rwFirstHead

2

First row containing PivotTable headings

14

rwFirstData

2

First row containing PivotTable data

16

colFirstData

2

First column containing PivotTable data

18

iCache

2

Index to the cache

20

(Reserved)

2

Reserved; must be 0 (zero)

22

sxaxis4Data

2

Default axis for a data field

24

ipos4Data

2

Default position for a data field

26

cDim

2

Number of fields

28

cDimRw

2

Number of row fields

30

cDimCol

2

Number of column fields

32

cDimPg

2

Number of page fields

34

cDimData

2

Number of data fields

36

cRw

2

Number of data rows

38

cCol

2

Number of data columns

40

grbit

2

Option flags

42

itblAutoFmt

2

Index to the PivotTable autoformat

44

cchName

2

Length of the PivotTable name

46

cchData

2

Length of the data field name

48

rgch

var

PivotTable name, followed by the name of a data field


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

Offset

Bits

Mask

Name

Contents

0

0

0001h

fRwGrand

= 1 if the PivotTable contains grand totals for rows

1

0002h

fColGrand

= 1 if the PivotTable contains grand totals for columns

2

0004h

(Reserved)

Reserved; must be 0 (zero)

3

0008h

fAutoFormat

= 1 if the PivotTable has an autoformat applied

4

0010h

fWH

= 1 if the width/height autoformat is applied

5

0020h

fFont

= 1 if the font autoformat is applied

6

0040h

fAlign

= 1 if the alignment autoformat is applied

7

0080h

fBorder

= 1 if the border autoformat is applied

8

0100h

fPattern

= 1 if the pattern autoformat is applied

9

0200h

fNumber

= 1 if the number autoformat is applied

15–10

FC00h

(Reserved)

Reserved; must be 0 (zero)