Codec.Xlsx.Types.ConditionalFormatting

Documentation

type ConditionalFormatting = [CfRule]

data CfRule

This collection represents a description of a conditional formatting rule.

See 18.3.1.10 "cfRule (Conditional Formatting Rule)" (p. 1602)

Constructors

CfRule

Fields

• _cfrCondition :: Condition
• _cfrDxfId :: Maybe Int

  This is an index to a dxf element in the Styles Part indicating which cell formatting to apply when the conditional formatting rule criteria is met.

• _cfrPriority :: Int

  The priority of this conditional formatting rule. This value is used to determine which format should be evaluated and rendered. Lower numeric values are higher priority than higher numeric values, where 1 is the highest priority.

• _cfrStopIfTrue :: Maybe Bool

  If this flag is set, no rules with lower priority shall be applied over this rule, when this rule evaluates to true.

Instances

Eq CfRule

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

(==) :: CfRule -> CfRule -> Bool

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

Ord CfRule

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

compare :: CfRule -> CfRule -> Ordering

(<) :: CfRule -> CfRule -> Bool

(<=) :: CfRule -> CfRule -> Bool

(>) :: CfRule -> CfRule -> Bool

(>=) :: CfRule -> CfRule -> Bool

max :: CfRule -> CfRule -> CfRule

min :: CfRule -> CfRule -> CfRule

Show CfRule

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

showsPrec :: Int -> CfRule -> ShowS

show :: CfRule -> String

showList :: [CfRule] -> ShowS

Generic CfRule

Defined in Codec.Xlsx.Types.ConditionalFormatting

Associated Types

type Rep CfRule :: Type -> Type

Methods

from :: CfRule -> Rep CfRule x

to :: Rep CfRule x -> CfRule

NFData CfRule

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

rnf :: CfRule -> ()

FromXenoNode CfRule

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromXenoNode :: Node -> Either Text CfRule

FromCursor CfRule

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromCursor :: Cursor -> [CfRule]

ToElement CfRule

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

toElement :: Name -> CfRule -> Element

type Rep CfRule

Defined in Codec.Xlsx.Types.ConditionalFormatting

