# C1.C1Excel.XLValidationType

## Content

<div class="doc-site-dotnet-api-container">




  <h1 id="C1_C1Excel_XLValidationType" data-uid="C1.C1Excel.XLValidationType" class="text-break">XLValidationType Enum
</h1>
  <div class="markdown level0 summary"><p>Specifies the type of validation test to be performed in conjunction with values.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="C1.C1Excel.html">C1.C1Excel</a></h6>
  <h6><strong>Assembly</strong>: C1.C1Excel.4.8.dll</h6>
  <h5 id="C1_C1Excel_XLValidationType_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public enum XLValidationType : byte</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Enum XLValidationType As Byte</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="C1_C1Excel_XLValidationType_Custom">Custom</td>
        <td><p>Specifies that the data validation uses a custom formula to check the cell value.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLValidationType_Date">Date</td>
        <td><p>Specifies that the data validation checks for and allows date values that meet the given condition.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLValidationType_Decimal">Decimal</td>
        <td><p>Specifies that the data validation checks for and allows decimal values that meet the given condition.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLValidationType_List">List</td>
        <td><p>Specifies that the data validation checks for and allows a value that matches one in a list of values.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLValidationType_None">None</td>
        <td><p>Specifies that the data validation allows any type of value and does not check for a type or range of values.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLValidationType_TextLength">TextLength</td>
        <td><p>Specifies that the data validation checks for and allows text values whose length meet the given condition.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLValidationType_Time">Time</td>
        <td><p>Specifies that the data validation checks for and allows time values that meet the given condition.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLValidationType_Whole">Whole</td>
        <td><p>Specifies that the data validation checks for and allows whole number values that meet the given condition.</p>
</td>
      </tr>
    </tbody>
  </table>
</div>