2.4.785 BrtShrFmla
The BrtShrFmla record specifies a shared formula (section 2.2.2) as specified in Worksheet part ABNF (section 2.1.7.62) and Macro Sheet (section 2.1.7.32) part ABNF. A shared formula specifies a formula that is shared across multiple cells. Cells that share this formula each have a formula record that contains a PtgExp (section 2.5.98.40) that specifies the row of this cell and a corresponding PtgExtraCol (section 2.5.98.42) with a col field equal to the column (1) of this cell. It is preceded by a single BrtFmlaString (section 2.4.680), BrtFmlaNum (section 2.4.679), BrtFmlaBool (section 2.4.677), or BrtFmlaError (section 2.4.678) record that specifies the first cell in the range that uses this shared formula. This record is used with the preceding BrtFmlaString, BrtFmlaNum, BrtFmlaBool, or BrtFmlaError record to optimize storage and memory required for the shared formula.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
rfx (16 bytes) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
formula (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
rfx (16 bytes): An UncheckedRfX (section 2.5.154) that specifies the row and column (1) bounds for this shared formula.
formula (variable): A SharedParsedFormula (section 2.5.98.98) that contains this shared formula.