Module slicer 

Slicers: on-sheet widgets that filter one column of a table by clicking value tiles.

A slicer is a thin front-end over the existing filter machinery: its selection is written as a FilterCriterion::Values into the sheet’s AutoFilter (over the table’s range) and [super::data::apply_filter] hides the rows. Creating a slicer (insert.slicer / table.insertSlicer) selects everything, i.e. applies no filter.

Functions

column_values

Distinct, non-blank display values of a table column, in first-seen order. Used to populate a slicer’s tiles and to detect “everything selected”.

slicer_items

A slicer’s tiles as (value, selected), for the UI. selected is true for every tile when the slicer has no filter (selected == None).

specs