From 8b5164163c705e55ae10704c88534fc2ce50c407 Mon Sep 17 00:00:00 2001 From: Randy Morgan Date: Mon, 21 Nov 2011 23:46:07 +0900 Subject: version bump and docs update --- .yardoc/checksums | 28 +- .yardoc/objects/root.dat | Bin 406538 -> 425443 bytes doc/Axlsx.html | 6 +- doc/Axlsx/App.html | 2 +- doc/Axlsx/Axis.html | 4 +- doc/Axlsx/Bar3DChart.html | 8 +- doc/Axlsx/BarSeries.html | 6 +- doc/Axlsx/Border.html | 2 +- doc/Axlsx/BorderPr.html | 2 +- doc/Axlsx/CatAxis.html | 2 +- doc/Axlsx/Cell.html | 2 +- doc/Axlsx/CellAlignment.html | 2 +- doc/Axlsx/CellProtection.html | 2 +- doc/Axlsx/CellStyle.html | 2 +- doc/Axlsx/Chart.html | 220 +++++++--- doc/Axlsx/Color.html | 2 +- doc/Axlsx/ContentType.html | 2 +- doc/Axlsx/Core.html | 2 +- doc/Axlsx/DataTypeValidator.html | 2 +- doc/Axlsx/Default.html | 2 +- doc/Axlsx/Drawing.html | 106 ++--- doc/Axlsx/Fill.html | 2 +- doc/Axlsx/Font.html | 2 +- doc/Axlsx/GradientFill.html | 2 +- doc/Axlsx/GradientStop.html | 2 +- doc/Axlsx/GraphicFrame.html | 2 +- doc/Axlsx/Marker.html | 2 +- doc/Axlsx/NumFmt.html | 2 +- doc/Axlsx/Override.html | 2 +- doc/Axlsx/Package.html | 2 +- doc/Axlsx/PatternFill.html | 2 +- doc/Axlsx/Pie3DChart.html | 6 +- doc/Axlsx/PieSeries.html | 2 +- doc/Axlsx/RegexValidator.html | 2 +- doc/Axlsx/Relationship.html | 2 +- doc/Axlsx/Relationships.html | 2 +- doc/Axlsx/RestrictionValidator.html | 2 +- doc/Axlsx/Row.html | 2 +- doc/Axlsx/Scaling.html | 2 +- doc/Axlsx/Series.html | 26 +- doc/Axlsx/SimpleTypedList.html | 2 +- doc/Axlsx/Styles.html | 2 +- doc/Axlsx/TableStyle.html | 2 +- doc/Axlsx/TableStyleElement.html | 2 +- doc/Axlsx/TableStyles.html | 2 +- doc/Axlsx/Title.html | 18 +- doc/Axlsx/TwoCellAnchor.html | 2 +- doc/Axlsx/ValAxis.html | 2 +- doc/Axlsx/View3D.html | 2 +- doc/Axlsx/Workbook.html | 2 +- doc/Axlsx/Worksheet.html | 2 +- doc/Axlsx/Xf.html | 2 +- doc/_index.html | 50 ++- doc/class_list.html | 2 +- doc/file.README.html | 37 +- doc/index.html | 37 +- doc/method_list.html | 796 +++++++++++++++++++++--------------- doc/top-level-namespace.html | 2 +- lib/axlsx/util/constants.rb | 2 +- 59 files changed, 881 insertions(+), 555 deletions(-) diff --git a/.yardoc/checksums b/.yardoc/checksums index ebcb2a47..11790402 100644 --- a/.yardoc/checksums +++ b/.yardoc/checksums @@ -1,49 +1,53 @@ lib/axlsx/stylesheet/table_styles.rb 04b778652c29d612f63e93080d06c3936e48d765 lib/axlsx/stylesheet/table_style.rb b592135b8b02969a29bd24c28a13282f6af76f30 -lib/axlsx/drawing/pie_3D_chart.rb 9a93a6fcf43122ed41f522f50b9d0d0340be1688 +lib/axlsx/drawing/pie_3D_chart.rb dd669c8dc9ef1f762d45a9589260c8c17308d944 lib/axlsx/stylesheet/border_pr.rb 09dcb61ec7b0cf49f2da4c4f8ccba8f7e0df7b07 lib/axlsx/stylesheet/color.rb 4927aaebe27dda42d78bb7baf9a44edc1753c77f lib/axlsx/drawing/marker.rb 3507738522c02a3733a01f115d9ef22fae4ea542 lib/axlsx/util/constants.rb ebb670bf42bffc225281bcec13e654118603c698 lib/axlsx/stylesheet/cell_protection.rb ce494f9add6de0a51407ddd9122fffe95759a48a lib/axlsx/stylesheet/cell_style.rb 46c6ff183bce5c6b1ab6228823257d638007b03c -lib/axlsx/drawing/series.rb 76a9b00ab44c4b9553a017aa25f7f504c2b41484 +lib/axlsx/drawing/series_title.rb 7ace4ba7c7835db5a7c69d2319cd59ed8c45908a +lib/axlsx/drawing/line_series.rb 80f2c27edafacbc5de9bb4fac9916b0ad0030a63 +lib/axlsx/drawing/series.rb b35c182d9e3b09d99f743d3828344c4e5ac9c373 lib/axlsx/package.rb eea7499e09e0936eeb8e08d10823f05990722023 lib/axlsx/stylesheet/cell_alignment.rb f67f6a0bc16bf13669ed7b18714e4de23825ed94 lib/axlsx/content_type/default.rb 8ec0d9d1e6bf261735739823acd460c271e3f5ed -lib/axlsx/drawing/title.rb 7069b1c32bd209addd9808be005dae176819b8e0 +lib/axlsx/drawing/title.rb b46fb082e3bea936d129c8aa0998f3b71c9838cc lib/axlsx/drawing/axis.rb 5316065040d08d4f15e5da2751a2ee90185dad61 lib/axlsx/stylesheet/table_style_element.rb bee66d743e3113fb14adc7ebdecbeb606bfb49fc lib/axlsx/content_type/content_type.rb 6c576e1618f99f7163fffa6b6e89e964653dcb5f -lib/axlsx/stylesheet/num_fmt.rb dc830c6540465afa824881efa2f1ce4070957c47 lib/axlsx/rels/relationships.rb 9c741e180796259bb378a789fd484fa1d8f04425 +lib/axlsx/stylesheet/num_fmt.rb dc830c6540465afa824881efa2f1ce4070957c47 lib/axlsx.rb 7d8c589a0bdc16acf8774ae1b77d5177b030a80c -lib/axlsx/drawing/graphic_frame.rb 5ff7476b8fa3e2101fde200d1c65844084fb42f7 lib/axlsx/content_type/override.rb 72245683bca868f181d709a515f9152485653229 +lib/axlsx/drawing/graphic_frame.rb 5ff7476b8fa3e2101fde200d1c65844084fb42f7 lib/axlsx/drawing/pie_series.rb 76c67a0227e913fb14eb70d756323974718e204a -lib/axlsx/drawing/bar_series.rb a8a1648a1bec8d3d4bc07786f2c55c0c0d658e15 +lib/axlsx/drawing/bar_series.rb 48eb4533dd8fa89c40a8ab05e78cdb7b8061fd62 lib/axlsx/stylesheet/gradient_fill.rb 5fd260ec2b94ab75a970159035528548a9d21cd6 lib/axlsx/workbook/worksheet/row.rb f866a98341ce4e604908e42d00f2af09e58c75d2 lib/axlsx/util/simple_typed_list.rb 2ae647d5305acd9181c3303d5638db46d190b786 lib/axlsx/workbook/workbook.rb ec98ed826e6c3ca9c6e3303dbfbe00c0b5fb9aee -lib/axlsx/stylesheet/fill.rb 35966285f5d759d63451005ceae3a5ae5ba2ceca lib/axlsx/drawing/view_3D.rb aca4d987f0c2cd5d0a653c96ac2bc1df9392583a +lib/axlsx/stylesheet/fill.rb 35966285f5d759d63451005ceae3a5ae5ba2ceca lib/axlsx/stylesheet/xf.rb e3d6e2e4c3b0b33c91de4c3db16c73aca3db4473 lib/axlsx/drawing/two_cell_anchor.rb cc320f580ff9c639daa670f7ba1a1648bf26c157 lib/axlsx/stylesheet/styles.rb 3679a8fe86270bdef96f02bcf76f2eac27b1c2ef -lib/axlsx/drawing/val_axis.rb 710e67120c1262ef4cbbb56b632a568731df3215 lib/axlsx/drawing/cat_axis.rb bf9eae6efae39b003a98b44cc437e6e9b4c51985 +lib/axlsx/drawing/val_axis.rb 710e67120c1262ef4cbbb56b632a568731df3215 lib/axlsx/stylesheet/font.rb 8b002d5fcba2fb0979858517f5254aadf96c7e58 lib/axlsx/util/validators.rb 2320eee50ceee29cc0dbab95721a6c633dc660e1 lib/axlsx/doc_props/app.rb 52f01e985a33253987177798d4e79ed208649b30 lib/axlsx/workbook/worksheet/worksheet.rb 1af6b7e4a54b41e770709c26ad7100ed516448b8 lib/axlsx/workbook/worksheet/cell.rb 939623ffc2065e9ec26bc56d9e289d9137fe57d3 -lib/axlsx/stylesheet/border.rb 517bfcb43380919ce7abef494d5d3e50911b7c19 lib/axlsx/rels/relationship.rb a160c998acf7fd0ab8195ea6162b1eb2eab4963c -lib/axlsx/drawing/drawing.rb cdb97d463eb539baf96a105493aca17d7ddf57e5 -lib/axlsx/drawing/chart.rb 41dce85f81b7f5d5df3493597c1560d0f0c50c62 +lib/axlsx/stylesheet/border.rb 517bfcb43380919ce7abef494d5d3e50911b7c19 +lib/axlsx/drawing/ser_axis.rb e1072fa920f084e22fc6ef4697d3f7d455fb0550 +lib/axlsx/drawing/drawing.rb ca457723c04ec7f2c9d3d16846b4cf0a9045da07 +lib/axlsx/drawing/chart.rb 059fa0f1af9e145f2b28871ea4aaa70653ec589f lib/axlsx/stylesheet/gradient_stop.rb de34e289aeccb4abd9a3b7e60e816a0b12ffacff lib/axlsx/doc_props/core.rb 90ebc8086f6606af02275c27068c359a5647faf0 -lib/axlsx/drawing/bar_3D_chart.rb 68a516574b727bf9fc7e030d13060eaf7e36221e +lib/axlsx/drawing/bar_3D_chart.rb 90ee990d00f63aaa8bfa23805580b3fea16a74ac lib/axlsx/drawing/scaling.rb d3b59eed1897dc2b07bb41b2245c6e4b3e274d7e lib/axlsx/stylesheet/pattern_fill.rb 817cf55beb3db160b2b56edb6c94de1ecf1ecee7 +lib/axlsx/drawing/line_3D_chart.rb 062b83115dccb3b67c737faea1adf5f0cfce1cea diff --git a/.yardoc/objects/root.dat b/.yardoc/objects/root.dat index 24b29118..24d12b6c 100644 Binary files a/.yardoc/objects/root.dat and b/.yardoc/objects/root.dat differ diff --git a/doc/Axlsx.html b/doc/Axlsx.html index bd7f61fd..eba574fe 100644 --- a/doc/Axlsx.html +++ b/doc/Axlsx.html @@ -73,7 +73,7 @@
Defined in:
lib/axlsx/package.rb,
- lib/axlsx.rb,
lib/axlsx/drawing/axis.rb,
lib/axlsx/drawing/chart.rb,
lib/axlsx/stylesheet/xf.rb,
lib/axlsx/doc_props/app.rb,
lib/axlsx/drawing/title.rb,
lib/axlsx/util/constants.rb,
lib/axlsx/doc_props/core.rb,
lib/axlsx/drawing/marker.rb,
lib/axlsx/drawing/series.rb,
lib/axlsx/drawing/view_3D.rb,
lib/axlsx/util/validators.rb,
lib/axlsx/stylesheet/font.rb,
lib/axlsx/stylesheet/fill.rb,
lib/axlsx/drawing/scaling.rb,
lib/axlsx/drawing/drawing.rb,
lib/axlsx/drawing/cat_axis.rb,
lib/axlsx/stylesheet/color.rb,
lib/axlsx/drawing/val_axis.rb,
lib/axlsx/stylesheet/styles.rb,
lib/axlsx/workbook/workbook.rb,
lib/axlsx/rels/relationship.rb,
lib/axlsx/stylesheet/border.rb,
lib/axlsx/rels/relationships.rb,
lib/axlsx/drawing/bar_series.rb,
lib/axlsx/drawing/pie_series.rb,
lib/axlsx/stylesheet/num_fmt.rb,
lib/axlsx/drawing/bar_3D_chart.rb,
lib/axlsx/stylesheet/border_pr.rb,
lib/axlsx/content_type/default.rb,
lib/axlsx/drawing/pie_3D_chart.rb,
lib/axlsx/content_type/override.rb,
lib/axlsx/stylesheet/cell_style.rb,
lib/axlsx/drawing/graphic_frame.rb,
lib/axlsx/util/simple_typed_list.rb,
lib/axlsx/workbook/worksheet/row.rb,
lib/axlsx/stylesheet/table_style.rb,
lib/axlsx/stylesheet/pattern_fill.rb,
lib/axlsx/stylesheet/table_styles.rb,
lib/axlsx/workbook/worksheet/cell.rb,
lib/axlsx/drawing/two_cell_anchor.rb,
lib/axlsx/stylesheet/gradient_stop.rb,
lib/axlsx/stylesheet/gradient_fill.rb,
lib/axlsx/stylesheet/cell_alignment.rb,
lib/axlsx/content_type/content_type.rb,
lib/axlsx/stylesheet/cell_protection.rb,
lib/axlsx/workbook/worksheet/worksheet.rb,
lib/axlsx/stylesheet/table_style_element.rb
+ lib/axlsx.rb,
lib/axlsx/drawing/axis.rb,
lib/axlsx/drawing/chart.rb,
lib/axlsx/stylesheet/xf.rb,
lib/axlsx/doc_props/app.rb,
lib/axlsx/drawing/title.rb,
lib/axlsx/util/constants.rb,
lib/axlsx/doc_props/core.rb,
lib/axlsx/drawing/marker.rb,
lib/axlsx/drawing/series.rb,
lib/axlsx/drawing/drawing.rb,
lib/axlsx/drawing/scaling.rb,
lib/axlsx/stylesheet/fill.rb,
lib/axlsx/util/validators.rb,
lib/axlsx/drawing/view_3D.rb,
lib/axlsx/stylesheet/font.rb,
lib/axlsx/drawing/val_axis.rb,
lib/axlsx/drawing/ser_axis.rb,
lib/axlsx/stylesheet/color.rb,
lib/axlsx/drawing/cat_axis.rb,
lib/axlsx/stylesheet/styles.rb,
lib/axlsx/workbook/workbook.rb,
lib/axlsx/stylesheet/border.rb,
lib/axlsx/rels/relationship.rb,
lib/axlsx/drawing/bar_series.rb,
lib/axlsx/stylesheet/num_fmt.rb,
lib/axlsx/drawing/pie_series.rb,
lib/axlsx/rels/relationships.rb,
lib/axlsx/drawing/line_series.rb,
lib/axlsx/stylesheet/border_pr.rb,
lib/axlsx/content_type/default.rb,
lib/axlsx/drawing/series_title.rb,
lib/axlsx/drawing/pie_3D_chart.rb,
lib/axlsx/drawing/bar_3D_chart.rb,
lib/axlsx/stylesheet/cell_style.rb,
lib/axlsx/drawing/graphic_frame.rb,
lib/axlsx/content_type/override.rb,
lib/axlsx/drawing/line_3D_chart.rb,
lib/axlsx/util/simple_typed_list.rb,
lib/axlsx/workbook/worksheet/row.rb,
lib/axlsx/stylesheet/table_style.rb,
lib/axlsx/workbook/worksheet/cell.rb,
lib/axlsx/stylesheet/table_styles.rb,
lib/axlsx/drawing/two_cell_anchor.rb,
lib/axlsx/stylesheet/pattern_fill.rb,
lib/axlsx/stylesheet/gradient_fill.rb,
lib/axlsx/stylesheet/gradient_stop.rb,
lib/axlsx/content_type/content_type.rb,
lib/axlsx/stylesheet/cell_alignment.rb,
lib/axlsx/stylesheet/cell_protection.rb,
lib/axlsx/workbook/worksheet/worksheet.rb,
lib/axlsx/stylesheet/table_style_element.rb
@@ -98,7 +98,7 @@ cell styles, automatically resized column widths and 3D pie charts. - Classes: App, Axis, Bar3DChart, BarSeries, Border, BorderPr, CatAxis, Cell, CellAlignment, CellProtection, CellStyle, Chart, Color, ContentType, Core, DataTypeValidator, Default, Drawing, Fill, Font, GradientFill, GradientStop, GraphicFrame, Marker, NumFmt, Override, Package, PatternFill, Pie3DChart, PieSeries, RegexValidator, Relationship, Relationships, RestrictionValidator, Row, Scaling, Series, SimpleTypedList, Styles, TableStyle, TableStyleElement, TableStyles, Title, TwoCellAnchor, ValAxis, View3D, Workbook, Worksheet, Xf + Classes: App, Axis, Bar3DChart, BarSeries, Border, BorderPr, CatAxis, Cell, CellAlignment, CellProtection, CellStyle, Chart, Color, ContentType, Core, DataTypeValidator, Default, Drawing, Fill, Font, GradientFill, GradientStop, GraphicFrame, Line3DChart, LineSeries, Marker, NumFmt, Override, Package, PatternFill, Pie3DChart, PieSeries, RegexValidator, Relationship, Relationships, RestrictionValidator, Row, Scaling, SerAxis, Series, SeriesTitle, SimpleTypedList, Styles, TableStyle, TableStyleElement, TableStyles, Title, TwoCellAnchor, ValAxis, View3D, Workbook, Worksheet, Xf

