Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

2.4.273.108 SXAddl_SXCView_SXDVer10Info

Office

The SXAddl_SXCView_SXDVer10Info record specifies information about 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

...

bVerSxMacro

A

B

C

D

E

F

G

H

I

J

unused

reserved2

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

bVerSxMacro (1 byte): A DataFunctionalityLevel structure that specifies the data functionality level that this PivotTable was created with. SHOULD<129> be less than 3 if the PivotCache functionality level of the associated PivotCache is less than 3. MUST be greater than or equal to 3 if the PivotCache functionality level of the associated PivotCache is greater than or equal to 3.

A - fDisplayImmediateItems (1 bit): A bit that specifies whether pivot items are displayed in the PivotTable view even when there is no pivot field on the data axis. If bVerSxMacro is greater than or equal to 3 then this value MUST be 1.

B - fEnableDataEd (1 bit): A bit that specifies whether the user is allowed to change values in the data axis of the PivotTable view.

C - fDisableFList (1 bit): A bit that specifies whether the PivotTable field list is disabled.

D - fReenterOnLoadOnce (1 bit): A bit that specifies whether the PivotTable view is recalculated the next time the workbook is opened.

E - fNotViewCalculatedMembers (1 bit): A bit that specifies whether OLAP calculated members are hidden in the PivotTable view.

MUST be a value from the following table:

Value

Meaning

0

OLAP calculated members are not hidden.

1

OLAP calculated members are hidden.

MUST be ignored if the PivotTable view is a non-OLAP PivotTable view.

F - fNotVisualTotals (1 bit): A bit that specifies whether grand totals and subtotals in an OLAP PivotTable view include the values of hidden OLAP members.

MUST be a value from the following table:

Value

Meaning

0

Hidden OLAP members are not included in grand totals and subtotals.

1

Hidden OLAP members are included in grand totals and subtotals.

MUST be ignored if the PivotTable view is a non-OLAP PivotTable view.

G - fPageMultipleItemLabel (1 bit): A bit that specifies what text is displayed in a cell in the page area when a non-OLAPdata source (1) has one or more hidden pivot items.

MUST be a value from the following table:

Value

Meaning

0

Always show text indicating that all items are displayed.

1

If the data source (1) has one or more hidden pivot items, show text indicating that not all items are displayed, otherwise show text indicating that all items are displayed.

MUST be ignored if the PivotTable view is an OLAP PivotTable view.

H - fTensorFillCv (1 bit): A bit that specifies whether the fill color retrieved from the OLAP data source (1) is used in the PivotTable view.

MUST be a value from the following table:

Value

Meaning

0

The fill color from the OLAP data source (1) is not used.

1

If the data source (1) is OLAP and the fill color is available from the OLAP data source (1), then the fill color is used.

MUST be ignored if the PivotTable view is a non-OLAP PivotTable view.

I - fHideDDData (1 bit): A bit that specifies whether the control for selecting the pivot items to be displayed in the PivotTable view is hidden.

J - reserved1 (3 bits): MUST be zero, and MUST be ignored.

unused (12 bits): Undefined, and MUST be ignored.

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

Show:
© 2015 Microsoft