Export (0) Print
Expand All
Expand Minimize

2.4.273.77 SXAddl_SXCSXfilt_SXDSXfilt

Office

The SXAddl_SXCSXfilt_SXDSXfilt record specifies information for a PivotTable rule filter, for an SXCSXfilt class.


0

1

2

3

4

5

6

7

8

9
1
0

1

2

3

4

5

6

7

8

9
2
0

1

2

3

4

5

6

7

8

9
3
0

1

hdr

...

reserved1

...

A

B

C

D

E

F

G

reserved5

grbitSbt

iDim

isxvd

cisxvi

hdr (6 bytes): An SXAddlHdr structure. The value of hdr.sxc MUST equal 0x0D and the value of hdr.sxd MUST equal 0x14.

reserved1 (6 bytes): MUST be zero, and MUST be ignored.

A - sxaxisRw (1 bit): A bit that specifies whether the row axis is being referred to.

MUST be zero if the value of sxaxisCol is 1 or the value of sxaxisPage is 1 or the value of sxaxisData is 1.

B - sxaxisCol (1 bit): A bit that specifies whether the column axis is being referred to.

MUST be zero if the value of sxaxisRw is 1 or the value of sxaxisPage is 1 or the value of sxaxisData is 1.

C - reserved2 (1 bit): MUST be zero, and MUST be ignored.

D - sxaxisData (1 bit): A bit that specifies whether the value axis is being referred to.

MUST be zero if the value of sxaxisRw is 1 or the value of sxaxisCol is 1 or the value of sxaxisPage is 1.

E - fSelected (1 bit): A bit that specifies whether the header of the Pivot Field is included in the PivotTable rule filters.

F - reserved3 (1 bit): MUST be zero, and MUST be ignored.

G - reserved4 (1 bit): MUST be zero, and MUST be ignored.

reserved5 (9 bits): MUST be zero, and MUST be ignored.

grbitSbt (2 bytes): A signed integer that specifies the subtotals for this PivotTable rule filter. MUST be a value from the following table:

Value

Meaning

0

No subtotals are displayed.

1

Data value subtotals are displayed.

iDim (4 bytes): A signed integer that specifies the position of the Pivot Field within the axis specified by sxaxisRw, sxaxisCol, sxaxisPage, or sxaxisData. MUST be greater than or equal to -1 and less than or equal to 0x0000001F.

isxvd (4 bytes): A signed integer that specifies the Pivot Field that this PivotTable rule filter refers to. MUST be a value from the following table:

Value

Meaning

-2

This PivotTable rule filter refers to the data field.

-1

This PivotTable rule filter does not refer to a pivot field

0 to 255

This value specifies a pivot field index, as specified in Pivot Fields. The pivot field index specifies which pivot field this PivotTable rule filter refers to.

If the value is greater than or equal to zero, MUST be less than the number of pivot fields in the PivotTable view.

cisxvi (4 bytes): An unsigned integer that specifies the count of pivot item indexes in the SXAddl_SXCSXfilt_SXDSXItm record that follows this record. MUST be greater than or equal to zero. If isxvd is -1, MUST be 0.

Show:
© 2015 Microsoft