Class: Axlsx::DLbls

Inherits:
Object
  • Object
show all
Includes:
Accessors, OptionsParser
Defined in:
lib/axlsx/drawing/d_lbls.rb

Overview

There are more elements in the dLbls spec that allow for customizations and formatting. For now, I am just implementing the basics. The DLbls class manages serialization of data labels showLeaderLines and leaderLines are not currently implemented

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from OptionsParser

#parse_options

Constructor Details

#initialize(chart_type, options = {}) ⇒ DLbls

creates a new DLbls object

Raises:

  • (ArgumentError)

12
13
14
15
16
17
# File 'lib/axlsx/drawing/d_lbls.rb', line 12

def initialize(chart_type, options={})
  raise ArgumentError, 'chart_type must inherit from Chart' unless [Chart, LineChart].include?(chart_type.superclass)
  @chart_type = chart_type
  initialize_defaults
  parse_options options
end

Instance Attribute Details

#chart_typeObject (readonly)

The chart type that is using this data lables instance. This affects the xml output as not all chart types support the same data label attributes.


46
47
48
# File 'lib/axlsx/drawing/d_lbls.rb', line 46

def chart_type
  @chart_type
end

Instance Method Details

#d_lbl_posSymbol

The position of the data labels in the chart

Returns:

  • (Symbol)

See Also:


51
52
53
54
# File 'lib/axlsx/drawing/d_lbls.rb', line 51

def d_lbl_pos
  return unless [Pie3DChart, LineChart].include? @chart_type
  @d_lbl_pos ||= :bestFit
end

#d_lbl_pos=(label_position) ⇒ Object

Assigns the label postion for this data labels on this chart. Allowed positions are :bestFilt, :b, :ctr, :inBase, :inEnd, :l, :outEnd, :r and :t The default is :bestFit

Parameters:

  • label_position (Symbol)

    the postion you want to use.

See Also:


62
63
64
65
66
# File 'lib/axlsx/drawing/d_lbls.rb', line 62

def d_lbl_pos=(label_position)
  return unless [Pie3DChart, LineChart].include? @chart_type
  Axlsx::RestrictionValidator.validate 'DLbls#d_lbl_pos',  [:bestFit, :b, :ctr, :inBase, :inEnd, :l, :outEnd, :r, :t], label_position
  @d_lbl_pos = label_position
end

#initialize_defaultsObject

Initialize all the values to false as Excel requires them to explicitly be disabled or all will show.


35
36
37
38
39
40
41
# File 'lib/axlsx/drawing/d_lbls.rb', line 35

def initialize_defaults
  [:show_legend_key, :show_val, :show_cat_name, 
   :show_ser_name, :show_percent, :show_bubble_size, 
   :show_leader_lines].each do |attr|
    self.send("#{attr}=", false)
  end
end

#to_xml_string(str = '') ⇒ String

serializes the data labels

Returns:

  • (String)

71
72
73
74
75
76
77
78
79
# File 'lib/axlsx/drawing/d_lbls.rb', line 71

def to_xml_string(str = '')
  validate_attributes_for_chart_type
  str << '<c:dLbls>'
  %w(d_lbl_pos show_legend_key show_val show_cat_name show_ser_name show_percent show_bubble_size show_leader_lines).each do |key|
    next unless instance_values.keys.include?(key) && instance_values[key] != nil
    str <<  "<c:#{Axlsx::camel(key, false)} val='#{instance_values[key]}' />" 
  end
  str << '</c:dLbls>'
end

#validate_attributes_for_chart_typeObject

nills out d_lbl_pos and show_leader_lines as these attributes, while valid in the spec actually chrash excel for any chart type other than pie charts.


82
83
84
85
86
# File 'lib/axlsx/drawing/d_lbls.rb', line 82

def validate_attributes_for_chart_type
  return if [Pie3DChart, LineChart].include? @chart_type
  @d_lbl_pos = nil
  @show_leader_lines = nil
end