SXVD: View Fields (B1h)

This record contains PivotTable view fields and other information.

Record Data

Offset

Name

Size

Contents

4

sxaxis

2

Axis:
= 0, no axis
= 1, row
= 2, column
= 4, page
= 8, data

6

cSub

2

Number of subtotals attached.

8

grbitSub

2

Item subtotal type (see the following table).

10

cItm

2

Number of items.

12

cchName

2

Length of the name; if the name = FFFFh, rgch is null and the name in the cache is used.

14

rgch

var

Name.


The subtotal type (grbitSub) bits are defined as shown in the following table.

Name

Contents

bitFNone

0000h

bitFDefault

0001h

bitFSum

0002h

bitFCounta

0004h

bitFAverage

0008h

bitFMax

0010h

bitFMin

0020h


Name

Contents

bitFProduct

0040h

bitFCount

0080h

bitFStdev

0100h

bitFStdevp

0200h

bitFVar

0400h

bitFVarp

0800h