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
|
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 :catAxis
# the valueaxis
# @return [ValAxis]
attr_reader :valAxis
# The direction of the bars in the chart
# must be one of [:bar, :col]
# @return [Symbol]
attr_reader :barDir
# space between bar or column clusters, as a percentage of the bar or column width.
# @return [String]
attr_reader :gapDepth
# space between bar or column clusters, as a percentage of the bar or column width.
# @return [String]
attr_reader :gapWidth
#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] barDir
# @option options [Symbol] grouping
# @option options [String] gapWidth
# @option options [String] gapDepth
# @option options [Symbol] shape
# @option options [Integer] rotX
# @option options [String] hPercent
# @option options [Integer] rotY
# @option options [String] depthPercent
# @option options [Boolean] rAngAx
# @option options [Integer] perspective
# @see Chart
# @see View3D
def initialize(frame, options={})
@barDir = :bar
@grouping = :clustered
@gapWidth, @gapDepth, @shape = nil, nil, nil
@catAxId = rand(8 ** 8)
@valAxId = rand(8 ** 8)
@catAxis = CatAxis.new(@catAxId, @valAxId)
@valAxis = ValAxis.new(@valAxId, @catAxId)
super(frame, options)
@series_type = BarSeries
@view3D = View3D.new({:rAngAx=>1}.merge(options))
end
# The direction of the bars in the chart
# must be one of [:bar, :col]
def barDir=(v)
RestrictionValidator.validate "Bar3DChart.barDir", [:bar, :col], v
@barDir = v
end
#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 gapWidth=(v)
RegexValidator.validate "Bar3DChart.gapWidth", GAP_AMOUNT_PERCENT, v
@gapWidth=(v)
end
# space between bar or column clusters, as a percentage of the bar or column width.
def gapDepth=(v)
RegexValidator.validate "Bar3DChart.gapWidth", GAP_AMOUNT_PERCENT, v
@gapDepth=(v)
end
# 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 bar chart
# @return [String]
def to_xml
super() do |xml|
xml.send('c:bar3DChart') {
xml.send('c:barDir', :val => barDir)
xml.send('c:grouping', :val=>grouping)
xml.send('c:varyColors', :val=>1)
@series.each { |ser| ser.to_xml(xml) }
xml.send('c:gapWidth', :val=>@gapWidth) unless @gapWidth.nil?
xml.send('c:gapDepth', :val=>@gapDepth) unless @gapDepth.nil?
xml.send('c:shape', :val=>@shape) unless @shape.nil?
xml.send('c:axId', :val=>@catAxId)
xml.send('c:axId', :val=>@valAxId)
xml.send('c:axId', :val=>0)
}
@catAxis.to_xml(xml)
@valAxis.to_xml(xml)
end
end
end
end
|
