# GrapeCity.Spreadsheet.IAutoFilter

## Content

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



  <h1 id="GrapeCity_Spreadsheet_IAutoFilter" data-uid="GrapeCity.Spreadsheet.IAutoFilter" class="text-break">IAutoFilter Interface
</h1>
  <div class="markdown level0 summary"><p>Represents the filter for the specified worksheet.</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_IAutoFilter_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public interface IAutoFilter</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Interface IAutoFilter</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_IAutoFilter_AutoUpdate" data-uid="GrapeCity.Spreadsheet.IAutoFilter.AutoUpdate">
          <a class="xref" href="GrapeCity.Spreadsheet.IAutoFilter.AutoUpdate.html#GrapeCity_Spreadsheet_IAutoFilter_AutoUpdate">AutoUpdate</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a value indicating whether the filter update automatically after user input new value.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IAutoFilter_FilterMode" data-uid="GrapeCity.Spreadsheet.IAutoFilter.FilterMode">
          <a class="xref" href="GrapeCity.Spreadsheet.IAutoFilter.FilterMode.html#GrapeCity_Spreadsheet_IAutoFilter_FilterMode">FilterMode</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a value indicating whether the worksheet is in the AutoFilter filter mode.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IAutoFilter_Filters" data-uid="GrapeCity.Spreadsheet.IAutoFilter.Filters">
          <a class="xref" href="GrapeCity.Spreadsheet.IAutoFilter.Filters.html#GrapeCity_Spreadsheet_IAutoFilter_Filters">Filters</a>
        </td>
        <td class="markdown level1 summary"><p>Gets an <a class="xref" href="GrapeCity.Spreadsheet.IFilters.html">IFilters</a> collection that represents all the filters in an auto filtered range.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IAutoFilter_Range" data-uid="GrapeCity.Spreadsheet.IAutoFilter.Range">
          <a class="xref" href="GrapeCity.Spreadsheet.IAutoFilter.Range.html#GrapeCity_Spreadsheet_IAutoFilter_Range">Range</a>
        </td>
        <td class="markdown level1 summary"><p>Gets an <a class="xref" href="GrapeCity.Spreadsheet.IRange.html">IRange</a> object that represents the range to which the specified AutoFilter applies.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IAutoFilter_Sort" data-uid="GrapeCity.Spreadsheet.IAutoFilter.Sort">
          <a class="xref" href="GrapeCity.Spreadsheet.IAutoFilter.Sort.html#GrapeCity_Spreadsheet_IAutoFilter_Sort">Sort</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the sort column or columns, and sort order for the <a class="xref" href="GrapeCity.Spreadsheet.IAutoFilter.html">IAutoFilter</a> collection.</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_IAutoFilter_ApplyFilter" data-uid="GrapeCity.Spreadsheet.IAutoFilter.ApplyFilter">
          <a class="xref" href="GrapeCity.Spreadsheet.IAutoFilter.ApplyFilter.html#GrapeCity_Spreadsheet_IAutoFilter_ApplyFilter">ApplyFilter()</a>
        </td>
        <td class="markdown level1 summary"><p>Applies the specified <a class="xref" href="GrapeCity.Spreadsheet.IAutoFilter.html">IAutoFilter</a> object.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IAutoFilter_GetFilteredOutRows_System_Int32_" data-uid="GrapeCity.Spreadsheet.IAutoFilter.GetFilteredOutRows(System.Int32)">
          <a class="xref" href="GrapeCity.Spreadsheet.IAutoFilter.GetFilteredOutRows.html#GrapeCity_Spreadsheet_IAutoFilter_GetFilteredOutRows_System_Int32_">GetFilteredOutRows(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the array of rows that are filtered out.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IAutoFilter_ShowAllData_System_Boolean_" data-uid="GrapeCity.Spreadsheet.IAutoFilter.ShowAllData(System.Boolean)">
          <a class="xref" href="GrapeCity.Spreadsheet.IAutoFilter.ShowAllData.html#GrapeCity_Spreadsheet_IAutoFilter_ShowAllData_System_Boolean_">ShowAllData(bool)</a>
        </td>
        <td class="markdown level1 summary"><p>Displays all the data returned by the <a class="xref" href="GrapeCity.Spreadsheet.IAutoFilter.html">IAutoFilter</a> object.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>