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

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

ToAttrVal ValidationType

Methods

toAttrVal :: ValidationType -> Text

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

ToAttrVal ErrorStyle

Methods

toAttrVal :: ErrorStyle -> Text

FromAttrVal ErrorStyle

Methods

fromAttrVal :: Reader ErrorStyle

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

Default DataValidation

Methods

def :: DataValidation

ToElement DataValidation

Methods

toElement :: Name -> DataValidation -> Element

FromCursor DataValidation

Methods

fromCursor :: Cursor -> [DataValidation]

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]

readListFormula :: Formula -> [[Text]]

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

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

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

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