Slicer

Spread.Services Documentation
Slicer
Collapse All Expand All

Spread.Services provides you a powerful way to perform quick and effective data filtration using Slicers - easy-to-use visual filters that can filter data residing in tables and pivot tables.

A slicer is comprised of the following elements :

- Slicer Header - This element indicates the category of the items in the slicer.
- Filtering Button- This element indicates whether or not the item is included in the filter.
- Clear Filter button - This element eliminates the filter by selecting all the items in the slicer.
- Scroll bar - This element enables scrolling when multiple items are visible in the filter.
- Border Moving Controls - This element allows you to change the location of the slicer.
- Border Resizing Controls - This element allows you to change the size of the slicer.

After applying slicer style to spreadsheets, users can simply click on the type of data they wish to see instead of performing the cumbersome task of opening drop-down lists to search for desired items again and again. Not just slicers represent the current filtering state of the table or pivot table (with slicer cache available in Spread.Services) but they also help in visualizing data in a much better way by hiding the rest of the information that can be made available as and when required.

Copyright © GrapeCity, inc. All rights reserved.