Class: Axlsx::Cfvo

Inherits:
Object
  • Object
show all
Includes:
OptionsParser, SerializedAttributes
Defined in:
lib/axlsx/workbook/worksheet/cfvo.rb

Overview

Note:

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

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from SerializedAttributes

#declared_attributes, included, #serialized_attributes, #serialized_element_attributes

Methods included from OptionsParser

#parse_options

Constructor Details

#initialize(options = {}) ⇒ Cfvo

Creates a new Cfvo object

Parameters:

  • 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



18
19
20
21
# File 'lib/axlsx/workbook/worksheet/cfvo.rb', line 18

def initialize(options={})
  @gte = true
  parse_options options
end

Instance Attribute Details

#gteBoolean

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

Returns:

  • (Boolean)


34
35
36
# File 'lib/axlsx/workbook/worksheet/cfvo.rb', line 34

def gte
  @gte
end

#typeSymbol

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

Returns:

  • (Symbol)


28
29
30
# File 'lib/axlsx/workbook/worksheet/cfvo.rb', line 28

def type
  @type
end

#valObject

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



39
40
41
# File 'lib/axlsx/workbook/worksheet/cfvo.rb', line 39

def val
  @val
end

Instance Method Details

#to_xml_string(str = '') ⇒ String

serialize the Csvo object

Parameters:

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

Returns:

  • (String)


56
57
58
59
60
# File 'lib/axlsx/workbook/worksheet/cfvo.rb', line 56

def to_xml_string(str = '')
  str << '<cfvo '
  serialized_attributes str
  str << ' />'
end