# FarPoint.Win.Spread.DefaultRowFilter

## Content

<div class="doc-site-dotnet-api-container">



  <h1 id="FarPoint_Win_Spread_DefaultRowFilter" data-uid="FarPoint.Win.Spread.DefaultRowFilter" class="text-break">DefaultRowFilter Class
</h1>
  <div class="markdown level0 summary"><p>Represents a default row filter that extends to implement the supported row filters.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <div class="inheritance">
    <h5>Inheritance</h5>
    <div class="level0"><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a></div>
    <div class="level1"><span class="xref">DefaultRowFilter</span></div>
      <div class="level2"><a class="xref" href="FarPoint.Win.Spread.HideRowFilter.html">HideRowFilter</a></div>
      <div class="level2"><a class="xref" href="FarPoint.Win.Spread.StyleRowFilter.html">StyleRowFilter</a></div>
  </div>
  <div class="implements">
    <h5>Implements</h5>
    <div><a class="xref" href="FarPoint.Win.Spread.IRowFilter2.html">IRowFilter2</a></div>
    <div><a class="xref" href="FarPoint.Win.Spread.IRowFilter.html">IRowFilter</a></div>
    <div><a class="xref" href="../FarPoint.Win/FarPoint.Win.ISerializeSupport.html">ISerializeSupport</a></div>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.runtime.serialization.ideserializationcallback">IDeserializationCallback</a></div>
    <div><a class="xref" href="FarPoint.Win.Spread.IManualRowFilterSupport.html">IManualRowFilterSupport</a></div>
    <div><a class="xref" href="FarPoint.Win.Spread.IRowFilterFrozenSupport.html">IRowFilterFrozenSupport</a></div>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.runtime.serialization.iserializable">ISerializable</a></div>
  </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_DefaultRowFilter_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public abstract class DefaultRowFilter : IRowFilter2, IRowFilter, ISerializeSupport, IDeserializationCallback, IManualRowFilterSupport, IRowFilterFrozenSupport, ISerializable</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public MustInherit Class DefaultRowFilter
    Implements IRowFilter2, IRowFilter, ISerializeSupport, IDeserializationCallback, IManualRowFilterSupport, IRowFilterFrozenSupport, ISerializable</code></pre>
  </div>
  <h3 id="constructors">Constructors
</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_DefaultRowFilter__ctor_FarPoint_Win_Spread_DefaultRowFilter_" data-uid="FarPoint.Win.Spread.DefaultRowFilter.#ctor(FarPoint.Win.Spread.DefaultRowFilter)">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.-ctor.html#FarPoint_Win_Spread_DefaultRowFilter__ctor_FarPoint_Win_Spread_DefaultRowFilter_">DefaultRowFilter(DefaultRowFilter)</a>
        </td>
        <td class="markdown level1 summary"><p>Use in serialization/deserialization only</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter__ctor_FarPoint_Win_Spread_SheetView_" data-uid="FarPoint.Win.Spread.DefaultRowFilter.#ctor(FarPoint.Win.Spread.SheetView)">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.-ctor.html#FarPoint_Win_Spread_DefaultRowFilter__ctor_FarPoint_Win_Spread_SheetView_">DefaultRowFilter(SheetView)</a>
        </td>
        <td class="markdown level1 summary"><p>Creates a new default row filter for the specified sheet.</p>
