<ignoredError> (Ignored Error)
A single ignored error type for a range of cells.
A cell is considered to have an error condition when it meets one of the conditions specified in the attribute descriptions below. For example, if a cell is formatted as text but contains a numeric value, this is considered to be a potential error because the number won't be treated as a number, for example, in calculations.
Note that this simply a guess by the implementing application, and a recommendation to the user. Cells with the errors specified below may have perfectly valid reasons for being in such a state, for example a cell formatted as text which contains numeric Postal Codes or Order numbers. It is useful to format these cells as text so that leading zeros remain as part of the value instead of being removed.
An <ignoreError> element is not written in the file unless the user has specifically reviewed the error and decided to keep the cell state as it is, and no longer wishes to be alerted about it for this cell. This can be helpful for the application to decide which errors should be surfaced to the user vs kept quiet because the user doesn't want these to be surfaced (e.g., because they are legitimate cell states).
<ignoredErrors> <ignoredError sqref="A1 B2" numberStoredAsText="1"/> </ignoredErrors>
Note: more than one kind of error can exist on a cell. These flags are not mutually exclusive.
Parent Elements |
|---|
|
Attributes |
Description |
|---|---|
|
Ignore errors when cells contain a value different from a calculated column formula. In other words, for a calculated column, a cell in that column is considered to have an error if its formula is different from the calculated column formula, or doesn't contain a formula at all. The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
Ignore errors when formulas refer to empty cells. The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
Ignore errors when cells contain formulas that result in an error. The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
Ignore errors when a formula in a region of your worksheet differs from other formulas in the same region. The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
Ignore errors when formulas omit certain cells in a region. The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
Ignore errors when a cell's value in a Table does not comply with the Data Validation rules specified. The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
Ignore errors when numbers are formatted as text or are preceded by an apostrophe. The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
Reference to a range of cells that have this ignored error. The possible values for this attribute are defined by the ST_Sqref simple type (§3.18.78). |
|
Ignore errors when formulas contain text formatted cells with years represented as 2 digits. The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
Ignore errors when unlocked cells contain formulas. The possible values for this attribute are defined by the XML Schema boolean datatype. |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_IgnoredError">
<attribute name="sqref" type="ST_Sqref" use="required"/>
<attribute name="evalError" type="xsd:boolean" use="optional" default="false"/>
<attribute name="twoDigitTextYear" type="xsd:boolean" use="optional" default="false"/>
<attribute name="numberStoredAsText" type="xsd:boolean" use="optional" default="false"/>
<attribute name="formula" type="xsd:boolean" use="optional" default="false"/>
<attribute name="formulaRange" type="xsd:boolean" use="optional" default="false"/>
<attribute name="unlockedFormula" type="xsd:boolean" use="optional" default="false"/>
<attribute name="emptyCellReference" type="xsd:boolean" use="optional" default="false"/>
<attribute name="listDataValidation" type="xsd:boolean" use="optional" default="false"/>
<attribute name="calculatedColumn" type="xsd:boolean" use="optional" default="false"/>
</complexType>