[Libreoffice-commits] core.git: sc/qa

[Eike Rathke]

 sc/qa/unit/data/xlsx/functions-excel-2010.xlsx |binary
 sc/qa/unit/subsequent_filters-test.cxx         |   17 ++++++++++++-----
 2 files changed, 12 insertions(+), 5 deletions(-)

New commits:
commit 50820ace559d715891e35d9cf1213001049c96a4
Author: Eike Rathke <erack at redhat.com>
Date:   Fri Apr 4 15:21:37 2014 +0200

    updated test document for new Excel functions, fdo#70798
    
    https://bugs.freedesktop.org/attachment.cgi?id=96899
    
    Two function calls currently fail where implementation needs to be
    fixed:
    - row 45, function name=[ NETWORKDAYS.INTL ], result=18, expected=19
    - row 79, function name=[ WORKDAY.INTL ], result=41755 , expected=41754
    
    Change-Id: Ibb58dfa2f8687c7daa2cb7409803cd14b015dc98

diff --git a/sc/qa/unit/data/xlsx/functions-excel-2010.xlsx b/sc/qa/unit/data/xlsx/functions-excel-2010.xlsx
index 208c1c5..c6d6ebb8ab 100644
Binary files a/sc/qa/unit/data/xlsx/functions-excel-2010.xlsx and b/sc/qa/unit/data/xlsx/functions-excel-2010.xlsx differ
diff --git a/sc/qa/unit/subsequent_filters-test.cxx b/sc/qa/unit/subsequent_filters-test.cxx
index 1e08cf7..92429ad 100644
--- a/sc/qa/unit/subsequent_filters-test.cxx
+++ b/sc/qa/unit/subsequent_filters-test.cxx
@@ -465,9 +465,9 @@ void ScFiltersTest::testFunctionsExcel2010()
         { 40, true  },
         { 41, true  },
         { 42, true  },
-        { 43, false }, // fdo73147 to be set to true
+        { 43, true  },
         { 44, true  },
-        { 45, true  },
+        { 45, false },  // name=[ NETWORKDAYS.INTL ], result=18, expected=19
         { 46, true  },
         { 47, true  },
         { 48, true  },
@@ -488,14 +488,21 @@ void ScFiltersTest::testFunctionsExcel2010()
         { 63, true  },
         { 64, true  },
         { 65, true  },
-        { 66, false },
+        { 66, true  },
         { 67, true  },
         { 68, true  },
         { 69, true  },
         { 70, true  },
         { 71, true  },
-        { 72, false }, // fdo73147 to be set to true
-        { 73, true  }
+        { 72, true  },
+        { 73, true  },
+        { 74, true  },
+        { 75, true  },
+        { 76, true  },
+        { 77, true  },
+        { 78, true  },
+        { 79, false },  // name=[ WORKDAY.INTL ], result=41755 , expected=41754
+        { 80, true  }
     };
 
     for (size_t i=0; i < SAL_N_ELEMENTS(aTests); ++i)