@@ -2434,7 +2434,7 @@ The value validated diff --git a/doc/Axlsx/App.html b/doc/Axlsx/App.html index ceacd9b7..cabd1e88 100644 --- a/doc/Axlsx/App.html +++ b/doc/Axlsx/App.html @@ -2631,7 +2631,7 @@ The document as a string diff --git a/doc/Axlsx/Axis.html b/doc/Axlsx/Axis.html index bd28e976..980939ef 100644 --- a/doc/Axlsx/Axis.html +++ b/doc/Axlsx/Axis.html @@ -106,7 +106,7 @@ the access class defines common properties and values for chart axis

Direct Known Subclasses

-

CatAxis, ValAxis

+

CatAxis, SerAxis, ValAxis

@@ -1038,7 +1038,7 @@ The document builder instance this objects xml will be added to. diff --git a/doc/Axlsx/Bar3DChart.html b/doc/Axlsx/Bar3DChart.html index 1d6f3539..82b4f37b 100644 --- a/doc/Axlsx/Bar3DChart.html +++ b/doc/Axlsx/Bar3DChart.html @@ -392,7 +392,7 @@ the category axis.

Attributes inherited from Chart

-

end_at, graphic_frame, index, pn, series, series_type, show_legend, start_at, title, view3D

+

end_at, graphic_frame, index, pn, series, series_type, show_legend, start_at, style, title, view3D

