2.4.127 Formula
The Formula record specifies a formula (section 2.2.2) for a cell.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
cell |
|||||||||||||||||||||||||||||||
|
... |
val |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
A |
B |
C |
D |
E |
F |
reserved3 |
||||||||||||||||||||||||
|
chn |
|||||||||||||||||||||||||||||||
|
formula (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
cell (6 bytes): A Cell structure that specifies a cell on the sheet.
val (8 bytes): A FormulaValue structure that specifies the value of the formula.
A - fAlwaysCalc (1 bit): A bit that specifies whether the formula needs to be calculated during the next recalculation.
B - reserved1 (1 bit): MUST be zero, and MUST be ignored.
C - fFill (1 bit): A bit that specifies whether the cell has a fill alignment or a center-across-selection alignment.
-
Value
Meaning
0
Cell does not have a fill alignment or a center-across-selection alignment.
1
Cell has either a fill alignment or a center-across-selection alignment.
D - fShrFmla (1 bit): A bit that specifies whether the formula is part of a shared formula as defined in ShrFmla. If this formula is part of a shared formula, formula.rgce MUST begin with a PtgExp structure.
E - reserved2 (1 bit): MUST be zero, and MUST be ignored.
F - fClearErrors (1 bit): A bit that specifies whether the formula is excluded from formula error checking.
reserved3 (10 bits): MUST be zero, and MUST be ignored.
chn (4 bytes): A field that specifies an application-specific cache of information. This cache exists for performance reasons only, and can be rebuilt based on information stored elsewhere in the file without affecting calculation results.
formula (variable): A CellParsedFormula structure that specifies the formula.