From 4d16bfc43780e5d3f7368625700b583e3e98217a Mon Sep 17 00:00:00 2001 From: Randy Morgan Date: Sun, 27 Nov 2011 18:11:42 +0900 Subject: adding in row_style and col_style methods to worksheet and active record 'acts_as_axlsx' to provide to_xlsx. --- doc/Axlsx/Bar3DChart.html | 244 ++++++++++++++++++++++++++-------------------- 1 file changed, 138 insertions(+), 106 deletions(-) (limited to 'doc/Axlsx/Bar3DChart.html') diff --git a/doc/Axlsx/Bar3DChart.html b/doc/Axlsx/Bar3DChart.html index 3ad3b313..2fb7ad0b 100644 --- a/doc/Axlsx/Bar3DChart.html +++ b/doc/Axlsx/Bar3DChart.html @@ -96,9 +96,10 @@

Overview

- -

The Bar3DChart is a three dimentional barchart (who would have guessed?) -that you can add to your worksheet.

+

+The Bar3DChart is a three dimentional barchart (who would have guessed?) +that you can add to your worksheet. +

@@ -127,8 +128,9 @@ that you can add to your worksheet.

GAP_AMOUNT_PERCENT =
- -

validation regex for gap amount percent

+

+validation regex for gap amount percent +

@@ -138,7 +140,8 @@ that you can add to your worksheet.

- 
/0*(([0-9])|([1-9][0-9])|([1-4][0-9][0-9])|500)%/
+ 
/0*(([0-9])|([1-9][0-9])|([1-4][0-9][0-9])|500)%/
+
@@ -170,8 +173,9 @@ that you can add to your worksheet.

-
-

The direction of the bars in the chart must be one of [:bar, :col].

+

+The direction of the bars in the chart must be one of [:bar, :col]. +

 @@ -196,8 +200,9 @@ that you can add to your worksheet.

-
-

the category axis.

+

+the category axis. +

 @@ -222,9 +227,10 @@ that you can add to your worksheet.

-
-

space between bar or column clusters, as a percentage of the bar or column -width.

+

+space between bar or column clusters, as a percentage of the bar or column +width. +

 @@ -249,9 +255,10 @@ width.

-
-

space between bar or column clusters, as a percentage of the bar or column -width.

+

+space between bar or column clusters, as a percentage of the bar or column +width. +

 @@ -276,8 +283,9 @@ width.

-
-

grouping for a column, line, or area chart.

+

+grouping for a column, line, or area chart. +

 @@ -302,9 +310,10 @@ width.

-
-

The shabe of the bars or columns must be one of [:cone, :coneToMax, :box, -:cylinder, :pyramid, :pyramidToMax].

+

+The shabe of the bars or columns must be one of [:cone, :coneToMax, :box, +:cylinder, :pyramid, :pyramidToMax]. +

 @@ -329,8 +338,9 @@ width.

-
-

the valueaxis.

+

+the valueaxis. +

 @@ -375,8 +385,9 @@ width.

-
-

Creates a new bar chart object.

+

+Creates a new bar chart object. +

 @@ -398,8 +409,9 @@ width.

-
-

Serializes the bar chart.

+

+Serializes the bar chart. +

 @@ -430,8 +442,9 @@ width.

- -

Creates a new bar chart object

+

+Creates a new bar chart object +

@@ -450,8 +463,9 @@ width.

— -
-

The workbook that owns this chart.

+

+The workbook that owns this chart. +

@@ -468,8 +482,9 @@ width.

— -
-

a customizable set of options

+

+a customizable set of options +

@@ -636,18 +651,19 @@ width.

# File 'lib/axlsx/drawing/bar_3D_chart.rb', line 61
 
-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
+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 + @@ -670,8 +686,9 @@ width.

- -

The direction of the bars in the chart must be one of [:bar, :col]

+

+The direction of the bars in the chart must be one of [:bar, :col] +

@@ -705,9 +722,10 @@ width.

# File 'lib/axlsx/drawing/bar_3D_chart.rb', line 21
 
-def barDir
-  @barDir
-end
+def barDir + @barDir +end + @@ -725,8 +743,9 @@ width.

- -

the category axis

+

+the category axis +

@@ -760,9 +779,10 @@ width.

# File 'lib/axlsx/drawing/bar_3D_chart.rb', line 12
 
-def catAxis
-  @catAxis
-end
+def catAxis + @catAxis +end + @@ -780,9 +800,10 @@ width.

- -

space between bar or column clusters, as a percentage of the bar or column -width.

+

+space between bar or column clusters, as a percentage of the bar or column +width. +

@@ -816,9 +837,10 @@ width.

# File 'lib/axlsx/drawing/bar_3D_chart.rb', line 25
 
-def gapDepth
-  @gapDepth
-end
+def gapDepth + @gapDepth +end + @@ -836,9 +858,10 @@ width.

- -

space between bar or column clusters, as a percentage of the bar or column -width.

+

+space between bar or column clusters, as a percentage of the bar or column +width. +

@@ -872,9 +895,10 @@ width.

# File 'lib/axlsx/drawing/bar_3D_chart.rb', line 29
 
-def gapWidth
-  @gapWidth
-end
+def gapWidth + @gapWidth +end + @@ -892,9 +916,10 @@ width.

- -

grouping for a column, line, or area chart. must be one of -[:percentStacked, :clustered, :standard, :stacked]

+

+grouping for a column, line, or area chart. must be one of +[:percentStacked, :clustered, :standard, :stacked] +

@@ -928,9 +953,10 @@ width.

# File 'lib/axlsx/drawing/bar_3D_chart.rb', line 34
 
-def grouping
-  @grouping
-end
+def grouping + @grouping +end + @@ -948,9 +974,10 @@ width.

- -

The shabe of the bars or columns must be one of [:cone, :coneToMax, :box, -:cylinder, :pyramid, :pyramidToMax]

+

+The shabe of the bars or columns must be one of [:cone, :coneToMax, :box, +:cylinder, :pyramid, :pyramidToMax] +

@@ -984,9 +1011,10 @@ width.

# File 'lib/axlsx/drawing/bar_3D_chart.rb', line 39
 
-def shape
-  @shape
-end
+def shape + @shape +end + @@ -1004,8 +1032,9 @@ width.

- -

the valueaxis

+

+the valueaxis +

@@ -1039,9 +1068,10 @@ width.

# File 'lib/axlsx/drawing/bar_3D_chart.rb', line 16
 
-def valAxis
-  @valAxis
-end
+def valAxis + @valAxis +end + @@ -1063,8 +1093,9 @@ width.

- -

Serializes the bar chart

+

+Serializes the bar chart +

@@ -1113,24 +1144,25 @@ width.

# File 'lib/axlsx/drawing/bar_3D_chart.rb', line 109
 
-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
+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 + @@ -1141,9 +1173,9 @@ width.

-- cgit v1.2.3