Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

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:
© 2014 Microsoft