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

Methods

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

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

Show ValidationExpression

Methods

showsPrec :: Int -> ValidationExpression -> ShowS

show :: ValidationExpression -> String

showList :: [ValidationExpression] -> ShowS

Generic ValidationExpression

Associated Types

type Rep ValidationExpression :: * -> *

Methods

from :: ValidationExpression -> Rep ValidationExpression x

to :: Rep ValidationExpression x -> ValidationExpression

NFData ValidationExpression

Methods

rnf :: ValidationExpression -> ()

type Rep ValidationExpression

type Rep ValidationExpression = D1 * (MetaData "ValidationExpression" "Codec.Xlsx.Types.DataValidation" "xlsx-0.7.0-67d30z0rd5vGH8ecLQYdXm" False) ((:+:) * ((:+:) * ((:+:) * (C1 * (MetaCons "ValBetween" PrefixI False) ((:*:) * (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula)) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula)))) (C1 * (MetaCons "ValEqual" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula)))) ((:+:) * (C1 * (MetaCons "ValGreaterThan" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula))) (C1 * (MetaCons "ValGreaterThanOrEqual" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula))))) ((:+:) * ((:+:) * (C1 * (MetaCons "ValLessThan" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula))) (C1 * (MetaCons "ValLessThanOrEqual" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula)))) ((:+:) * (C1 * (MetaCons "ValNotBetween" PrefixI False) ((:*:) * (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula)) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula)))) (C1 * (MetaCons "ValNotEqual" PrefixI False) (S1 * (MetaSel (Nothing 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

Methods

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

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

Show ValidationType

Methods

showsPrec :: Int -> ValidationType -> ShowS

show :: ValidationType -> String

showList :: [ValidationType] -> ShowS

Generic ValidationType

Associated Types

type Rep ValidationType :: * -> *

Methods

from :: ValidationType -> Rep ValidationType x

to :: Rep ValidationType x -> ValidationType

NFData ValidationType

Methods

rnf :: ValidationType -> ()

ToAttrVal ValidationType

Methods

toAttrVal :: ValidationType -> Text

type Rep ValidationType

type Rep ValidationType = D1 * (MetaData "ValidationType" "Codec.Xlsx.Types.DataValidation" "xlsx-0.7.0-67d30z0rd5vGH8ecLQYdXm" False) ((:+:) * ((:+:) * ((:+:) * (C1 * (MetaCons "ValidationTypeNone" PrefixI False) (U1 *)) (C1 * (MetaCons "ValidationTypeCustom" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula)))) ((:+:) * (C1 * (MetaCons "ValidationTypeDate" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * ValidationExpression))) (C1 * (MetaCons "ValidationTypeDecimal" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * ValidationExpression))))) ((:+:) * ((:+:) * (C1 * (MetaCons "ValidationTypeList" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * [Text]))) (C1 * (MetaCons "ValidationTypeTextLength" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * ValidationExpression)))) ((:+:) * (C1 * (MetaCons "ValidationTypeTime" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * ValidationExpression))) (C1 * (MetaCons "ValidationTypeWhole" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * ValidationExpression))))))

data ErrorStyle

Constructors

ErrorStyleInformation

ErrorStyleStop

ErrorStyleWarning

Instances

Eq ErrorStyle

Methods

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

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

Show ErrorStyle

Methods

showsPrec :: Int -> ErrorStyle -> ShowS

show :: ErrorStyle -> String

showList :: [ErrorStyle] -> ShowS

Generic ErrorStyle

Associated Types

type Rep ErrorStyle :: * -> *

Methods

from :: ErrorStyle -> Rep ErrorStyle x

to :: Rep ErrorStyle x -> ErrorStyle

NFData ErrorStyle

Methods

rnf :: ErrorStyle -> ()

FromAttrBs ErrorStyle

Methods

fromAttrBs :: ByteString -> Either Text ErrorStyle

FromAttrVal ErrorStyle

Methods

fromAttrVal :: Reader ErrorStyle

ToAttrVal ErrorStyle

Methods

toAttrVal :: ErrorStyle -> Text

type Rep ErrorStyle

type Rep ErrorStyle = D1 * (MetaData "ErrorStyle" "Codec.Xlsx.Types.DataValidation" "xlsx-0.7.0-67d30z0rd5vGH8ecLQYdXm" False) ((:+:) * (C1 * (MetaCons "ErrorStyleInformation" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "ErrorStyleStop" PrefixI False) (U1 *)) (C1 * (MetaCons "ErrorStyleWarning" PrefixI False) (U1 *))))

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

Methods

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

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

Show DataValidation

Methods

showsPrec :: Int -> DataValidation -> ShowS

show :: DataValidation -> String

showList :: [DataValidation] -> ShowS

Generic DataValidation

Associated Types

type Rep DataValidation :: * -> *

Methods

from :: DataValidation -> Rep DataValidation x

to :: Rep DataValidation x -> DataValidation

Default DataValidation

Methods

def :: DataValidation

NFData DataValidation

Methods

rnf :: DataValidation -> ()

FromXenoNode DataValidation

Methods

fromXenoNode :: Node -> Either Text DataValidation

FromCursor DataValidation

Methods

fromCursor :: Cursor -> [DataValidation]

ToElement DataValidation

Methods

toElement :: Name -> DataValidation -> Element

type Rep DataValidation

type Rep DataValidation = D1 * (MetaData "DataValidation" "Codec.Xlsx.Types.DataValidation" "xlsx-0.7.0-67d30z0rd5vGH8ecLQYdXm" False) (C1 * (MetaCons "DataValidation" PrefixI True) ((:*:) * ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_dvAllowBlank") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Bool)) (S1 * (MetaSel (Just Symbol "_dvError") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Text)))) ((:*:) * (S1 * (MetaSel (Just Symbol "_dvErrorStyle") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * ErrorStyle)) ((:*:) * (S1 * (MetaSel (Just Symbol "_dvErrorTitle") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Text))) (S1 * (MetaSel (Just Symbol "_dvPrompt") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Text)))))) ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_dvPromptTitle") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Text))) (S1 * (MetaSel (Just Symbol "_dvShowDropDown") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Bool))) ((:*:) * (S1 * (MetaSel (Just Symbol "_dvShowErrorMessage") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Bool)) ((:*:) * (S1 * (MetaSel (Just Symbol "_dvShowInputMessage") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Bool)) (S1 * (MetaSel (Just Symbol "_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)