2.4.127 Formula

Office

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)

...

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.

Show: