| Safe Haskell | None |
|---|---|
| Language | Haskell2010 |
Codec.Xlsx.Types.ConditionalFormatting
Synopsis
- type ConditionalFormatting = [CfRule]
- data CfRule = CfRule {}
- newtype NStdDev = NStdDev Int
- data Inclusion
- data CfValue
- data MinCfValue
- data MaxCfValue
- data Condition
- = AboveAverage Inclusion (Maybe NStdDev)
- | BeginsWith Text
- | BelowAverage Inclusion (Maybe NStdDev)
- | BottomNPercent Int
- | BottomNValues Int
- | CellIs OperatorExpression
- | ColorScale2 MinCfValue Color MaxCfValue Color
- | ColorScale3 MinCfValue Color CfValue Color MaxCfValue Color
- | ContainsBlanks
- | ContainsErrors
- | ContainsText Text
- | DataBar DataBarOptions
- | DoesNotContainErrors
- | DoesNotContainBlanks
- | DoesNotContainText Text
- | DuplicateValues
- | EndsWith Text
- | Expression Formula
- | IconSet IconSetOptions
- | InTimePeriod TimePeriod
- | TopNPercent Int
- | TopNValues Int
- | UniqueValues
- data OperatorExpression
- data TimePeriod
- data IconSetOptions = IconSetOptions {
- _isoIconSet :: IconSetType
- _isoValues :: [CfValue]
- _isoReverse :: Bool
- _isoShowValue :: Bool
- data IconSetType
- = IconSet3Arrows
- | IconSet3ArrowsGray
- | IconSet3Flags
- | IconSet3Signs
- | IconSet3Symbols
- | IconSet3Symbols2
- | IconSet3TrafficLights1
- | IconSet3TrafficLights2
- | IconSet4Arrows
- | IconSet4ArrowsGray
- | IconSet4Rating
- | IconSet4RedToBlack
- | IconSet4TrafficLights
- | IconSet5Arrows
- | IconSet5ArrowsGray
- | IconSet5Quarters
- | IconSet5Rating
- data DataBarOptions = DataBarOptions {}
- dataBarWithColor :: Color -> Condition
- cfrCondition :: Lens' CfRule Condition
- cfrDxfId :: Lens' CfRule (Maybe Int)
- cfrPriority :: Lens' CfRule Int
- cfrStopIfTrue :: Lens' CfRule (Maybe Bool)
- isoIconSet :: Lens' IconSetOptions IconSetType
- isoValues :: Lens' IconSetOptions [CfValue]
- isoReverse :: Lens' IconSetOptions Bool
- isoShowValue :: Lens' IconSetOptions Bool
- dboMaxLength :: Lens' DataBarOptions Int
- dboMinLength :: Lens' DataBarOptions Int
- dboShowValue :: Lens' DataBarOptions Bool
- dboMinimum :: Lens' DataBarOptions MinCfValue
- dboMaximum :: Lens' DataBarOptions MaxCfValue
- dboColor :: Lens' DataBarOptions Color
- topCfPriority :: Int
Documentation
type ConditionalFormatting = [CfRule] Source #
This collection represents a description of a conditional formatting rule.
See 18.3.1.10 "cfRule (Conditional Formatting Rule)" (p. 1602)
Constructors
| CfRule | |
Fields
| |
Instances
The number of standard deviations to include above or below the average in the conditional formatting rule.
Instances
| NFData NStdDev Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| Generic NStdDev Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Associated Types
| |||||
| Show NStdDev Source # | |||||
| Eq NStdDev Source # | |||||
| Ord NStdDev Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| FromAttrVal NStdDev Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods | |||||
| FromAttrBs NStdDev Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods fromAttrBs :: ByteString -> Either Text NStdDev Source # | |||||
| ToAttrVal NStdDev Source # | |||||
| type Rep NStdDev Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
Flag indicating whether the aboveAverage and belowAverage
criteria is inclusive of the average itself, or exclusive of that
value.
Instances
| NFData Inclusion Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| Generic Inclusion Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Associated Types
| |||||
| Show Inclusion Source # | |||||
| Eq Inclusion Source # | |||||
| Ord Inclusion Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| FromAttrVal Inclusion Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods | |||||
| FromAttrBs Inclusion Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods fromAttrBs :: ByteString -> Either Text Inclusion Source # | |||||
| ToAttrVal Inclusion Source # | |||||
| type Rep Inclusion Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
Describes the values of the interpolation points in a color scale, data bar or icon set conditional formatting rules.
See 18.3.1.11 "cfvo (Conditional Format Value Object)" (p. 1604)
Instances
| NFData CfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| Generic CfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Associated Types
| |||||
| Show CfValue Source # | |||||
| Eq CfValue Source # | |||||
| Ord CfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| FromCursor CfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods fromCursor :: Cursor -> [CfValue] Source # | |||||
| FromXenoNode CfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| ToElement CfValue Source # | |||||
| type Rep CfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting type Rep CfValue = D1 ('MetaData "CfValue" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" 'False) ((C1 ('MetaCons "CfValue" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Double)) :+: C1 ('MetaCons "CfPercent" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Double))) :+: (C1 ('MetaCons "CfPercentile" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Double)) :+: C1 ('MetaCons "CfFormula" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)))) | |||||
data MinCfValue Source #
Constructors
| CfvMin | |
| MinCfValue CfValue |
Instances
| NFData MinCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods rnf :: MinCfValue -> () Source # | |||||
| Generic MinCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Associated Types
| |||||
| Show MinCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| Eq MinCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods (==) :: MinCfValue -> MinCfValue -> Bool Source # (/=) :: MinCfValue -> MinCfValue -> Bool Source # | |||||
| Ord MinCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods compare :: MinCfValue -> MinCfValue -> Ordering Source # (<) :: MinCfValue -> MinCfValue -> Bool Source # (<=) :: MinCfValue -> MinCfValue -> Bool Source # (>) :: MinCfValue -> MinCfValue -> Bool Source # (>=) :: MinCfValue -> MinCfValue -> Bool Source # max :: MinCfValue -> MinCfValue -> MinCfValue Source # min :: MinCfValue -> MinCfValue -> MinCfValue Source # | |||||
| FromCursor MinCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods fromCursor :: Cursor -> [MinCfValue] Source # | |||||
| FromXenoNode MinCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods fromXenoNode :: Node -> Either Text MinCfValue Source # | |||||
| ToElement MinCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| type Rep MinCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting type Rep MinCfValue = D1 ('MetaData "MinCfValue" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" 'False) (C1 ('MetaCons "CfvMin" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "MinCfValue" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 CfValue))) | |||||
data MaxCfValue Source #
Constructors
| CfvMax | |
| MaxCfValue CfValue |
Instances
| NFData MaxCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods rnf :: MaxCfValue -> () Source # | |||||
| Generic MaxCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Associated Types
| |||||
| Show MaxCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| Eq MaxCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods (==) :: MaxCfValue -> MaxCfValue -> Bool Source # (/=) :: MaxCfValue -> MaxCfValue -> Bool Source # | |||||
| Ord MaxCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods compare :: MaxCfValue -> MaxCfValue -> Ordering Source # (<) :: MaxCfValue -> MaxCfValue -> Bool Source # (<=) :: MaxCfValue -> MaxCfValue -> Bool Source # (>) :: MaxCfValue -> MaxCfValue -> Bool Source # (>=) :: MaxCfValue -> MaxCfValue -> Bool Source # max :: MaxCfValue -> MaxCfValue -> MaxCfValue Source # min :: MaxCfValue -> MaxCfValue -> MaxCfValue Source # | |||||
| FromCursor MaxCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods fromCursor :: Cursor -> [MaxCfValue] Source # | |||||
| FromXenoNode MaxCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods fromXenoNode :: Node -> Either Text MaxCfValue Source # | |||||
| ToElement MaxCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| type Rep MaxCfValue Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting type Rep MaxCfValue = D1 ('MetaData "MaxCfValue" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" 'False) (C1 ('MetaCons "CfvMax" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "MaxCfValue" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 CfValue))) | |||||
Conditions which could be used for conditional formatting
See 18.18.12 "ST_CfType (Conditional Format Type)" (p. 2443)
Constructors
| AboveAverage Inclusion (Maybe NStdDev) | This conditional formatting rule highlights cells that are above (or maybe equal to) the average for all values in the range. |
| BeginsWith Text | This conditional formatting rule highlights cells in the range that begin with the given text. Equivalent to using the LEFT() sheet function and comparing values. |
| BelowAverage Inclusion (Maybe NStdDev) | This conditional formatting rule highlights cells that are below the average for all values in the range. |
| BottomNPercent Int | This conditional formatting rule highlights cells whose values fall in the bottom N percent bracket. |
| BottomNValues Int | This conditional formatting rule highlights cells whose values fall in the bottom N bracket. |
| CellIs OperatorExpression | This conditional formatting rule compares a cell value to a formula calculated result, using an operator. |
| ColorScale2 MinCfValue Color MaxCfValue Color | This conditional formatting rule creates a gradated color scale on the cells with specified colors for specified minimum and maximum. |
| ColorScale3 MinCfValue Color CfValue Color MaxCfValue Color | This conditional formatting rule creates a gradated color scale on the cells with specified colors for specified minimum, midpoint and maximum. |
| ContainsBlanks | This conditional formatting rule highlights cells that are completely blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank. |
| ContainsErrors | This conditional formatting rule highlights cells with formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error. |
| ContainsText Text | This conditional formatting rule highlights cells containing given text. Equivalent to using the SEARCH() sheet function to determine whether the cell contains the text. |
| DataBar DataBarOptions | This conditional formatting rule displays a gradated data bar in the range of cells. |
| DoesNotContainErrors | This conditional formatting rule highlights cells without formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error. |
| DoesNotContainBlanks | This conditional formatting rule highlights cells that are not blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank. |
| DoesNotContainText Text | This conditional formatting rule highlights cells that do not contain given text. Equivalent to using the SEARCH() sheet function. |
| DuplicateValues | This conditional formatting rule highlights duplicated values. |
| EndsWith Text | This conditional formatting rule highlights cells ending with given text. Equivalent to using the RIGHT() sheet function and comparing values. |
| Expression Formula | This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted. |
| IconSet IconSetOptions | This conditional formatting rule applies icons to cells according to their values. |
| InTimePeriod TimePeriod | This conditional formatting rule highlights cells containing dates in the specified time period. The underlying value of the cell is evaluated, therefore the cell does not need to be formatted as a date to be evaluated. For example, with a cell containing the value 38913 the conditional format shall be applied if the rule requires a value of 7142006. |
| TopNPercent Int | This conditional formatting rule highlights cells whose values fall in the top N percent bracket. |
| TopNValues Int | This conditional formatting rule highlights cells whose values fall in the top N bracket. |
| UniqueValues | This conditional formatting rule highlights unique values in the range. |
Instances
| NFData Condition Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| Generic Condition Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Associated Types
| |||||
| Show Condition Source # | |||||
| Eq Condition Source # | |||||
| Ord Condition Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| type Rep Condition Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting type Rep Condition = D1 ('MetaData "Condition" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" 'False) ((((C1 ('MetaCons "AboveAverage" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Inclusion) :*: S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe NStdDev))) :+: C1 ('MetaCons "BeginsWith" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Text))) :+: (C1 ('MetaCons "BelowAverage" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Inclusion) :*: S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe NStdDev))) :+: (C1 ('MetaCons "BottomNPercent" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Int)) :+: C1 ('MetaCons "BottomNValues" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Int))))) :+: ((C1 ('MetaCons "CellIs" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 OperatorExpression)) :+: (C1 ('MetaCons "ColorScale2" 'PrefixI 'False) ((S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 MinCfValue) :*: S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Color)) :*: (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 MaxCfValue) :*: S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Color))) :+: C1 ('MetaCons "ColorScale3" 'PrefixI 'False) ((S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 MinCfValue) :*: (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Color) :*: S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 CfValue))) :*: (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Color) :*: (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 MaxCfValue) :*: S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Color)))))) :+: (C1 ('MetaCons "ContainsBlanks" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "ContainsErrors" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "ContainsText" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Text)))))) :+: (((C1 ('MetaCons "DataBar" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 DataBarOptions)) :+: (C1 ('MetaCons "DoesNotContainErrors" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "DoesNotContainBlanks" 'PrefixI 'False) (U1 :: Type -> Type))) :+: (C1 ('MetaCons "DoesNotContainText" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Text)) :+: (C1 ('MetaCons "DuplicateValues" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "EndsWith" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Text))))) :+: ((C1 ('MetaCons "Expression" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)) :+: (C1 ('MetaCons "IconSet" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 IconSetOptions)) :+: C1 ('MetaCons "InTimePeriod" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 TimePeriod)))) :+: (C1 ('MetaCons "TopNPercent" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Int)) :+: (C1 ('MetaCons "TopNValues" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Int)) :+: C1 ('MetaCons "UniqueValues" 'PrefixI 'False) (U1 :: Type -> Type)))))) | |||||
data OperatorExpression Source #
Logical operation used in CellIs condition
See 18.18.15 "ST_ConditionalFormattingOperator (Conditional Format Operators)" (p. 2446)
Constructors
| OpBeginsWith Formula | 'Begins with' operator |
| OpBetween Formula Formula |
|
| OpContainsText Formula |
|
| OpEndsWith Formula | 'Ends with' operator |
| OpEqual Formula | 'Equal to' operator |
| OpGreaterThan Formula | 'Greater than' operator |
| OpGreaterThanOrEqual Formula | 'Greater than or equal to' operator |
| OpLessThan Formula | 'Less than' operator |
| OpLessThanOrEqual Formula | 'Less than or equal to' operator |
| OpNotBetween Formula Formula | 'Not between' operator |
| OpNotContains Formula | 'Does not contain' operator |
| OpNotEqual Formula | 'Not equal to' operator |
Instances
| NFData OperatorExpression Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods rnf :: OperatorExpression -> () Source # | |||||
| Generic OperatorExpression Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Associated Types
Methods from :: OperatorExpression -> Rep OperatorExpression x Source # to :: Rep OperatorExpression x -> OperatorExpression Source # | |||||
| Show OperatorExpression Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| Eq OperatorExpression Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods (==) :: OperatorExpression -> OperatorExpression -> Bool Source # (/=) :: OperatorExpression -> OperatorExpression -> Bool Source # | |||||
| Ord OperatorExpression Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods compare :: OperatorExpression -> OperatorExpression -> Ordering Source # (<) :: OperatorExpression -> OperatorExpression -> Bool Source # (<=) :: OperatorExpression -> OperatorExpression -> Bool Source # (>) :: OperatorExpression -> OperatorExpression -> Bool Source # (>=) :: OperatorExpression -> OperatorExpression -> Bool Source # max :: OperatorExpression -> OperatorExpression -> OperatorExpression Source # min :: OperatorExpression -> OperatorExpression -> OperatorExpression Source # | |||||
| type Rep OperatorExpression Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting type Rep OperatorExpression = D1 ('MetaData "OperatorExpression" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" 'False) (((C1 ('MetaCons "OpBeginsWith" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)) :+: (C1 ('MetaCons "OpBetween" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula) :*: S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)) :+: C1 ('MetaCons "OpContainsText" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)))) :+: (C1 ('MetaCons "OpEndsWith" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)) :+: (C1 ('MetaCons "OpEqual" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)) :+: C1 ('MetaCons "OpGreaterThan" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula))))) :+: ((C1 ('MetaCons "OpGreaterThanOrEqual" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)) :+: (C1 ('MetaCons "OpLessThan" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)) :+: C1 ('MetaCons "OpLessThanOrEqual" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)))) :+: (C1 ('MetaCons "OpNotBetween" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula) :*: S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)) :+: (C1 ('MetaCons "OpNotContains" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)) :+: C1 ('MetaCons "OpNotEqual" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Formula)))))) | |||||
data TimePeriod Source #
Used in a "contains dates" conditional formatting rule. These are dynamic time periods, which change based on the date the conditional formatting is refreshed / applied.
See 18.18.82 "ST_TimePeriod (Time Period Types)" (p. 2508)
Constructors
| PerLast7Days | A date in the last seven days. |
| PerLastMonth | A date occuring in the last calendar month. |
| PerLastWeek | A date occuring last week. |
| PerNextMonth | A date occuring in the next calendar month. |
| PerNextWeek | A date occuring next week. |
| PerThisMonth | A date occuring in this calendar month. |
| PerThisWeek | A date occuring this week. |
| PerToday | Today's date. |
| PerTomorrow | Tomorrow's date. |
| PerYesterday | Yesterday's date. |
Instances
| NFData TimePeriod Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods rnf :: TimePeriod -> () Source # | |||||
| Generic TimePeriod Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Associated Types
| |||||
| Show TimePeriod Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| Eq TimePeriod Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods (==) :: TimePeriod -> TimePeriod -> Bool Source # (/=) :: TimePeriod -> TimePeriod -> Bool Source # | |||||
| Ord TimePeriod Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods compare :: TimePeriod -> TimePeriod -> Ordering Source # (<) :: TimePeriod -> TimePeriod -> Bool Source # (<=) :: TimePeriod -> TimePeriod -> Bool Source # (>) :: TimePeriod -> TimePeriod -> Bool Source # (>=) :: TimePeriod -> TimePeriod -> Bool Source # max :: TimePeriod -> TimePeriod -> TimePeriod Source # min :: TimePeriod -> TimePeriod -> TimePeriod Source # | |||||
| FromAttrVal TimePeriod Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods | |||||
| FromAttrBs TimePeriod Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods fromAttrBs :: ByteString -> Either Text TimePeriod Source # | |||||
| ToAttrVal TimePeriod Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods toAttrVal :: TimePeriod -> Text Source # | |||||
| type Rep TimePeriod Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting type Rep TimePeriod = D1 ('MetaData "TimePeriod" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" 'False) (((C1 ('MetaCons "PerLast7Days" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "PerLastMonth" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "PerLastWeek" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "PerNextMonth" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "PerNextWeek" 'PrefixI 'False) (U1 :: Type -> Type)))) :+: ((C1 ('MetaCons "PerThisMonth" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "PerThisWeek" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "PerToday" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "PerTomorrow" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "PerYesterday" 'PrefixI 'False) (U1 :: Type -> Type))))) | |||||
data IconSetOptions Source #
Describes an icon set conditional formatting rule.
See 18.3.1.49 "iconSet (Icon Set)" (p. 1645)
Constructors
| IconSetOptions | |
Fields
| |
Instances
| Default IconSetOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods def :: IconSetOptions Source # | |||||
| NFData IconSetOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods rnf :: IconSetOptions -> () Source # | |||||
| Generic IconSetOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Associated Types
Methods from :: IconSetOptions -> Rep IconSetOptions x Source # to :: Rep IconSetOptions x -> IconSetOptions Source # | |||||
| Show IconSetOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| Eq IconSetOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods (==) :: IconSetOptions -> IconSetOptions -> Bool Source # (/=) :: IconSetOptions -> IconSetOptions -> Bool Source # | |||||
| Ord IconSetOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods compare :: IconSetOptions -> IconSetOptions -> Ordering Source # (<) :: IconSetOptions -> IconSetOptions -> Bool Source # (<=) :: IconSetOptions -> IconSetOptions -> Bool Source # (>) :: IconSetOptions -> IconSetOptions -> Bool Source # (>=) :: IconSetOptions -> IconSetOptions -> Bool Source # max :: IconSetOptions -> IconSetOptions -> IconSetOptions Source # min :: IconSetOptions -> IconSetOptions -> IconSetOptions Source # | |||||
| FromCursor IconSetOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods fromCursor :: Cursor -> [IconSetOptions] Source # | |||||
| FromXenoNode IconSetOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods fromXenoNode :: Node -> Either Text IconSetOptions Source # | |||||
| ToElement IconSetOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| type Rep IconSetOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting type Rep IconSetOptions = D1 ('MetaData "IconSetOptions" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" 'False) (C1 ('MetaCons "IconSetOptions" 'PrefixI 'True) ((S1 ('MetaSel ('Just "_isoIconSet") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 IconSetType) :*: S1 ('MetaSel ('Just "_isoValues") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 [CfValue])) :*: (S1 ('MetaSel ('Just "_isoReverse") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool) :*: S1 ('MetaSel ('Just "_isoShowValue") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool)))) | |||||
data IconSetType Source #
Icon set type for conditional formatting. CfValue fields
determine lower range bounds. I.e. IconSet3Signs (CfPercent 0)
(CfPercent 33) (CfPercent 67) say that 1st icon will be shown for
values ranging from 0 to 33 percents, 2nd for 33 to 67 percent and
the 3rd one for values from 67 to 100 percent.
- 18.42 "ST_IconSetType (Icon Set Type)" (p. 2463)
Constructors
| IconSet3Arrows | |
| IconSet3ArrowsGray | |
| IconSet3Flags | |
| IconSet3Signs | |
| IconSet3Symbols | |
| IconSet3Symbols2 | |
| IconSet3TrafficLights1 | |
| IconSet3TrafficLights2 | 3 traffic lights icon set with thick black border. |
| IconSet4Arrows | |
| IconSet4ArrowsGray | |
| IconSet4Rating | |
| IconSet4RedToBlack | |
| IconSet4TrafficLights | |
| IconSet5Arrows | |
| IconSet5ArrowsGray | |
| IconSet5Quarters | |
| IconSet5Rating |
Instances
| NFData IconSetType Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods rnf :: IconSetType -> () Source # | |||||
| Generic IconSetType Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Associated Types
Methods from :: IconSetType -> Rep IconSetType x Source # to :: Rep IconSetType x -> IconSetType Source # | |||||
| Show IconSetType Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| Eq IconSetType Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods (==) :: IconSetType -> IconSetType -> Bool Source # (/=) :: IconSetType -> IconSetType -> Bool Source # | |||||
| Ord IconSetType Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods compare :: IconSetType -> IconSetType -> Ordering Source # (<) :: IconSetType -> IconSetType -> Bool Source # (<=) :: IconSetType -> IconSetType -> Bool Source # (>) :: IconSetType -> IconSetType -> Bool Source # (>=) :: IconSetType -> IconSetType -> Bool Source # max :: IconSetType -> IconSetType -> IconSetType Source # min :: IconSetType -> IconSetType -> IconSetType Source # | |||||
| FromAttrVal IconSetType Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods | |||||
| FromAttrBs IconSetType Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods fromAttrBs :: ByteString -> Either Text IconSetType Source # | |||||
| ToAttrVal IconSetType Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods toAttrVal :: IconSetType -> Text Source # | |||||
| type Rep IconSetType Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting type Rep IconSetType = D1 ('MetaData "IconSetType" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" 'False) ((((C1 ('MetaCons "IconSet3Arrows" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "IconSet3ArrowsGray" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "IconSet3Flags" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "IconSet3Signs" 'PrefixI 'False) (U1 :: Type -> Type))) :+: ((C1 ('MetaCons "IconSet3Symbols" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "IconSet3Symbols2" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "IconSet3TrafficLights1" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "IconSet3TrafficLights2" 'PrefixI 'False) (U1 :: Type -> Type)))) :+: (((C1 ('MetaCons "IconSet4Arrows" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "IconSet4ArrowsGray" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "IconSet4Rating" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "IconSet4RedToBlack" 'PrefixI 'False) (U1 :: Type -> Type))) :+: ((C1 ('MetaCons "IconSet4TrafficLights" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "IconSet5Arrows" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "IconSet5ArrowsGray" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "IconSet5Quarters" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "IconSet5Rating" 'PrefixI 'False) (U1 :: Type -> Type)))))) | |||||
data DataBarOptions Source #
Describes a data bar conditional formatting rule.
See 18.3.1.28 "dataBar (Data Bar)" (p. 1621)
Constructors
| DataBarOptions | |
Fields
| |
Instances
| NFData DataBarOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods rnf :: DataBarOptions -> () Source # | |||||
| Generic DataBarOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Associated Types
Methods from :: DataBarOptions -> Rep DataBarOptions x Source # to :: Rep DataBarOptions x -> DataBarOptions Source # | |||||
| Show DataBarOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| Eq DataBarOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods (==) :: DataBarOptions -> DataBarOptions -> Bool Source # (/=) :: DataBarOptions -> DataBarOptions -> Bool Source # | |||||
| Ord DataBarOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods compare :: DataBarOptions -> DataBarOptions -> Ordering Source # (<) :: DataBarOptions -> DataBarOptions -> Bool Source # (<=) :: DataBarOptions -> DataBarOptions -> Bool Source # (>) :: DataBarOptions -> DataBarOptions -> Bool Source # (>=) :: DataBarOptions -> DataBarOptions -> Bool Source # max :: DataBarOptions -> DataBarOptions -> DataBarOptions Source # min :: DataBarOptions -> DataBarOptions -> DataBarOptions Source # | |||||
| FromCursor DataBarOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods fromCursor :: Cursor -> [DataBarOptions] Source # | |||||
| FromXenoNode DataBarOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting Methods fromXenoNode :: Node -> Either Text DataBarOptions Source # | |||||
| ToElement DataBarOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting | |||||
| type Rep DataBarOptions Source # | |||||
Defined in Codec.Xlsx.Types.ConditionalFormatting type Rep DataBarOptions = D1 ('MetaData "DataBarOptions" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-1.1.4-G0KawmQS4mL8oRGRTaTy8Y" 'False) (C1 ('MetaCons "DataBarOptions" 'PrefixI 'True) ((S1 ('MetaSel ('Just "_dboMaxLength") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Int) :*: (S1 ('MetaSel ('Just "_dboMinLength") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Int) :*: S1 ('MetaSel ('Just "_dboShowValue") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Bool))) :*: (S1 ('MetaSel ('Just "_dboMinimum") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 MinCfValue) :*: (S1 ('MetaSel ('Just "_dboMaximum") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 MaxCfValue) :*: S1 ('MetaSel ('Just "_dboColor") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Color))))) | |||||
dataBarWithColor :: Color -> Condition Source #
Lenses
CfRule
IconSetOptions
DataBarOptions
Misc
topCfPriority :: Int Source #