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.