type Rep CfRule = D1 ('MetaData "CfRule" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" 'False) (C1 ('MetaCons "CfRule" 'PrefixI 'True) ((S1 ('MetaSel ('Just "_cfrCondition") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Condition) :*: S1 ('MetaSel ('Just "_cfrDxfId") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int))) :*: (S1 ('MetaSel ('Just "_cfrPriority") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Int) :*: S1 ('MetaSel ('Just "_cfrStopIfTrue") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)))))

newtype NStdDev

The number of standard deviations to include above or below the average in the conditional formatting rule.

Constructors

NStdDev Int

Instances

Eq NStdDev

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

(==) :: NStdDev -> NStdDev -> Bool

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

Ord NStdDev

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

compare :: NStdDev -> NStdDev -> Ordering

(<) :: NStdDev -> NStdDev -> Bool

(<=) :: NStdDev -> NStdDev -> Bool

(>) :: NStdDev -> NStdDev -> Bool

(>=) :: NStdDev -> NStdDev -> Bool

max :: NStdDev -> NStdDev -> NStdDev

min :: NStdDev -> NStdDev -> NStdDev

Show NStdDev

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

showsPrec :: Int -> NStdDev -> ShowS

show :: NStdDev -> String

showList :: [NStdDev] -> ShowS

Generic NStdDev

Defined in Codec.Xlsx.Types.ConditionalFormatting

Associated Types

type Rep NStdDev :: Type -> Type

Methods

from :: NStdDev -> Rep NStdDev x

to :: Rep NStdDev x -> NStdDev

NFData NStdDev

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

rnf :: NStdDev -> ()

FromAttrBs NStdDev

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromAttrBs :: ByteString -> Either Text NStdDev

FromAttrVal NStdDev

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromAttrVal :: Reader NStdDev

ToAttrVal NStdDev

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

toAttrVal :: NStdDev -> Text

type Rep NStdDev

Defined in Codec.Xlsx.Types.ConditionalFormatting

type Rep NStdDev = D1 ('MetaData "NStdDev" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" 'True) (C1 ('MetaCons "NStdDev" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Int)))

data Inclusion

Flag indicating whether the aboveAverage and belowAverage criteria is inclusive of the average itself, or exclusive of that value.

Constructors

Inclusive

Exclusive

Instances

Eq Inclusion

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

(==) :: Inclusion -> Inclusion -> Bool

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

Ord Inclusion

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

compare :: Inclusion -> Inclusion -> Ordering

(<) :: Inclusion -> Inclusion -> Bool

(<=) :: Inclusion -> Inclusion -> Bool

(>) :: Inclusion -> Inclusion -> Bool

(>=) :: Inclusion -> Inclusion -> Bool

max :: Inclusion -> Inclusion -> Inclusion

min :: Inclusion -> Inclusion -> Inclusion

Show Inclusion

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

showsPrec :: Int -> Inclusion -> ShowS

show :: Inclusion -> String

showList :: [Inclusion] -> ShowS

Generic Inclusion

Defined in Codec.Xlsx.Types.ConditionalFormatting

Associated Types

type Rep Inclusion :: Type -> Type

Methods

from :: Inclusion -> Rep Inclusion x

to :: Rep Inclusion x -> Inclusion

NFData Inclusion

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

rnf :: Inclusion -> ()

FromAttrBs Inclusion

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromAttrBs :: ByteString -> Either Text Inclusion

FromAttrVal Inclusion

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromAttrVal :: Reader Inclusion

ToAttrVal Inclusion

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

toAttrVal :: Inclusion -> Text

type Rep Inclusion

Defined in Codec.Xlsx.Types.ConditionalFormatting

type Rep Inclusion = D1 ('MetaData "Inclusion" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" 'False) (C1 ('MetaCons "Inclusive" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "Exclusive" 'PrefixI 'False) (U1 :: Type -> Type))

data CfValue

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)

Constructors

CfValue Double

CfPercent Double

CfPercentile Double

CfFormula Formula

Instances

Eq CfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

(==) :: CfValue -> CfValue -> Bool

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

Ord CfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

compare :: CfValue -> CfValue -> Ordering

(<) :: CfValue -> CfValue -> Bool

(<=) :: CfValue -> CfValue -> Bool

(>) :: CfValue -> CfValue -> Bool

(>=) :: CfValue -> CfValue -> Bool

max :: CfValue -> CfValue -> CfValue

min :: CfValue -> CfValue -> CfValue

Show CfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

showsPrec :: Int -> CfValue -> ShowS

show :: CfValue -> String

showList :: [CfValue] -> ShowS

Generic CfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Associated Types

type Rep CfValue :: Type -> Type

Methods

from :: CfValue -> Rep CfValue x

to :: Rep CfValue x -> CfValue

NFData CfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

rnf :: CfValue -> ()

FromXenoNode CfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromXenoNode :: Node -> Either Text CfValue

FromCursor CfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromCursor :: Cursor -> [CfValue]

ToElement CfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

toElement :: Name -> CfValue -> Element

type Rep CfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

type Rep CfValue = D1 ('MetaData "CfValue" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" '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

Constructors

CfvMin

MinCfValue CfValue

Instances

Eq MinCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

(==) :: MinCfValue -> MinCfValue -> Bool

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

Ord MinCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

compare :: MinCfValue -> MinCfValue -> Ordering

(<) :: MinCfValue -> MinCfValue -> Bool

(<=) :: MinCfValue -> MinCfValue -> Bool

(>) :: MinCfValue -> MinCfValue -> Bool

(>=) :: MinCfValue -> MinCfValue -> Bool

max :: MinCfValue -> MinCfValue -> MinCfValue

min :: MinCfValue -> MinCfValue -> MinCfValue

Show MinCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

showsPrec :: Int -> MinCfValue -> ShowS

show :: MinCfValue -> String

showList :: [MinCfValue] -> ShowS

Generic MinCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Associated Types

type Rep MinCfValue :: Type -> Type

Methods

from :: MinCfValue -> Rep MinCfValue x

to :: Rep MinCfValue x -> MinCfValue

NFData MinCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

rnf :: MinCfValue -> ()

FromXenoNode MinCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromXenoNode :: Node -> Either Text MinCfValue

FromCursor MinCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromCursor :: Cursor -> [MinCfValue]

ToElement MinCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

toElement :: Name -> MinCfValue -> Element

type Rep MinCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

type Rep MinCfValue = D1 ('MetaData "MinCfValue" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" '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

Constructors

CfvMax

MaxCfValue CfValue

Instances

Eq MaxCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

(==) :: MaxCfValue -> MaxCfValue -> Bool

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

Ord MaxCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

compare :: MaxCfValue -> MaxCfValue -> Ordering

(<) :: MaxCfValue -> MaxCfValue -> Bool

(<=) :: MaxCfValue -> MaxCfValue -> Bool

(>) :: MaxCfValue -> MaxCfValue -> Bool

(>=) :: MaxCfValue -> MaxCfValue -> Bool

max :: MaxCfValue -> MaxCfValue -> MaxCfValue

min :: MaxCfValue -> MaxCfValue -> MaxCfValue

Show MaxCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

showsPrec :: Int -> MaxCfValue -> ShowS

show :: MaxCfValue -> String

showList :: [MaxCfValue] -> ShowS

Generic MaxCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Associated Types

type Rep MaxCfValue :: Type -> Type

Methods

from :: MaxCfValue -> Rep MaxCfValue x

to :: Rep MaxCfValue x -> MaxCfValue

NFData MaxCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

rnf :: MaxCfValue -> ()

FromXenoNode MaxCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromXenoNode :: Node -> Either Text MaxCfValue

FromCursor MaxCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromCursor :: Cursor -> [MaxCfValue]

ToElement MaxCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

toElement :: Name -> MaxCfValue -> Element

type Rep MaxCfValue

Defined in Codec.Xlsx.Types.ConditionalFormatting

type Rep MaxCfValue = D1 ('MetaData "MaxCfValue" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" 'False) (C1 ('MetaCons "CfvMax" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "MaxCfValue" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 CfValue)))

data Condition

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

Eq Condition

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

(==) :: Condition -> Condition -> Bool

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

Ord Condition

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

compare :: Condition -> Condition -> Ordering

(<) :: Condition -> Condition -> Bool

(<=) :: Condition -> Condition -> Bool

(>) :: Condition -> Condition -> Bool

(>=) :: Condition -> Condition -> Bool

max :: Condition -> Condition -> Condition

min :: Condition -> Condition -> Condition

Show Condition

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

showsPrec :: Int -> Condition -> ShowS

show :: Condition -> String

showList :: [Condition] -> ShowS

Generic Condition

Defined in Codec.Xlsx.Types.ConditionalFormatting

Associated Types

type Rep Condition :: Type -> Type

Methods

from :: Condition -> Rep Condition x

to :: Rep Condition x -> Condition

NFData Condition

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

rnf :: Condition -> ()

type Rep Condition

Defined in Codec.Xlsx.Types.ConditionalFormatting

type Rep Condition = D1 ('MetaData "Condition" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" '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

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

Between operator

OpContainsText Formula

Contains operator

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

Eq OperatorExpression

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

(==) :: OperatorExpression -> OperatorExpression -> Bool

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

Ord OperatorExpression

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

compare :: OperatorExpression -> OperatorExpression -> Ordering

(<) :: OperatorExpression -> OperatorExpression -> Bool

(<=) :: OperatorExpression -> OperatorExpression -> Bool

(>) :: OperatorExpression -> OperatorExpression -> Bool

(>=) :: OperatorExpression -> OperatorExpression -> Bool

max :: OperatorExpression -> OperatorExpression -> OperatorExpression

min :: OperatorExpression -> OperatorExpression -> OperatorExpression

Show OperatorExpression

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

showsPrec :: Int -> OperatorExpression -> ShowS

show :: OperatorExpression -> String

showList :: [OperatorExpression] -> ShowS

Generic OperatorExpression

Defined in Codec.Xlsx.Types.ConditionalFormatting

Associated Types

type Rep OperatorExpression :: Type -> Type

Methods

from :: OperatorExpression -> Rep OperatorExpression x

to :: Rep OperatorExpression x -> OperatorExpression

NFData OperatorExpression

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

rnf :: OperatorExpression -> ()

type Rep OperatorExpression

Defined in Codec.Xlsx.Types.ConditionalFormatting

type Rep OperatorExpression = D1 ('MetaData "OperatorExpression" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" '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

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

Eq TimePeriod

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

(==) :: TimePeriod -> TimePeriod -> Bool

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

Ord TimePeriod

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

compare :: TimePeriod -> TimePeriod -> Ordering

(<) :: TimePeriod -> TimePeriod -> Bool

(<=) :: TimePeriod -> TimePeriod -> Bool

(>) :: TimePeriod -> TimePeriod -> Bool

(>=) :: TimePeriod -> TimePeriod -> Bool

max :: TimePeriod -> TimePeriod -> TimePeriod

min :: TimePeriod -> TimePeriod -> TimePeriod

Show TimePeriod

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

showsPrec :: Int -> TimePeriod -> ShowS

show :: TimePeriod -> String

showList :: [TimePeriod] -> ShowS

Generic TimePeriod

Defined in Codec.Xlsx.Types.ConditionalFormatting

Associated Types

type Rep TimePeriod :: Type -> Type

Methods

from :: TimePeriod -> Rep TimePeriod x

to :: Rep TimePeriod x -> TimePeriod

NFData TimePeriod

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

rnf :: TimePeriod -> ()

FromAttrBs TimePeriod

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromAttrBs :: ByteString -> Either Text TimePeriod

FromAttrVal TimePeriod

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromAttrVal :: Reader TimePeriod

ToAttrVal TimePeriod

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

toAttrVal :: TimePeriod -> Text

type Rep TimePeriod

Defined in Codec.Xlsx.Types.ConditionalFormatting

type Rep TimePeriod = D1 ('MetaData "TimePeriod" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" '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

Describes an icon set conditional formatting rule.

See 18.3.1.49 "iconSet (Icon Set)" (p. 1645)

Constructors

IconSetOptions

Fields

• _isoIconSet :: IconSetType

  icon set used, default value is IconSet3Trafficlights1

• _isoValues :: [CfValue]

  values describing per icon ranges

• _isoReverse :: Bool

  reverses the default order of the icons in the specified icon set

• _isoShowValue :: Bool

  indicates whether to show the values of the cells on which this icon set is applied.

Instances

Eq IconSetOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

(==) :: IconSetOptions -> IconSetOptions -> Bool

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

Ord IconSetOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

compare :: IconSetOptions -> IconSetOptions -> Ordering

(<) :: IconSetOptions -> IconSetOptions -> Bool

(<=) :: IconSetOptions -> IconSetOptions -> Bool

(>) :: IconSetOptions -> IconSetOptions -> Bool

(>=) :: IconSetOptions -> IconSetOptions -> Bool

max :: IconSetOptions -> IconSetOptions -> IconSetOptions

min :: IconSetOptions -> IconSetOptions -> IconSetOptions

Show IconSetOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

showsPrec :: Int -> IconSetOptions -> ShowS

show :: IconSetOptions -> String

showList :: [IconSetOptions] -> ShowS

Generic IconSetOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

Associated Types

type Rep IconSetOptions :: Type -> Type

Methods

from :: IconSetOptions -> Rep IconSetOptions x

to :: Rep IconSetOptions x -> IconSetOptions

Default IconSetOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

def :: IconSetOptions

NFData IconSetOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

rnf :: IconSetOptions -> ()

FromXenoNode IconSetOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromXenoNode :: Node -> Either Text IconSetOptions

FromCursor IconSetOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromCursor :: Cursor -> [IconSetOptions]

ToElement IconSetOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

toElement :: Name -> IconSetOptions -> Element

type Rep IconSetOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

type Rep IconSetOptions = D1 ('MetaData "IconSetOptions" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" '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

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.

1. 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

Eq IconSetType

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

(==) :: IconSetType -> IconSetType -> Bool

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

Ord IconSetType

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

compare :: IconSetType -> IconSetType -> Ordering

(<) :: IconSetType -> IconSetType -> Bool

(<=) :: IconSetType -> IconSetType -> Bool

(>) :: IconSetType -> IconSetType -> Bool

(>=) :: IconSetType -> IconSetType -> Bool

max :: IconSetType -> IconSetType -> IconSetType

min :: IconSetType -> IconSetType -> IconSetType

Show IconSetType

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

showsPrec :: Int -> IconSetType -> ShowS

show :: IconSetType -> String

showList :: [IconSetType] -> ShowS

Generic IconSetType

Defined in Codec.Xlsx.Types.ConditionalFormatting

Associated Types

type Rep IconSetType :: Type -> Type

Methods

from :: IconSetType -> Rep IconSetType x

to :: Rep IconSetType x -> IconSetType

NFData IconSetType

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

rnf :: IconSetType -> ()

FromAttrBs IconSetType

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromAttrBs :: ByteString -> Either Text IconSetType

FromAttrVal IconSetType

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromAttrVal :: Reader IconSetType

ToAttrVal IconSetType

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

toAttrVal :: IconSetType -> Text

type Rep IconSetType

Defined in Codec.Xlsx.Types.ConditionalFormatting

type Rep IconSetType = D1 ('MetaData "IconSetType" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" '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

Describes a data bar conditional formatting rule.

See 18.3.1.28 "dataBar (Data Bar)" (p. 1621)

Constructors

DataBarOptions

Fields

• _dboMaxLength :: Int

  The maximum length of the data bar, as a percentage of the cell width.

• _dboMinLength :: Int

  The minimum length of the data bar, as a percentage of the cell width.

• _dboShowValue :: Bool

  Indicates whether to show the values of the cells on which this data bar is applied.

• _dboMinimum :: MinCfValue
• _dboMaximum :: MaxCfValue
• _dboColor :: Color

Instances

Eq DataBarOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

(==) :: DataBarOptions -> DataBarOptions -> Bool

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

Ord DataBarOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

compare :: DataBarOptions -> DataBarOptions -> Ordering

(<) :: DataBarOptions -> DataBarOptions -> Bool

(<=) :: DataBarOptions -> DataBarOptions -> Bool

(>) :: DataBarOptions -> DataBarOptions -> Bool

(>=) :: DataBarOptions -> DataBarOptions -> Bool

max :: DataBarOptions -> DataBarOptions -> DataBarOptions

min :: DataBarOptions -> DataBarOptions -> DataBarOptions

Show DataBarOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

showsPrec :: Int -> DataBarOptions -> ShowS

show :: DataBarOptions -> String

showList :: [DataBarOptions] -> ShowS

Generic DataBarOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

Associated Types

type Rep DataBarOptions :: Type -> Type

Methods

from :: DataBarOptions -> Rep DataBarOptions x

to :: Rep DataBarOptions x -> DataBarOptions

NFData DataBarOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

rnf :: DataBarOptions -> ()

FromXenoNode DataBarOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromXenoNode :: Node -> Either Text DataBarOptions

FromCursor DataBarOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

fromCursor :: Cursor -> [DataBarOptions]

ToElement DataBarOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

Methods

toElement :: Name -> DataBarOptions -> Element

type Rep DataBarOptions

Defined in Codec.Xlsx.Types.ConditionalFormatting

type Rep DataBarOptions = D1 ('MetaData "DataBarOptions" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.8.4-HaLEmVo1ZhGFVO4n3Yfot" '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

Lenses

CfRule

cfrCondition :: Lens' CfRule Condition

cfrDxfId :: Lens' CfRule (Maybe Int)

cfrPriority :: Lens' CfRule Int

cfrStopIfTrue :: Lens' CfRule (Maybe Bool)

IconSetOptions

isoIconSet :: Lens' IconSetOptions IconSetType

isoValues :: Lens' IconSetOptions [CfValue]

isoReverse :: Lens' IconSetOptions Bool

isoShowValue :: Lens' IconSetOptions Bool

DataBarOptions

dboMaxLength :: Lens' DataBarOptions Int

dboMinLength :: Lens' DataBarOptions Int

dboShowValue :: Lens' DataBarOptions Bool

dboMinimum :: Lens' DataBarOptions MinCfValue

dboMaximum :: Lens' DataBarOptions MaxCfValue

dboColor :: Lens' DataBarOptions Color

Misc

topCfPriority :: Int