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

Safe HaskellNone
LanguageHaskell2010

Codec.Xlsx.Types.ConditionalFormatting

Contents

Synopsis

Documentation

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 # 

Methods

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

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

Ord CfRule # 
Show CfRule # 
Generic CfRule # 

Associated Types

type Rep CfRule :: * -> * #

Methods

from :: CfRule -> Rep CfRule x #

to :: Rep CfRule x -> CfRule #

NFData CfRule # 

Methods

rnf :: CfRule -> () #

FromXenoNode CfRule # 
FromCursor CfRule # 

Methods

fromCursor :: Cursor -> [CfRule] #

ToElement CfRule # 

Methods

toElement :: Name -> CfRule -> Element #

type Rep CfRule # 
type Rep CfRule = D1 * (MetaData "CfRule" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.7.2-lPjfwcf8ew7uO9JhyAhCa" False) (C1 * (MetaCons "CfRule" PrefixI True) ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_cfrCondition") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Condition)) (S1 * (MetaSel (Just Symbol "_cfrDxfId") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Int)))) ((:*:) * (S1 * (MetaSel (Just Symbol "_cfrPriority") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Int)) (S1 * (MetaSel (Just Symbol "_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 # 

Methods

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

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

Ord NStdDev # 
Show NStdDev # 
Generic NStdDev # 

Associated Types

type Rep NStdDev :: * -> * #

Methods

from :: NStdDev -> Rep NStdDev x #

to :: Rep NStdDev x -> NStdDev #

NFData NStdDev # 

Methods

rnf :: NStdDev -> () #

FromAttrBs NStdDev # 
FromAttrVal NStdDev # 
ToAttrVal NStdDev # 

Methods

toAttrVal :: NStdDev -> Text #

type Rep NStdDev # 
type Rep NStdDev = D1 * (MetaData "NStdDev" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.7.2-lPjfwcf8ew7uO9JhyAhCa" True) (C1 * (MetaCons "NStdDev" PrefixI False) (S1 * (MetaSel (Nothing 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 # 
Ord Inclusion # 
Show Inclusion # 
Generic Inclusion # 

Associated Types

type Rep Inclusion :: * -> * #

NFData Inclusion # 

Methods

rnf :: Inclusion -> () #

FromAttrBs Inclusion # 
FromAttrVal Inclusion # 
ToAttrVal Inclusion # 

Methods

toAttrVal :: Inclusion -> Text #

type Rep Inclusion # 
type Rep Inclusion = D1 * (MetaData "Inclusion" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.7.2-lPjfwcf8ew7uO9JhyAhCa" False) ((:+:) * (C1 * (MetaCons "Inclusive" PrefixI False) (U1 *)) (C1 * (MetaCons "Exclusive" PrefixI False) (U1 *)))

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)

Instances

Eq CfValue # 

Methods

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

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

Ord CfValue # 
Show CfValue # 
Generic CfValue # 

Associated Types

type Rep CfValue :: * -> * #

Methods

from :: CfValue -> Rep CfValue x #

to :: Rep CfValue x -> CfValue #

NFData CfValue # 

Methods

rnf :: CfValue -> () #

FromXenoNode CfValue # 
FromCursor CfValue # 

Methods

fromCursor :: Cursor -> [CfValue] #

ToElement CfValue # 

Methods

toElement :: Name -> CfValue -> Element #

type Rep 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 # 
Ord Condition # 
Show Condition # 
Generic Condition # 

Associated Types

type Rep Condition :: * -> * #

NFData Condition # 

Methods

rnf :: Condition -> () #

type Rep Condition # 
type Rep Condition = D1 * (MetaData "Condition" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.7.2-lPjfwcf8ew7uO9JhyAhCa" False) ((:+:) * ((:+:) * ((:+:) * ((:+:) * (C1 * (MetaCons "AboveAverage" PrefixI False) ((:*:) * (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Inclusion)) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe NStdDev))))) (C1 * (MetaCons "BeginsWith" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Text)))) ((:+:) * (C1 * (MetaCons "BelowAverage" PrefixI False) ((:*:) * (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Inclusion)) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe NStdDev))))) ((:+:) * (C1 * (MetaCons "BottomNPercent" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Int))) (C1 * (MetaCons "BottomNValues" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Int)))))) ((:+:) * ((:+:) * (C1 * (MetaCons "CellIs" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * OperatorExpression))) ((:+:) * (C1 * (MetaCons "ColorScale2" PrefixI False) ((:*:) * ((:*:) * (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * MinCfValue)) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Color))) ((:*:) * (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * MaxCfValue)) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Color))))) (C1 * (MetaCons "ColorScale3" PrefixI False) ((:*:) * ((:*:) * (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * MinCfValue)) ((:*:) * (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Color)) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * CfValue)))) ((:*:) * (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Color)) ((:*:) * (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * MaxCfValue)) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Color)))))))) ((:+:) * (C1 * (MetaCons "ContainsBlanks" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "ContainsErrors" PrefixI False) (U1 *)) (C1 * (MetaCons "ContainsText" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Text))))))) ((:+:) * ((:+:) * ((:+:) * (C1 * (MetaCons "DataBar" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * DataBarOptions))) ((:+:) * (C1 * (MetaCons "DoesNotContainErrors" PrefixI False) (U1 *)) (C1 * (MetaCons "DoesNotContainBlanks" PrefixI False) (U1 *)))) ((:+:) * (C1 * (MetaCons "DoesNotContainText" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Text))) ((:+:) * (C1 * (MetaCons "DuplicateValues" PrefixI False) (U1 *)) (C1 * (MetaCons "EndsWith" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Text)))))) ((:+:) * ((:+:) * (C1 * (MetaCons "Expression" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula))) ((:+:) * (C1 * (MetaCons "IconSet" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * IconSetOptions))) (C1 * (MetaCons "InTimePeriod" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * TimePeriod))))) ((:+:) * (C1 * (MetaCons "TopNPercent" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Int))) ((:+:) * (C1 * (MetaCons "TopNValues" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Int))) (C1 * (MetaCons "UniqueValues" PrefixI False) (U1 *)))))))

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 # 
Ord OperatorExpression # 
Show OperatorExpression # 
Generic OperatorExpression # 
NFData OperatorExpression # 

Methods

rnf :: OperatorExpression -> () #

type Rep OperatorExpression # 
type Rep OperatorExpression = D1 * (MetaData "OperatorExpression" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.7.2-lPjfwcf8ew7uO9JhyAhCa" False) ((:+:) * ((:+:) * ((:+:) * (C1 * (MetaCons "OpBeginsWith" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula))) ((:+:) * (C1 * (MetaCons "OpBetween" PrefixI False) ((:*:) * (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula)) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula)))) (C1 * (MetaCons "OpContainsText" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula))))) ((:+:) * (C1 * (MetaCons "OpEndsWith" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula))) ((:+:) * (C1 * (MetaCons "OpEqual" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula))) (C1 * (MetaCons "OpGreaterThan" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula)))))) ((:+:) * ((:+:) * (C1 * (MetaCons "OpGreaterThanOrEqual" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula))) ((:+:) * (C1 * (MetaCons "OpLessThan" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula))) (C1 * (MetaCons "OpLessThanOrEqual" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula))))) ((:+:) * (C1 * (MetaCons "OpNotBetween" PrefixI False) ((:*:) * (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula)) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula)))) ((:+:) * (C1 * (MetaCons "OpNotContains" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Formula))) (C1 * (MetaCons "OpNotEqual" PrefixI False) (S1 * (MetaSel (Nothing 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 # 
Ord TimePeriod # 
Show TimePeriod # 
Generic TimePeriod # 

Associated Types

type Rep TimePeriod :: * -> * #

NFData TimePeriod # 

Methods

rnf :: TimePeriod -> () #

FromAttrBs TimePeriod # 
FromAttrVal TimePeriod # 
ToAttrVal TimePeriod # 

Methods

toAttrVal :: TimePeriod -> Text #

type Rep TimePeriod # 
type Rep TimePeriod = D1 * (MetaData "TimePeriod" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.7.2-lPjfwcf8ew7uO9JhyAhCa" False) ((:+:) * ((:+:) * ((:+:) * (C1 * (MetaCons "PerLast7Days" PrefixI False) (U1 *)) (C1 * (MetaCons "PerLastMonth" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "PerLastWeek" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "PerNextMonth" PrefixI False) (U1 *)) (C1 * (MetaCons "PerNextWeek" PrefixI False) (U1 *))))) ((:+:) * ((:+:) * (C1 * (MetaCons "PerThisMonth" PrefixI False) (U1 *)) (C1 * (MetaCons "PerThisWeek" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "PerToday" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "PerTomorrow" PrefixI False) (U1 *)) (C1 * (MetaCons "PerYesterday" PrefixI False) (U1 *))))))

data IconSetOptions #

Describes an icon set conditional formatting rule.

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

Constructors

IconSetOptions 

Fields

Instances

Eq IconSetOptions # 
Ord IconSetOptions # 
Show IconSetOptions # 
Generic IconSetOptions # 

Associated Types

type Rep IconSetOptions :: * -> * #

Default IconSetOptions # 

Methods

def :: IconSetOptions #

NFData IconSetOptions # 

Methods

rnf :: IconSetOptions -> () #

FromXenoNode IconSetOptions # 
FromCursor IconSetOptions # 
ToElement IconSetOptions # 
type Rep IconSetOptions # 
type Rep IconSetOptions = D1 * (MetaData "IconSetOptions" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.7.2-lPjfwcf8ew7uO9JhyAhCa" False) (C1 * (MetaCons "IconSetOptions" PrefixI True) ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_isoIconSet") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * IconSetType)) (S1 * (MetaSel (Just Symbol "_isoValues") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * [CfValue]))) ((:*:) * (S1 * (MetaSel (Just Symbol "_isoReverse") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Bool)) (S1 * (MetaSel (Just Symbol "_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)

Instances

Eq IconSetType # 
Ord IconSetType # 
Show IconSetType # 
Generic IconSetType # 

Associated Types

type Rep IconSetType :: * -> * #

NFData IconSetType # 

Methods

rnf :: IconSetType -> () #

FromAttrBs IconSetType # 
FromAttrVal IconSetType # 
ToAttrVal IconSetType # 
type Rep IconSetType # 
type Rep IconSetType = D1 * (MetaData "IconSetType" "Codec.Xlsx.Types.ConditionalFormatting" "xlsx-0.7.2-lPjfwcf8ew7uO9JhyAhCa" False) ((:+:) * ((:+:) * ((:+:) * ((:+:) * (C1 * (MetaCons "IconSet3Arrows" PrefixI False) (U1 *)) (C1 * (MetaCons "IconSet3ArrowsGray" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "IconSet3Flags" PrefixI False) (U1 *)) (C1 * (MetaCons "IconSet3Signs" PrefixI False) (U1 *)))) ((:+:) * ((:+:) * (C1 * (MetaCons "IconSet3Symbols" PrefixI False) (U1 *)) (C1 * (MetaCons "IconSet3Symbols2" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "IconSet3TrafficLights1" PrefixI False) (U1 *)) (C1 * (MetaCons "IconSet3TrafficLights2" PrefixI False) (U1 *))))) ((:+:) * ((:+:) * ((:+:) * (C1 * (MetaCons "IconSet4Arrows" PrefixI False) (U1 *)) (C1 * (MetaCons "IconSet4ArrowsGray" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "IconSet4Rating" PrefixI False) (U1 *)) (C1 * (MetaCons "IconSet4RedToBlack" PrefixI False) (U1 *)))) ((:+:) * ((:+:) * (C1 * (MetaCons "IconSet4TrafficLights" PrefixI False) (U1 *)) (C1 * (MetaCons "IconSet5Arrows" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "IconSet5ArrowsGray" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "IconSet5Quarters" PrefixI False) (U1 *)) (C1 * (MetaCons "IconSet5Rating" PrefixI False) (U1 *)))))))

data DataBarOptions #

Describes a data bar conditional formatting rule.

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

Constructors

DataBarOptions 

Fields

Instances

Eq DataBarOptions # 
Ord DataBarOptions # 
Show DataBarOptions # 
Generic DataBarOptions # 

Associated Types

type Rep DataBarOptions :: * -> * #

NFData DataBarOptions # 

Methods

rnf :: DataBarOptions -> () #

FromXenoNode DataBarOptions # 
FromCursor DataBarOptions # 
ToElement DataBarOptions # 
type Rep DataBarOptions # 

Lenses

CfRule

IconSetOptions

DataBarOptions

Misc