Export (0) Print
Expand All
Expand Minimize

2.4.211 QsiSXTag

Office

The QsiSXTag record specifies the name and refresh information for a query table or a PivotTable view, and specifies the beginning of a collection of records as defined by the Worksheet SubstreamABNF. The collection of records specifies additional information for a query table or a PivotTable view.

If fSx is 0 and stName is equal to the rgchName field of a Qsi record in this worksheet substream, then this collection of records applies to the query table that the Qsi record is associated with. If fSx is 1 and stName is equal to the stName field of an SxView record in this worksheet substream, then this collection of records applies to the PivotTable view that the SxView record is associated with and its associated PivotCache. Otherwise, this collection of records MUST be ignored.


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

frtHeaderOld

fSx

A

B

C

reserved1

dwQsiFuture

verSxLastUpdated

verSxUpdatableMin

obCchName

reserved2

stName (variable)

...

unused

frtHeaderOld (4 bytes): An FrtHeaderOld structure. The frtHeaderOld.rt field MUST be 0x0802.

fSx (2 bytes): A Boolean (section 2.5.14) that specifies whether this record relates to a PivotTable view or a query table.

Value

Meaning

0x0000

Specifies that this record relates to a query table.

0x0001

Specifies that this record relates to a PivotTable view.

A - fEnableRefresh (1 bit): A bit that specifies whether refresh of the PivotTable view or query table is enabled. MUST be 0 if fSx is 1 and the PivotCache functionality level of the associated PivotCache is greater than or equal to 3.

Value

Value of fSx

Meaning

0

0

Whether refresh of the query table is enabled is specified by the fDisableRefresh field of the associated Qsi record.

0

1

Whether refresh of the associated PivotCache is enabled is specified by the fEnableRefresh field in the SXDB record of the PivotCache.

1

0

Specifies that refresh of the query table is enabled.

1

1

Specifies that refresh of the associated PivotCache is enabled.

B - fInvalid (1 bit): A bit that specifies the invalid state of the cache records of the associated PivotCache; see Cache Records for more information. MUST be 1 if fSx is 1 and the PivotCache functionality level of the associated PivotCache is greater than or equal to 3.

C - fTensorEx (1 bit): A bit that specifies whether the PivotTable view is an OLAP PivotTable view. MUST be equal to 0 if fSx is 0.

reserved1 (13 bits): MUST be zero, and MUST be ignored.

dwQsiFuture (4 bytes): This structure specifies additional option flags for a query table or a PivotTable view depending on the value of the fSx field.

Value of fSx Field

Type of dwQsiFuture

0x0000

DwQsiFuture

0x0001

SXView9Save

verSxLastUpdated (1 byte): A DataFunctionalityLevel value that specifies the data functionality level that the PivotTable view was last refreshed with. MUST be 0 if this record relates to a query table.

verSxUpdatableMin (1 byte): A DataFunctionalityLevel value that specifies the minimum version of the application that can recalculate the PivotTable view. MUST be 0x00 or 0x03. MUST be 0 if this record is for a query table. MUST be 3 if the PivotCache functionality level of the associated PivotCache is 3.

obCchName (1 byte): MUST be 0x10, and MUST be ignored.

reserved2 (1 byte): MUST be zero, and MUST be ignored.

stName (variable): An XLUnicodeString structure that specifies the query table or PivotTable view name.

unused (2 bytes): Undefined and MUST be ignored.

Show:
© 2014 Microsoft