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.294 SxName

Office

The SxName record specifies information used for a calculated field or calculated item and that specifies the beginning of a collection of records as specified by the pivot cache storage ABNF.  When used for a calculated field, this record specifies the index of a cache field used in a calculated field formula (section 2.2.2).  When used for a calculated item, this record is followed by a collection of SxPair records that specify a pivot item used in a calculated item formula (section 2.2.2).


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

A

B

unused2

ifdb

ifn

csxpair

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

B - fErrName (1 bit): A bit that specifies whether this record is not valid. MUST be set to 1 if ifdb field is set to -1.

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

ifdb (2 bytes): A signed integer that specifies a cache field index. The cache field index specifies a cache field used in a calculated field formula. MUST be greater than or equal to -1. MUST be set to -1 if csxpair is greater than 0. MUST be set to -1 when the calculated field formula cannot be computed because the cache field used in the formula is removed.

ifn (2 bytes): A signed integer that MUST be set to -1.

csxpair (2 bytes): An unsigned integer that specifies the count of contiguous SXPair records that follow this record. MUST be less than or equal to 1. MUST be equal to 0 if and only if this record is in a calculated field.

Show:
© 2015 Microsoft