2.4.294 SxName
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).
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.