Share via

2.4.319 BrtCellIgnoreEC

  • Article

The BrtCellIgnoreEC record specifies the types of error conditions that are ignored in a formula evaluation for a specified range or ranges.


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

A

B

C

D

E

F

G

H

I

reserved

sqrfxu (variable)

...

A - ffecCalcError (1 bit):  A bit that specifies whether to ignore calculation errors.

B - ffecEmptyCellRef (1 bit):  A bit that specifies whether to ignore errors arising from references to empty cells.

C - ffecNumStoredAsText (1 bit):  A bit that specifies whether to ignore errors arising from formatting of numeric values.

D - ffecInconsistRange (1 bit):  A bit that specifies whether to ignore errors arising from formulas that contain references to less than the entirety of a range containing continuous data.

E - ffecInconsistFmla (1 bit):  A bit that specifies whether to ignore errors arising from formulas that are inconsistent with formulas in neighboring cells.

F - ffecTextDateInsuff (1 bit):  A bit that specifies whether to ignore errors arising from formatting of date/time values.

G - ffecUnprotFmla (1 bit):  A bit that specifies whether to ignore errors arising from unprotected formulas.

H - ffecDataValidation (1 bit):  A bit that specifies whether to ignore errors arising from data validation.

I - ffecCalcCol (1 bit):  A bit that specifies whether to ignore errors arising from calculated column formulas (section 2.2.2).

reserved (23 bits): This value MUST be 0, and MUST be ignored.

sqrfxu (variable):  An UncheckedSqRfX (section 2.5.156) that specifies the range or ranges where cell errors have been ignored. The sqrfxu.crfx MUST be less than 8,192.