2.4.273.109 SXAddl_SXCView_SXDVer12Info

Office

The SXAddl_SXCView_SXDVer12Info record specifies information for a PivotTable view, for an SxcView 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

G

H

I

J

K

reserved2

...

L

M

N

O

cIndentInc

P

reserved3

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

A - fDefaultCompact (1 bit): A bit that specifies whether new pivot fields added to the PivotTable view are in compact axis mode by default.

B - fDefaultOutline (1 bit): A bit that specifies whether new pivot fields added to the PivotTable view are displayed in outline format by default.

C - fOutlineData (1 bit): A bit that specifies whether the data field is displayed in outline format. See Subtotalling for more information.

D - fCompactData (1 bit): A bit that specifies whether the data field is displayed in compact axis mode. See PivotTable Layout for more information.

E - fNewDropZones (1 bit): A bit that specifies whether the application allows dragging within the PivotTable field list.

F - fPublished (1 bit): A bit that specifies whether this PivotTable is marked as having already been published to a server-based application. This bit is ignored if the fPublishedBookItems field of the BookExt_Conditional2.5.13 structure is zero.

G - fTurnOffImmersive (1 bit): A bit that specifies whether a user interface for manipulating PivotTable options is displayed.

MUST be a value from the following table:

Value

Meaning

0

A user interface for manipulating PivotTable options is displayed.

1

A user interface for manipulating PivotTable options is not displayed.

H - fSingleFilterPerField (1 bit): A bit that specifies whether this PivotTable can have multiple filters per field.

MUST be a value from the following table:

Value

Meaning

0

The PivotTable can have many filters per field.

1

The PivotTable can have a maximum of one filter per field.

I - fNonDefaultSortInFlist (1 bit): A bit that specifies whether PivotTable fields are sorted in the PivotTable field list.

MUST be a value from the following table:

Value

Meaning

0

PivotTable fields are not sorted in the PivotTable field list.

1

PivotTable fields are sorted in the PivotTable field list.

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

K - fDontUseCustomLists (1 bit): A bit that specifies whether to use custom lists when sorting the PivotTable.

MUST be a value from the following table:

Value

Meaning

0

Custom lists are used when sorting the PivotTable.

1

Custom lists are not used when sorting the PivotTable.

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

L - fHideDrillIndicators (1 bit): A bit that specifies whether the expand/collapse buttons are hidden in the PivotTable view.

M - fPrintDrillIndicators (1 bit): A bit that specifies whether the expand/collapse buttons are printed.

N - fMemPropsInTips (1 bit): A bit that specifies whether OLAP member properties are displayed in ToolTips.

O - fNoPivotTips (1 bit): A bit that specifies whether ToolTips are displayed on cells in the PivotTable view.

MUST be a value from the following table:

Value

Meaning

0

ToolTips are displayed on cells in the PivotTable view.

1

ToolTips are not displayed on cells in the PivotTable view.

cIndentInc (7 bits): An unsigned integer that specifies the number of characters to indent row labels by when compact axis mode is used. See PivotTable Layout for more information.

P - fNoHeaders (1 bit): A bit that specifies whether field captions are displayed in the PivotTable layout.

MUST be a value from the following table:

Value

Meaning

0

Field captions are displayed in the PivotTable layout.

1

Field captions are not displayed in the PivotTable layout.

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

Show: