2.4.320 BrtCellIgnoreEC14
The BrtCellIgnoreEC14 record specifies the types of error conditions that are ignored in a formula evaluation for a specified range or ranges. This record is equivalent to BrtCellIgnoreEC (section 2.4.319) but allows for more than 8,192 ranges where cell errors have been ignored.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
FRTHeader (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
reserved |
||||||||||||||||||||||
FRTHeader (variable): An FRTHeader (section 2.5.61) that specifies the future record (section 2.1.6) information for this record.
-
Field
Value
FRTHeader.fRef
0
FRTHeader.fSqref
1
FRTHeader.fFormulas
0
FRTHeader.fRelID
0
-
The sqrfx of the single FRTSqref (section 2.5.66) comprising the array of the FRTHeader.rgSqrefs is an UncheckedSqRfX (section 2.5.156) that specifies the range or ranges where cell errors have been ignored.
-
The FRTHeader.rgSqrefs.csqref MUST be 1.
-
The sqrfx.crfx of the single FRTSqref comprising the array of the FRTHeader.rgSqrefs MUST be equal to or greater than 8,192.
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 (section 2.2.2) 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.
reserved (23 bits): This value MUST be 0, and MUST be ignored.