summaryrefslogtreecommitdiffhomepage
path: root/test/workbook
diff options
context:
space:
mode:
authorRandy Morgan <[email protected]>2012-07-17 09:30:05 +0900
committerRandy Morgan <[email protected]>2012-07-17 09:30:05 +0900
commit40fdb054a0f31a12870d2d12be3928075c738ebf (patch)
tree493baeffb6ca578cf438f066bb348a62bc66121d /test/workbook
parentaeb2d164c3db46d4d2d6e05fd34eba4e2193d28a (diff)
downloadcaxlsx-40fdb054a0f31a12870d2d12be3928075c738ebf.tar.gz
caxlsx-40fdb054a0f31a12870d2d12be3928075c738ebf.zip
MOAR cleanup for worksheet.
Diffstat (limited to 'test/workbook')
-rw-r--r--test/workbook/tc_workbook.rb2
-rw-r--r--test/workbook/worksheet/table/tc_table.rb8
-rw-r--r--test/workbook/worksheet/tc_worksheet.rb17
3 files changed, 11 insertions, 16 deletions
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