共用方式為


IgnoredErrors Class

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

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Office2010.Excel.IgnoredErrors

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

Syntax

'Declaration
<ChildElementInfoAttribute(GetType(IgnoredError), FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(ExtensionList), FileFormatVersions.Office2010)> _
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class IgnoredErrors _
    Inherits OpenXmlCompositeElement
'Usage
Dim instance As IgnoredErrors
[ChildElementInfoAttribute(typeof(IgnoredError), FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(ExtensionList), FileFormatVersions.Office2010)]
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class IgnoredErrors : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

  • IgnoredError <x14:ignoredError>

  • ExtensionList <x14:extLst>

2.4.9 ignoredErrors

Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main

A CT_IgnoredErrors element 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 Worksheet under Extensions by Part for how this element integrates with [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.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.6.53 CT_IgnoredErrors

Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/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.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

Thread Safety

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

See Also

Reference

IgnoredErrors Members

DocumentFormat.OpenXml.Office2010.Excel Namespace