Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.