# C1.C1Excel.XLDataValidation

## Content

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



  <h1 id="C1_C1Excel_XLDataValidation" data-uid="C1.C1Excel.XLDataValidation" class="text-break">XLDataValidation Class
</h1>
  <div class="markdown level0 summary"><p>Data validation.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <div class="inheritance">
    <h5>Inheritance</h5>
    <div class="level0"><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a></div>
    <div class="level1"><span class="xref">XLDataValidation</span></div>
  </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_XLDataValidation_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public class XLDataValidation</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Class XLDataValidation</code></pre>
  </div>
  <h3 id="constructors">Constructors
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_C1Excel_XLDataValidation__ctor_C1_C1Excel_C1XLBook_" data-uid="C1.C1Excel.XLDataValidation.#ctor(C1.C1Excel.C1XLBook)">
          <a class="xref" href="C1.C1Excel.XLDataValidation.-ctor.html#C1_C1Excel_XLDataValidation__ctor_C1_C1Excel_C1XLBook_">XLDataValidation(C1XLBook)</a>
        </td>
        <td class="markdown level1 summary"><p>Initialization data validation object.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="properties">Properties
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_AllowBlank" data-uid="C1.C1Excel.XLDataValidation.AllowBlank">
          <a class="xref" href="C1.C1Excel.XLDataValidation.AllowBlank.html#C1_C1Excel_XLDataValidation_AllowBlank">AllowBlank</a>
        </td>
        <td class="markdown level1 summary"></td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_Book" data-uid="C1.C1Excel.XLDataValidation.Book">
          <a class="xref" href="C1.C1Excel.XLDataValidation.Book.html#C1_C1Excel_XLDataValidation_Book">Book</a>
        </td>
        <td class="markdown level1 summary"><p>Gets parent workbook.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_Error" data-uid="C1.C1Excel.XLDataValidation.Error">
          <a class="xref" href="C1.C1Excel.XLDataValidation.Error.html#C1_C1Excel_XLDataValidation_Error">Error</a>
        </td>
        <td class="markdown level1 summary"></td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_ErrorStyle" data-uid="C1.C1Excel.XLDataValidation.ErrorStyle">
          <a class="xref" href="C1.C1Excel.XLDataValidation.ErrorStyle.html#C1_C1Excel_XLDataValidation_ErrorStyle">ErrorStyle</a>
        </td>
        <td class="markdown level1 summary"></td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_ErrorTitle" data-uid="C1.C1Excel.XLDataValidation.ErrorTitle">
          <a class="xref" href="C1.C1Excel.XLDataValidation.ErrorTitle.html#C1_C1Excel_XLDataValidation_ErrorTitle">ErrorTitle</a>
        </td>
        <td class="markdown level1 summary"></td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_FirstFormula" data-uid="C1.C1Excel.XLDataValidation.FirstFormula">
          <a class="xref" href="C1.C1Excel.XLDataValidation.FirstFormula.html#C1_C1Excel_XLDataValidation_FirstFormula">FirstFormula</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or set first formula for this data validation.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_HideDropDown" data-uid="C1.C1Excel.XLDataValidation.HideDropDown">
          <a class="xref" href="C1.C1Excel.XLDataValidation.HideDropDown.html#C1_C1Excel_XLDataValidation_HideDropDown">HideDropDown</a>
        </td>
        <td class="markdown level1 summary"></td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_IMEMode" data-uid="C1.C1Excel.XLDataValidation.IMEMode">
          <a class="xref" href="C1.C1Excel.XLDataValidation.IMEMode.html#C1_C1Excel_XLDataValidation_IMEMode">IMEMode</a>
        </td>
        <td class="markdown level1 summary"></td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_Operator" data-uid="C1.C1Excel.XLDataValidation.Operator">
          <a class="xref" href="C1.C1Excel.XLDataValidation.Operator.html#C1_C1Excel_XLDataValidation_Operator">Operator</a>
        </td>
        <td class="markdown level1 summary"></td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_Prompt" data-uid="C1.C1Excel.XLDataValidation.Prompt">
          <a class="xref" href="C1.C1Excel.XLDataValidation.Prompt.html#C1_C1Excel_XLDataValidation_Prompt">Prompt</a>
        </td>
        <td class="markdown level1 summary"></td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_PromptTitle" data-uid="C1.C1Excel.XLDataValidation.PromptTitle">
          <a class="xref" href="C1.C1Excel.XLDataValidation.PromptTitle.html#C1_C1Excel_XLDataValidation_PromptTitle">PromptTitle</a>
        </td>
        <td class="markdown level1 summary"></td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_Ranges" data-uid="C1.C1Excel.XLDataValidation.Ranges">
          <a class="xref" href="C1.C1Excel.XLDataValidation.Ranges.html#C1_C1Excel_XLDataValidation_Ranges">Ranges</a>
        </td>
        <td class="markdown level1 summary"><p>The collection of data validation ranges.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_SecondFormula" data-uid="C1.C1Excel.XLDataValidation.SecondFormula">
          <a class="xref" href="C1.C1Excel.XLDataValidation.SecondFormula.html#C1_C1Excel_XLDataValidation_SecondFormula">SecondFormula</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or set second formula for this data validation.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_ShowErrorMessage" data-uid="C1.C1Excel.XLDataValidation.ShowErrorMessage">
          <a class="xref" href="C1.C1Excel.XLDataValidation.ShowErrorMessage.html#C1_C1Excel_XLDataValidation_ShowErrorMessage">ShowErrorMessage</a>
        </td>
        <td class="markdown level1 summary"></td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_ShowInputMessage" data-uid="C1.C1Excel.XLDataValidation.ShowInputMessage">
          <a class="xref" href="C1.C1Excel.XLDataValidation.ShowInputMessage.html#C1_C1Excel_XLDataValidation_ShowInputMessage">ShowInputMessage</a>
        </td>
        <td class="markdown level1 summary"></td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_TextLookup" data-uid="C1.C1Excel.XLDataValidation.TextLookup">
          <a class="xref" href="C1.C1Excel.XLDataValidation.TextLookup.html#C1_C1Excel_XLDataValidation_TextLookup">TextLookup</a>
        </td>
        <td class="markdown level1 summary"></td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_ValidationType" data-uid="C1.C1Excel.XLDataValidation.ValidationType">
          <a class="xref" href="C1.C1Excel.XLDataValidation.ValidationType.html#C1_C1Excel_XLDataValidation_ValidationType">ValidationType</a>
        </td>
        <td class="markdown level1 summary"></td>
      </tr>
    </tbody>
  </table>
  <h3 id="methods">Methods
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_C1Excel_XLDataValidation_Clone" data-uid="C1.C1Excel.XLDataValidation.Clone">
          <a class="xref" href="C1.C1Excel.XLDataValidation.Clone.html#C1_C1Excel_XLDataValidation_Clone">Clone()</a>
        </td>
        <td class="markdown level1 summary"><p>Creates a new <a class="xref" href="C1.C1Excel.XLDataValidation.html">XLDataValidation</a> object that is a copy of the current instance.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>