2.4.260 ShrFmla
The ShrFmla record specifies a formula (section 2.2.2) that is shared across multiple cells. This record specifies a file size optimization. It is used with the Formula record to compress the amount of storage required for the formula. This record is preceded by a single Formula record that specifies the first cell in the range that uses this shared formula. Other Formula records that use this shared formula follow later in the file, not necessarily in a contiguous sequence. Formula records that use this shared formula have the Formula.fShrFmla bit set, and a Formula.cell that is within the range specified in the ref field of this record.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ref |
|||||||||||||||||||||||||||||||
|
... |
reserved |
cUse |
|||||||||||||||||||||||||||||
|
formula (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
ref (6 bytes): A RefU structure that specifies the range of cells that use this shared formula. Cells in this range do not have to use the shared formula.
reserved (8 bits): MUST be zero, and MUST be ignored.
cUse (8 bits): An unsigned integer that specifies the number of cells that use this shared formula.
formula (variable): A SharedParsedFormula structure that specifies the shared formula.