Export (0) Print
Expand All
Expand Minimize

2.4.297 SXPair

Office

The SXPair record specifies a reference to a pivot item used to compute the value of a calculated item in a PivotTable.


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

isxvd

iCache

reserved1

A

B

C

D

reserved3

isxvd (2 bytes): An unsigned integer that specifies a cache field index. This index specifies a cache field that contains the cache item associated with the pivot item specified by iCache.

iCache (2 bytes): A signed integer that specifies a pivot item of the PivotTable view associated with this record as specified by Associated PivotCache. This pivot item is used in a calculated item formula (section 2.2.2). If more than one PivotTable view is associated with this record, iCache specifies a pivot item for each such PivotTable view.

If the value of fPhysical is 0, iCache is a cache item index and specifies the pivot item associated with that cache item.

Otherwise, if the value of fRelative is 0 or if no pivot item in the visible item collection has a pivot item index smaller than the pivot item index of the current pivot item, iCache is a visible item index. Otherwise, the pivot item specified by iCache is the pivot item whose visible item index equals the value of iCache + 1 + the largest visible item index whose associated pivot item has a pivot item index smaller than the pivot item index of the current pivot item. If this value is less than 0 or greater than or equal to the number of elements in the visible item collection, no pivot item is specified.

The current pivot item is the pivot item in the current pivot field that corresponds to the calculated item that contains this record.

The current pivot field is the pivot field of the PivotTable view associated with the cache field specified by isxvd.

The visible item collection is the ordered collection of all pivot items specified by the sequence of records that conforms to the PIVOTVD rule associated with the current pivot field that satisfy the following criteria:

  • The value of the fHidden field of the SXVI record associated with the pivot item is 0.

  • The value of the fMissing field of the SXVI record associated with the pivot item is 0 or the value of the fShowAllItems field of the SXVI record associated with the current pivot field is 1.

  • The value of the itmType field of the SXVI record associated with the pivot item is 0.

A visible item index is specified to be the zero-based index of a pivot item in the visible item collection.

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

A - fFormula (1 bit): A bit that specifies whether the item is a calculated item. If fPhysical is 1, it MUST have the same value as the fFormula field of the SXVI record corresponding to the pivot item specified by iCache.

B - reserved2 (2 bits): MUST be zero, and MUST be ignored.

C - fPhysical (1 bit): A bit that specifies whether iCache specifies a cache item index.

Value

Meaning

0

iCache specifies a cache item index.

1

iCache does not specify a cache item index.

D - fRelative (1 bit): A bit that specifies whether the item is referred to by relative position rather than absolute position. If fPhysical is 0, fRelative MUST be 0 and MUST be ignored. If fPhysical is 1, fRelative MUST be a value from the following table:

Value

Meaning

0

Absolute position.

1

Position relative to the calculated item referring this item.

reserved3 (11 bits): MUST be zero, and MUST be ignored.

Show:
© 2015 Microsoft