test_roo.rb in roo-0.9.0

- old
+ new

@@ -114,11 +114,11 @@
 
 class TestRoo < Test::Unit::TestCase
 
   OPENOFFICE = true  	# do Openoffice-Spreadsheet Tests?
   EXCEL      = true  	# do Excel Tests?
-  GOOGLE     = false 	# do Google-Spreadsheet Tests?
+  GOOGLE     = true 	# do Google-Spreadsheet Tests?
 
   OPENOFFICEWRITE = false # experimental: write access with OO-Documents
   ONLINE = false
   LONG_RUN = false
   GLOBAL_TIMEOUT = 2*12*60 # seconds
@@ -1091,22 +1091,30 @@
       # assert_equal 21, oo.cell('A',7)
       assert_equal 21.0, oo.cell('A',7) #TODO: better solution Fixnum/Float
       assert_equal :formula, oo.celltype('A',7)
       # assert_equal "=[Sheet2.A1]", oo.formula('C',7)
       # !!! different from formulas in Openoffice
-      assert_equal "=sheet2!R[-6]C[-2]", oo.formula('C',7)
+      #was: assert_equal "=sheet2!R[-6]C[-2]", oo.formula('C',7)
+      # has Google changed their format of formulas/references to other sheets?
+      assert_equal "=Sheet2!R[-6]C[-2]", oo.formula('C',7)
       assert_nil oo.formula('A',6)
       # assert_equal [[7, 1, "=SUM([.A1:.A6])"],
       #   [7, 2, "=SUM([.$A$1:.B6])"],
       #   [7, 3, "=[Sheet2.A1]"],
       #   [8, 2, "=SUM([.$A$1:.B7])"],
       # ], oo.formulas(oo.sheets.first)
       # different format than in openoffice spreadsheets:
-      assert_equal [[7, 1, "=SUM(R[-6]C[0]:R[-1]C[0])"],
-        [7, 2, "=SUM(R1C1:R[-1]C[0])"],
-        [7, 3, "=sheet2!R[-6]C[-2]"],
-        [8, 2, "=SUM(R1C1:R[-1]C[0])"]],
+      #was: 
+      # assert_equal [[7, 1, "=SUM(R[-6]C[0]:R[-1]C[0])"],
+      #  [7, 2, "=SUM(R1C1:R[-1]C[0])"],
+      #  [7, 3, "=sheet2!R[-6]C[-2]"],
+      #  [8, 2, "=SUM(R1C1:R[-1]C[0])"]],
+      #  oo.formulas(oo.sheets.first)
+      assert_equal [[7, 1, "=SUM(R[-6]C:R[-1]C)"],
+        [7, 2, "=SUM(R1C1:R[-1]C)"],
+        [7, 3, "=Sheet2!R[-6]C[-2]"],
+        [8, 2, "=SUM(R1C1:R[-1]C)"]],
         oo.formulas(oo.sheets.first)
     end # GOOGLE
   end
 
 
@@ -1909,13 +1917,16 @@
     if OPENOFFICE
       oo = Openoffice.new(File.join("test","numbers1.ods"))
       oo.default_sheet = oo.sheets.first
       rec = oo.find 16
       assert rec
-      after Date.new(2008,1,15) do
-        #          assert_equal "einundvierzig", rec[0]
-        assert_equal false, rec
+      oo.header_line = nil
+      assert_nil oo.header_line
+      # keine Headerlines in diesem Beispiel definiert
+      after Date.new(2008,1,31) do
+        assert_equal "einundvierzig", rec[0]
+        #assert_equal false, rec
 
         rec = oo.find 15
         assert rec
         assert_equal 41,rec
       end
@@ -1926,11 +1937,12 @@
     if EXCEL
       oo = Excel.new(File.join("test","numbers1.xls"))
       oo.default_sheet = oo.sheets.first
       rec = oo.find 16
       assert rec
-      after Date.new(2008,1,15) do
+      # keine Headerlines in diesem Beispiel definiert
+      after Date.new(2008,1,31) do
         assert_equal "einundvierzig", rec[0]
 
         rec = oo.find 15
         assert rec
         assert_equal 41,rec[0]
@@ -1938,15 +1950,16 @@
     end
   end
 
   def test_find_by_row_google
     if GOOGLE
-      oo = Excel.new(key_of("numbers1"))
+      oo = Google.new(key_of("numbers1"))
       oo.default_sheet = oo.sheets.first
       rec = oo.find 16
       assert rec
-      after Date.new(2008,1,15) do
+      # keine Headerlines in diesem Beispiel definiert
+      after Date.new(2008,1,31) do
         assert_equal "einundvierzig", rec[0]
 
         rec = oo.find 15
         assert rec
         assert_equal 41,rec[0]
@@ -2505,13 +2518,14 @@
       assert_raise(IOError) {
         oo = Excel.new(File.join('testnichtvorhanden','Bibelbund.xls'))
       }
     end
     if GOOGLE
-      after Date.new(2008,1,1) do
-        assert_raise(IOError) {
-          oo = Google.new(key_of('testnichtvorhanden'+'Bibelbund.ods'))
-        }
+      after Date.new(2008,1,31) do
+      assert_raise(IOError) {
+        # oo = Google.new(key_of('testnichtvorhanden'+'Bibelbund.ods'))
+        oo = Google.new('testnichtvorhanden')
+      }
       end
     end
   end
 
   def test_bug_cell_no_default_sheet