2.4.127 Formula
The Formula record specifies a formula (section 2.2.2) for a cell.
0 
1 
2 
3 
4 
5 
6 
7 
8 
9  1 0 
1 
2 
3 
4 
5 
6 
7 
8 
9  2 0 
1 
2 
3 
4 
5 
6 
7 
8 
9  3 0 
1 

cell  
... 
val  
...  
... 
A 
B 
C 
D 
E 
F 
reserved3  
chn  
formula (variable)  
... 

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 centeracrossselection alignment.
Value
Meaning
0
Cell does not have a fill alignment or a centeracrossselection alignment.
1
Cell has either a fill alignment or a centeracrossselection 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 applicationspecific 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.