Export (0) Print
Expand All
Expand Minimize

2.4.313 SxView

Office

The SxView record specifies PivotTable view information and that specifies the beginning of a collection of records as defined by the Worksheet substreamABNF. The collection specifies the remainder of 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

ref

...

rwFirstHead

rwFirstData

colFirstData

iCache

reserved

sxaxis4Data

ipos4Data

cDim

cDimRw

cDimCol

cDimPg

cDimData

cRw

cCol

A

B

C

D

E

F

G

H

I

J

unused2

itblAutoFmt

cchTableName

cchDataName

stTable (variable)

...

stData (variable)

...

ref (8 bytes): A Ref8U structure that specifies the PivotTable report body. For more information, see Location and Body.

rwFirstHead (2 bytes): An RwU structure that specifies the first row of the row area. MUST be 1 if none of the axes are assigned in this PivotTable view. Otherwise, the value MUST be greater than or equal to ref.rwFirst.

rwFirstData (2 bytes): An RwU structure that specifies the first row of the data area. MUST be 1 if none of the axes are assigned in this PivotTable view. Otherwise, it MUST be equal to the value as specified by the following formula:

rwFirstData = rwFirstHead + cDimCol

colFirstData (2 bytes): A ColU structure that specifies the first column of the data area. It MUST be 1 if none of the axes are assigned in this PivotTable view. Otherwise, the value MUST be greater than or equal to ref.colFirst, and if the value of cDimCol or cDimData is not zero, it MUST be less than or equal to ref.colLast.

iCache (2 bytes): A signed integer that specifies the zero-based index of an SXStreamID record in the Globals Substream. See Associated PivotCache for more information. MUST be greater than or equal to zero and less than the number of SXStreamID records in the Globals Substream.

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

sxaxis4Data (2 bytes): An SXAxis structure that specifies the default axis for the data field. Either the sxaxis4Data.sxaxisRw field MUST be 1 or the sxaxis4Data.sxaxisCol field MUST be 1. The sxaxis4Data.sxaxisPage field MUST be 0 and the sxaxis4Data.sxaxisData field MUST be 0.

ipos4Data (2 bytes): A signed integer that specifies the row or column position for the data field in the PivotTable view. The sxaxis4Data field specifies whether this is a row or column position. MUST be greater than or equal to -1 and less than or equal to 0x7FFF. A value of -1 specifies the default position.

cDim (2 bytes): A signed integer that specifies the number of pivot fields in the PivotTable view. MUST equal the number of Sxvd records following this record. MUST equal the number of fields in the associated PivotCache specified by iCache.

cDimRw (2 bytes): An unsigned integer that specifies the number of fields on the row axis of the PivotTable view. MUST be less than or equal to 0x7FFF. MUST equal the number of array elements in the SxIvd record in this PivotTable view that contain row items.

cDimCol (2 bytes): An unsigned integer that specifies the number of fields on the column axis of the PivotTable view. MUST be less than or equal to 0x7FFF. MUST equal the number of array elements in the SxIvd record in this PivotTable view that contain column items.

cDimPg (2 bytes): An unsigned integer that specifies the number of page fields in the PivotTable view. MUST be less than or equal to 0x7FFF. MUST equal the number of array elements in the SXPI record in this PivotTable view.

cDimData (2 bytes): A signed integer that specifies the number of data fields in the PivotTable view. MUST be greater than or equal to zero and less than or equal to 0x7FFF. MUST equal the number of SXDI records in this PivotTable view.

cRw (2 bytes): An unsigned integer that specifies the number of pivot lines in the row area of the PivotTable view. MUST be less than or equal to 0x7FFF. MUST equal the number of array elements in the first SXLI record in this PivotTable view.

cCol (2 bytes): An unsigned integer that specifies the number of pivot lines in the column area of the PivotTable view. MUST equal the number of array elements in the second SXLI record in this PivotTable view.

A - fRwGrand (1 bit): A bit that specifies whether the PivotTable contains grand totals for rows. MUST be 0 if none of the axes have been assigned in this PivotTable view.

B - fColGrand (1 bit): A bit that specifies whether the PivotTable contains grand totals for columns. MUST be 1 if none of the axes are assigned in this PivotTable view.

C - unused1 (1 bit): Undefined and MUST be ignored.

D - fAutoFormat (1 bit): A bit that specifies whether the PivotTable has AutoFormat applied.

E - fAtrNum (1 bit): A bit that specifies whether the PivotTable has number AutoFormat applied.

F - fAtrFnt (1 bit): A bit that specifies whether the PivotTable has font AutoFormat applied.

G - fAtrAlc (1 bit): A bit that specifies whether the PivotTable has alignment AutoFormat applied.

H - fAtrBdr (1 bit): A bit that specifies whether the PivotTable has border AutoFormat applied.

I - fAtrPat (1 bit): A bit that specifies whether the PivotTable has pattern AutoFormat applied.

J - fAtrProc (1 bit): A bit that specifies whether the PivotTable has width/height AutoFormat applied.

unused2 (6 bits): Undefined and MUST be ignored.

itblAutoFmt (2 bytes): An AutoFmt8 structure that specifies the PivotTable AutoFormat. If the value of itblAutoFmt in the associated SXViewEx9 record is not 1, this field is overridden by the value of itblAutoFmt in the associated SXViewEx9.

cchTableName (2 bytes): An unsigned integer that specifies the length, in characters, of stTable. MUST be greater than or equal to zero and less than or equal to 0x00FF.

cchDataName (2 bytes): An unsigned integer that specifies the length, in characters of stData. MUST be greater than zero and less than or equal to 0x00FE.

stTable (variable): An XLUnicodeStringNoCch structure that specifies the name of the PivotTable. The length of this field is specified by cchTableName.

stData (variable): An XLUnicodeStringNoCch structure that specifies the name of the data field. The length of this field is specified by cchDataName.

Show:
© 2015 Microsoft