2.4.6 BrtArrFmla
The BrtArrFmla record type specifies an array formula (section 2.2.2) for a range of cells, as specified in Worksheet (section 2.1.7.62) part ABNF and Macro Sheet (section 2.1.7.32) part ABNF, that performs calculations on one or more sets of values, and then returns either a single result or multiple results across a continuous range of cells. This record 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 represents the logical top-left cell in the range that uses this array formula. Other BrtFmlaString, BrtFmlaNum, BrtFmlaBool, or BrtFmlaError records that use this array formula follow after the BrtArrFmla record in the file, and are not necessarily in a contiguous sequence. The BrtFmlaString, BrtFmlaNum, BrtFmlaBool, or BrtFmlaError records that use this array formula MUST have a cell field that is within the range specified in the ref field of this record and MUST have their formula begin with PtgExp (section 2.5.98.40).
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
rfx (16 bytes) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
A |
unused |
formula (variable) |
|||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
rfx (16 bytes): An RfX (section 2.5.118) that specifies the row and column (1) bounds of the array formula (section 2.2.2). Every cell specified by rfx MUST use the array formula.
A - fAlwaysCalc (1 bit): A bit that specifies if the array formula (section 2.2.2) needs to be calculated as part of the next recalculation.
-
Value
Meaning
0
Formula does not need to be calculated as part of the next recalculation.
1
Formula needs to be calculated as part of the next recalculation.
unused (7 bits): Undefined and MUST be ignored.
formula (variable): An ArrayParsedFormula (section 2.5.98.1) that contains this formula (section 2.2.2).