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. --- test/workbook/worksheet/tc_row.rb | 6 ++++++ test/workbook/worksheet/tc_worksheet.rb | 25 +++++++++++++++++++++++++ 2 files changed, 31 insertions(+) (limited to 'test') diff --git a/test/workbook/worksheet/tc_row.rb b/test/workbook/worksheet/tc_row.rb index 5dfdc601..f9b589e3 100644 --- a/test/workbook/worksheet/tc_row.rb +++ b/test/workbook/worksheet/tc_row.rb @@ -14,6 +14,12 @@ class TestRow < Test::Unit::TestCase assert_equal(@row.worksheet, @ws, "has a reference to the worksheet") end + def test_style + r = @ws.add_row([1,2,3,4,5]) + r.style=1 + r.cells.each { |c| assert_equal(c.style,1) } + end + def test_index assert_equal(@row.index, @row.worksheet.rows.index(@row)) end diff --git a/test/workbook/worksheet/tc_worksheet.rb b/test/workbook/worksheet/tc_worksheet.rb index ce913778..6bdf5f20 100644 --- a/test/workbook/worksheet/tc_worksheet.rb +++ b/test/workbook/worksheet/tc_worksheet.rb @@ -46,6 +46,31 @@ class TestWorksheet < Test::Unit::TestCase assert @ws.drawing.is_a? Axlsx::Drawing end + def test_col_style + @ws.add_row [1,2,3,4] + @ws.add_row [1,2,3,4] + @ws.add_row [1,2,3,4] + @ws.add_row [1,2,3,4] + @ws.col_style 1, 1, :row_offset=>1 + @ws.rows[(1..-1)].each do | r | + assert_equal(r.cells[1].style, 1) + end + assert_equal(@ws.rows.first.cells[1].style, 0) + assert_equal(@ws.rows.first.cells[0].style, 0) + end + + def test_row_style + @ws.add_row [1,2,3,4] + @ws.add_row [1,2,3,4] + @ws.add_row [1,2,3,4] + @ws.add_row [1,2,3,4] + @ws.row_style 1, 1, :col_offset=>1 + @ws.rows[1].cells[(1..-1)].each do | c | + assert_equal(c.style, 1) + end + assert_equal(@ws.rows[1].cells[0].style, 0) + assert_equal(@ws.rows[2].cells[1].style, 0) + end def test_to_xml schema = Nokogiri::XML::Schema(File.open(Axlsx::SML_XSD)) -- cgit v1.2.3