# GrapeCity.Documents.Excel.IgnoredErrorType

## Content

<div class="doc-site-dotnet-api-container">




  <h1 id="GrapeCity_Documents_Excel_IgnoredErrorType" data-uid="GrapeCity.Documents.Excel.IgnoredErrorType" class="text-break">IgnoredErrorType Enum
</h1>
  <div class="markdown level0 summary"><p>The types of errors that can occur in cell.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.Documents.Excel.html">GrapeCity.Documents.Excel</a></h6>
  <h6><strong>Assembly</strong>: DS.Documents.Excel.dll</h6>
  <h5 id="GrapeCity_Documents_Excel_IgnoredErrorType_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">[Flags]
public enum IgnoredErrorType</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">&lt;Flags&gt;
Public Enum IgnoredErrorType</code></pre>
  </div>
  <h3 id="fields">Fields
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    <thead>
    </thead></thead><tbody>
      <tr>
        <td id="GrapeCity_Documents_Excel_IgnoredErrorType_All">All</td>
        <td><p>Ignore all types of errors.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IgnoredErrorType_EmptyCellReferences">EmptyCellReferences</td>
        <td><p>Ignore the error when formula contains a reference to an empty cell.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IgnoredErrorType_EvaluateToError">EvaluateToError</td>
        <td><p>Ignore the error of the formula result error. <br>
Formula result error types include <a class="xref" href="GrapeCity.Documents.Excel.CalcError.html#GrapeCity_Documents_Excel_CalcError_Div0">#DIV/0!</a>, <a class="xref" href="GrapeCity.Documents.Excel.CalcError.html#GrapeCity_Documents_Excel_CalcError_NA">#N/A</a>, <a class="xref" href="GrapeCity.Documents.Excel.CalcError.html#GrapeCity_Documents_Excel_CalcError_Name">#NAME?</a>, <a class="xref" href="GrapeCity.Documents.Excel.CalcError.html#GrapeCity_Documents_Excel_CalcError_Null">#NULL!</a>, <a class="xref" href="GrapeCity.Documents.Excel.CalcError.html#GrapeCity_Documents_Excel_CalcError_Num">#NUM!</a>, <a class="xref" href="GrapeCity.Documents.Excel.CalcError.html#GrapeCity_Documents_Excel_CalcError_Ref">#REF!</a>, and <a class="xref" href="GrapeCity.Documents.Excel.CalcError.html#GrapeCity_Documents_Excel_CalcError_Value">#VALUE!</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IgnoredErrorType_InconsistentFormula">InconsistentFormula</td>
        <td><p>Ignore the error of discrepancies in formulas within a range.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IgnoredErrorType_InconsistentListFormula">InconsistentListFormula</td>
        <td><p>Ignore the error of discrepancies in formulas within a calculated column.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IgnoredErrorType_ListDataValidation">ListDataValidation</td>
        <td><p>Ignore the error of cell value that does not comply with the Data Validation rule that restricts data to predefined items in a list.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IgnoredErrorType_None">None</td>
        <td><p>No errors are ignored.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IgnoredErrorType_NumberAsText">NumberAsText</td>
        <td><p>Ignore the error in cells containing numbers stored as text or preceded by an apostrophe.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IgnoredErrorType_OmittedCells">OmittedCells</td>
        <td><p>Ignore the error in cells containing formulas referring to a range that omits adjacent cells that could be included.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IgnoredErrorType_TextDate">TextDate</td>
        <td><p>Ignore the error when formulas contain text formatted cells with years misinterpreted as the wrong century.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IgnoredErrorType_UnlockedFormulaCells">UnlockedFormulaCells</td>
        <td><p>Ignore the error in unlocked cells containing formulas.</p>
</td>
      </tr>
    </tbody>
  </table>
</div>
