2.4.273.33 SXAddl_SXCField12_SXDVer12Info

  • Article

The SXAddl_SXCField12_SXDVer12Info record specifies additional properties of a pivot field for an SXCField12 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

...

A

B

C

D

E

F

reserved2

...

reserved3

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

A - reserved1 (1 bit): MUST be zero, and MUST be ignored.

B - fHiddenLvl (1 bit): A bit that specifies whether the OLAP pivot field is a hidden level. The value is ignored if it is not an OLAP PivotTable view.

C - fUseMemPropCaption (1 bit): A bit that specifies whether the member property is used as a caption for the pivot field. If it is set and there is a SXAddl_SXCField12_SXDMemberCaption record in this SXCField12 class, then the value from the member property specified by SXAddl_SXCField12_SXDMemberCaption is used as captions for the pivot items of this pivot field.

D - fCompact (1 bit): A bit that specifies where the next pivot field is displayed in the PivotTable layout.

Value

Meaning

0x0

The pivot field is displayed in the next column on the sheet.

0x1

The pivot field is displayed in the same column on the sheet.

E - fNotAutoSortDft (1 bit): A bit that specifies whether, during the next sort operation that is done on this pivot field, the pivot items are  sorted or whether the sort condition is remembered and reapplied on subsequent recalculation of the PivotTable view. A value of 1 specifies that pivot items are to be sorted.

F - fFilterInclusive (1 bit): A bit that specifies whether any manual filter applied to this pivot field specifies pivot items that are included or excluded. If this pivot field is associated with a pivot hierarchy, this value MUST equal the fFilterInclusive field on the SXTH record that specifies the pivot hierarchy that this pivot field is associated with. MUST be a value from the following table:

Value

Meaning

0x0

Any manual filter applied to this pivot field specifies pivot items that are excluded.

0x1

Any manual filter applied to this pivot field specifies pivot items that are included.

reserved2 (26 bits): MUST be zero, and MUST be ignored.

reserved3 (2 bytes): MUST be zero, and MUST be ignored.