xlsx-1.1.2.1: Simple and incomplete Excel file parser/writer
Safe HaskellSafe-Inferred
LanguageHaskell2010

Codec.Xlsx.Types.DataValidation

Synopsis

Documentation

data ValidationExpression Source #

Constructors

ValBetween Formula Formula

Between operator

ValEqual Formula

"Equal to" operator

ValGreaterThan Formula

"Greater than" operator

ValGreaterThanOrEqual Formula

"Greater than or equal to" operator

ValLessThan Formula

"Less than" operator

ValLessThanOrEqual Formula

"Less than or equal to" operator

ValNotBetween Formula Formula

"Not between" operator

ValNotEqual Formula

"Not equal to" operator

Instances

Instances details
Generic ValidationExpression Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Associated Types

type Rep ValidationExpression :: Type -> Type #

Methods

from :: ValidationExpression -> Rep ValidationExpression x #

to :: Rep ValidationExpression x -> ValidationExpression #

Show ValidationExpression Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

showsPrec :: Int -> ValidationExpression -> ShowS #

show :: ValidationExpression -> String #

showList :: [ValidationExpression] -> ShowS #

NFData ValidationExpression Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

rnf :: ValidationExpression -> () #

Eq ValidationExpression Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

(==) :: ValidationExpression -> ValidationExpression -> Bool #

(/=) :: ValidationExpression -> ValidationExpression -> Bool #

type Rep ValidationExpression Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

type Rep ValidationExpression = D1 ('MetaData "ValidationExpression" "Codec.Xlsx.Types.DataValidation" "xlsx-1.1.2.1-GdAjj0zF0PPpPuMGO3FJH" 'False) (((C1 ('MetaCons "ValBetween" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula) :*: S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)) :+: C1 ('MetaCons "ValEqual" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula))) :+: (C1 ('MetaCons "ValGreaterThan" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)) :+: C1 ('MetaCons "ValGreaterThanOrEqual" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)))) :+: ((C1 ('MetaCons "ValLessThan" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)) :+: C1 ('MetaCons "ValLessThanOrEqual" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula))) :+: (C1 ('MetaCons "ValNotBetween" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula) :*: S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)) :+: C1 ('MetaCons "ValNotEqual" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)))))

data ValidationType Source #

Constructors

ValidationTypeNone 
ValidationTypeCustom Formula 
ValidationTypeDate ValidationExpression 
ValidationTypeDecimal ValidationExpression 
ValidationTypeList ListOrRangeExpression 
ValidationTypeTextLength ValidationExpression 
ValidationTypeTime ValidationExpression 
ValidationTypeWhole ValidationExpression 

Instances

Instances details
Generic ValidationType Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Associated Types

type Rep ValidationType :: Type -> Type #

Methods

from :: ValidationType -> Rep ValidationType x #

to :: Rep ValidationType x -> ValidationType #

Show ValidationType Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

showsPrec :: Int -> ValidationType -> ShowS #

show :: ValidationType -> String #

showList :: [ValidationType] -> ShowS #

NFData ValidationType Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

rnf :: ValidationType -> () #

Eq ValidationType Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

(==) :: ValidationType -> ValidationType -> Bool #

(/=) :: ValidationType -> ValidationType -> Bool #

ToAttrVal ValidationType Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

toAttrVal :: ValidationType -> Text Source #

type Rep ValidationType Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