@@ -624,8 +624,6 @@ a customizable set of options
# File 'lib/axlsx/drawing/bar_3D_chart.rb', line 79
 
 def initialize(frame, options={})
-  super(frame, options)      
-  @series_type = BarSeries
   @barDir = :bar
   @grouping = :clustered
   @catAxId = rand(8 ** 8)
@@ -633,6 +631,8 @@ a customizable set of options
   @catAxis = CatAxis.new(@catAxId, @valAxId)
   @valAxis = ValAxis.new(@valAxId, @catAxId)
   @view3D = View3D.new(:rAngAx=>1)
+  super(frame, options)      
+  @series_type = BarSeries
 end
 
@@ -1144,7 +1144,7 @@ Serializes the bar chart diff --git a/doc/Axlsx/BarSeries.html b/doc/Axlsx/BarSeries.html index 5384a077..02884b20 100644 --- a/doc/Axlsx/BarSeries.html +++ b/doc/Axlsx/BarSeries.html @@ -702,7 +702,8 @@ The document builder instance this objects xml will be added to. 74 75 76 -77 +77 +78
# File 'lib/axlsx/drawing/bar_series.rb', line 43
@@ -740,6 +741,7 @@ The document builder instance this objects xml will be added to.
         }                        
       }
     }
+    xml.send('c:shape', :val=>@shape)
   end      
 end
 
@@ -753,7 +755,7 @@ The document builder instance this objects xml will be added to. diff --git a/doc/Axlsx/Border.html b/doc/Axlsx/Border.html index 24d11058..e52f64e7 100644 --- a/doc/Axlsx/Border.html +++ b/doc/Axlsx/Border.html @@ -766,7 +766,7 @@ The document builder instance this objects xml will be added to. diff --git a/doc/Axlsx/BorderPr.html b/doc/Axlsx/BorderPr.html index f9a93ed0..4a8fe417 100644 --- a/doc/Axlsx/BorderPr.html +++ b/doc/Axlsx/BorderPr.html @@ -700,7 +700,7 @@ The document builder instance this objects xml will be added to. diff --git a/doc/Axlsx/CatAxis.html b/doc/Axlsx/CatAxis.html index 891168a1..7c2ccee8 100644 --- a/doc/Axlsx/CatAxis.html +++ b/doc/Axlsx/CatAxis.html @@ -757,7 +757,7 @@ The document builder instance this objects xml will be added to. diff --git a/doc/Axlsx/Cell.html b/doc/Axlsx/Cell.html index 9f90513f..163b909a 100644 --- a/doc/Axlsx/Cell.html +++ b/doc/Axlsx/Cell.html @@ -1614,7 +1614,7 @@ xml text for the cell diff --git a/doc/Axlsx/CellAlignment.html b/doc/Axlsx/CellAlignment.html index 07651c06..9b5fcf4e 100644 --- a/doc/Axlsx/CellAlignment.html +++ b/doc/Axlsx/CellAlignment.html @@ -1238,7 +1238,7 @@ The document builder instance this objects xml will be added to. diff --git a/doc/Axlsx/CellProtection.html b/doc/Axlsx/CellProtection.html index 9f0d06d6..65fcf78f 100644 --- a/doc/Axlsx/CellProtection.html +++ b/doc/Axlsx/CellProtection.html @@ -556,7 +556,7 @@ The document builder instance this objects xml will be added to. diff --git a/doc/Axlsx/CellStyle.html b/doc/Axlsx/CellStyle.html index f3dfc76b..7bcc7bfa 100644 --- a/doc/Axlsx/CellStyle.html +++ b/doc/Axlsx/CellStyle.html @@ -940,7 +940,7 @@ The document builder instance this objects xml will be added to. diff --git a/doc/Axlsx/Chart.html b/doc/Axlsx/Chart.html index d60170e6..af6c0596 100644 --- a/doc/Axlsx/Chart.html +++ b/doc/Axlsx/Chart.html @@ -116,7 +116,7 @@ A Chart is the superclass for specific charts

Direct Known Subclasses

-

Bar3DChart, Pie3DChart

+

Bar3DChart, Line3DChart, Pie3DChart

@@ -336,6 +336,33 @@ The starting marker for this chart.

