| Safe Haskell | None |
|---|---|
| Language | Haskell2010 |
Codec.Xlsx.Types.DataValidation
Synopsis
- data ValidationExpression
- data ValidationType
- = ValidationTypeNone
- | ValidationTypeCustom Formula
- | ValidationTypeDate ValidationExpression
- | ValidationTypeDecimal ValidationExpression
- | ValidationTypeList ListOrRangeExpression
- | ValidationTypeTextLength ValidationExpression
- | ValidationTypeTime ValidationExpression
- | ValidationTypeWhole ValidationExpression
- dvAllowBlank :: Lens' DataValidation Bool
- dvError :: Lens' DataValidation (Maybe Text)
- dvErrorStyle :: Lens' DataValidation ErrorStyle
- dvErrorTitle :: Lens' DataValidation (Maybe Text)
- dvPrompt :: Lens' DataValidation (Maybe Text)
- dvPromptTitle :: Lens' DataValidation (Maybe Text)
- dvShowDropDown :: Lens' DataValidation Bool
- dvShowErrorMessage :: Lens' DataValidation Bool
- dvShowInputMessage :: Lens' DataValidation Bool
- dvValidationType :: Lens' DataValidation ValidationType
- data ErrorStyle
- data DataValidation = DataValidation {}
- data ListOrRangeExpression
- type ValidationList = [Text]
- maybePlainValidationList :: ValidationType -> Maybe ValidationList
- maybeValidationRange :: ValidationType -> Maybe Range
- readValidationType :: Text -> Text -> Cursor -> [ValidationType]
- readListFormulas :: Formula -> Maybe ListOrRangeExpression
- readOpExpression2 :: Text -> Cursor -> [ValidationExpression]
- readValidationTypeOpExp :: Text -> ValidationExpression -> [ValidationType]
- readValExpression :: Text -> [Formula] -> [ValidationExpression]
- viewValidationExpression :: ValidationExpression -> (Text, Formula, Maybe Formula)
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
data ValidationType Source #
Constructors
| ValidationTypeNone | |
| ValidationTypeCustom Formula | |
| ValidationTypeDate ValidationExpression | |
| ValidationTypeDecimal ValidationExpression | |
| ValidationTypeList ListOrRangeExpression | |
| ValidationTypeTextLength ValidationExpression | |
| ValidationTypeTime ValidationExpression | |
| ValidationTypeWhole ValidationExpression |
Instances
| NFData ValidationType Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Methods rnf :: ValidationType -> () Source # | |||||
| Generic ValidationType Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Associated Types
Methods from :: ValidationType -> Rep ValidationType x Source # to :: Rep ValidationType x -> ValidationType Source # | |||||
| Show ValidationType Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation | |||||
| Eq ValidationType Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Methods (==) :: ValidationType -> ValidationType -> Bool Source # (/=) :: ValidationType -> ValidationType -> Bool Source # | |||||
| ToAttrVal ValidationType Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Methods toAttrVal :: ValidationType -> Text Source # | |||||
| type Rep ValidationType Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation type Rep ValidationType = D1 ('MetaData "ValidationType" "Codec.Xlsx.Types.DataValidation" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" '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))))) | |||||
data ErrorStyle Source #
Constructors
| ErrorStyleInformation | |
| ErrorStyleStop | |
| ErrorStyleWarning |
Instances
| NFData ErrorStyle Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Methods rnf :: ErrorStyle -> () Source # | |||||
| Generic ErrorStyle Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Associated Types
| |||||
| Show ErrorStyle Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation | |||||
| Eq ErrorStyle Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Methods (==) :: ErrorStyle -> ErrorStyle -> Bool Source # (/=) :: ErrorStyle -> ErrorStyle -> Bool Source # | |||||
| FromAttrVal ErrorStyle Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Methods | |||||
| FromAttrBs ErrorStyle Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Methods fromAttrBs :: ByteString -> Either Text ErrorStyle Source # | |||||
| ToAttrVal ErrorStyle Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Methods toAttrVal :: ErrorStyle -> Text Source # | |||||
| type Rep ErrorStyle Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation type Rep ErrorStyle = D1 ('MetaData "ErrorStyle" "Codec.Xlsx.Types.DataValidation" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" '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
| Default DataValidation Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Methods def :: DataValidation Source # | |||||
| NFData DataValidation Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Methods rnf :: DataValidation -> () Source # | |||||
| Generic DataValidation Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Associated Types
Methods from :: DataValidation -> Rep DataValidation x Source # to :: Rep DataValidation x -> DataValidation Source # | |||||
| Show DataValidation Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation | |||||
| Eq DataValidation Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Methods (==) :: DataValidation -> DataValidation -> Bool Source # (/=) :: DataValidation -> DataValidation -> Bool Source # | |||||
| FromCursor DataValidation Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Methods fromCursor :: Cursor -> [DataValidation] Source # | |||||
| FromXenoNode DataValidation Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Methods fromXenoNode :: Node -> Either Text DataValidation Source # | |||||
| ToElement DataValidation Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation | |||||
| type Rep DataValidation Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation type Rep DataValidation = D1 ('MetaData "DataValidation" "Codec.Xlsx.Types.DataValidation" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" '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
| NFData ListOrRangeExpression Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Methods rnf :: ListOrRangeExpression -> () Source # | |||||
| Generic ListOrRangeExpression Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Associated Types
Methods from :: ListOrRangeExpression -> Rep ListOrRangeExpression x Source # to :: Rep ListOrRangeExpression x -> ListOrRangeExpression Source # | |||||
| Show ListOrRangeExpression Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation | |||||
| Eq ListOrRangeExpression Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation Methods (==) :: ListOrRangeExpression -> ListOrRangeExpression -> Bool Source # (/=) :: ListOrRangeExpression -> ListOrRangeExpression -> Bool Source # | |||||
| type Rep ListOrRangeExpression Source # | |||||
Defined in Codec.Xlsx.Types.DataValidation type Rep ListOrRangeExpression = D1 ('MetaData "ListOrRangeExpression" "Codec.Xlsx.Types.DataValidation" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" '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 #
readOpExpression2 :: Text -> Cursor -> [ValidationExpression] Source #
readValExpression :: Text -> [Formula] -> [ValidationExpression] Source #