1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
|
# encoding: UTF-8
module Axlsx
# The Bar3DChart is a three dimentional barchart (who would have guessed?) that you can add to your worksheet.
# @see Worksheet#add_chart
# @see Chart#add_series
# @see Package#serialize
# @see README for an example
class Bar3DChart < Chart
# the category axis
# @return [CatAxis]
attr_reader :cat_axis
alias :catAxis :cat_axis
# the value axis
# @return [ValAxis]
attr_reader :val_axis
alias :valAxis :val_axis
# The direction of the bars in the chart
# must be one of [:bar, :col]
# @return [Symbol]
attr_reader :bar_dir
alias :barDir :bar_dir
# space between bar or column clusters, as a percentage of the bar or column width.
# @return [String]
attr_reader :gap_depth
alias :gapDepth :gap_depth
# space between bar or column clusters, as a percentage of the bar or column width.
# @return [String]
attr_reader :gap_width
alias :gapWidth :gap_width
#grouping for a column, line, or area chart.
# must be one of [:percentStacked, :clustered, :standard, :stacked]
# @return [Symbol]
attr_reader :grouping
# The shabe of the bars or columns
# must be one of [:cone, :coneToMax, :box, :cylinder, :pyramid, :pyramidToMax]
# @return [Symbol]
attr_reader :shape
# validation regex for gap amount percent
GAP_AMOUNT_PERCENT = /0*(([0-9])|([1-9][0-9])|([1-4][0-9][0-9])|500)%/
# Creates a new bar chart object
# @param [GraphicFrame] frame The workbook that owns this chart.
# @option options [Cell, String] title
# @option options [Boolean] show_legend
# @option options [Symbol] bar_dir
# @option options [Symbol] grouping
# @option options [String] gap_width
# @option options [String] gap_depth
# @option options [Symbol] shape
# @option options [Integer] rot_x
# @option options [String] h_percent
# @option options [Integer] rot_y
# @option options [String] depth_percent
# @option options [Boolean] r_ang_ax
# @option options [Integer] perspective
# @see Chart
# @see View3D
def initialize(frame, options={})
@bar_dir = :bar
@grouping = :clustered
@shape = :box
@gap_width = 150
@gap_width, @gap_depth, @shape = nil, nil, nil
@cat_ax_id = rand(8 ** 8)
@val_ax_id = rand(8 ** 8)
@cat_axis = CatAxis.new(@cat_ax_id, @val_ax_id)
@val_axis = ValAxis.new(@val_ax_id, @cat_ax_id, :tick_lbl_pos => :low, :ax_pos => :l)
super(frame, options)
@series_type = BarSeries
@view_3D = View3D.new({:r_ang_ax=>1}.merge(options))
@d_lbls = nil
end
# The direction of the bars in the chart
# must be one of [:bar, :col]
def bar_dir=(v)
RestrictionValidator.validate "Bar3DChart.bar_dir", [:bar, :col], v
@bar_dir = v
end
alias :barDir= :bar_dir=
#grouping for a column, line, or area chart.
# must be one of [:percentStacked, :clustered, :standard, :stacked]
def grouping=(v)
RestrictionValidator.validate "Bar3DChart.grouping", [:percentStacked, :clustered, :standard, :stacked], v
@grouping = v
end
# space between bar or column clusters, as a percentage of the bar or column width.
def gap_width=(v)
RegexValidator.validate "Bar3DChart.gap_width", GAP_AMOUNT_PERCENT, v
@gap_width=(v)
end
alias :gapWidth= :gap_width=
# space between bar or column clusters, as a percentage of the bar or column width.
def gap_depth=(v)
RegexValidator.validate "Bar3DChart.gap_didth", GAP_AMOUNT_PERCENT, v
@gap_depth=(v)
end
alias :gapDepth= :gap_depth=
# The shabe of the bars or columns
# must be one of [:cone, :coneToMax, :box, :cylinder, :pyramid, :pyramidToMax]
def shape=(v)
RestrictionValidator.validate "Bar3DChart.shape", [:cone, :coneToMax, :box, :cylinder, :pyramid, :pyramidToMax], v
@shape = v
end
# Serializes the object
# @param [String] str
# @return [String]
def to_xml_string(str = '')
remove_invalid_d_lbls_attributes
super(str) do |str_inner|
str_inner << '<c:bar3DChart>'
str_inner << '<c:barDir val="' << bar_dir.to_s << '"/>'
str_inner << '<c:grouping val="' << grouping.to_s << '"/>'
str_inner << '<c:varyColors val="1"/>'
@series.each { |ser| ser.to_xml_string(str_inner) }
@d_lbls.to_xml_string(str) if @d_lbls
str_inner << '<c:gapWidth val="' << @gap_width.to_s << '"/>' unless @gap_width.nil?
str_inner << '<c:gapDepth val="' << @gap_depth.to_s << '"/>' unless @gap_depth.nil?
str_inner << '<c:shape val="' << @shape.to_s << '"/>' unless @shape.nil?
str_inner << '<c:axId val="' << @cat_ax_id.to_s << '"/>'
str_inner << '<c:axId val="' << @val_ax_id.to_s << '"/>'
str_inner << '<c:axId val="0"/>'
str_inner << '</c:bar3DChart>'
@cat_axis.to_xml_string str_inner
@val_axis.to_xml_string str_inner
end
end
def remove_invalid_d_lbls_attributes
return unless @d_lbls
@d_lbls.instance_eval{ @d_lbl_pos = nil
@show_leader_lines = nil
}
end
end
end
|
