class Axlsx::Cfvo

The recommended way to manage these rules is via Worksheet#add_conditional_formatting

Conditional Format Value Object Describes the values of the interpolation points in a gradient scale. This object is used by ColorScale, DataBar and IconSet classes

Creates a new Cfvo object


  • options (Hash) (defaults to: {})

    a customizable set of options

Options Hash (options):

  • type (Symbol)

    The type of conditional formatting value object

  • gte (Boolean)

    threshold value usage indicator

  • val (String)

    The value of the conditional formatting object

Type (xsd:boolean) For icon sets, determines whether this threshold value uses the greater than or equal to operator. 0 indicates 'greater than' is used instead of 'greater than or equal to'. The default value is true

serialize the Csvo object


  • str (String) (defaults to: '')

Type (ST_CfvoType) The type of this conditional formatting value object. options are num, percent, max, min, formula and percentile

Type (ST_Xstring) The value of the conditional formatting object This library will accept any value so long as it supports to_s

Cfvo is referenced in 0 repositories