Class: Writexlsx::Package::IconSetFormat

Inherits:
ConditionalFormat show all
Defined in:
lib/write_xlsx/package/conditional_format.rb

Constant Summary

Constants included from Constants

Constants::COL_MAX, Constants::ROW_MAX, Constants::SHEETNAME_MAX, Constants::STR_MAX

Constants included from Utility::Common

Utility::Common::PERL_TRUE_VALUES

Instance Attribute Summary

Attributes inherited from ConditionalFormat

#range

Instance Method Summary collapse

Methods inherited from ConditionalFormat

#attributes, #bar_axis_color, #bar_axis_position, #bar_border_color, #bar_color, #bar_negative_color, #bar_negative_color_same, #bar_no_border, #bar_only, #criteria, #direction, factory, #format, #formula, #icon_style, #icons, #icons_only, #initialize, #max_color, #max_type, #max_value, #maximum, #mid_color, #mid_type, #mid_value, #min_color, #min_type, #min_value, #minimum, #priority, #range_param_for_conditional_formatting, #reverse_icons, #stop_if_true, #total_icons, #type, #value, #write_cf_rule_formula_tag, #write_cfvo, #write_formula_tag

Methods included from Utility::XmlPrimitives

#r_id_attributes, #write_color, #write_xml_declaration, #xml_str

Methods included from Utility::DateTime

#convert_date_time

Methods included from Utility::Dimensions

#check_dimensions, #check_dimensions_and_update_max_min_values, #store_col_max_min_values, #store_row_max_min_values

Methods included from Utility::CellReference

#row_col_notation, #substitute_cellref, #xl_cell_to_rowcol, #xl_col_to_name, #xl_range, #xl_range_formula, #xl_rowcol_to_cell

Methods included from Utility::Common

#absolute_char, #check_parameter, #float_to_str, #ptrue?, #put_deprecate_message

Constructor Details

This class inherits a constructor from Writexlsx::Package::ConditionalFormat

Instance Method Details

#write_cf_rule ⇒ Object 



887
888
889
890
891
 
# File 'lib/write_xlsx/package/conditional_format.rb', line 887

def write_cf_rule
  @writer.tag_elements('cfRule', attributes) do
    write_icon_set
  end
end

#write_icon_set ⇒ Object

Write the <iconSet> element.



896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
 
# File 'lib/write_xlsx/package/conditional_format.rb', line 896

def write_icon_set
  attributes = []
  # Don't set attribute for default style.
  attributes = [['iconSet', icon_style]] if icon_style != '3TrafficLights'
  attributes << ['showValue', 0]           if icons_only
  attributes << ['reverse', 1]             if reverse_icons

  @writer.tag_elements('iconSet', attributes) do
    # Write the properties for different icon styles.
    if icons
      icons.reverse.each do |icon|
        write_cfvo(icon[:type], icon[:value], icon[:criteria])
      end
    end
  end
end