xlsx-0.5.0: Simple and incomplete Excel file parser/writer

Safe HaskellNone
LanguageHaskell2010

Codec.Xlsx.Types.AutoFilter

Synopsis

Documentation

data FilterColumn Source #

The filterColumn collection identifies a particular column in the AutoFilter range and specifies filter information that has been applied to this column. If a column in the AutoFilter range has no criteria specified, then there is no corresponding filterColumn collection expressed for that column.

Section 18.3.2.7 "filterColumn (AutoFilter Column)" (p. 1717)

data CustomFilterOperator Source #

Constructors

FltrEqual

Show results which are equal to criteria.

FltrGreaterThan

Show results which are greater than criteria.

FltrGreaterThanOrEqual

Show results which are greater than or equal to criteria.

FltrLessThan

Show results which are less than criteria.

FltrLessThanOrEqual

Show results which are less than or equal to criteria.

FltrNotEqual

Show results which are not equal to criteria.

data AutoFilter Source #

AutoFilter temporarily hides rows based on a filter criteria, which is applied column by column to a table of datain the worksheet.

TODO: sortState, extList

Section 18.3.1.2 "autoFilter (AutoFilter Settings)" (p. 1596)