type Rep ValidationType = D1 ('MetaData "ValidationType" "Codec.Xlsx.Types.DataValidation" "xlsx-1.1.2.1-GdAjj0zF0PPpPuMGO3FJH" 'False) (((C1 ('MetaCons "ValidationTypeNone" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "ValidationTypeCustom" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula))) :+: (C1 ('MetaCons "ValidationTypeDate" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 ValidationExpression)) :+: C1 ('MetaCons "ValidationTypeDecimal" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 ValidationExpression)))) :+: ((C1 ('MetaCons "ValidationTypeList" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 ListOrRangeExpression)) :+: C1 ('MetaCons "ValidationTypeTextLength" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 ValidationExpression))) :+: (C1 ('MetaCons "ValidationTypeTime" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 ValidationExpression)) :+: C1 ('MetaCons "ValidationTypeWhole" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 ValidationExpression)))))

dvAllowBlank :: Lens' DataValidation Bool Source #

dvError :: Lens' DataValidation (Maybe Text) Source #

dvErrorStyle :: Lens' DataValidation ErrorStyle Source #

dvErrorTitle :: Lens' DataValidation (Maybe Text) Source #

dvPrompt :: Lens' DataValidation (Maybe Text) Source #

dvPromptTitle :: Lens' DataValidation (Maybe Text) Source #

dvShowDropDown :: Lens' DataValidation Bool Source #

dvShowErrorMessage :: Lens' DataValidation Bool Source #

dvShowInputMessage :: Lens' DataValidation Bool Source #

dvValidationType :: Lens' DataValidation ValidationType Source #

data ErrorStyle Source #

Constructors

ErrorStyleInformation 
ErrorStyleStop 
ErrorStyleWarning 

Instances

Instances details
Generic ErrorStyle Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Associated Types

type Rep ErrorStyle :: Type -> Type #

Methods

from :: ErrorStyle -> Rep ErrorStyle x #

to :: Rep ErrorStyle x -> ErrorStyle #

Show ErrorStyle Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

showsPrec :: Int -> ErrorStyle -> ShowS #

show :: ErrorStyle -> String #

showList :: [ErrorStyle] -> ShowS #

NFData ErrorStyle Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

rnf :: ErrorStyle -> () #

Eq ErrorStyle Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

(==) :: ErrorStyle -> ErrorStyle -> Bool #

(/=) :: ErrorStyle -> ErrorStyle -> Bool #

FromAttrVal ErrorStyle Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

fromAttrVal :: Reader ErrorStyle Source #

FromAttrBs ErrorStyle Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

fromAttrBs :: ByteString -> Either Text ErrorStyle Source #

ToAttrVal ErrorStyle Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

toAttrVal :: ErrorStyle -> Text Source #

type Rep ErrorStyle Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

type Rep ErrorStyle = D1 ('MetaData "ErrorStyle" "Codec.Xlsx.Types.DataValidation" "xlsx-1.1.2.1-GdAjj0zF0PPpPuMGO3FJH" 'False) (C1 ('MetaCons "ErrorStyleInformation" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "ErrorStyleStop" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "ErrorStyleWarning" 'PrefixI 'False) (U1 :: Type -> Type)))

data DataValidation Source #

Constructors

DataValidation 

Fields

Instances

Instances details
Generic DataValidation Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Associated Types

type Rep DataValidation :: Type -> Type #

Methods

from :: DataValidation -> Rep DataValidation x #

to :: Rep DataValidation x -> DataValidation #

Show DataValidation Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

showsPrec :: Int -> DataValidation -> ShowS #

show :: DataValidation -> String #

showList :: [DataValidation] -> ShowS #

Default DataValidation Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

def :: DataValidation #

NFData DataValidation Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

rnf :: DataValidation -> () #

Eq DataValidation Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

(==) :: DataValidation -> DataValidation -> Bool #

(/=) :: DataValidation -> DataValidation -> Bool #

FromCursor DataValidation Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

fromCursor :: Cursor -> [DataValidation] Source #

FromXenoNode DataValidation Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

fromXenoNode :: Node -> Either Text DataValidation Source #

ToElement DataValidation Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

toElement :: Name -> DataValidation -> Element Source #

type Rep DataValidation Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

type Rep DataValidation = D1 ('MetaData "DataValidation" "Codec.Xlsx.Types.DataValidation" "xlsx-1.1.2.1-GdAjj0zF0PPpPuMGO3FJH" 'False) (C1 ('MetaCons "DataValidation" 'PrefixI 'True) (((S1 ('MetaSel ('Just "_dvAllowBlank") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool) :*: S1 ('MetaSel ('Just "_dvError") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Text))) :*: (S1 ('MetaSel ('Just "_dvErrorStyle") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 ErrorStyle) :*: (S1 ('MetaSel ('Just "_dvErrorTitle") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Text)) :*: S1 ('MetaSel ('Just "_dvPrompt") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Text))))) :*: ((S1 ('MetaSel ('Just "_dvPromptTitle") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Text)) :*: S1 ('MetaSel ('Just "_dvShowDropDown") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool)) :*: (S1 ('MetaSel ('Just "_dvShowErrorMessage") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool) :*: (S1 ('MetaSel ('Just "_dvShowInputMessage") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool) :*: S1 ('MetaSel ('Just "_dvValidationType") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 ValidationType))))))

data ListOrRangeExpression Source #

Constructors

ListExpression ValidationList

a plain list of elements

RangeExpression Range

a cell or range reference

Instances

Instances details
Generic ListOrRangeExpression Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Associated Types

type Rep ListOrRangeExpression :: Type -> Type #

Methods

from :: ListOrRangeExpression -> Rep ListOrRangeExpression x #

to :: Rep ListOrRangeExpression x -> ListOrRangeExpression #

Show ListOrRangeExpression Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

showsPrec :: Int -> ListOrRangeExpression -> ShowS #

show :: ListOrRangeExpression -> String #

showList :: [ListOrRangeExpression] -> ShowS #

NFData ListOrRangeExpression Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

rnf :: ListOrRangeExpression -> () #

Eq ListOrRangeExpression Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

Methods

(==) :: ListOrRangeExpression -> ListOrRangeExpression -> Bool #

(/=) :: ListOrRangeExpression -> ListOrRangeExpression -> Bool #

type Rep ListOrRangeExpression Source # 
Instance details

Defined in Codec.Xlsx.Types.DataValidation

type Rep ListOrRangeExpression = D1 ('MetaData "ListOrRangeExpression" "Codec.Xlsx.Types.DataValidation" "xlsx-1.1.2.1-GdAjj0zF0PPpPuMGO3FJH" 'False) (C1 ('MetaCons "ListExpression" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 ValidationList)) :+: C1 ('MetaCons "RangeExpression" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Range)))

type ValidationList = [Text] Source #

maybePlainValidationList :: ValidationType -> Maybe ValidationList Source #

Attempt to obtain a plain list expression

maybeValidationRange :: ValidationType -> Maybe Range Source #

Attempt to obtain a range expression

readValidationType :: Text -> Text -> Cursor -> [ValidationType] Source #

readListFormulas :: Formula -> Maybe ListOrRangeExpression Source #

readOpExpression2 :: Text -> Cursor -> [ValidationExpression] Source #

readValidationTypeOpExp :: Text -> ValidationExpression -> [ValidationType] Source #

readValExpression :: Text -> [Formula] -> [ValidationExpression] Source #

viewValidationExpression :: ValidationExpression -> (Text, Formula, Maybe Formula) Source #