次の方法で共有


IgnoredError Class

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

Inheritance Hierarchy

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

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

Syntax

'宣言
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(ReferenceSequence))> _
Public Class IgnoredError _
    Inherits OpenXmlCompositeElement
'使用
Dim instance As IgnoredError
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(ReferenceSequence))]
public class IgnoredError : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

  • DocumentFormat.OpenXml.Office.Excel.ReferenceSequence <xne:sqref>

2.6.54 CT_IgnoredError

Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/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/IEC-29500-1] section 18.3.1.50) but allows the sqref child element to have greater than or equal to 8192 ref children.

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 8192 ref children.

Attributes:

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

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

numberStoredAsText : A boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to ignore errors arising from 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/IEC-29500-1] 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/IEC-29500-1] 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/IEC-29500-1] section 18.17).

emptyCellReference : A boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to 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.

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

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

<xsd:complexType name="CT_IgnoredError">

<xsd:sequence>

<xsd:element ref="xm:sqref" minOccurs="1" maxOccurs="1"/>

</xsd:sequence>

<xsd:attribute name="evalError" type="xsd:boolean" use="optional" default="false"/>

<xsd:attribute name="twoDigitTextYear" type="xsd:boolean" use="optional" default="false"/>

<xsd:attribute name="numberStoredAsText" type="xsd:boolean" use="optional" default="false"/>

<xsd:attribute name="formula" type="xsd:boolean" use="optional" default="false"/>

<xsd:attribute name="formulaRange" type="xsd:boolean" use="optional" default="false"/>

<xsd:attribute name="unlockedFormula" type="xsd:boolean" use="optional" default="false"/>

<xsd:attribute name="emptyCellReference" type="xsd:boolean" use="optional" default="false"/>

<xsd:attribute name="listDataValidation" type="xsd:boolean" use="optional" default="false"/>

<xsd:attribute name="calculatedColumn" type="xsd:boolean" use="optional" default="false"/>

</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

IgnoredError Members

DocumentFormat.OpenXml.Office2010.Excel Namespace