# FarPoint.Win.Spread.IRowFilter

## Content

<div class="doc-site-dotnet-api-container">



  <h1 id="FarPoint_Win_Spread_IRowFilter" data-uid="FarPoint.Win.Spread.IRowFilter" class="text-break">IRowFilter Interface
</h1>
  <div class="markdown level0 summary"><p>Interface that supports row filters for filtering rows on a sheet.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="FarPoint.Win.Spread.html">FarPoint.Win.Spread</a></h6>
  <h6><strong>Assembly</strong>: FarPoint.Win.Spread.dll</h6>
  <h5 id="FarPoint_Win_Spread_IRowFilter_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">[TypeConverter(typeof(_wv))]
public interface IRowFilter : ISerializeSupport</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">&lt;TypeConverter(GetType(_wv))&gt;
Public Interface IRowFilter
    Inherits ISerializeSupport</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="FarPoint_Win_Spread_IRowFilter_AllString" data-uid="FarPoint.Win.Spread.IRowFilter.AllString">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.AllString.html#FarPoint_Win_Spread_IRowFilter_AllString">AllString</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the &quot;(All)&quot; filter item string.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_BlanksString" data-uid="FarPoint.Win.Spread.IRowFilter.BlanksString">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.BlanksString.html#FarPoint_Win_Spread_IRowFilter_BlanksString">BlanksString</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the &quot;(Blanks)&quot; filter item string.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_ColumnDefinitions" data-uid="FarPoint.Win.Spread.IRowFilter.ColumnDefinitions">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.ColumnDefinitions.html#FarPoint_Win_Spread_IRowFilter_ColumnDefinitions">ColumnDefinitions</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the collection of filter column definitions for the sheet.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_DropDownBorderStyle" data-uid="FarPoint.Win.Spread.IRowFilter.DropDownBorderStyle">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.DropDownBorderStyle.html#FarPoint_Win_Spread_IRowFilter_DropDownBorderStyle">DropDownBorderStyle</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the style for the border around the drop-down list of filter items.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_NonBlanksString" data-uid="FarPoint.Win.Spread.IRowFilter.NonBlanksString">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.NonBlanksString.html#FarPoint_Win_Spread_IRowFilter_NonBlanksString">NonBlanksString</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the &quot;(NonBlanks)&quot; filter item string.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_SheetView" data-uid="FarPoint.Win.Spread.IRowFilter.SheetView">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.SheetView.html#FarPoint_Win_Spread_IRowFilter_SheetView">SheetView</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the sheet for this row filter.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_ShowFilterIndicator" data-uid="FarPoint.Win.Spread.IRowFilter.ShowFilterIndicator">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.ShowFilterIndicator.html#FarPoint_Win_Spread_IRowFilter_ShowFilterIndicator">ShowFilterIndicator</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the filter indicator is displayed.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_UnfilteredRows" data-uid="FarPoint.Win.Spread.IRowFilter.UnfilteredRows">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.UnfilteredRows.html#FarPoint_Win_Spread_IRowFilter_UnfilteredRows">UnfilteredRows</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets rows that are not to be filtered.</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="FarPoint_Win_Spread_IRowFilter_AddColumn_FarPoint_Win_Spread_FilterColumnDefinition_" data-uid="FarPoint.Win.Spread.IRowFilter.AddColumn(FarPoint.Win.Spread.FilterColumnDefinition)">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.AddColumn.html#FarPoint_Win_Spread_IRowFilter_AddColumn_FarPoint_Win_Spread_FilterColumnDefinition_">AddColumn(FilterColumnDefinition)</a>
        </td>
        <td class="markdown level1 summary"><p>Adds a filter column definition to the row filter.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_AddColumn_System_Int32_" data-uid="FarPoint.Win.Spread.IRowFilter.AddColumn(System.Int32)">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.AddColumn.html#FarPoint_Win_Spread_IRowFilter_AddColumn_System_Int32_">AddColumn(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Adds a filter column definition to the row filter.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_AddColumn_System_Int32_FarPoint_Win_Spread_FilterListBehavior_" data-uid="FarPoint.Win.Spread.IRowFilter.AddColumn(System.Int32,FarPoint.Win.Spread.FilterListBehavior)">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.AddColumn.html#FarPoint_Win_Spread_IRowFilter_AddColumn_System_Int32_FarPoint_Win_Spread_FilterListBehavior_">AddColumn(int, FilterListBehavior)</a>
        </td>
        <td class="markdown level1 summary"><p>Adds a filter column definition to the row filter.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_GetColumnFilterBy_System_Int32_" data-uid="FarPoint.Win.Spread.IRowFilter.GetColumnFilterBy(System.Int32)">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.GetColumnFilterBy.html#FarPoint_Win_Spread_IRowFilter_GetColumnFilterBy_System_Int32_">GetColumnFilterBy(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the string selected in the drop-down list of filters for the specified column.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_GetColumnFilterIndexFromColumnIndex_System_Int32_" data-uid="FarPoint.Win.Spread.IRowFilter.GetColumnFilterIndexFromColumnIndex(System.Int32)">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.GetColumnFilterIndexFromColumnIndex.html#FarPoint_Win_Spread_IRowFilter_GetColumnFilterIndexFromColumnIndex_System_Int32_">GetColumnFilterIndexFromColumnIndex(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the column filter index for the specified column.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_GetFilterColumnDefinition_System_Int32_" data-uid="FarPoint.Win.Spread.IRowFilter.GetFilterColumnDefinition(System.Int32)">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.GetFilterColumnDefinition.html#FarPoint_Win_Spread_IRowFilter_GetFilterColumnDefinition_System_Int32_">GetFilterColumnDefinition(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the filter column definition for the specified column.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_GetFilteredColumnIndexes" data-uid="FarPoint.Win.Spread.IRowFilter.GetFilteredColumnIndexes">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.GetFilteredColumnIndexes.html#FarPoint_Win_Spread_IRowFilter_GetFilteredColumnIndexes">GetFilteredColumnIndexes()</a>
        </td>
        <td class="markdown level1 summary"><p>Gets an array of column indexes where row filters exist.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_GetFilteredOutRowList" data-uid="FarPoint.Win.Spread.IRowFilter.GetFilteredOutRowList">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.GetFilteredOutRowList.html#FarPoint_Win_Spread_IRowFilter_GetFilteredOutRowList">GetFilteredOutRowList()</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the list of rows that are filtered out.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_GetIntersectedFilteredInRows" data-uid="FarPoint.Win.Spread.IRowFilter.GetIntersectedFilteredInRows">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.GetIntersectedFilteredInRows.html#FarPoint_Win_Spread_IRowFilter_GetIntersectedFilteredInRows">GetIntersectedFilteredInRows()</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the intersection of the filtered-in rows for all the filtered columns.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_GetIntersectedFilteredInRows_System_Int32_" data-uid="FarPoint.Win.Spread.IRowFilter.GetIntersectedFilteredInRows(System.Int32)">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.GetIntersectedFilteredInRows.html#FarPoint_Win_Spread_IRowFilter_GetIntersectedFilteredInRows_System_Int32_">GetIntersectedFilteredInRows(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the intersection of the filtered-in rows for all the filtered columns except
the specified column.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_IsFiltered_System_Int32_" data-uid="FarPoint.Win.Spread.IRowFilter.IsFiltered(System.Int32)">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.IsFiltered.html#FarPoint_Win_Spread_IRowFilter_IsFiltered_System_Int32_">IsFiltered(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Determines whether the specified column is filtered.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_IsRowFilteredOut_System_Int32_" data-uid="FarPoint.Win.Spread.IRowFilter.IsRowFilteredOut(System.Int32)">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.IsRowFilteredOut.html#FarPoint_Win_Spread_IRowFilter_IsRowFilteredOut_System_Int32_">IsRowFilteredOut(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Determines whether the specified row is filtered out.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_RemoveColumn_System_Int32_" data-uid="FarPoint.Win.Spread.IRowFilter.RemoveColumn(System.Int32)">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.RemoveColumn.html#FarPoint_Win_Spread_IRowFilter_RemoveColumn_System_Int32_">RemoveColumn(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Removes a filter column definition from the row filter.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_ResetFilter" data-uid="FarPoint.Win.Spread.IRowFilter.ResetFilter">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.ResetFilter.html#FarPoint_Win_Spread_IRowFilter_ResetFilter">ResetFilter()</a>
        </td>
        <td class="markdown level1 summary"><p>Resets the temporary filter settings for all columns.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_IRowFilter_ResetFilter_System_Int32_" data-uid="FarPoint.Win.Spread.IRowFilter.ResetFilter(System.Int32)">
          <a class="xref" href="FarPoint.Win.Spread.IRowFilter.ResetFilter.html#FarPoint_Win_Spread_IRowFilter_ResetFilter_System_Int32_">ResetFilter(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Resets the temporary filter settings for the specified column.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>
