Implement :offset option for worksheet#add_row (#87)

1 files changed, 21 insertions, 0 deletions

diff --git a/test/workbook/worksheet/tc_row.rb b/test/workbook/worksheet/tc_row.rb
index f909129c..e6dc3ef1 100644
--- a/test/workbook/worksheet/tc_row.rb
+++ b/test/workbook/worksheet/tc_row.rb
@@ -136,4 +136,25 @@ class TestRow < Test::Unit::TestCase
     assert_equal(r_s_xml.xpath(".//row[@r=1][@ht=20][@customHeight=1]").size, 1)
   end
 
+  def test_offsets
+    offset = 3
+    values = [1,2,3,4,5]
+    r = @ws.add_row(values, offset: offset, style: 1)
+    r.cells.each_with_index do |c, index| 
+      assert_equal(c.style, index < offset ? 0 : 1)
+      assert_equal(c.value, index < offset ? nil : values[index - offset])
+    end
+  end
+
+  def test_offsets_with_styles
+    offset = 3
+    values = [1,2,3,4,5]
+    styles = [6,7,8,9,10]
+    r = @ws.add_row(values, offset: offset, style: styles)
+    r.cells.each_with_index do |c, index| 
+      assert_equal(c.style, index < offset ? 0 : styles[index-offset])
+      assert_equal(c.value, index < offset ? nil : values[index - offset])
+    end
+  end
+
 end