# GrapeCity.Documents.Excel.IPivotFilter

## Content

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



  <h1 id="GrapeCity_Documents_Excel_IPivotFilter" data-uid="GrapeCity.Documents.Excel.IPivotFilter" class="text-break">IPivotFilter Interface
</h1>
  <div class="markdown level0 summary"><p>Represents a pivot filter in the PivotFilters collection.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.Documents.Excel.html">GrapeCity.Documents.Excel</a></h6>
  <h6><strong>Assembly</strong>: DS.Documents.Excel.dll</h6>
  <h5 id="GrapeCity_Documents_Excel_IPivotFilter_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public interface IPivotFilter</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Interface IPivotFilter</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_Documents_Excel_IPivotFilter_DataField" data-uid="GrapeCity.Documents.Excel.IPivotFilter.DataField">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotFilter.DataField.html#GrapeCity_Documents_Excel_IPivotFilter_DataField">DataField</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the data field that the pivot filter depends on.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotFilter_Description" data-uid="GrapeCity.Documents.Excel.IPivotFilter.Description">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotFilter.Description.html#GrapeCity_Documents_Excel_IPivotFilter_Description">Description</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the description of the pivot filter. The maximum length of the description string is 255 characters.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotFilter_FilterType" data-uid="GrapeCity.Documents.Excel.IPivotFilter.FilterType">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotFilter.FilterType.html#GrapeCity_Documents_Excel_IPivotFilter_FilterType">FilterType</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the type of the pivot filter.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotFilter_Name" data-uid="GrapeCity.Documents.Excel.IPivotFilter.Name">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotFilter.Name.html#GrapeCity_Documents_Excel_IPivotFilter_Name">Name</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the name of the pivot filter.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotFilter_PivotField" data-uid="GrapeCity.Documents.Excel.IPivotFilter.PivotField">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotFilter.PivotField.html#GrapeCity_Documents_Excel_IPivotFilter_PivotField">PivotField</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the label field that the pivot filter depends on.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotFilter_Value1" data-uid="GrapeCity.Documents.Excel.IPivotFilter.Value1">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotFilter.Value1.html#GrapeCity_Documents_Excel_IPivotFilter_Value1">Value1</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the first filter value.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotFilter_Value2" data-uid="GrapeCity.Documents.Excel.IPivotFilter.Value2">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotFilter.Value2.html#GrapeCity_Documents_Excel_IPivotFilter_Value2">Value2</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the second filter value.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IPivotFilter_WholeDayFilter" data-uid="GrapeCity.Documents.Excel.IPivotFilter.WholeDayFilter">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotFilter.WholeDayFilter.html#GrapeCity_Documents_Excel_IPivotFilter_WholeDayFilter">WholeDayFilter</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a value indicating whether the date filter should use whole days in its filtering criteria.</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_Documents_Excel_IPivotFilter_Delete" data-uid="GrapeCity.Documents.Excel.IPivotFilter.Delete">
          <a class="xref" href="GrapeCity.Documents.Excel.IPivotFilter.Delete.html#GrapeCity_Documents_Excel_IPivotFilter_Delete">Delete()</a>
        </td>
        <td class="markdown level1 summary"><p>Deletes the filter and removes it from the filter collections of the PivotField.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>