A slicer: buttons that filter one column of a table, or one field of pivot tables.
Remarks
A slicer holds no selection of its own. On a table, what it shows as selected is the column's
filter (ITable.IColumn.getFilter), so a filter set from the column's menu shows on the
slicer, and a selection made on the slicer is the column's filter, saved with the table. On pivot
tables it is the field's items hidden by hand (IPivotTable.IField.setVisibleItems), the
same on every pivot table it filters; a label or value filter on the field does not show on it.
Two slicers on one column or field always agree.
A table slicer follows its table and column through a rename. When the column or its table is
deleted, the slicer is deleted with it, in the same step; an undo brings both back. A pivot slicer
stays when its pivot tables are deleted, filtering nothing, and is deleted with its field when a
pivot table's source no longer has it.
Where a slicer sits is its movable's (IMovable.getBounds); it moves freely of the cells
under it by default.
A slicer: buttons that filter one column of a table, or one field of pivot tables.
Remarks
A slicer holds no selection of its own. On a table, what it shows as selected is the column's filter (ITable.IColumn.getFilter), so a filter set from the column's menu shows on the slicer, and a selection made on the slicer is the column's filter, saved with the table. On pivot tables it is the field's items hidden by hand (IPivotTable.IField.setVisibleItems), the same on every pivot table it filters; a label or value filter on the field does not show on it. Two slicers on one column or field always agree.
A table slicer follows its table and column through a rename. When the column or its table is deleted, the slicer is deleted with it, in the same step; an undo brings both back. A pivot slicer stays when its pivot tables are deleted, filtering nothing, and is deleted with its field when a pivot table's source no longer has it.
Where a slicer sits is its movable's (IMovable.getBounds); it moves freely of the cells under it by default.
See
Interface
ISlicer