Class: Axlsx::Cfvo

Inherits:
Object
  • Object
show all
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

See Also:

Instance Attribute Summary collapse

Instance Method Summary collapse

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



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

def initialize(options={})
  @gte = true
  options.each do |o|
    self.send("#{o[0]}=", o[1]) if self.respond_to? "#{o[0]}="
  end
end

Instance Attribute Details

#gte ⇒ Boolean

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) 


21
22
23
 
# File 'lib/axlsx/workbook/worksheet/cfvo.rb', line 21

def gte
  @gte
end

#type ⇒ Symbol

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

Returns:

  • (Symbol) 


14
15
16
 
# File 'lib/axlsx/workbook/worksheet/cfvo.rb', line 14

def type
  @type
end

#val ⇒ Object

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



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

def val
  @val
end

Instance Method Details

#to_xml_string(str = '') ⇒ String

serialize the Csvo object

Parameters:

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

Returns:

  • (String) 


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

def to_xml_string(str = '')
  str << '<cfvo '
  str << instance_values.map { |key, value| '' << key << '="' << value.to_s << '"' }.join(' ')
  str << ' />'
end