[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format Intellectual Property Rights Notice for Open Specifications Documentation

1632.1.1CT_IgnoredErrors

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: ignoredErrors

A complex type that specifies a list of cell ranges and the types of cell errors that are to be ignored for each of those specific cell ranges.

Child Elements:

ignoredError: A CT_IgnoredError element that specifies the types of cell errors that are to be ignored for a specific cell range.

extLst: A CT_ExtensionList ([ISO/IEC29500-4:2012] section A.2) element that specifies future extensibility for this element.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

1633

1634

1635

1636

1637

1638

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

1638.1.1CT_IgnoredError

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_IgnoredErrors

A complex type that specifies the types of cell errors that are to be ignored for a specific cell range. This complex type is equivalent to CT_IgnoredError ([ISO/IEC29500-1:2012] section 18.3.1.50), but allows the sqref child element to have greater than or equal to 8,192 ref child elements.

Child Elements:

xm:sqref: A sqref element that specifies the range where cell errors have been ignored. This sqref MUST have greater than or equal to 8,192 ref child elements.

Attributes:

evalError: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to ignore calculation errors.

Value	Meaning
"true"	Ignore calculation errors.
"false"	Do not ignore calculation errors.

twoDigitTextYear: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to ignore errors arising from the formatting of date/time values.

Value	Meaning
"true"	Ignore errors arising from the formatting of data/time values.
"false"	Do not ignore errors arising from the formatting of date/time values.

numberStoredAsText: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to ignore errors arising from the formatting of numeric values.

Value	Meaning
"true"	Ignore errors arising from the formatting of numeric values.
"false"	Do not ignore errors arising from the formatting of numeric values.

formula: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to ignore errors arising from formulas that are inconsistent with formulas ([ISO/IEC29500-1:2012] section 18.17) in neighboring cells.

Value	Meaning
"true"	Ignore errors arising from formulas that are inconsistent with formulas ([ISO/IEC29500-1:2012] section 18.17) in neighboring cells.
"false"	Do not ignore errors arising from formulas that are inconsistent with formulas ([ISO/IEC29500-1:2012] section 18.17) in neighboring cells.

formulaRange: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to ignore errors arising from formulas ([ISO/IEC29500-1:2012] section 18.17) that contain references to less than the entirety of a range containing contiguous data.

Value	Meaning
"true"	Ignore errors arising from formulas ([ISO/IEC29500-1:2012] section 18.17) that contain references to less than the entirety of a range containing contiguous data.
"false"	Do not ignore errors arising from formulas ([ISO/IEC29500-1:2012] section 18.17) that contain references to less than the entirety of a range containing contiguous data.

unlockedFormula: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to ignore errors arising from unprotected formulas ([ISO/IEC29500-1:2012] section 18.17).

Value	Meaning
"true"	Ignore errors arising from unprotected formulas ([ISO/IEC29500-1:2012] section 18.17).
"false"	Do not ignore errors arising from unprotected formulas ([ISO/IEC29500-1:2012] section 18.17).

emptyCellReference: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to ignore errors arising from references to empty cells.

Value	Meaning
"true"	Ignore errors arising from references to empty cells.
"false"	Do not ignore errors arising from references to empty cells.

listDataValidation: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to ignore errors arising from data validation.

Value	Meaning
"true"	Ignore errors arising from data validation.
"false"	Do not ignore errors arising from data validation.

calculatedColumn: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to ignore errors arising from calculated column formulas ([ISO/IEC29500-1:2012] section 18.17).

Value	Meaning
"true"	Ignore errors arising from calculated column (2) formulas ([ISO/IEC29500-1:2012] section 18.17).
"false"	Do not ignore errors arising from calculated column (2) formulas ([ISO/IEC29500-1:2012] section 18.17).

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

1639

1640

1641

1642

1643

1644

1645

1646

1647

1648

1649

1650

1651

1652

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).