# GrapeCity.Spreadsheet.IValidation

## Content

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



  <h1 id="GrapeCity_Spreadsheet_IValidation" data-uid="GrapeCity.Spreadsheet.IValidation" class="text-break">IValidation Interface
</h1>
  <div class="markdown level0 summary"><p>Represents data validation for a worksheet range.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.Spreadsheet.html">GrapeCity.Spreadsheet</a></h6>
  <h6><strong>Assembly</strong>: GrapeCity.Spreadsheet.dll</h6>
  <h5 id="GrapeCity_Spreadsheet_IValidation_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public interface IValidation</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Interface IValidation</code></pre>
  </div>
  <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="GrapeCity_Spreadsheet_IValidation_AlertStyle" data-uid="GrapeCity.Spreadsheet.IValidation.AlertStyle">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.AlertStyle.html#GrapeCity_Spreadsheet_IValidation_AlertStyle">AlertStyle</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the validation alert style.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IValidation_ErrorMessage" data-uid="GrapeCity.Spreadsheet.IValidation.ErrorMessage">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.ErrorMessage.html#GrapeCity_Spreadsheet_IValidation_ErrorMessage">ErrorMessage</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the data validation error message.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IValidation_ErrorTitle" data-uid="GrapeCity.Spreadsheet.IValidation.ErrorTitle">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.ErrorTitle.html#GrapeCity_Spreadsheet_IValidation_ErrorTitle">ErrorTitle</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the title of the data validation error dialog box.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IValidation_Formula1" data-uid="GrapeCity.Spreadsheet.IValidation.Formula1">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.Formula1.html#GrapeCity_Spreadsheet_IValidation_Formula1">Formula1</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the value or expression associated with the conditional format or data validation.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IValidation_Formula2" data-uid="GrapeCity.Spreadsheet.IValidation.Formula2">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.Formula2.html#GrapeCity_Spreadsheet_IValidation_Formula2">Formula2</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the value or expression associated with the second part of a conditional format or data validation.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IValidation_IgnoreBlank" data-uid="GrapeCity.Spreadsheet.IValidation.IgnoreBlank">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.IgnoreBlank.html#GrapeCity_Spreadsheet_IValidation_IgnoreBlank">IgnoreBlank</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a value indicating whether blank values are permitted by the range data validation.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IValidation_ImeMode" data-uid="GrapeCity.Spreadsheet.IValidation.ImeMode">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.ImeMode.html#GrapeCity_Spreadsheet_IValidation_ImeMode">ImeMode</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the description of the Japanese input rules.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IValidation_InCellDropdown" data-uid="GrapeCity.Spreadsheet.IValidation.InCellDropdown">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.InCellDropdown.html#GrapeCity_Spreadsheet_IValidation_InCellDropdown">InCellDropdown</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets data validation displays a drop-down list that contains acceptable values.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IValidation_InputMessage" data-uid="GrapeCity.Spreadsheet.IValidation.InputMessage">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.InputMessage.html#GrapeCity_Spreadsheet_IValidation_InputMessage">InputMessage</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the data validation input message.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IValidation_InputTitle" data-uid="GrapeCity.Spreadsheet.IValidation.InputTitle">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.InputTitle.html#GrapeCity_Spreadsheet_IValidation_InputTitle">InputTitle</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the title of the data validation input dialog box.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IValidation_Operator" data-uid="GrapeCity.Spreadsheet.IValidation.Operator">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.Operator.html#GrapeCity_Spreadsheet_IValidation_Operator">Operator</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a value indicating the operator for the data validation.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IValidation_ShowError" data-uid="GrapeCity.Spreadsheet.IValidation.ShowError">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.ShowError.html#GrapeCity_Spreadsheet_IValidation_ShowError">ShowError</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the data validation error message will be displayed whenever the user enters invalid data.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IValidation_ShowInput" data-uid="GrapeCity.Spreadsheet.IValidation.ShowInput">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.ShowInput.html#GrapeCity_Spreadsheet_IValidation_ShowInput">ShowInput</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the data validation input message will be displayed whenever the user selects a cell in the data validation range.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IValidation_Type" data-uid="GrapeCity.Spreadsheet.IValidation.Type">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.Type.html#GrapeCity_Spreadsheet_IValidation_Type">Type</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a value indicating the data type validation for a range.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IValidation_Value" data-uid="GrapeCity.Spreadsheet.IValidation.Value">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.Value.html#GrapeCity_Spreadsheet_IValidation_Value">Value</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a> value indicating whether all the validation criteria are met (that is, if the range contains valid data).</p>
</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="GrapeCity_Spreadsheet_IValidation_Add_GrapeCity_Spreadsheet_DataValidationType_GrapeCity_Spreadsheet_DataValidationErrorStyle_GrapeCity_Spreadsheet_DataValidationOperator_System_String_System_String_" data-uid="GrapeCity.Spreadsheet.IValidation.Add(GrapeCity.Spreadsheet.DataValidationType,GrapeCity.Spreadsheet.DataValidationErrorStyle,GrapeCity.Spreadsheet.DataValidationOperator,System.String,System.String)">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.Add.html#GrapeCity_Spreadsheet_IValidation_Add_GrapeCity_Spreadsheet_DataValidationType_GrapeCity_Spreadsheet_DataValidationErrorStyle_GrapeCity_Spreadsheet_DataValidationOperator_System_String_System_String_">Add(DataValidationType, DataValidationErrorStyle, DataValidationOperator, string, string)</a>
        </td>
        <td class="markdown level1 summary"><p>Adds data validation to a range of cells using the specified options.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IValidation_Delete" data-uid="GrapeCity.Spreadsheet.IValidation.Delete">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.Delete.html#GrapeCity_Spreadsheet_IValidation_Delete">Delete()</a>
        </td>
        <td class="markdown level1 summary"><p>Deletes data validation.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IValidation_Modify_GrapeCity_Spreadsheet_DataValidationType_GrapeCity_Spreadsheet_DataValidationErrorStyle_GrapeCity_Spreadsheet_DataValidationOperator_System_String_System_String_" data-uid="GrapeCity.Spreadsheet.IValidation.Modify(GrapeCity.Spreadsheet.DataValidationType,GrapeCity.Spreadsheet.DataValidationErrorStyle,GrapeCity.Spreadsheet.DataValidationOperator,System.String,System.String)">
          <a class="xref" href="GrapeCity.Spreadsheet.IValidation.Modify.html#GrapeCity_Spreadsheet_IValidation_Modify_GrapeCity_Spreadsheet_DataValidationType_GrapeCity_Spreadsheet_DataValidationErrorStyle_GrapeCity_Spreadsheet_DataValidationOperator_System_String_System_String_">Modify(DataValidationType, DataValidationErrorStyle, DataValidationOperator, string, string)</a>
        </td>
        <td class="markdown level1 summary"><p>Modifies existing data validation for a range of cells using the specified options.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>