diff options
Diffstat (limited to 'test')
| -rw-r--r-- | test/drawing/tc_bar_series.rb | 2 | ||||
| -rw-r--r-- | test/drawing/tc_drawing.rb | 9 | ||||
| -rw-r--r-- | test/drawing/tc_line_series.rb | 2 | ||||
| -rw-r--r-- | test/drawing/tc_pie_3D_chart.rb | 2 | ||||
| -rw-r--r-- | test/drawing/tc_pie_series.rb | 2 | ||||
| -rw-r--r-- | test/drawing/tc_scatter_series.rb | 2 | ||||
| -rw-r--r-- | test/drawing/tc_series.rb | 2 | ||||
| -rw-r--r-- | test/workbook/tc_workbook.rb | 2 | ||||
| -rw-r--r-- | test/workbook/worksheet/table/tc_table.rb | 8 | ||||
| -rw-r--r-- | test/workbook/worksheet/tc_worksheet.rb | 17 |
10 files changed, 22 insertions, 26 deletions
diff --git a/test/drawing/tc_bar_series.rb b/test/drawing/tc_bar_series.rb index 6b173155..483e561d 100644 --- a/test/drawing/tc_bar_series.rb +++ b/test/drawing/tc_bar_series.rb @@ -5,7 +5,7 @@ class TestBarSeries < Test::Unit::TestCase def setup p = Axlsx::Package.new @ws = p.workbook.add_worksheet :name=>"hmmm" - @chart = @ws.drawing.add_chart Axlsx::Bar3DChart, :title => "fishery" + @chart = @ws.add_chart Axlsx::Bar3DChart, :title => "fishery" @series = @chart.add_series :data=>[0,1,2], :labels=>["zero", "one", "two"], :title=>"bob", :colors => ['FF0000', '00FF00', '0000FF'], :shape => :cone end diff --git a/test/drawing/tc_drawing.rb b/test/drawing/tc_drawing.rb index 4d213d56..f347001f 100644 --- a/test/drawing/tc_drawing.rb +++ b/test/drawing/tc_drawing.rb @@ -9,8 +9,6 @@ class TestDrawing < Test::Unit::TestCase def test_initialization assert(@ws.workbook.drawings.empty?) - assert_equal(@ws.drawing, @ws.workbook.drawings.last, "drawing is added to workbook") - assert(@ws.drawing.anchors.is_a?(Axlsx::SimpleTypedList) && @ws.drawing.anchors.empty?, "anchor list is created and empty") end def test_add_chart @@ -39,7 +37,6 @@ class TestDrawing < Test::Unit::TestCase assert(image.is_a?(Axlsx::Pic)) end def test_charts - assert(@ws.drawing.charts.empty?) chart = @ws.add_chart(Axlsx::Pie3DChart, :title=>"bob", :start_at=>[0,0], :end_at=>[1,1]) assert_equal(@ws.drawing.charts.last, chart, "add chart is returned") chart = @ws.add_chart(Axlsx::Pie3DChart, :title=>"nancy", :start_at=>[1,5], :end_at=>[5,10]) @@ -47,23 +44,26 @@ class TestDrawing < Test::Unit::TestCase end def test_pn + @ws.add_chart(Axlsx::Pie3DChart) assert_equal(@ws.drawing.pn, "drawings/drawing1.xml") end def test_rels_pn + @ws.add_chart(Axlsx::Pie3DChart) assert_equal(@ws.drawing.rels_pn, "drawings/_rels/drawing1.xml.rels") end def test_rId + @ws.add_chart(Axlsx::Pie3DChart) assert_equal(@ws.drawing.rId, "rId1") end def test_index + @ws.add_chart(Axlsx::Pie3DChart) assert_equal(@ws.drawing.index, @ws.workbook.drawings.index(@ws.drawing)) end def test_relationships - assert(@ws.drawing.relationships.empty?) chart = @ws.add_chart(Axlsx::Pie3DChart, :title=>"bob", :start_at=>[0,0], :end_at=>[1,1]) assert_equal(@ws.drawing.relationships.size, 1, "adding a chart adds a relationship") chart = @ws.add_chart(Axlsx::Pie3DChart, :title=>"nancy", :start_at=>[1,5], :end_at=>[5,10]) @@ -72,6 +72,7 @@ class TestDrawing < Test::Unit::TestCase def test_to_xml schema = Nokogiri::XML::Schema(File.open(Axlsx::DRAWING_XSD)) + @ws.add_chart(Axlsx::Pie3DChart) doc = Nokogiri::XML(@ws.drawing.to_xml_string) errors = [] schema.validate(doc).each do |error| diff --git a/test/drawing/tc_line_series.rb b/test/drawing/tc_line_series.rb index 557ba251..cc62005b 100644 --- a/test/drawing/tc_line_series.rb +++ b/test/drawing/tc_line_series.rb @@ -5,7 +5,7 @@ class TestLineSeries < Test::Unit::TestCase def setup p = Axlsx::Package.new @ws = p.workbook.add_worksheet :name=>"hmmm" - chart = @ws.drawing.add_chart Axlsx::Line3DChart, :title => "fishery" + chart = @ws.add_chart Axlsx::Line3DChart, :title => "fishery" @series = chart.add_series :data=>[0,1,2], :labels=>["zero", "one", "two"], :title=>"bob", :color => "#FF0000" end diff --git a/test/drawing/tc_pie_3D_chart.rb b/test/drawing/tc_pie_3D_chart.rb index 5e671989..a941eacd 100644 --- a/test/drawing/tc_pie_3D_chart.rb +++ b/test/drawing/tc_pie_3D_chart.rb @@ -6,7 +6,7 @@ class TestPie3DChart < Test::Unit::TestCase p = Axlsx::Package.new ws = p.workbook.add_worksheet @row = ws.add_row ["one", 1, Time.now] - @chart = ws.drawing.add_chart Axlsx::Pie3DChart, :title => "fishery" + @chart = ws.add_chart Axlsx::Pie3DChart, :title => "fishery" end def teardown diff --git a/test/drawing/tc_pie_series.rb b/test/drawing/tc_pie_series.rb index 2c8859c7..70abb602 100644 --- a/test/drawing/tc_pie_series.rb +++ b/test/drawing/tc_pie_series.rb @@ -5,7 +5,7 @@ class TestPieSeries < Test::Unit::TestCase def setup p = Axlsx::Package.new @ws = p.workbook.add_worksheet :name=>"hmmm" - chart = @ws.drawing.add_chart Axlsx::Pie3DChart, :title => "fishery" + chart = @ws.add_chart Axlsx::Pie3DChart, :title => "fishery" @series = chart.add_series :data=>[0,1,2], :labels=>["zero", "one", "two"], :title=>"bob", :colors => ["FF0000", "00FF00", "0000FF"] end diff --git a/test/drawing/tc_scatter_series.rb b/test/drawing/tc_scatter_series.rb index e97abca7..b43ed171 100644 --- a/test/drawing/tc_scatter_series.rb +++ b/test/drawing/tc_scatter_series.rb @@ -5,7 +5,7 @@ class TestScatterSeries < Test::Unit::TestCase def setup p = Axlsx::Package.new @ws = p.workbook.add_worksheet :name=>"hmmm" - @chart = @ws.drawing.add_chart Axlsx::ScatterChart, :title => "Scatter Chart" + @chart = @ws.add_chart Axlsx::ScatterChart, :title => "Scatter Chart" @series = @chart.add_series :xData=>[1,2,4], :yData=>[1,3,9], :title=>"exponents", :color => 'FF0000' end diff --git a/test/drawing/tc_series.rb b/test/drawing/tc_series.rb index 6b83015a..b32595a7 100644 --- a/test/drawing/tc_series.rb +++ b/test/drawing/tc_series.rb @@ -5,7 +5,7 @@ class TestSeries < Test::Unit::TestCase def setup p = Axlsx::Package.new @ws = p.workbook.add_worksheet :name=>"hmmm" - chart = @ws.drawing.add_chart Axlsx::Chart, :title => "fishery" + chart = @ws.add_chart Axlsx::Chart, :title => "fishery" @series = chart.add_series :title=>"bob" end diff --git a/test/workbook/tc_workbook.rb b/test/workbook/tc_workbook.rb index e6bb48a0..f6f38778 100644 --- a/test/workbook/tc_workbook.rb +++ b/test/workbook/tc_workbook.rb @@ -79,7 +79,7 @@ class TestWorkbook < Test::Unit::TestCase sheet.auto_filter = "A1:B1" end doc = Nokogiri::XML(@wb.to_xml_string) - assert_equal(doc.xpath('//xmlns:workbook/xmlns:definedNames/xmlns:definedName').inner_text, @wb.worksheets[0].abs_auto_filter) + assert_equal(doc.xpath('//xmlns:workbook/xmlns:definedNames/xmlns:definedName').inner_text, @wb.worksheets[0].auto_filter.defined_name) end diff --git a/test/workbook/worksheet/table/tc_table.rb b/test/workbook/worksheet/table/tc_table.rb index c8e56fc3..7c87c69e 100644 --- a/test/workbook/worksheet/table/tc_table.rb +++ b/test/workbook/worksheet/table/tc_table.rb @@ -25,14 +25,6 @@ class TestTable < Test::Unit::TestCase end - def test_charts - assert(@ws.drawing.charts.empty?) - chart = @ws.add_chart(Axlsx::Pie3DChart, :title=>"bob", :start_at=>[0,0], :end_at=>[1,1]) - assert_equal(@ws.drawing.charts.last, chart, "add chart is returned") - chart = @ws.add_chart(Axlsx::Pie3DChart, :title=>"nancy", :start_at=>[1,5], :end_at=>[5,10]) - assert_equal(@ws.drawing.charts.last, chart, "add chart is returned") - end - def test_pn @ws.add_table("A1:D5") assert_equal(@ws.tables.first.pn, "tables/table1.xml") diff --git a/test/workbook/worksheet/tc_worksheet.rb b/test/workbook/worksheet/tc_worksheet.rb index df808025..3bb9908f 100644 --- a/test/workbook/worksheet/tc_worksheet.rb +++ b/test/workbook/worksheet/tc_worksheet.rb @@ -113,12 +113,12 @@ class TestWorksheet < Test::Unit::TestCase def test_dimension @ws.add_row [1, 2, 3] @ws.add_row [4, 5, 6] - assert_equal @ws.dimension, "A1:C2" + assert_equal @ws.dimension.sqref, "A1:C2" end def test_dimension_with_empty_row @ws.add_row - assert_equal "A1:AA200", @ws.dimension + assert_equal "A1:AA200", @ws.dimension.sqref end def test_referencing @@ -148,7 +148,9 @@ class TestWorksheet < Test::Unit::TestCase end def test_drawing - assert @ws.drawing.is_a? Axlsx::Drawing + assert @ws.drawing == nil + @ws.add_chart(Axlsx::Pie3DChart) + assert @ws.drawing.is_a?(Axlsx::Drawing) end def test_col_style @@ -306,10 +308,11 @@ class TestWorksheet < Test::Unit::TestCase assert_equal(doc.xpath('//xmlns:worksheet/xmlns:tableParts/xmlns:tablePart[@r:id="rId1"]').size, 1) end - def test_abs_auto_filter + def test_auto_filter @ws.add_row [1, "two", 3] @ws.auto_filter = "A1:C1" - assert_equal(@ws.abs_auto_filter, "'Sheet1'!$A$1:$C$1") + assert_equal("A1:C1", @ws.auto_filter.range) + assert_equal(@ws.auto_filter.defined_name, "'Sheet1'!$A$1:$C$1") end def test_to_xml_string @@ -415,9 +418,9 @@ class TestWorksheet < Test::Unit::TestCase end def test_auto_filter - assert(@ws.auto_filter.nil?) + assert(@ws.auto_filter.range.nil?) assert_raise(ArgumentError) { @ws.auto_filter = 123 } @ws.auto_filter = "A1:D9" - assert_equal(@ws.auto_filter, "A1:D9") + assert_equal(@ws.auto_filter.range, "A1:D9") end end |
