IgnoredErrors class

Office 2013 and later

Defines the IgnoredErrors Class.This class is available in Office2010 or above. When the object is serialized out as xml, its qualified name is x14:ignoredErrors.

Namespace:  DocumentFormat.OpenXml.Office2010.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

2.4.11 ignoredErrors

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

An ignoredErrors element is a CT_IgnoredErrors type element, as specified in section 2.6.53, 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. See section 2.2.4.11 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC-29500-1].

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

<xsd:element name="ignoredErrors" type="CT_IgnoredErrors"/>

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

2.6.53 CT_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/IEC-29500-4] 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.

<xsd:complexType name="CT_IgnoredErrors">

<xsd:sequence>

<xsd:element name="ignoredError" type="CT_IgnoredError" minOccurs="0" maxOccurs="unbounded"/>

<xsd:element name="extLst" type="x:CT_ExtensionList" minOccurs="0" maxOccurs="1"/>

</xsd:sequence>

</xsd:complexType>

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

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show: