xlsx-1.1.4: Simple and incomplete Excel file parser/writer

Safe Haskell | None
Language | Haskell2010

Codec.Xlsx.Types.DataValidation

Synopsis

- data ValidationExpression
  - = ValBetween Formula Formula
  - | ValEqual Formula
  - | ValGreaterThan Formula
  - | ValGreaterThanOrEqual Formula
  - | ValLessThan Formula
  - | ValLessThanOrEqual Formula
  - | ValNotBetween Formula Formula
  - | ValNotEqual Formula
- 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
  - = ErrorStyleInformation
  - | ErrorStyleStop
  - | ErrorStyleWarning
- data DataValidation = DataValidation {
  - _dvAllowBlank :: Bool
  - _dvError :: Maybe Text
  - _dvErrorStyle :: ErrorStyle
  - _dvErrorTitle :: Maybe Text
  - _dvPrompt :: Maybe Text
  - _dvPromptTitle :: Maybe Text
  - _dvShowDropDown :: Bool
  - _dvShowErrorMessage :: Bool
  - _dvShowInputMessage :: Bool
  - _dvValidationType :: ValidationType
  }
- data ListOrRangeExpression
  - = ListExpression ValidationList
  - | RangeExpression Range
- 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

Instances details

NFData ValidationExpression Source # |
Instance details Defined in Codec.Xlsx.Types.DataValidation Methods rnf :: ValidationExpression -> () Source #
Generic ValidationExpression Source # |

Instance details

Defined in Codec.Xlsx.Types.DataValidation

Associated Types

type Rep ValidationExpression |

Instance details

Defined in Codec.Xlsx.Types.DataValidation

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

Methods

from :: ValidationExpression -> Rep ValidationExpression x Source #

to :: Rep ValidationExpression x -> ValidationExpression Source #

Show ValidationExpression Source # |
Instance details Defined in Codec.Xlsx.Types.DataValidation Methods showsPrec :: Int -> ValidationExpression -> ShowS Source # show :: ValidationExpression -> String Source # showList :: [ValidationExpression] -> ShowS Source #
Eq ValidationExpression Source # |
Instance details Defined in Codec.Xlsx.Types.DataValidation Methods (==) :: ValidationExpression -> ValidationExpression -> Bool Source # (/=) :: ValidationExpression -> ValidationExpression -> Bool Source #
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.4-G0KawmQS4mL8oRGRTaTy8Y" '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

NFData ValidationType Source # |
Instance details Defined in Codec.Xlsx.Types.DataValidation Methods rnf :: ValidationType -> () Source #
Generic ValidationType Source # |

Instance details

Defined in Codec.Xlsx.Types.DataValidation

Associated Types

type Rep ValidationType |

Instance details

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)))))

Methods

from :: ValidationType -> Rep ValidationType x Source #

to :: Rep ValidationType x -> ValidationType Source #

Show ValidationType Source # |
Instance details Defined in Codec.Xlsx.Types.DataValidation Methods showsPrec :: Int -> ValidationType -> ShowS Source # show :: ValidationType -> String Source # showList :: [ValidationType] -> ShowS Source #
Eq ValidationType Source # |
Instance details Defined in Codec.Xlsx.Types.DataValidation Methods (==) :: ValidationType -> ValidationType -> Bool Source # (/=) :: ValidationType -> ValidationType -> Bool Source #
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.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)))))

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

NFData ErrorStyle Source # |
Instance details Defined in Codec.Xlsx.Types.DataValidation Methods rnf :: ErrorStyle -> () Source #
Generic ErrorStyle Source # |

Instance details

Defined in Codec.Xlsx.Types.DataValidation

Associated Types

type Rep ErrorStyle |

Instance details

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)))

Methods

from :: ErrorStyle -> Rep ErrorStyle x Source #

to :: Rep ErrorStyle x -> ErrorStyle Source #

Show ErrorStyle Source # |
Instance details Defined in Codec.Xlsx.Types.DataValidation Methods showsPrec :: Int -> ErrorStyle -> ShowS Source # show :: ErrorStyle -> String Source # showList :: [ErrorStyle] -> ShowS Source #
Eq ErrorStyle Source # |
Instance details Defined in Codec.Xlsx.Types.DataValidation Methods (==) :: ErrorStyle -> ErrorStyle -> Bool Source # (/=) :: ErrorStyle -> ErrorStyle -> Bool Source #
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.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

- _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

Instances details

Default DataValidation Source # |
Instance details Defined in Codec.Xlsx.Types.DataValidation Methods def :: DataValidation Source #
NFData DataValidation Source # |
Instance details Defined in Codec.Xlsx.Types.DataValidation Methods rnf :: DataValidation -> () Source #
Generic DataValidation Source # |

Instance details

Defined in Codec.Xlsx.Types.DataValidation

Associated Types

type Rep DataValidation |

Instance details

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))))))

Methods

from :: DataValidation -> Rep DataValidation x Source #

to :: Rep DataValidation x -> DataValidation Source #

Show DataValidation Source # |
Instance details Defined in Codec.Xlsx.Types.DataValidation Methods showsPrec :: Int -> DataValidation -> ShowS Source # show :: DataValidation -> String Source # showList :: [DataValidation] -> ShowS Source #
Eq DataValidation Source # |
Instance details Defined in Codec.Xlsx.Types.DataValidation Methods (==) :: DataValidation -> DataValidation -> Bool Source # (/=) :: DataValidation -> DataValidation -> Bool Source #
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.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

Instances details

NFData ListOrRangeExpression Source # |
Instance details Defined in Codec.Xlsx.Types.DataValidation Methods rnf :: ListOrRangeExpression -> () Source #
Generic ListOrRangeExpression Source # |

Instance details

Defined in Codec.Xlsx.Types.DataValidation

Associated Types

type Rep ListOrRangeExpression |

Instance details

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)))

Methods

from :: ListOrRangeExpression -> Rep ListOrRangeExpression x Source #

to :: Rep ListOrRangeExpression x -> ListOrRangeExpression Source #

Show ListOrRangeExpression Source # |
Instance details Defined in Codec.Xlsx.Types.DataValidation Methods showsPrec :: Int -> ListOrRangeExpression -> ShowS Source # show :: ListOrRangeExpression -> String Source # showList :: [ListOrRangeExpression] -> ShowS Source #
Eq ListOrRangeExpression Source # |
Instance details Defined in Codec.Xlsx.Types.DataValidation Methods (==) :: ListOrRangeExpression -> ListOrRangeExpression -> Bool Source # (/=) :: ListOrRangeExpression -> ListOrRangeExpression -> Bool Source #
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.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 #

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 #