# GrapeCity.Spreadsheet.Slicers.ISlicerCache

## Content

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



  <h1 id="GrapeCity_Spreadsheet_Slicers_ISlicerCache" data-uid="GrapeCity.Spreadsheet.Slicers.ISlicerCache" class="text-break">ISlicerCache Interface
</h1>
  <div class="markdown level0 summary"><p>Represents the current filter state for a slicer and information about which source the slicer is connected to.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.Spreadsheet.Slicers.html">GrapeCity.Spreadsheet.Slicers</a></h6>
  <h6><strong>Assembly</strong>: GrapeCity.Spreadsheet.dll</h6>
  <h5 id="GrapeCity_Spreadsheet_Slicers_ISlicerCache_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public interface ISlicerCache</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Interface ISlicerCache</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_Slicers_ISlicerCache_CrossFilterType" data-uid="GrapeCity.Spreadsheet.Slicers.ISlicerCache.CrossFilterType">
          <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.CrossFilterType.html#GrapeCity_Spreadsheet_Slicers_ISlicerCache_CrossFilterType">CrossFilterType</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the slicer is participating in cross filtering with other slicers that share the same slicer cache, and how cross filtering is displayed.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_Slicers_ISlicerCache_FilterCleared" data-uid="GrapeCity.Spreadsheet.Slicers.ISlicerCache.FilterCleared">
          <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.FilterCleared.html#GrapeCity_Spreadsheet_Slicers_ISlicerCache_FilterCleared">FilterCleared</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a value indicating whether the filter state is cleared.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_Slicers_ISlicerCache_Index" data-uid="GrapeCity.Spreadsheet.Slicers.ISlicerCache.Index">
          <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.Index.html#GrapeCity_Spreadsheet_Slicers_ISlicerCache_Index">Index</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the index of the specified <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.html">ISlicerCache</a> object in the <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCaches.html">ISlicerCaches</a> collection.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_Slicers_ISlicerCache_List" data-uid="GrapeCity.Spreadsheet.Slicers.ISlicerCache.List">
          <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.List.html#GrapeCity_Spreadsheet_Slicers_ISlicerCache_List">List</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a value indicating whether the slicer cache is for a slicer on a table.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_Slicers_ISlicerCache_ListObject" data-uid="GrapeCity.Spreadsheet.Slicers.ISlicerCache.ListObject">
          <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.ListObject.html#GrapeCity_Spreadsheet_Slicers_ISlicerCache_ListObject">ListObject</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the <a class="xref" href="GrapeCity.Spreadsheet.ITable.html">ITable</a> object associated with this <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.html">ISlicerCache</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_Slicers_ISlicerCache_Name" data-uid="GrapeCity.Spreadsheet.Slicers.ISlicerCache.Name">
          <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.Name.html#GrapeCity_Spreadsheet_Slicers_ISlicerCache_Name">Name</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the name of the slicer cache.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_Slicers_ISlicerCache_RequireManualUpdate" data-uid="GrapeCity.Spreadsheet.Slicers.ISlicerCache.RequireManualUpdate">
          <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.RequireManualUpdate.html#GrapeCity_Spreadsheet_Slicers_ISlicerCache_RequireManualUpdate">RequireManualUpdate</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets a value indicating whether manual updates of the slicer cache required.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_Slicers_ISlicerCache_SlicerItems" data-uid="GrapeCity.Spreadsheet.Slicers.ISlicerCache.SlicerItems">
          <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.SlicerItems.html#GrapeCity_Spreadsheet_Slicers_ISlicerCache_SlicerItems">SlicerItems</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerItems.html">ISlicerItems</a> collection that contains the collection of all items in the slicer cache.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_Slicers_ISlicerCache_Slicers" data-uid="GrapeCity.Spreadsheet.Slicers.ISlicerCache.Slicers">
          <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.Slicers.html#GrapeCity_Spreadsheet_Slicers_ISlicerCache_Slicers">Slicers</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicers.html">ISlicers</a> collection that contains the collection of <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicer.html">ISlicer</a> objects associated with the specified <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.html">ISlicerCache</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_Slicers_ISlicerCache_SortItems" data-uid="GrapeCity.Spreadsheet.Slicers.ISlicerCache.SortItems">
          <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.SortItems.html#GrapeCity_Spreadsheet_Slicers_ISlicerCache_SortItems">SortItems</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the sort order of the items in the slicer.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_Slicers_ISlicerCache_SourceName" data-uid="GrapeCity.Spreadsheet.Slicers.ISlicerCache.SourceName">
          <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.SourceName.html#GrapeCity_Spreadsheet_Slicers_ISlicerCache_SourceName">SourceName</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the name of the data source the slicer is connected to.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_Slicers_ISlicerCache_VisibleSlicerItems" data-uid="GrapeCity.Spreadsheet.Slicers.ISlicerCache.VisibleSlicerItems">
          <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.VisibleSlicerItems.html#GrapeCity_Spreadsheet_Slicers_ISlicerCache_VisibleSlicerItems">VisibleSlicerItems</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerItems.html">ISlicerItems</a> collection that contains the collection of all the visible items in the specified slicer cache.</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_Slicers_ISlicerCache_ClearAllFilters" data-uid="GrapeCity.Spreadsheet.Slicers.ISlicerCache.ClearAllFilters">
          <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.ClearAllFilters.html#GrapeCity_Spreadsheet_Slicers_ISlicerCache_ClearAllFilters">ClearAllFilters()</a>
        </td>
        <td class="markdown level1 summary"><p>Clears the filter depending on the slicer cache type.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_Slicers_ISlicerCache_ClearDateFilter" data-uid="GrapeCity.Spreadsheet.Slicers.ISlicerCache.ClearDateFilter">
          <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.ClearDateFilter.html#GrapeCity_Spreadsheet_Slicers_ISlicerCache_ClearDateFilter">ClearDateFilter()</a>
        </td>
        <td class="markdown level1 summary"><p>Clears the filter for a timeline (date filter).</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_Slicers_ISlicerCache_ClearManualFilter" data-uid="GrapeCity.Spreadsheet.Slicers.ISlicerCache.ClearManualFilter">
          <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.ClearManualFilter.html#GrapeCity_Spreadsheet_Slicers_ISlicerCache_ClearManualFilter">ClearManualFilter()</a>
        </td>
        <td class="markdown level1 summary"><p>Clears the manual filter for the slicer cache.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_Slicers_ISlicerCache_Delete" data-uid="GrapeCity.Spreadsheet.Slicers.ISlicerCache.Delete">
          <a class="xref" href="GrapeCity.Spreadsheet.Slicers.ISlicerCache.Delete.html#GrapeCity_Spreadsheet_Slicers_ISlicerCache_Delete">Delete()</a>
        </td>
        <td class="markdown level1 summary"><p>Deletes the specified slicer cache and the slicers associated with it.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>