- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
-
Features
- Workbook
- Worksheet
- Rows and Columns
- Headers
- Cells
- Data Binding
- TableSheet
- GanttSheet
- ReportSheet
- Data Charts
- JSON Schema with SpreadJS
- SpreadJS File Format
- Data Validation
- Conditional Formatting
- Sort
- Group
- Formulas
- Serialization
- Keyboard Actions
- Shapes
- Floating Objects
- Barcodes
- Charts
- Sparklines
- Tables
- Pivot Table
- Slicer
- Theme
- Culture
- AI Assistant
- SpreadJS Designer
- SpreadJS Designer Component
- SpreadJS Collaboration Server
- Touch Support
- Formula Reference
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
(Showing Draft Content)
Pivot Table Slicer
Pivot Table supports slicers, which provide convenient graphical interfaces for the label filter.
PivotTable supports the following types of slicers:
Note: To work with pivot slicers in a SpreadJS worksheet, you need to reference the following plugins:
gc.spread.sheets.all.js
gc.spread.sheets.shapes.js
gc.spread.sheets.slicers.js
gc.spread.pivot.pivottables.jsThe Slicer Plugin relies on the Shape Plugin, so the Shape Plugin must be imported first.
To upgrade to the new slicers, see Breaking Changes.