test_roo.rb in roo-0.5.4

- old
+ new

@@ -1074,11 +1074,11 @@
       sheet.remove_tmp # don't forget to remove the temporary files
     end
   end
 
   def test_excel_zipped
-    after Date.new(2007,8,30) do
+    after Date.new(2007,8,10) do
       excel = Excel.new(File.join("test","bode-v1.xls.zip"), :zip)
       assert excel
       assert_equal 'ist "e" im Nenner von H(s)', excel.cell('b', 5)
       excel.remove_tmp # don't forget to remove the temporary files
     end
@@ -1090,7 +1090,62 @@
       assert oo
       oo.default_sheet = oo.sheets.first
       assert_equal 'ist "e" im Nenner von H(s)', oo.cell('b', 5)
       oo.remove_tmp # don't forget to remove the temporary files
     end
+  end
+
+  def test_bug_ric
+      oo = Openoffice.new("/home/tp/Desktop/xxx.ods")
+      oo.default_sheet = oo.sheets.first
+      assert oo.empty?('A',1)
+      assert oo.empty?('B',1)
+      assert oo.empty?('C',1)
+      assert oo.empty?('D',1)
+      assert_equal 1, oo.cell('e',1)
+      assert_equal 2, oo.cell('f',1)
+      assert_equal 3, oo.cell('g',1)
+      assert_equal 4, oo.cell('h',1)
+      assert_equal 5, oo.cell('i',1)
+      assert_equal 6, oo.cell('j',1)
+      assert_equal 7, oo.cell('k',1)
+      assert_equal 8, oo.cell('l',1)
+      assert_equal 9, oo.cell('m',1)
+      assert_equal 10, oo.cell('n',1)
+      assert_equal 11, oo.cell('o',1)
+      assert_equal 12, oo.cell('p',1)
+      assert_equal 13, oo.cell('q',1)
+      assert_equal 14, oo.cell('r',1)
+      assert_equal 15, oo.cell('s',1)
+      assert_equal 16, oo.cell('t',1)
+      assert_equal 17, oo.cell('u',1)
+      assert_equal 'J', oo.cell('v',1)
+      assert_equal 'P', oo.cell('w',1)
+      assert_equal 'B', oo.cell('x',1)
+      assert_equal 'All', oo.cell('y',1)
+      assert_equal 0, oo.cell('a',2)
+      assert oo.empty?('b',2)
+      assert oo.empty?('c',2)
+      assert oo.empty?('d',2)
+      assert_equal 'B', oo.cell('e',2)
+      assert_equal 'B', oo.cell('f',2)
+      assert_equal 'B', oo.cell('g',2)
+      assert_equal 'B', oo.cell('h',2)
+      assert_equal 'B', oo.cell('i',2)
+      assert_equal 'B', oo.cell('j',2)
+      assert_equal 'B', oo.cell('k',2)
+      assert_equal 'B', oo.cell('l',2)
+      assert_equal 'B', oo.cell('m',2)
+      assert_equal 'B', oo.cell('n',2)
+      assert_equal 'B', oo.cell('o',2)
+      assert_equal 'B', oo.cell('p',2)
+      assert_equal 'B', oo.cell('q',2)
+      assert_equal 'B', oo.cell('r',2)
+      assert_equal 'B', oo.cell('s',2)
+      assert oo.empty?('t',2)
+      assert oo.empty?('u',2)
+      assert_equal 0  , oo.cell('v',2)
+      assert_equal 0  , oo.cell('w',2)
+      assert_equal 15 , oo.cell('x',2)
+      assert_equal 15 , oo.cell('y',2)
   end
 end # class