</td>
      </tr>
    </tbody>
  </table>
  <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_DefaultRowFilter_AllString" data-uid="FarPoint.Win.Spread.DefaultRowFilter.AllString">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.AllString.html#FarPoint_Win_Spread_DefaultRowFilter_AllString">AllString</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the all filter items string.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_BlanksString" data-uid="FarPoint.Win.Spread.DefaultRowFilter.BlanksString">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.BlanksString.html#FarPoint_Win_Spread_DefaultRowFilter_BlanksString">BlanksString</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the blanks (empty cells) string.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_ColumnDefinitions" data-uid="FarPoint.Win.Spread.DefaultRowFilter.ColumnDefinitions">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.ColumnDefinitions.html#FarPoint_Win_Spread_DefaultRowFilter_ColumnDefinitions">ColumnDefinitions</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the collection of filter column definitions.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_DropDownBorderStyle" data-uid="FarPoint.Win.Spread.DefaultRowFilter.DropDownBorderStyle">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.DropDownBorderStyle.html#FarPoint_Win_Spread_DefaultRowFilter_DropDownBorderStyle">DropDownBorderStyle</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the style for the drop-down list of filter items.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_FilterFrozenRows" data-uid="FarPoint.Win.Spread.DefaultRowFilter.FilterFrozenRows">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.FilterFrozenRows.html#FarPoint_Win_Spread_DefaultRowFilter_FilterFrozenRows">FilterFrozenRows</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether frozen rows are filtered.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_NonBlanksString" data-uid="FarPoint.Win.Spread.DefaultRowFilter.NonBlanksString">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.NonBlanksString.html#FarPoint_Win_Spread_DefaultRowFilter_NonBlanksString">NonBlanksString</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the non-blanks (non-empty cells) string.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_SheetView" data-uid="FarPoint.Win.Spread.DefaultRowFilter.SheetView">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.SheetView.html#FarPoint_Win_Spread_DefaultRowFilter_SheetView">SheetView</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the sheet associated with this row filter.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_ShowFilterIndicator" data-uid="FarPoint.Win.Spread.DefaultRowFilter.ShowFilterIndicator">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.ShowFilterIndicator.html#FarPoint_Win_Spread_DefaultRowFilter_ShowFilterIndicator">ShowFilterIndicator</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the filter indicator should be displayed.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_UnfilteredRows" data-uid="FarPoint.Win.Spread.DefaultRowFilter.UnfilteredRows">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.UnfilteredRows.html#FarPoint_Win_Spread_DefaultRowFilter_UnfilteredRows">UnfilteredRows</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets unfiltered rows.</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_DefaultRowFilter_AddColumn_FarPoint_Win_Spread_FilterColumnDefinition_" data-uid="FarPoint.Win.Spread.DefaultRowFilter.AddColumn(FarPoint.Win.Spread.FilterColumnDefinition)">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.AddColumn.html#FarPoint_Win_Spread_DefaultRowFilter_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_DefaultRowFilter_AddColumn_System_Int32_" data-uid="FarPoint.Win.Spread.DefaultRowFilter.AddColumn(System.Int32)">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.AddColumn.html#FarPoint_Win_Spread_DefaultRowFilter_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_DefaultRowFilter_AddColumn_System_Int32_FarPoint_Win_Spread_FilterListBehavior_" data-uid="FarPoint.Win.Spread.DefaultRowFilter.AddColumn(System.Int32,FarPoint.Win.Spread.FilterListBehavior)">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.AddColumn.html#FarPoint_Win_Spread_DefaultRowFilter_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 with the specified list behavior.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_Deserialize_System_Xml_XmlNodeReader_" data-uid="FarPoint.Win.Spread.DefaultRowFilter.Deserialize(System.Xml.XmlNodeReader)">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.Deserialize.html#FarPoint_Win_Spread_DefaultRowFilter_Deserialize_System_Xml_XmlNodeReader_">Deserialize(XmlNodeReader)</a>
        </td>
        <td class="markdown level1 summary"><p>Loads the object from XML.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_GetColumnFilterIndexFromColumnIndex_System_Int32_" data-uid="FarPoint.Win.Spread.DefaultRowFilter.GetColumnFilterIndexFromColumnIndex(System.Int32)">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.GetColumnFilterIndexFromColumnIndex.html#FarPoint_Win_Spread_DefaultRowFilter_GetColumnFilterIndexFromColumnIndex_System_Int32_">GetColumnFilterIndexFromColumnIndex(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the column filter index from the specified column.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_GetFilterColumnDefinition_System_Int32_" data-uid="FarPoint.Win.Spread.DefaultRowFilter.GetFilterColumnDefinition(System.Int32)">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.GetFilterColumnDefinition.html#FarPoint_Win_Spread_DefaultRowFilter_GetFilterColumnDefinition_System_Int32_">GetFilterColumnDefinition(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the filter column definition from the specified column.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_GetFilteredColumnIndexes" data-uid="FarPoint.Win.Spread.DefaultRowFilter.GetFilteredColumnIndexes">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.GetFilteredColumnIndexes.html#FarPoint_Win_Spread_DefaultRowFilter_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_DefaultRowFilter_IsAnyFilterApplied" data-uid="FarPoint.Win.Spread.DefaultRowFilter.IsAnyFilterApplied">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.IsAnyFilterApplied.html#FarPoint_Win_Spread_DefaultRowFilter_IsAnyFilterApplied">IsAnyFilterApplied()</a>
        </td>
        <td class="markdown level1 summary"><p>Checks whether a filter has been applied in the spread sheet.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_IsRowFilteredOut_System_Int32_" data-uid="FarPoint.Win.Spread.DefaultRowFilter.IsRowFilteredOut(System.Int32)">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.IsRowFilteredOut.html#FarPoint_Win_Spread_DefaultRowFilter_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_DefaultRowFilter_OnDataModelChanged_System_Object_FarPoint_Win_Spread_Model_SheetDataModelEventArgs_" data-uid="FarPoint.Win.Spread.DefaultRowFilter.OnDataModelChanged(System.Object,FarPoint.Win.Spread.Model.SheetDataModelEventArgs)">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.OnDataModelChanged.html#FarPoint_Win_Spread_DefaultRowFilter_OnDataModelChanged_System_Object_FarPoint_Win_Spread_Model_SheetDataModelEventArgs_">OnDataModelChanged(object, SheetDataModelEventArgs)</a>
        </td>
        <td class="markdown level1 summary"><p>Occurs when the data model has changed.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_OnFilterColumnDefinitionCollectionChanged_System_Object_System_ComponentModel_CollectionChangeEventArgs_" data-uid="FarPoint.Win.Spread.DefaultRowFilter.OnFilterColumnDefinitionCollectionChanged(System.Object,System.ComponentModel.CollectionChangeEventArgs)">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.OnFilterColumnDefinitionCollectionChanged.html#FarPoint_Win_Spread_DefaultRowFilter_OnFilterColumnDefinitionCollectionChanged_System_Object_System_ComponentModel_CollectionChangeEventArgs_">OnFilterColumnDefinitionCollectionChanged(object, CollectionChangeEventArgs)</a>
        </td>
        <td class="markdown level1 summary"><p>Occurs when the filter column definition collection has changed.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_OnStyleModelChanged_System_Object_FarPoint_Win_Spread_Model_SheetStyleModelEventArgs_" data-uid="FarPoint.Win.Spread.DefaultRowFilter.OnStyleModelChanged(System.Object,FarPoint.Win.Spread.Model.SheetStyleModelEventArgs)">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.OnStyleModelChanged.html#FarPoint_Win_Spread_DefaultRowFilter_OnStyleModelChanged_System_Object_FarPoint_Win_Spread_Model_SheetStyleModelEventArgs_">OnStyleModelChanged(object, SheetStyleModelEventArgs)</a>
        </td>
        <td class="markdown level1 summary"><p>Occurs when the style model has changed.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_RemoveColumn_System_Int32_" data-uid="FarPoint.Win.Spread.DefaultRowFilter.RemoveColumn(System.Int32)">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.RemoveColumn.html#FarPoint_Win_Spread_DefaultRowFilter_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_DefaultRowFilter_ResetFilter" data-uid="FarPoint.Win.Spread.DefaultRowFilter.ResetFilter">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.ResetFilter.html#FarPoint_Win_Spread_DefaultRowFilter_ResetFilter">ResetFilter()</a>
        </td>
        <td class="markdown level1 summary"><p>Resets the filter settings for the entire row filter.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_ResetFilter_System_Int32_" data-uid="FarPoint.Win.Spread.DefaultRowFilter.ResetFilter(System.Int32)">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.ResetFilter.html#FarPoint_Win_Spread_DefaultRowFilter_ResetFilter_System_Int32_">ResetFilter(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Resets the filter settings for the specified column.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_DefaultRowFilter_Serialize_System_Xml_XmlTextWriter_" data-uid="FarPoint.Win.Spread.DefaultRowFilter.Serialize(System.Xml.XmlTextWriter)">
          <a class="xref" href="FarPoint.Win.Spread.DefaultRowFilter.Serialize.html#FarPoint_Win_Spread_DefaultRowFilter_Serialize_System_Xml_XmlTextWriter_">Serialize(XmlTextWriter)</a>
        </td>
        <td class="markdown level1 summary"><p>Saves the object to XML.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>
