# GrapeCity.Spreadsheet.CustomFilterCriteria

## Content

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



  <h1 id="GrapeCity_Spreadsheet_CustomFilterCriteria" data-uid="GrapeCity.Spreadsheet.CustomFilterCriteria" class="text-break">CustomFilterCriteria Struct
</h1>
  <div class="markdown level0 summary"><p>A custom AutoFilter specifies an operator and a value. There can be at most two customFilters specified, and in that case the parent
element specifies whether the two conditions are joined by 'and' or 'or'. For any cells whose values do not meet the specified criteria,
the corresponding rows shall be hidden from view when the fitler is applied.</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_CustomFilterCriteria_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public struct CustomFilterCriteria</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Structure CustomFilterCriteria</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="GrapeCity_Spreadsheet_CustomFilterCriteria__ctor_GrapeCity_Spreadsheet_CustomFilterOperator_GrapeCity_CalcEngine_CalcError_" data-uid="GrapeCity.Spreadsheet.CustomFilterCriteria.#ctor(GrapeCity.Spreadsheet.CustomFilterOperator,GrapeCity.CalcEngine.CalcError)">
          <a class="xref" href="GrapeCity.Spreadsheet.CustomFilterCriteria.-ctor.html#GrapeCity_Spreadsheet_CustomFilterCriteria__ctor_GrapeCity_Spreadsheet_CustomFilterOperator_GrapeCity_CalcEngine_CalcError_">CustomFilterCriteria(CustomFilterOperator, CalcError)</a>
        </td>
        <td class="markdown level1 summary"><p>Initializes a new instance of the <a class="xref" href="GrapeCity.Spreadsheet.CustomFilterCriteria.html">CustomFilterCriteria</a> struct.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_CustomFilterCriteria__ctor_GrapeCity_Spreadsheet_CustomFilterOperator_System_Boolean_" data-uid="GrapeCity.Spreadsheet.CustomFilterCriteria.#ctor(GrapeCity.Spreadsheet.CustomFilterOperator,System.Boolean)">
          <a class="xref" href="GrapeCity.Spreadsheet.CustomFilterCriteria.-ctor.html#GrapeCity_Spreadsheet_CustomFilterCriteria__ctor_GrapeCity_Spreadsheet_CustomFilterOperator_System_Boolean_">CustomFilterCriteria(CustomFilterOperator, bool)</a>
        </td>
        <td class="markdown level1 summary"><p>Initializes a new instance of the <a class="xref" href="GrapeCity.Spreadsheet.CustomFilterCriteria.html">CustomFilterCriteria</a> struct.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_CustomFilterCriteria__ctor_GrapeCity_Spreadsheet_CustomFilterOperator_System_DateTime_" data-uid="GrapeCity.Spreadsheet.CustomFilterCriteria.#ctor(GrapeCity.Spreadsheet.CustomFilterOperator,System.DateTime)">
          <a class="xref" href="GrapeCity.Spreadsheet.CustomFilterCriteria.-ctor.html#GrapeCity_Spreadsheet_CustomFilterCriteria__ctor_GrapeCity_Spreadsheet_CustomFilterOperator_System_DateTime_">CustomFilterCriteria(CustomFilterOperator, DateTime)</a>
        </td>
        <td class="markdown level1 summary"><p>Initializes a new instance of the <a class="xref" href="GrapeCity.Spreadsheet.CustomFilterCriteria.html">CustomFilterCriteria</a> struct.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_CustomFilterCriteria__ctor_GrapeCity_Spreadsheet_CustomFilterOperator_System_Double_" data-uid="GrapeCity.Spreadsheet.CustomFilterCriteria.#ctor(GrapeCity.Spreadsheet.CustomFilterOperator,System.Double)">
          <a class="xref" href="GrapeCity.Spreadsheet.CustomFilterCriteria.-ctor.html#GrapeCity_Spreadsheet_CustomFilterCriteria__ctor_GrapeCity_Spreadsheet_CustomFilterOperator_System_Double_">CustomFilterCriteria(CustomFilterOperator, double)</a>
        </td>
        <td class="markdown level1 summary"><p>Initializes a new instance of the <a class="xref" href="GrapeCity.Spreadsheet.CustomFilterCriteria.html">CustomFilterCriteria</a> struct.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_CustomFilterCriteria__ctor_GrapeCity_Spreadsheet_CustomFilterOperator_System_String_" data-uid="GrapeCity.Spreadsheet.CustomFilterCriteria.#ctor(GrapeCity.Spreadsheet.CustomFilterOperator,System.String)">
          <a class="xref" href="GrapeCity.Spreadsheet.CustomFilterCriteria.-ctor.html#GrapeCity_Spreadsheet_CustomFilterCriteria__ctor_GrapeCity_Spreadsheet_CustomFilterOperator_System_String_">CustomFilterCriteria(CustomFilterOperator, string)</a>
        </td>
        <td class="markdown level1 summary"><p>Initializes a new instance of the <a class="xref" href="GrapeCity.Spreadsheet.CustomFilterCriteria.html">CustomFilterCriteria</a> struct.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="fields">Fields
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="GrapeCity_Spreadsheet_CustomFilterCriteria_None" data-uid="GrapeCity.Spreadsheet.CustomFilterCriteria.None">
          <a class="xref" href="GrapeCity.Spreadsheet.CustomFilterCriteria.None.html">None</a>
        </td>
        <td class="markdown level1 summary"><p>Returns a &quot;None&quot; filter criteria.</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="GrapeCity_Spreadsheet_CustomFilterCriteria_Operator" data-uid="GrapeCity.Spreadsheet.CustomFilterCriteria.Operator">
          <a class="xref" href="GrapeCity.Spreadsheet.CustomFilterCriteria.Operator.html#GrapeCity_Spreadsheet_CustomFilterCriteria_Operator">Operator</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the operator of this <a class="xref" href="GrapeCity.Spreadsheet.CustomFilterCriteria.html">CustomFilterCriteria</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_CustomFilterCriteria_Value" data-uid="GrapeCity.Spreadsheet.CustomFilterCriteria.Value">
          <a class="xref" href="GrapeCity.Spreadsheet.CustomFilterCriteria.Value.html#GrapeCity_Spreadsheet_CustomFilterCriteria_Value">Value</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the value of this <a class="xref" href="GrapeCity.Spreadsheet.CustomFilterCriteria.html">CustomFilterCriteria</a>.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>