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
|
# 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 :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, :tickLblPos => :low)
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
def to_xml_string(str = '')
super(str) do |str_inner|
str_inner << '<c:bar3DChart>'
str_inner << '<c:barDir val="' << barDir.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) }
str_inner << '<c:dLbls>'
str_inner << '<c:showLegendKey val="0"/>'
str_inner << '<c:showVal val="0"/>'
str_inner << '<c:showCatName val="0"/>'
str_inner << '<c:showSerName val="0"/>'
str_inner << '<c:showPercent val="0"/>'
str_inner << '<c:showBubbleSize val="0"/>'
str_inner << '</c:dLbls>'
str_inner << '<c:gapWidth val="' << @gapWidth.to_s << '"/>' unless @gapWidth.nil?
str_inner << '<c:gapDepth val="' << @gapDepth.to_s << '"/>' unless @gapDepth.nil?
str_inner << '<c:shape val="' << @shape.to_s << '"/>' unless @shape.nil?
str_inner << '<c:axId val="' << @catAxId.to_s << '"/>'
str_inner << '<c:axId val="' << @valAxId.to_s << '"/>'
str_inner << '<c:axId val="0"/>'
str_inner << '</c:bar3DChart>'
@catAxis.to_xml_string str_inner
@valAxis.to_xml_string str_inner
end
end
end
end
|
