# GrapeCity.Spreadsheet.IFilter

## Content

<div class="doc-site-dotnet-api-container">



  <h1 id="GrapeCity_Spreadsheet_IFilter" data-uid="GrapeCity.Spreadsheet.IFilter" class="text-break">IFilter Interface
</h1>
  <div class="markdown level0 summary"><p>Represents a filter for a single column.</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_IFilter_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public interface IFilter</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Interface IFilter</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_IFilter_Criteria1" data-uid="GrapeCity.Spreadsheet.IFilter.Criteria1">
          <a class="xref" href="GrapeCity.Spreadsheet.IFilter.Criteria1.html#GrapeCity_Spreadsheet_IFilter_Criteria1">Criteria1</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the first filtered value for the specified column in a filtered range.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IFilter_Criteria2" data-uid="GrapeCity.Spreadsheet.IFilter.Criteria2">
          <a class="xref" href="GrapeCity.Spreadsheet.IFilter.Criteria2.html#GrapeCity_Spreadsheet_IFilter_Criteria2">Criteria2</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the second filtered value for the specified column in a filtered range.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IFilter_On" data-uid="GrapeCity.Spreadsheet.IFilter.On">
          <a class="xref" href="GrapeCity.Spreadsheet.IFilter.On.html#GrapeCity_Spreadsheet_IFilter_On">On</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a value indicating whether this <a class="xref" href="GrapeCity.Spreadsheet.IFilter.html">IFilter</a> is on.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IFilter_Operator" data-uid="GrapeCity.Spreadsheet.IFilter.Operator">
          <a class="xref" href="GrapeCity.Spreadsheet.IFilter.Operator.html#GrapeCity_Spreadsheet_IFilter_Operator">Operator</a>
        </td>
        <td class="markdown level1 summary"><p>Gets an <a class="xref" href="GrapeCity.Spreadsheet.AutoFilterOperator.html">AutoFilterOperator</a> value that represents the operator that associates the two criteria applied by the specified filter.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>
