Codec.Xlsx.Types.DataValidation

Documentation

data ValidationExpression

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

Eq ValidationExpression

Defined in Codec.Xlsx.Types.DataValidation

Methods

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

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

Show ValidationExpression

Defined in Codec.Xlsx.Types.DataValidation

Methods

showsPrec :: Int -> ValidationExpression -> ShowS

show :: ValidationExpression -> String

showList :: [ValidationExpression] -> ShowS

Generic ValidationExpression

Defined in Codec.Xlsx.Types.DataValidation

Associated Types

type Rep ValidationExpression :: Type -> Type

Methods

from :: ValidationExpression -> Rep ValidationExpression x

to :: Rep ValidationExpression x -> ValidationExpression

NFData ValidationExpression

Defined in Codec.Xlsx.Types.DataValidation

Methods

rnf :: ValidationExpression -> ()

type Rep ValidationExpression

Defined in Codec.Xlsx.Types.DataValidation

type Rep ValidationExpression = D1 ('MetaData "ValidationExpression" "Codec.Xlsx.Types.DataValidation" "xlsx-1.0.0.1-inplace" '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

Constructors

ValidationTypeNone

ValidationTypeCustom Formula

ValidationTypeDate ValidationExpression

ValidationTypeDecimal ValidationExpression

ValidationTypeList [Text]

ValidationTypeTextLength ValidationExpression

ValidationTypeTime ValidationExpression

ValidationTypeWhole ValidationExpression

Instances

Eq ValidationType

Defined in Codec.Xlsx.Types.DataValidation

Methods

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

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

Show ValidationType

Defined in Codec.Xlsx.Types.DataValidation

Methods

showsPrec :: Int -> ValidationType -> ShowS

show :: ValidationType -> String

showList :: [ValidationType] -> ShowS

Generic ValidationType

Defined in Codec.Xlsx.Types.DataValidation

Associated Types

type Rep ValidationType :: Type -> Type

Methods

from :: ValidationType -> Rep ValidationType x

to :: Rep ValidationType x -> ValidationType

NFData ValidationType

Defined in Codec.Xlsx.Types.DataValidation

Methods

rnf :: ValidationType -> ()

ToAttrVal ValidationType

Defined in Codec.Xlsx.Types.DataValidation

Methods

toAttrVal :: ValidationType -> Text

type Rep ValidationType

Defined in Codec.Xlsx.Types.DataValidation

type Rep ValidationType = D1 ('MetaData "ValidationType" "Codec.Xlsx.Types.DataValidation" "xlsx-1.0.0.1-inplace" '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 [Text])) :+: 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)))))

data ErrorStyle

Constructors

ErrorStyleInformation

ErrorStyleStop

ErrorStyleWarning

Instances

Eq ErrorStyle

Defined in Codec.Xlsx.Types.DataValidation

Methods

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

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

Show ErrorStyle

Defined in Codec.Xlsx.Types.DataValidation

Methods

showsPrec :: Int -> ErrorStyle -> ShowS

show :: ErrorStyle -> String

showList :: [ErrorStyle] -> ShowS

Generic ErrorStyle

Defined in Codec.Xlsx.Types.DataValidation

Associated Types

type Rep ErrorStyle :: Type -> Type

Methods

from :: ErrorStyle -> Rep ErrorStyle x

to :: Rep ErrorStyle x -> ErrorStyle

NFData ErrorStyle

Defined in Codec.Xlsx.Types.DataValidation

Methods

rnf :: ErrorStyle -> ()

FromAttrBs ErrorStyle

Defined in Codec.Xlsx.Types.DataValidation

Methods

fromAttrBs :: ByteString -> Either Text ErrorStyle

FromAttrVal ErrorStyle

Defined in Codec.Xlsx.Types.DataValidation

Methods

fromAttrVal :: Reader ErrorStyle

ToAttrVal ErrorStyle

Defined in Codec.Xlsx.Types.DataValidation

Methods

toAttrVal :: ErrorStyle -> Text

type Rep ErrorStyle

Defined in Codec.Xlsx.Types.DataValidation

type Rep ErrorStyle = D1 ('MetaData "ErrorStyle" "Codec.Xlsx.Types.DataValidation" "xlsx-1.0.0.1-inplace" '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

Constructors

DataValidation

Fields

• _dvAllowBlank :: Bool
• _dvError :: Maybe Text
• _dvErrorStyle :: ErrorStyle
• _dvErrorTitle :: Maybe Text
• _dvPrompt :: Maybe Text
• _dvPromptTitle :: Maybe Text
• _dvShowDropDown :: Bool
• _dvShowErrorMessage :: Bool
• _dvShowInputMessage :: Bool
• _dvValidationType :: ValidationType

Instances

Eq DataValidation

Defined in Codec.Xlsx.Types.DataValidation

Methods

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

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

Show DataValidation

Defined in Codec.Xlsx.Types.DataValidation

Methods

showsPrec :: Int -> DataValidation -> ShowS

show :: DataValidation -> String

showList :: [DataValidation] -> ShowS

Generic DataValidation

Defined in Codec.Xlsx.Types.DataValidation

Associated Types

type Rep DataValidation :: Type -> Type

Methods

from :: DataValidation -> Rep DataValidation x

to :: Rep DataValidation x -> DataValidation

NFData DataValidation

Defined in Codec.Xlsx.Types.DataValidation

Methods

rnf :: DataValidation -> ()

FromXenoNode DataValidation

Defined in Codec.Xlsx.Types.DataValidation

Methods

fromXenoNode :: Node -> Either Text DataValidation

Default DataValidation

Defined in Codec.Xlsx.Types.DataValidation

Methods

def :: DataValidation

FromCursor DataValidation

Defined in Codec.Xlsx.Types.DataValidation

Methods

fromCursor :: Cursor -> [DataValidation]

ToElement DataValidation

Defined in Codec.Xlsx.Types.DataValidation

Methods

toElement :: Name -> DataValidation -> Element

type Rep DataValidation

Defined in Codec.Xlsx.Types.DataValidation

type Rep DataValidation = D1 ('MetaData "DataValidation" "Codec.Xlsx.Types.DataValidation" "xlsx-1.0.0.1-inplace" '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))))))

dvValidationType :: Lens' DataValidation ValidationType

dvShowInputMessage :: Lens' DataValidation Bool

dvShowErrorMessage :: Lens' DataValidation Bool

dvShowDropDown :: Lens' DataValidation Bool

dvPromptTitle :: Lens' DataValidation (Maybe Text)

dvPrompt :: Lens' DataValidation (Maybe Text)

dvErrorTitle :: Lens' DataValidation (Maybe Text)

dvErrorStyle :: Lens' DataValidation ErrorStyle

dvError :: Lens' DataValidation (Maybe Text)

dvAllowBlank :: Lens' DataValidation Bool

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

readListFormulas :: Formula -> Maybe [Text]

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

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

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

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