Class: Axlsx::IconSet

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

Overview

Note:

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

See Also:

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from SerializedAttributes

#declared_attributes, included, #serialized_attributes, #serialized_element_attributes, #serialized_tag

Methods included from OptionsParser

#parse_options

Constructor Details

#initialize(options = {}) {|_self| ... } ⇒ IconSet

Creates a new icon set object

Parameters:

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

    a customizable set of options

Options Hash (options):

  • iconSet (String)
  • reverse (Boolean)
  • percent (Boolean)
  • showValue (Boolean)

Yields:

  • (_self)

Yield Parameters:



17
18
19
20
21
22
23
24
 
# File 'lib/axlsx/workbook/worksheet/icon_set.rb', line 17

def initialize(options = {})
  @percent = @showValue = true
  @reverse = false
  @iconSet = "3TrafficLights1"
  initialize_value_objects
  parse_options options
  yield self if block_given?
end

Instance Attribute Details

#iconSet ⇒ String

The icon set to display. Allowed values are: 3Arrows, 3ArrowsGray, 3Flags, 3TrafficLights1, 3TrafficLights2, 3Signs, 3Symbols, 3Symbols2, 4Arrows, 4ArrowsGray, 4RedToBlack, 4Rating, 4TrafficLights, 5Arrows, 5ArrowsGray, 5Rating, 5Quarters The default value is 3TrafficLights1

Returns:

  • (String) 


32
33
34
 
# File 'lib/axlsx/workbook/worksheet/icon_set.rb', line 32

def iconSet
  @iconSet
end

#percent ⇒ Boolean

Indicates whether the thresholds indicate percentile values, instead of number values. The default falue is true

Returns:

  • (Boolean) 


37
38
39
 
# File 'lib/axlsx/workbook/worksheet/icon_set.rb', line 37

def percent
  @percent
end

#reverse ⇒ Boolean

If true, reverses the default order of the icons in this icon set.maxLength attribute The default value is false

Returns:

  • (Boolean) 


42
43
44
 
# File 'lib/axlsx/workbook/worksheet/icon_set.rb', line 42

def reverse
  @reverse
end

#showValue ⇒ Boolean

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

Returns:

  • (Boolean) 


47
48
49
 
# File 'lib/axlsx/workbook/worksheet/icon_set.rb', line 47

def showValue
  @showValue
end

Instance Method Details

#to_xml_string(str = "") ⇒ String

Serialize this object to an xml string

Parameters:

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

Returns:

  • (String) 


64
65
66
67
68
 
# File 'lib/axlsx/workbook/worksheet/icon_set.rb', line 64

def to_xml_string(str = "")
  serialized_tag('iconSet', str) do
    @value_objects.each { |cfvo| cfvo.to_xml_string(str) }
  end
end