Safe Haskell	None
Language	Haskell2010

Codec.Xlsx.Types.AutoFilter

Synopsis

Documentation

data FilterColumn #

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)

Constructors

Filters
Fields _fltValues :: [Text]
ACustomFilter CustomFilter
CustomFiltersOr CustomFilter CustomFilter
CustomFiltersAnd CustomFilter CustomFilter

Instances

Eq FilterColumn #
Methods (==) :: FilterColumn -> FilterColumn -> Bool # (/=) :: FilterColumn -> FilterColumn -> Bool #
Show FilterColumn #
Methods showsPrec :: Int -> FilterColumn -> ShowS # show :: FilterColumn -> String # showList :: [FilterColumn] -> ShowS #
Generic FilterColumn #
Associated Types type Rep FilterColumn :: * -> * # Methods from :: FilterColumn -> Rep FilterColumn x # to :: Rep FilterColumn x -> FilterColumn #
type Rep FilterColumn #
type Rep FilterColumn = D1 (MetaData "FilterColumn" "Codec.Xlsx.Types.AutoFilter" "xlsx-0.6.0-9Et6tz40HhX7mNeKNADElD" False) ((:+:) ((:+:) (C1 (MetaCons "Filters" PrefixI True) (S1 (MetaSel (Just Symbol "_fltValues") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 [Text]))) (C1 (MetaCons "ACustomFilter" PrefixI False) (S1 (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 CustomFilter)))) ((:+:) (C1 (MetaCons "CustomFiltersOr" PrefixI False) ((::) (S1 (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 CustomFilter)) (S1 (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 CustomFilter)))) (C1 (MetaCons "CustomFiltersAnd" PrefixI False) ((::) (S1 (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 CustomFilter)) (S1 (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 CustomFilter))))))

data CustomFilter #

Constructors

CustomFilter
Fields cfltOperator :: CustomFilterOperator cfltValue :: Text

Instances

Eq CustomFilter #
Methods (==) :: CustomFilter -> CustomFilter -> Bool # (/=) :: CustomFilter -> CustomFilter -> Bool #
Show CustomFilter #
Methods showsPrec :: Int -> CustomFilter -> ShowS # show :: CustomFilter -> String # showList :: [CustomFilter] -> ShowS #
Generic CustomFilter #
Associated Types type Rep CustomFilter :: * -> * # Methods from :: CustomFilter -> Rep CustomFilter x # to :: Rep CustomFilter x -> CustomFilter #
ToElement CustomFilter #
Methods toElement :: Name -> CustomFilter -> Element #
type Rep CustomFilter #
type Rep CustomFilter = D1 (MetaData "CustomFilter" "Codec.Xlsx.Types.AutoFilter" "xlsx-0.6.0-9Et6tz40HhX7mNeKNADElD" False) (C1 (MetaCons "CustomFilter" PrefixI True) ((:*:) (S1 (MetaSel (Just Symbol "cfltOperator") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 CustomFilterOperator)) (S1 (MetaSel (Just Symbol "cfltValue") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 Text))))

data CustomFilterOperator #

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.

Instances

Eq CustomFilterOperator #
Methods (==) :: CustomFilterOperator -> CustomFilterOperator -> Bool # (/=) :: CustomFilterOperator -> CustomFilterOperator -> Bool #
Show CustomFilterOperator #
Methods showsPrec :: Int -> CustomFilterOperator -> ShowS # show :: CustomFilterOperator -> String # showList :: [CustomFilterOperator] -> ShowS #
Generic CustomFilterOperator #
Associated Types type Rep CustomFilterOperator :: * -> * # Methods from :: CustomFilterOperator -> Rep CustomFilterOperator x # to :: Rep CustomFilterOperator x -> CustomFilterOperator #
ToAttrVal CustomFilterOperator #
Methods toAttrVal :: CustomFilterOperator -> Text #
FromAttrVal CustomFilterOperator #
Methods fromAttrVal :: Reader CustomFilterOperator #
type Rep CustomFilterOperator #
type Rep CustomFilterOperator = D1 (MetaData "CustomFilterOperator" "Codec.Xlsx.Types.AutoFilter" "xlsx-0.6.0-9Et6tz40HhX7mNeKNADElD" False) ((:+:) ((:+:) (C1 (MetaCons "FltrEqual" PrefixI False) U1) ((:+:) (C1 (MetaCons "FltrGreaterThan" PrefixI False) U1) (C1 (MetaCons "FltrGreaterThanOrEqual" PrefixI False) U1))) ((:+:) (C1 (MetaCons "FltrLessThan" PrefixI False) U1) ((:+:) (C1 (MetaCons "FltrLessThanOrEqual" PrefixI False) U1) (C1 (MetaCons "FltrNotEqual" PrefixI False) U1))))

data AutoFilter #

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)

Constructors

AutoFilter
Fields _afRef :: Maybe CellRef _afFilterColumns :: Map Int FilterColumn

Instances

Eq AutoFilter #
Methods (==) :: AutoFilter -> AutoFilter -> Bool # (/=) :: AutoFilter -> AutoFilter -> Bool #
Show AutoFilter #
Methods showsPrec :: Int -> AutoFilter -> ShowS # show :: AutoFilter -> String # showList :: [AutoFilter] -> ShowS #
Generic AutoFilter #
Associated Types type Rep AutoFilter :: * -> * # Methods from :: AutoFilter -> Rep AutoFilter x # to :: Rep AutoFilter x -> AutoFilter #
Default AutoFilter #
Methods def :: AutoFilter #
ToElement AutoFilter #
Methods toElement :: Name -> AutoFilter -> Element #
FromCursor AutoFilter #
Methods fromCursor :: Cursor -> [AutoFilter] #
type Rep AutoFilter #
type Rep AutoFilter = D1 (MetaData "AutoFilter" "Codec.Xlsx.Types.AutoFilter" "xlsx-0.6.0-9Et6tz40HhX7mNeKNADElD" False) (C1 (MetaCons "AutoFilter" PrefixI True) ((:*:) (S1 (MetaSel (Just Symbol "_afRef") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Maybe CellRef))) (S1 (MetaSel (Just Symbol "_afFilterColumns") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 (Map Int FilterColumn)))))

afRef :: Lens' AutoFilter (Maybe CellRef) #

afFilterColumns :: Lens' AutoFilter (Map Int FilterColumn) #

fltColFromNode :: Node -> [FilterColumn] #

fltColToElement :: FilterColumn -> Element #