From 50820ace559d715891e35d9cf1213001049c96a4 Mon Sep 17 00:00:00 2001
From: Eike Rathke <erack@redhat.com>
Date: Fri, 4 Apr 2014 15:21:37 +0200
Subject: 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
---
 sc/qa/unit/data/xlsx/functions-excel-2010.xlsx | Bin 15459 -> 16074 bytes
 sc/qa/unit/subsequent_filters-test.cxx         |  17 ++++++++++++-----
 2 files changed, 12 insertions(+), 5 deletions(-)

diff --git a/sc/qa/unit/data/xlsx/functions-excel-2010.xlsx b/sc/qa/unit/data/xlsx/functions-excel-2010.xlsx
index 208c1c55e078..c6d6ebb8abcc 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 1e08cf793f7c..92429ad2430a 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)
-- 
cgit