adding in row_style and col_style methods to worksheet and active record 'acts_as_axlsx' to provide to_xlsx.

2 files changed, 31 insertions, 0 deletions

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))