+ + + +
  • + + + - (Integer) style + + + + + + + + + + + + + + + +

    +The style for the chart. +

    +
    +
  • @@ -614,22 +641,24 @@ the object that the method was called on
     
     
    -52
    -53
    -54
    -55
    -56
    -57
     58
     59
     60
     61
    -62
    +62 +63 +64 +65 +66 +67 +68 +69 -
    # File 'lib/axlsx/drawing/chart.rb', line 52
    +      
    # File 'lib/axlsx/drawing/chart.rb', line 58
     
     def initialize(frame, options={})
    +  @style = 2
       @graphic_frame=frame
       @graphic_frame.anchor.drawing.worksheet.workbook.charts << self
       @series = SimpleTypedList.new Series
    @@ -692,12 +721,12 @@ The ending marker for this chart
           
     
     
    -42
    -43
    -44
    +48 +49 +50
    -
    # File 'lib/axlsx/drawing/chart.rb', line 42
    +      
    # File 'lib/axlsx/drawing/chart.rb', line 48
     
     def end_at
       @end_at
    @@ -749,12 +778,12 @@ A reference to the graphic frame that owns this chart
           
     
     
    -15
    -16
    -17
    +21 +22 +23
    -
    # File 'lib/axlsx/drawing/chart.rb', line 15
    +      
    # File 'lib/axlsx/drawing/chart.rb', line 21
     
     def graphic_frame
       @graphic_frame
    @@ -806,12 +835,12 @@ The index of this chart in the workbooks charts collection
           
     
     
    -27
    -28
    -29
    +33 +34 +35
    -
    # File 'lib/axlsx/drawing/chart.rb', line 27
    +      
    # File 'lib/axlsx/drawing/chart.rb', line 33
     
     def index
       @graphic_frame.anchor.drawing.worksheet.workbook.charts.index(self)
    @@ -863,12 +892,12 @@ The part name for this chart
           
     
     
    -31
    -32
    -33
    +37 +38 +39
    -
    # File 'lib/axlsx/drawing/chart.rb', line 31
    +      
    # File 'lib/axlsx/drawing/chart.rb', line 37
     
     def pn
       "#{CHART_PN % (index+1)}"
    @@ -920,12 +949,12 @@ A collection of series objects that are applied to the chart
           
     
     
    -19
    -20
    -21
    +25 +26 +27
    -
    # File 'lib/axlsx/drawing/chart.rb', line 19
    +      
    # File 'lib/axlsx/drawing/chart.rb', line 25
     
     def series
       @series
    @@ -977,12 +1006,12 @@ The type of series to use for this chart
           
     
     
    -23
    -24
    -25
    +29 +30 +31
    -
    # File 'lib/axlsx/drawing/chart.rb', line 23
    +      
    # File 'lib/axlsx/drawing/chart.rb', line 29
     
     def series_type
       @series_type
    @@ -1034,12 +1063,12 @@ Show the legend in the chart
           
     
     
    -46
    -47
    -48
    +52 +53 +54
    -
    # File 'lib/axlsx/drawing/chart.rb', line 46
    +      
    # File 'lib/axlsx/drawing/chart.rb', line 52
     
     def show_legend
       @show_legend
    @@ -1091,12 +1120,12 @@ The starting marker for this chart
           
     
     
    -38
    -39
    -40
    +44 +45 +46
    -
    # File 'lib/axlsx/drawing/chart.rb', line 38
    +      
    # File 'lib/axlsx/drawing/chart.rb', line 44
     
     def start_at
       @start_at
    @@ -1108,6 +1137,63 @@ The starting marker for this chart
     
         
           
    +      
    +      
    +      
    +

    + + - (Integer) style + + + +

    +
    +

    +The style for the chart. see ECMA Part 1 ยง21.2.2.196 +

    + + +
    +
    +
    + +

    Returns:

    +
      + +
    • + + + (Integer) + + + +
    • + +
    + +
    + + + + +
    +
    +
    +
    +14
    +15
    +16
    +
    +
    # File 'lib/axlsx/drawing/chart.rb', line 14
    +
    +def style
    +  @style
    +end
    +
    +
    +
    + +
    @@ -1148,12 +1234,12 @@ The title object for the chart.
     
     
    -8
     9
    -10
    +10 +11
    -
    # File 'lib/axlsx/drawing/chart.rb', line 8
    +      
    # File 'lib/axlsx/drawing/chart.rb', line 9
     
     def title
       @title
    @@ -1192,12 +1278,12 @@ The 3D view properties for the chart
           
     
     
    -11
    -12
    -13
    +17 +18 +19
    -
    # File 'lib/axlsx/drawing/chart.rb', line 11
    +      
    # File 'lib/axlsx/drawing/chart.rb', line 17
     
     def view3D
       @view3D
    @@ -1260,13 +1346,13 @@ Adds a new series to the chart’s series collection.
           
     
     
    -85
    -86
    -87
    -88
    +94 +95 +96 +97
    -
    # File 'lib/axlsx/drawing/chart.rb', line 85
    +      
    # File 'lib/axlsx/drawing/chart.rb', line 94
     
     def add_series(options={})
       @series_type.new(self, options)
    @@ -1303,15 +1389,6 @@ Chart Serialization serializes the chart
           
     
     
    -92
    -93
    -94
    -95
    -96
    -97
    -98
    -99
    -100
     101
     102
     103
    @@ -1323,14 +1400,27 @@ Chart Serialization serializes the chart
     109
     110
     111
    -112
    +112 +113 +114 +115 +116 +117 +118 +119 +120 +121 +122 +123
    -
    # File 'lib/axlsx/drawing/chart.rb', line 92
    +      
    # File 'lib/axlsx/drawing/chart.rb', line 101
     
     def to_xml
       builder = Nokogiri::XML::Builder.new(:encoding => ENCODING) do |xml|
         xml.send('c:chartSpace',:'xmlns:c' => XML_NS_C, :'xmlns:a' => XML_NS_A) {
    +      xml.send('c:date1904', :val=>Axlsx::Workbook.date1904)
    +      xml.send('c:style', :val=>style)
           xml.send('c:chart') {
             @title.to_xml(xml) unless @title.nil?
             @view3D.to_xml(xml) unless @view3D.nil?
    @@ -1360,7 +1450,7 @@ Chart Serialization serializes the chart
     
         
         
    diff --git a/doc/Axlsx/Color.html b/doc/Axlsx/Color.html
    index 9a5fdbc8..5cfc7ac6 100644
    --- a/doc/Axlsx/Color.html
    +++ b/doc/Axlsx/Color.html
    @@ -656,7 +656,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/ContentType.html b/doc/Axlsx/ContentType.html
    index 72b5f52c..a60a275b 100644
    --- a/doc/Axlsx/ContentType.html
    +++ b/doc/Axlsx/ContentType.html
    @@ -331,7 +331,7 @@ The document as a string.
     
         
         
    diff --git a/doc/Axlsx/Core.html b/doc/Axlsx/Core.html
    index 2b9f51f4..19f5431b 100644
    --- a/doc/Axlsx/Core.html
    +++ b/doc/Axlsx/Core.html
    @@ -456,7 +456,7 @@ time when this method is called.
     
         
         
    diff --git a/doc/Axlsx/DataTypeValidator.html b/doc/Axlsx/DataTypeValidator.html
    index 31b3bb99..15afbfc9 100644
    --- a/doc/Axlsx/DataTypeValidator.html
    +++ b/doc/Axlsx/DataTypeValidator.html
    @@ -315,7 +315,7 @@ types or the block passed returns false
     
         
         
    diff --git a/doc/Axlsx/Default.html b/doc/Axlsx/Default.html
    index 961e096e..9c005b15 100644
    --- a/doc/Axlsx/Default.html
    +++ b/doc/Axlsx/Default.html
    @@ -566,7 +566,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/Drawing.html b/doc/Axlsx/Drawing.html
    index e6f1fb51..fffef370 100644
    --- a/doc/Axlsx/Drawing.html
    +++ b/doc/Axlsx/Drawing.html
    @@ -487,15 +487,15 @@ The worksheet that owns this drawing
           
     
     
    -63
    -64
    -65
    -66
     67
    -68
    +68 +69 +70 +71 +72
    -
    # File 'lib/axlsx/drawing/drawing.rb', line 63
    +      
    # File 'lib/axlsx/drawing/drawing.rb', line 67
     
     def initialize(worksheet)
       DataTypeValidator.validate "Drawing.worksheet", Worksheet, worksheet
    @@ -555,12 +555,12 @@ A collection of anchors for this drawing
           
     
     
    -35
    -36
    -37
    +39 +40 +41
    -
    # File 'lib/axlsx/drawing/drawing.rb', line 35
    +      
    # File 'lib/axlsx/drawing/drawing.rb', line 39
     
     def anchors
       @anchors
    @@ -612,12 +612,12 @@ An array of charts that are associated with this drawing’s anchors
           
     
     
    -39
    -40
    -41
    +43 +44 +45
    -
    # File 'lib/axlsx/drawing/drawing.rb', line 39
    +      
    # File 'lib/axlsx/drawing/drawing.rb', line 43
     
     def charts
       @anchors.map { |a| a.graphic_frame.chart }
    @@ -670,12 +670,12 @@ collection.
           
     
     
    -43
    -44
    -45
    +47 +48 +49
    -
    # File 'lib/axlsx/drawing/drawing.rb', line 43
    +      
    # File 'lib/axlsx/drawing/drawing.rb', line 47
     
     def index
       @worksheet.workbook.drawings.index(self)
    @@ -727,12 +727,12 @@ The part name for this drawing
           
     
     
    -51
    -52
    -53
    +55 +56 +57
    -
    # File 'lib/axlsx/drawing/drawing.rb', line 51
    +      
    # File 'lib/axlsx/drawing/drawing.rb', line 55
     
     def pn
       "#{DRAWING_PN % (index+1)}"
    @@ -784,17 +784,17 @@ The drawing’s relationships.
           
     
     
    -59
    -60
    -61
    -62
     63
     64
     65
    -66
    +66 +67 +68 +69 +70
    -
    # File 'lib/axlsx/drawing/drawing.rb', line 59
    +      
    # File 'lib/axlsx/drawing/drawing.rb', line 63
     
     def relationships
       r = Relationships.new
    @@ -851,12 +851,12 @@ The relational part name for this drawing
           
     
     
    -55
    -56
    -57
    +59 +60 +61
    -
    # File 'lib/axlsx/drawing/drawing.rb', line 55
    +      
    # File 'lib/axlsx/drawing/drawing.rb', line 59
     
     def rels_pn
       "#{DRAWING_RELS_PN % (index+1)}"
    @@ -908,12 +908,12 @@ The relation reference id for this drawing
           
     
     
    -47
    -48
    -49
    +51 +52 +53
    -
    # File 'lib/axlsx/drawing/drawing.rb', line 47
    +      
    # File 'lib/axlsx/drawing/drawing.rb', line 51
     
     def rId
       "rId#{index+1}"
    @@ -965,12 +965,12 @@ The worksheet that owns the drawing
           
     
     
    -30
    -31
    -32
    +34 +35 +36
    -
    # File 'lib/axlsx/drawing/drawing.rb', line 30
    +      
    # File 'lib/axlsx/drawing/drawing.rb', line 34
     
     def worksheet
       @worksheet
    @@ -1056,14 +1056,14 @@ The class of the chart to be added to the drawing
           
     
     
    -75
    -76
    -77
    -78
    -79
    +79 +80 +81 +82 +83
    -
    # File 'lib/axlsx/drawing/drawing.rb', line 75
    +      
    # File 'lib/axlsx/drawing/drawing.rb', line 79
     
     def add_chart(chart_type, options={})
       DataTypeValidator.validate "Drawing.chart_type", Chart, chart_type 
    @@ -1114,17 +1114,17 @@ Serializes the drawing
           
     
     
    -112
    -113
    -114
    -115
     116
     117
     118
    -119
    +119 +120 +121 +122 +123
    -
    # File 'lib/axlsx/drawing/drawing.rb', line 112
    +      
    # File 'lib/axlsx/drawing/drawing.rb', line 116
     
     def to_xml
       builder = Nokogiri::XML::Builder.new(:encoding => ENCODING) do |xml|
    @@ -1145,7 +1145,7 @@ Serializes the drawing
     
         
         
    diff --git a/doc/Axlsx/Fill.html b/doc/Axlsx/Fill.html
    index 65103017..c2a1d64c 100644
    --- a/doc/Axlsx/Fill.html
    +++ b/doc/Axlsx/Fill.html
    @@ -451,7 +451,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/Font.html b/doc/Axlsx/Font.html
    index 8e829ac3..ada7b676 100644
    --- a/doc/Axlsx/Font.html
    +++ b/doc/Axlsx/Font.html
    @@ -1545,7 +1545,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/GradientFill.html b/doc/Axlsx/GradientFill.html
    index bfc9407a..3c37b50c 100644
    --- a/doc/Axlsx/GradientFill.html
    +++ b/doc/Axlsx/GradientFill.html
    @@ -1017,7 +1017,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/GradientStop.html b/doc/Axlsx/GradientStop.html
    index 51727c98..f5f8ece1 100644
    --- a/doc/Axlsx/GradientStop.html
    +++ b/doc/Axlsx/GradientStop.html
    @@ -517,7 +517,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/GraphicFrame.html b/doc/Axlsx/GraphicFrame.html
    index 6c259d82..ce46db59 100644
    --- a/doc/Axlsx/GraphicFrame.html
    +++ b/doc/Axlsx/GraphicFrame.html
    @@ -637,7 +637,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/Marker.html b/doc/Axlsx/Marker.html
    index b7212a79..68315516 100644
    --- a/doc/Axlsx/Marker.html
    +++ b/doc/Axlsx/Marker.html
    @@ -848,7 +848,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/NumFmt.html b/doc/Axlsx/NumFmt.html
    index afe2086f..0a4b42f2 100644
    --- a/doc/Axlsx/NumFmt.html
    +++ b/doc/Axlsx/NumFmt.html
    @@ -553,7 +553,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/Override.html b/doc/Axlsx/Override.html
    index 23d29842..a1935495 100644
    --- a/doc/Axlsx/Override.html
    +++ b/doc/Axlsx/Override.html
    @@ -559,7 +559,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/Package.html b/doc/Axlsx/Package.html
    index a9007719..87bd8c22 100644
    --- a/doc/Axlsx/Package.html
    +++ b/doc/Axlsx/Package.html
    @@ -1284,7 +1284,7 @@ An array of all validation errors encountered.
     
         
         
    diff --git a/doc/Axlsx/PatternFill.html b/doc/Axlsx/PatternFill.html
    index 3dcc6dd9..6772f0c7 100644
    --- a/doc/Axlsx/PatternFill.html
    +++ b/doc/Axlsx/PatternFill.html
    @@ -672,7 +672,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/Pie3DChart.html b/doc/Axlsx/Pie3DChart.html
    index ec7187c3..ef2ab02c 100644
    --- a/doc/Axlsx/Pie3DChart.html
    +++ b/doc/Axlsx/Pie3DChart.html
    @@ -170,7 +170,7 @@ Creating a chart
       

    Instance Attribute Summary

    Attributes inherited from Chart

    -

    end_at, graphic_frame, index, pn, series, series_type, show_legend, start_at, title, view3D

    +

    end_at, graphic_frame, index, pn, series, series_type, show_legend, start_at, style, title, view3D

    @@ -343,8 +343,8 @@ a customizable set of options
    # File 'lib/axlsx/drawing/pie_3D_chart.rb', line 41
     
     def initialize(workbook, options={})
    -  super(workbook, options)
       # this charts series type
    +  super(workbook, options)
       @series_type = PieSeries
       @view3D = View3D.new(:rotX => 30, :perspective => 30)
     end
    @@ -430,7 +430,7 @@ Serializes the pie chart
     
         
         
    diff --git a/doc/Axlsx/PieSeries.html b/doc/Axlsx/PieSeries.html
    index aa9adfee..75789976 100644
    --- a/doc/Axlsx/PieSeries.html
    +++ b/doc/Axlsx/PieSeries.html
    @@ -753,7 +753,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/RegexValidator.html b/doc/Axlsx/RegexValidator.html
    index 3d0b4c97..b1d029a6 100644
    --- a/doc/Axlsx/RegexValidator.html
    +++ b/doc/Axlsx/RegexValidator.html
    @@ -259,7 +259,7 @@ The value to validate.
     
         
         
    diff --git a/doc/Axlsx/Relationship.html b/doc/Axlsx/Relationship.html
    index 16e1e3e6..52eef338 100644
    --- a/doc/Axlsx/Relationship.html
    +++ b/doc/Axlsx/Relationship.html
    @@ -545,7 +545,7 @@ the reference id of the object.
     
         
         
    diff --git a/doc/Axlsx/Relationships.html b/doc/Axlsx/Relationships.html
    index e7b973ef..e98e2e3c 100644
    --- a/doc/Axlsx/Relationships.html
    +++ b/doc/Axlsx/Relationships.html
    @@ -334,7 +334,7 @@ Serializes the relationships document.
     
         
         
    diff --git a/doc/Axlsx/RestrictionValidator.html b/doc/Axlsx/RestrictionValidator.html
    index a6441a7d..1935862d 100644
    --- a/doc/Axlsx/RestrictionValidator.html
    +++ b/doc/Axlsx/RestrictionValidator.html
    @@ -291,7 +291,7 @@ Raised if the value provided is not in the list of choices.
     
         
         
    diff --git a/doc/Axlsx/Row.html b/doc/Axlsx/Row.html
    index d7e6d669..c840fd06 100644
    --- a/doc/Axlsx/Row.html
    +++ b/doc/Axlsx/Row.html
    @@ -762,7 +762,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/Scaling.html b/doc/Axlsx/Scaling.html
    index a2a24dbf..4d201069 100644
    --- a/doc/Axlsx/Scaling.html
    +++ b/doc/Axlsx/Scaling.html
    @@ -731,7 +731,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/Series.html b/doc/Axlsx/Series.html
    index 5da758f4..2c488521 100644
    --- a/doc/Axlsx/Series.html
    +++ b/doc/Axlsx/Series.html
    @@ -124,7 +124,7 @@ A Series defines the title, data and labels for chart data.
     
     

    Direct Known Subclasses

    -

    BarSeries, PieSeries

    +

    BarSeries, LineSeries, PieSeries

    @@ -215,7 +215,7 @@ The order of this series in the chart’s series.
  • - - (String) title + - (SeriesTitle) title @@ -589,7 +589,7 @@ The order of this series in the chart’s series.

    - - (String) title + - (SeriesTitle) title @@ -610,7 +610,7 @@ The title of the series

  • - (String) + (SeriesTitle) @@ -706,27 +706,23 @@ The document builder instance this objects xml will be added to.
     
     
    -57
    -58
    -59
    -60
     61
     62
     63
     64
     65
    -66
    +66 +67 +68
  • -
    # File 'lib/axlsx/drawing/series.rb', line 57
    +      
    # File 'lib/axlsx/drawing/series.rb', line 61
     
     def to_xml(xml)
       xml.send('c:ser') {
         xml.send('c:idx', :val=>index)
    -    xml.send('c:order', :val=>order || index)
    -    xml.send('c:tx') {
    -      xml.send('c:v', self.title)
    -    }
    +    xml.send('c:order', :val=>order || index)        
    +    title.to_xml(xml) unless title.nil?
         yield xml if block_given?
       }
     end
    @@ -741,7 +737,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/SimpleTypedList.html b/doc/Axlsx/SimpleTypedList.html
    index bc3e4b5f..70e588f5 100644
    --- a/doc/Axlsx/SimpleTypedList.html
    +++ b/doc/Axlsx/SimpleTypedList.html
    @@ -1608,7 +1608,7 @@ Unlock the list
     
         
         
    diff --git a/doc/Axlsx/Styles.html b/doc/Axlsx/Styles.html
    index 0fca6383..a91a665c 100644
    --- a/doc/Axlsx/Styles.html
    +++ b/doc/Axlsx/Styles.html
    @@ -1745,7 +1745,7 @@ Serializes the styles document
     
         
         
    diff --git a/doc/Axlsx/TableStyle.html b/doc/Axlsx/TableStyle.html
    index c8f1f93c..f78aec2c 100644
    --- a/doc/Axlsx/TableStyle.html
    +++ b/doc/Axlsx/TableStyle.html
    @@ -701,7 +701,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/TableStyleElement.html b/doc/Axlsx/TableStyleElement.html
    index 885d8e15..618bcdaf 100644
    --- a/doc/Axlsx/TableStyleElement.html
    +++ b/doc/Axlsx/TableStyleElement.html
    @@ -668,7 +668,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/TableStyles.html b/doc/Axlsx/TableStyles.html
    index fdb60660..6967532e 100644
    --- a/doc/Axlsx/TableStyles.html
    +++ b/doc/Axlsx/TableStyles.html
    @@ -590,7 +590,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/Title.html b/doc/Axlsx/Title.html
    index c55d9b51..625f1dc6 100644
    --- a/doc/Axlsx/Title.html
    +++ b/doc/Axlsx/Title.html
    @@ -104,8 +104,12 @@ A Title stores information about the title of a chart
     
    +
    +

    Direct Known Subclasses

    +

    SeriesTitle

    +

    Instance Attribute Summary (collapse)

      @@ -490,13 +494,13 @@ Cell object
       
       
      +62
       63
       64
      -65
      -66
      +65
    -
    # File 'lib/axlsx/drawing/title.rb', line 63
    +      
    # File 'lib/axlsx/drawing/title.rb', line 62
     
     def range
       return "" unless @data.is_a?(Cell)
    @@ -567,6 +571,7 @@ The document builder instance this objects xml will be added to.
           
     
     
    +42
     43
     44
     45
    @@ -580,11 +585,10 @@ The document builder instance this objects xml will be added to.
     53
     54
     55
    -56
    -57
    +56
    -
    # File 'lib/axlsx/drawing/title.rb', line 43
    +      
    # File 'lib/axlsx/drawing/title.rb', line 42
     
     def to_xml(xml)
       xml.send('c:title') {
    @@ -612,7 +616,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/TwoCellAnchor.html b/doc/Axlsx/TwoCellAnchor.html
    index b5ef9a71..0f235871 100644
    --- a/doc/Axlsx/TwoCellAnchor.html
    +++ b/doc/Axlsx/TwoCellAnchor.html
    @@ -1106,7 +1106,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/ValAxis.html b/doc/Axlsx/ValAxis.html
    index a1433dc5..c7e968b6 100644
    --- a/doc/Axlsx/ValAxis.html
    +++ b/doc/Axlsx/ValAxis.html
    @@ -530,7 +530,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/View3D.html b/doc/Axlsx/View3D.html
    index 31d98713..39dee6f8 100644
    --- a/doc/Axlsx/View3D.html
    +++ b/doc/Axlsx/View3D.html
    @@ -962,7 +962,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/Axlsx/Workbook.html b/doc/Axlsx/Workbook.html
    index adbeafcb..de654131 100644
    --- a/doc/Axlsx/Workbook.html
    +++ b/doc/Axlsx/Workbook.html
    @@ -1338,7 +1338,7 @@ Serializes the workbook document
     
         
         
    diff --git a/doc/Axlsx/Worksheet.html b/doc/Axlsx/Worksheet.html
    index 881561d0..e00f3633 100644
    --- a/doc/Axlsx/Worksheet.html
    +++ b/doc/Axlsx/Worksheet.html
    @@ -1855,7 +1855,7 @@ of Cell objects
     
         
         
    diff --git a/doc/Axlsx/Xf.html b/doc/Axlsx/Xf.html
    index b8462333..67fd183b 100644
    --- a/doc/Axlsx/Xf.html
    +++ b/doc/Axlsx/Xf.html
    @@ -1672,7 +1672,7 @@ The document builder instance this objects xml will be added to.
     
         
         
    diff --git a/doc/_index.html b/doc/_index.html
    index 8249c785..787429f1 100644
    --- a/doc/_index.html
    +++ b/doc/_index.html
    @@ -290,12 +290,19 @@
             
           
             
    -        
    +

    Generating A Line Chart

    + +
     p = Axlsx::Package.new
    + p.workbook.add_worksheet do |sheet|
    +   sheet.add_row ["First", 1, 5, 7, 9]
    +   sheet.add_row ["Second", 5, 2, 14, 9]
    +   sheet.add_chart(Axlsx::Line3DChart, :start_at => [0,2], :end_at => [10, 15], :title=>"example 6: Line Chart") do |chart|
    +     chart.add_series :data=>sheet.rows.first.cells[(1..-1)], :title=> sheet.rows.first.cells.first
    +     chart.add_series :data=>sheet.rows.last.cells[(1..-1)], :title=> sheet.rows.last.cells.first
    +   end
    + end  
    + p.serialize("example6.xlsx")
    +
    +

    Documentation

    This gem is 100% documented with YARD, an exceptional documentation library. To see documentation for this, and all the gems installed on your system use:

    @@ -191,21 +205,36 @@ It enables the you to generate 100% valid xlsx files that include customised sty
    • Updated documentation
    • +
    + +
  • October.21.11: 1.0.4 + +
    • altered package to accept a filename string for serialization instead of a File object.
    • Updated specs to conform
    • +
    • More examples for readme
    • +
    +
  • +
  • October.21.11: 1.05 + +
      +
    • Added support for line charts
    • +
    • Updated examples and readme
    • +
    • Updated series title to be a real title +Copyright
  • -

    Copyright

    +

    Axlsx © 2011 by Randy Morgan. Axlsx is licensed under the MIT license. Please see the LICENSE document for more information.

    diff --git a/doc/index.html b/doc/index.html index 10377a44..56188a47 100644 --- a/doc/index.html +++ b/doc/index.html @@ -61,8 +61,8 @@ Author: Randy Morgan Copyright: 2011
    License: MIT License
    -Latest Version: 1.0.2 -Release Date: November 20th 2011

    +Latest Version: 1.0.5 +Release Date: November 21st 2011

    Synopsis

    @@ -173,6 +173,20 @@ It enables the you to generate 100% valid xlsx files that include customised sty end
    +

    Generating A Line Chart

    + +
     p = Axlsx::Package.new
    + p.workbook.add_worksheet do |sheet|
    +   sheet.add_row ["First", 1, 5, 7, 9]
    +   sheet.add_row ["Second", 5, 2, 14, 9]
    +   sheet.add_chart(Axlsx::Line3DChart, :start_at => [0,2], :end_at => [10, 15], :title=>"example 6: Line Chart") do |chart|
    +     chart.add_series :data=>sheet.rows.first.cells[(1..-1)], :title=> sheet.rows.first.cells.first
    +     chart.add_series :data=>sheet.rows.last.cells[(1..-1)], :title=> sheet.rows.last.cells.first
    +   end
    + end  
    + p.serialize("example6.xlsx")
    +
    +

    Documentation

    This gem is 100% documented with YARD, an exceptional documentation library. To see documentation for this, and all the gems installed on your system use:

    @@ -191,21 +205,36 @@ It enables the you to generate 100% valid xlsx files that include customised sty
    • Updated documentation
    • +
    + +
  • October.21.11: 1.0.4 + +
    • altered package to accept a filename string for serialization instead of a File object.
    • Updated specs to conform
    • +
    • More examples for readme
    • +
    +
  • +
  • October.21.11: 1.05 + +
      +
    • Added support for line charts
    • +
    • Updated examples and readme
    • +
    • Updated series title to be a real title +Copyright
  • -

    Copyright

    +

    Axlsx © 2011 by Randy Morgan. Axlsx is licensed under the MIT license. Please see the LICENSE document for more information.

    diff --git a/doc/method_list.html b/doc/method_list.html index aede7025..2359d50a 100644 --- a/doc/method_list.html +++ b/doc/method_list.html @@ -553,6 +553,14 @@
  • + #catAxis + + Axlsx::Line3DChart + +
  • + + +
  • #cell Axlsx::Title @@ -560,7 +568,7 @@
  • -
  • +
  • #cellStyleXfs Axlsx::Styles @@ -568,7 +576,7 @@
  • -
  • +
  • #cellStyles Axlsx::Styles @@ -576,7 +584,7 @@
  • -
  • +
  • #cellXfs Axlsx::Styles @@ -584,7 +592,7 @@
  • -
  • +
  • cell_range Axlsx @@ -592,7 +600,7 @@
  • -
  • +
  • #cell_type_from_value Axlsx::Cell @@ -600,7 +608,7 @@
  • -
  • +
  • #cells Axlsx::Row @@ -608,7 +616,7 @@
  • -
  • +
  • #charset Axlsx::Font @@ -616,23 +624,23 @@
  • -
  • - #chart +
  • + #chart - Axlsx::Series + Axlsx::GraphicFrame
  • -
  • - #chart +
  • + #chart - Axlsx::GraphicFrame + Axlsx::Series
  • -
  • +
  • #charts Axlsx::Workbook @@ -640,7 +648,7 @@
  • -
  • +
  • #charts Axlsx::Drawing @@ -648,7 +656,7 @@
  • -
  • +
  • #col Axlsx::Marker @@ -656,7 +664,7 @@
  • -
  • +
  • #colOff Axlsx::Marker @@ -664,7 +672,7 @@
  • -
  • +
  • #col_ref Axlsx::Cell @@ -672,7 +680,7 @@
  • -
  • +
  • #color Axlsx::GradientStop @@ -680,23 +688,23 @@
  • -
  • - #color +
  • + #color - Axlsx::BorderPr + Axlsx::Font
  • -
  • - #color +
  • + #color - Axlsx::Font + Axlsx::BorderPr
  • -
  • +
  • #condense Axlsx::Font @@ -704,7 +712,7 @@
  • -
  • +
  • #content_types Axlsx::Package @@ -712,7 +720,7 @@
  • -
  • +
  • #coord Axlsx::Marker @@ -720,7 +728,7 @@
  • -
  • +
  • #creator Axlsx::Core @@ -728,7 +736,7 @@
  • -
  • +
  • #crossAx Axlsx::Axis @@ -736,7 +744,7 @@
  • -
  • +
  • #crossBetween Axlsx::ValAxis @@ -744,7 +752,7 @@
  • -
  • +
  • #crosses Axlsx::Axis @@ -752,7 +760,7 @@
  • -
  • +
  • #customBuiltin Axlsx::CellStyle @@ -760,7 +768,7 @@
  • -
  • +
  • #data Axlsx::BarSeries @@ -768,7 +776,7 @@
  • -
  • +
  • #data Axlsx::PieSeries @@ -776,6 +784,14 @@
  • +
  • + #data + + Axlsx::LineSeries + +
  • + +
  • #date1904 @@ -865,17 +881,17 @@
  • - #drawing + #drawing - Axlsx::TwoCellAnchor + Axlsx::Worksheet
  • - #drawing + #drawing - Axlsx::Worksheet + Axlsx::TwoCellAnchor
  • @@ -905,17 +921,17 @@
  • - #end_at + #end_at - Axlsx::TwoCellAnchor + Axlsx::Chart
  • - #end_at + #end_at - Axlsx::Chart + Axlsx::TwoCellAnchor
  • @@ -1025,6 +1041,14 @@
  • + #gapDepth + + Axlsx::Line3DChart + +
  • + + +
  • #gapWidth Axlsx::Bar3DChart @@ -1032,7 +1056,7 @@
  • -
  • +
  • #graphic_frame Axlsx::TwoCellAnchor @@ -1040,7 +1064,7 @@
  • -
  • +
  • #graphic_frame Axlsx::Chart @@ -1048,6 +1072,14 @@
  • +
  • + #grouping + + Axlsx::Line3DChart + +
  • + +
  • #grouping @@ -1113,57 +1145,57 @@
  • - #index + #index - Axlsx::Row + Axlsx::Drawing
  • - #index + #index - Axlsx::TwoCellAnchor + Axlsx::Row
  • - #index + #index - Axlsx::Worksheet + Axlsx::Cell
  • - #index + #index - Axlsx::Cell + Axlsx::Series
  • - #index + #index - Axlsx::Chart + Axlsx::Worksheet
  • - #index + #index - Axlsx::Drawing + Axlsx::Chart
  • - #index + #index - Axlsx::Series + Axlsx::TwoCellAnchor
  • @@ -1177,73 +1209,73 @@
  • - #initialize + #initialize - Axlsx::TableStyles + Axlsx::GradientStop
  • - #initialize + #initialize - Axlsx::Relationship + Axlsx::Font
  • - #initialize + #initialize - Axlsx::Row + Axlsx::Bar3DChart
  • - #initialize + #initialize - Axlsx::PieSeries + Axlsx::GradientFill
  • - #initialize + #initialize - Axlsx::Default + Axlsx::Pie3DChart
  • - #initialize + #initialize - Axlsx::GraphicFrame + Axlsx::SimpleTypedList
  • - #initialize + #initialize - Axlsx::CellAlignment + Axlsx::Cell
  • - #initialize + #initialize - Axlsx::ValAxis + Axlsx::View3D
  • - #initialize + #initialize - Axlsx::CatAxis + Axlsx::CellStyle
  • @@ -1257,201 +1289,201 @@
  • - #initialize + #initialize - Axlsx::Core + Axlsx::PieSeries
  • - #initialize + #initialize - Axlsx::TwoCellAnchor + Axlsx::Core
  • - #initialize + #initialize - Axlsx::Pie3DChart + Axlsx::TableStyles
  • - #initialize + #initialize - Axlsx::GradientStop + Axlsx::LineSeries
  • - #initialize + #initialize - Axlsx::TableStyleElement + Axlsx::Override
  • - #initialize + #initialize - Axlsx::Axis + Axlsx::TableStyle
  • - #initialize + #initialize - Axlsx::TableStyle + Axlsx::CatAxis
  • - #initialize + #initialize - Axlsx::View3D + Axlsx::PatternFill
  • - #initialize + #initialize - Axlsx::Drawing + Axlsx::CellProtection
  • - #initialize + #initialize - Axlsx::Override + Axlsx::GraphicFrame
  • - #initialize + #initialize - Axlsx::Font + Axlsx::ContentType
  • - #initialize + #initialize - Axlsx::Package + Axlsx::Fill
  • - #initialize + #initialize - Axlsx::Scaling + Axlsx::Drawing
  • - #initialize + #initialize - Axlsx::Worksheet + Axlsx::Relationship
  • - #initialize + #initialize - Axlsx::GradientFill + Axlsx::Row
  • - #initialize + #initialize - Axlsx::PatternFill + Axlsx::Chart
  • - #initialize + #initialize - Axlsx::Workbook + Axlsx::ValAxis
  • - #initialize + #initialize - Axlsx::SimpleTypedList + Axlsx::Series
  • - #initialize + #initialize - Axlsx::Border + Axlsx::Default
  • - #initialize + #initialize - Axlsx::Marker + Axlsx::Styles
  • - #initialize + #initialize - Axlsx::CellStyle + Axlsx::TableStyleElement
  • - #initialize + #initialize - Axlsx::CellProtection + Axlsx::BorderPr
  • - #initialize + #initialize - Axlsx::Chart + Axlsx::Marker
  • - #initialize + #initialize - Axlsx::Xf + Axlsx::NumFmt
  • - #initialize + #initialize - Axlsx::ContentType + Axlsx::Border
  • @@ -1465,78 +1497,102 @@
  • - #initialize + #initialize - Axlsx::Fill + Axlsx::Relationships
  • - #initialize + #initialize - Axlsx::Series + Axlsx::TwoCellAnchor
  • - #initialize + #initialize - Axlsx::Styles + Axlsx::Scaling
  • - #initialize + #initialize - Axlsx::Relationships + Axlsx::Color
  • - #initialize + #initialize - Axlsx::NumFmt + Axlsx::CellAlignment
  • - #initialize + #initialize - Axlsx::Cell + Axlsx::Axis
  • - #initialize + #initialize - Axlsx::Color + Axlsx::Line3DChart
  • - #initialize + #initialize - Axlsx::Bar3DChart + Axlsx::SerAxis
  • - #initialize + #initialize - Axlsx::BorderPr + Axlsx::Workbook
  • + #initialize + + Axlsx::Worksheet + +
  • + + +
  • + #initialize + + Axlsx::Xf + +
  • + + +
  • + #initialize + + Axlsx::Package + +
  • + + +
  • #justifyLastLine Axlsx::CellAlignment @@ -1544,6 +1600,14 @@
  • +
  • + #labels + + Axlsx::PieSeries + +
  • + +
  • #labels @@ -1553,9 +1617,9 @@
  • - #labels + #labels - Axlsx::PieSeries + Axlsx::LineSeries
  • @@ -1641,9 +1705,9 @@
  • - #name + #name - Axlsx::BorderPr + Axlsx::Font
  • @@ -1657,41 +1721,41 @@
  • - #name + #name - Axlsx::Font + Axlsx::CellStyle
  • - #name + #name - Axlsx::CellStyle + Axlsx::Worksheet
  • - #name + #name - Axlsx::Worksheet + Axlsx::BorderPr
  • - #numFmtId + #numFmtId - Axlsx::NumFmt + Axlsx::Xf
  • - #numFmtId + #numFmtId - Axlsx::Xf + Axlsx::NumFmt
  • @@ -1721,17 +1785,17 @@
  • - #outline + #outline - Axlsx::Border + Axlsx::Font
  • - #outline + #outline - Axlsx::Font + Axlsx::Border
  • @@ -1777,17 +1841,17 @@
  • - #pn + #pn - Axlsx::Worksheet + Axlsx::Drawing
  • - #pn + #pn - Axlsx::Drawing + Axlsx::Worksheet
  • @@ -1913,33 +1977,33 @@
  • - #relationships + #relationships - Axlsx::Package + Axlsx::Drawing
  • - #relationships + #relationships - Axlsx::Worksheet + Axlsx::Workbook
  • - #relationships + #relationships - Axlsx::Workbook + Axlsx::Worksheet
  • - #relationships + #relationships - Axlsx::Drawing + Axlsx::Package
  • @@ -1953,17 +2017,17 @@
  • - #rels_pn + #rels_pn - Axlsx::Drawing + Axlsx::Worksheet
  • - #rels_pn + #rels_pn - Axlsx::Worksheet + Axlsx::Drawing
  • @@ -2001,17 +2065,17 @@
  • - #row + #row - Axlsx::Marker + Axlsx::Cell
  • - #row + #row - Axlsx::Cell + Axlsx::Marker
  • @@ -2041,6 +2105,14 @@
  • + #serAxis + + Axlsx::Line3DChart + +
  • + + +
  • #serialize Axlsx::Package @@ -2048,7 +2120,7 @@
  • -
  • +
  • #serialize_as Axlsx::SimpleTypedList @@ -2056,7 +2128,7 @@
  • -
  • +
  • #series Axlsx::Chart @@ -2064,7 +2136,7 @@
  • -
  • +
  • #series_type Axlsx::Chart @@ -2072,7 +2144,7 @@
  • -
  • +
  • #shadow Axlsx::Font @@ -2080,6 +2152,14 @@
  • +
  • + #shape + + Axlsx::BarSeries + +
  • + +
  • #shape @@ -2089,33 +2169,33 @@
  • - #shape + #show_legend - Axlsx::BarSeries + Axlsx::Chart
  • - #show_legend + #shrinkToFit - Axlsx::Chart + Axlsx::CellAlignment
  • - #shrinkToFit + #size - Axlsx::CellAlignment + Axlsx::TableStyleElement
  • - #size + #start_at - Axlsx::TableStyleElement + Axlsx::Chart
  • @@ -2129,25 +2209,25 @@
  • - #start_at + #stop - Axlsx::Chart + Axlsx::GradientFill
  • - #stop + #strike - Axlsx::GradientFill + Axlsx::Font
  • - #strike + #style - Axlsx::Font + Axlsx::Chart
  • @@ -2225,22 +2305,30 @@
  • - #tint + #tickLblSkip - Axlsx::Color + Axlsx::SerAxis
  • - #title + #tickMarkSkip - Axlsx::Series + Axlsx::SerAxis
  • + #tint + + Axlsx::Color + +
  • + + +
  • #title Axlsx::Chart @@ -2248,6 +2336,14 @@
  • +
  • + #title + + Axlsx::Series + +
  • + +
  • #to @@ -2257,17 +2353,17 @@
  • - #to_xml + #to_xml - Axlsx::GradientStop + Axlsx::Title
  • - #to_xml + #to_xml - Axlsx::Border + Axlsx::TableStyles
  • @@ -2281,217 +2377,217 @@
  • - #to_xml + #to_xml - Axlsx::TableStyle + Axlsx::CellStyle
  • - #to_xml + #to_xml - Axlsx::Color + Axlsx::NumFmt
  • - #to_xml + #to_xml - Axlsx::Cell + Axlsx::Scaling
  • - #to_xml + #to_xml - Axlsx::Drawing + Axlsx::Color
  • - #to_xml + #to_xml - Axlsx::CellProtection + Axlsx::BarSeries
  • - #to_xml + #to_xml - Axlsx::TwoCellAnchor + Axlsx::PieSeries
  • - #to_xml + #to_xml - Axlsx::Styles + Axlsx::Worksheet
  • - #to_xml + #to_xml - Axlsx::Default + Axlsx::Relationship
  • - #to_xml + #to_xml - Axlsx::Worksheet + Axlsx::App
  • - #to_xml + #to_xml - Axlsx::TableStyles + Axlsx::View3D
  • - #to_xml + #to_xml - Axlsx::Relationship + Axlsx::SeriesTitle
  • - #to_xml + #to_xml - Axlsx::ValAxis + Axlsx::Default
  • - #to_xml + #to_xml - Axlsx::Axis + Axlsx::TableStyleElement
  • - #to_xml + #to_xml - Axlsx::BarSeries + Axlsx::Series
  • - #to_xml + #to_xml - Axlsx::GraphicFrame + Axlsx::CellProtection
  • - #to_xml + #to_xml - Axlsx::CellAlignment + Axlsx::CatAxis
  • - #to_xml + #to_xml - Axlsx::Title + Axlsx::Marker
  • - #to_xml + #to_xml - Axlsx::Scaling + Axlsx::ValAxis
  • - #to_xml + #to_xml - Axlsx::Bar3DChart + Axlsx::ContentType
  • - #to_xml + #to_xml - Axlsx::Marker + Axlsx::Cell
  • - #to_xml + #to_xml - Axlsx::View3D + Axlsx::Core
  • - #to_xml + #to_xml - Axlsx::Fill + Axlsx::Bar3DChart
  • - #to_xml + #to_xml - Axlsx::Core + Axlsx::GraphicFrame
  • - #to_xml + #to_xml - Axlsx::TableStyleElement + Axlsx::Workbook
  • - #to_xml + #to_xml - Axlsx::NumFmt + Axlsx::GradientStop
  • - #to_xml + #to_xml - Axlsx::Xf + Axlsx::TwoCellAnchor
  • - #to_xml + #to_xml - Axlsx::Workbook + Axlsx::Drawing
  • @@ -2505,97 +2601,113 @@
  • - #to_xml + #to_xml - Axlsx::Pie3DChart + Axlsx::Fill
  • - #to_xml + #to_xml - Axlsx::App + Axlsx::Border
  • - #to_xml + #to_xml - Axlsx::Row + Axlsx::LineSeries
  • - #to_xml + #to_xml - Axlsx::PatternFill + Axlsx::Styles
  • - #to_xml + #to_xml - Axlsx::CatAxis + Axlsx::Pie3DChart
  • - #to_xml + #to_xml - Axlsx::Override + Axlsx::SimpleTypedList
  • - #to_xml + #to_xml - Axlsx::PieSeries + Axlsx::TableStyle
  • - #to_xml + #to_xml - Axlsx::CellStyle + Axlsx::Axis
  • - #to_xml + #to_xml - Axlsx::Series + Axlsx::GradientFill
  • - #to_xml + #to_xml - Axlsx::SimpleTypedList + Axlsx::SerAxis
  • - #to_xml + #to_xml - Axlsx::ContentType + Axlsx::CellAlignment
  • - #to_xml + #to_xml - Axlsx::GradientFill + Axlsx::Line3DChart + +
  • + + +
  • + #to_xml + + Axlsx::Override + +
  • + + +
  • + #to_xml + + Axlsx::Xf
  • @@ -2617,23 +2729,23 @@
  • - #top + #to_xml - Axlsx::GradientFill + Axlsx::PatternFill
  • - #type + #to_xml - Axlsx::Cell + Axlsx::Row
  • - #type + #top Axlsx::GradientFill @@ -2641,6 +2753,14 @@
  • + #type + + Axlsx::GradientFill + +
  • + + +
  • #type Axlsx::TableStyleElement @@ -2648,6 +2768,14 @@
  • +
  • + #type + + Axlsx::Cell + +
  • + +
  • #unlock @@ -2665,25 +2793,25 @@
  • - #valAxis + #valAxis - Axlsx::Bar3DChart + Axlsx::Line3DChart
  • - #validate + #valAxis - Axlsx::Package + Axlsx::Bar3DChart
  • - validate + #validate - Axlsx::RegexValidator + Axlsx::Package
  • @@ -2697,6 +2825,14 @@
  • + validate + + Axlsx::RegexValidator + +
  • + + +
  • validate Axlsx::RestrictionValidator @@ -2704,7 +2840,7 @@
  • -
  • +
  • validate_boolean Axlsx @@ -2712,7 +2848,7 @@
  • -
  • +
  • validate_content_type Axlsx @@ -2720,7 +2856,7 @@
  • -
  • +
  • validate_float Axlsx @@ -2728,7 +2864,7 @@
  • -
  • +
  • validate_gradient_type Axlsx @@ -2736,7 +2872,7 @@
  • -
  • +
  • validate_horizontal_alignment Axlsx @@ -2744,7 +2880,7 @@
  • -
  • +
  • validate_int Axlsx @@ -2752,7 +2888,7 @@
  • -
  • +
  • validate_pattern_type Axlsx @@ -2760,7 +2896,7 @@
  • -
  • +
  • validate_relationship_type Axlsx @@ -2768,7 +2904,7 @@
  • -
  • +
  • #validate_single_doc Axlsx::Package @@ -2776,7 +2912,7 @@
  • -
  • +
  • validate_string Axlsx @@ -2784,7 +2920,7 @@
  • -
  • +
  • validate_table_element_type Axlsx @@ -2792,7 +2928,7 @@
  • -
  • +
  • validate_unsigned_int Axlsx @@ -2800,7 +2936,7 @@
  • -
  • +
  • validate_vertical_alignment Axlsx @@ -2808,7 +2944,7 @@
  • -
  • +
  • #value Axlsx::Cell @@ -2816,7 +2952,7 @@
  • -
  • +
  • #vertical Axlsx::CellAlignment @@ -2824,7 +2960,7 @@
  • -
  • +
  • #view3D Axlsx::Chart @@ -2832,7 +2968,7 @@
  • -
  • +
  • #workbook Axlsx::Worksheet @@ -2840,7 +2976,7 @@
  • -
  • +
  • #workbook Axlsx::Package @@ -2848,14 +2984,6 @@
  • -
  • - #worksheet - - Axlsx::Drawing - -
  • - -
  • #worksheet @@ -2865,25 +2993,25 @@
  • - #worksheets + #worksheet - Axlsx::Workbook + Axlsx::Drawing
  • - #wrapText + #worksheets - Axlsx::CellAlignment + Axlsx::Workbook
  • - #xfId + #wrapText - Axlsx::CellStyle + Axlsx::CellAlignment
  • @@ -2896,6 +3024,14 @@ +
  • + #xfId + + Axlsx::CellStyle + +
  • + + diff --git a/doc/top-level-namespace.html b/doc/top-level-namespace.html index 7ebd7b99..4c39c148 100644 --- a/doc/top-level-namespace.html +++ b/doc/top-level-namespace.html @@ -94,7 +94,7 @@ diff --git a/lib/axlsx/util/constants.rb b/lib/axlsx/util/constants.rb index 5fbfdf80..20167708 100644 --- a/lib/axlsx/util/constants.rb +++ b/lib/axlsx/util/constants.rb @@ -1,7 +1,7 @@ module Axlsx # version - VERSION="1.0.4" + VERSION="1.0.5" # XML Encoding ENCODING = "UTF-8" -- cgit v1.2.3