Export (0) Print
Expand All
Expand Minimize

2.4.315 SXViewEx9

Office

The SXViewEx9 record specifies extensions to the PivotTable view.


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

rt

A

B

reserved2

reserved3

C

D

E

F

G

reserved6

itblAutoFmt

chGrand (variable)

...

rt (2 bytes): An unsigned integer that specifies the record type identifier. The value MUST be 0x0810.

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

B - fFrtAlert (1 bit): A bit that specifies whether features of this PivotTable are not supported in earlier versions of the BIFF.

An application can alert the user of possible problems when saving as an earlier version of the BIFF.

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

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

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

D - fPrintTitles (1 bit): A bit that specifies whether the print titles for the worksheet are set based on the PivotTable report. The row print titles are set to the pivot item captions on the column axis and the column print titles are set to the pivot item captions on the row axis.

E - fLineMode (1 bit): A bit that specifies whether any pivot field is in outline mode. See Subtotalling for more information.

F - reserved5 (2 bits): MUST be zero, and MUST be ignored.

G - fRepeatItemsOnEachPrintedPage (1 bit): A bit that specifies whether pivot item captions on the row axis are repeated on each printed page for pivot fields in tabular form.

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

itblAutoFmt (2 bytes): An AutoFmt8 structure that specifies the PivotTable AutoFormat. If the value of this field is not 1, this field overrides the itblAutoFmt field in the previous SxView record.

chGrand (variable): An XLUnicodeString structure that specifies a user-entered caption to display for grand totals when the PivotTable is recalculated. The length MUST be less than or equal to 255 characters.

Show:
© 2015 Microsoft