# GrapeCity.Spreadsheet.AutoFilterOperator

## Content

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




  <h1 id="GrapeCity_Spreadsheet_AutoFilterOperator" data-uid="GrapeCity.Spreadsheet.AutoFilterOperator" class="text-break">AutoFilterOperator Enum
</h1>
  <div class="markdown level0 summary"><p>Specifies the operator to use to associate two criteria applied by a filter.</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_AutoFilterOperator_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public enum AutoFilterOperator</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Enum AutoFilterOperator</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_Spreadsheet_AutoFilterOperator_And">And</td>
        <td><p>Logical AND of Criteria1 and Criteria2.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_AutoFilterOperator_Bottom10Items">Bottom10Items</td>
        <td><p>Lowest-valued items displayed (number of items specified in Criteria1).</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_AutoFilterOperator_Bottom10Percent">Bottom10Percent</td>
        <td><p>Lowest-valued items displayed (percentage specified in Criteria1).</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_AutoFilterOperator_FilterCellColor">FilterCellColor</td>
        <td><p>Color of the cell</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_AutoFilterOperator_FilterDynamic">FilterDynamic</td>
        <td><p>Dynamic filter</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_AutoFilterOperator_FilterFontColor">FilterFontColor</td>
        <td><p>Color of the font</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_AutoFilterOperator_FilterIcon">FilterIcon</td>
        <td><p>Filter icon</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_AutoFilterOperator_FilterValues">FilterValues</td>
        <td><p>Filter values</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_AutoFilterOperator_Or">Or</td>
        <td><p>Logical OR of Criteria1 or Criteria2.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_AutoFilterOperator_Top10Items">Top10Items</td>
        <td><p>Highest-valued items displayed (number of items specified in Criteria1).</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_AutoFilterOperator_Top10Percent">Top10Percent</td>
        <td><p>Highest-valued items displayed (percentage specified in Criteria1).</p>
</td>
      </tr>
    </tbody>
  </table>
</div>