2.1.7.12 Pivot Cache Storage (_SX_DB_CUR)

Office

The Pivot Cache Storage specifies zero or more streams, each of which specify a PivotCache (section 2.2.5.3) for a PivotTable (section 2.2.5). The name of each stream MUST be unique within the storage, and the name MUST be a four digit hexadecimal number stored as text.

The name of this storage MUST be "_SX_DB_CUR". A file MUST contain at most one Pivot Cache Storage.

The number of FDB rules that occur MUST be equal to the value of cfdbTot in the SXDB record (section 2.4.275).

Record sequence ABNF for each stream:

PIVOTCACHE = SXDB SXDBEx *SXFORMULA *FDB *DBB EOF

FDB = SXFDB SXFDBType [SXFMLA / (*GRPSXOPER [SXRANGE / *(SxIsxoper *Continue)])] *SRCSXOPER

DBB = [SXDBB] *SXOPER

SXFORMULA = SXFMLA PIVOTRULE SXFormula

SXFMLA = SxFmla *(SxName *SXPair)

GRPSXOPER = SXOPER

SRCSXOPER = SXOPER

SXOPER = SxNil / SXNum / SxBool / SxErr / SXString / SXDtr

SXRANGE = SXRng (3SXNum / (2SXDtr SXInt))

Show: