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

[Markus Mohrhard]

 sc/qa/unit/data/contentCSV/financial-functions.csv |   55 +++++++++++++++++++++
 sc/qa/unit/data/ods/functions.ods                  |binary
 sc/qa/unit/helper/csv_handler.hxx                  |    2 
 sc/qa/unit/subsequent_filters-test.cxx             |    3 +
 4 files changed, 59 insertions(+), 1 deletion(-)

New commits:
commit 8c443f5c03d5202a7ef0c2738a21c74c36ef06a2
Author: Markus Mohrhard <markus.mohrhard at collabora.co.uk>
Date:   Wed Mar 5 08:10:33 2014 +0100

    integrate the financial-functions test
    
    Change-Id: I1d7ccbf4ceb3e825737a6c0af228767dc3fbce2d

diff --git a/sc/qa/unit/helper/csv_handler.hxx b/sc/qa/unit/helper/csv_handler.hxx
index 1223ef6..fc2e011 100644
--- a/sc/qa/unit/helper/csv_handler.hxx
+++ b/sc/qa/unit/helper/csv_handler.hxx
@@ -167,7 +167,7 @@ public:
                 std::cout << "CSVValue: " << nValue << std::endl;
                 std::cout << "result: " << (int)(aValue == nValue) << std::endl;
 #endif //DEBUG_CSV_HANDLER
-                CPPUNIT_ASSERT_MESSAGE(createErrorMessage(mnCol, mnRow, mnTab, nValue, aValue).getStr(), aValue == nValue);
+                CPPUNIT_ASSERT_DOUBLES_EQUAL_MESSAGE(createErrorMessage(mnCol, mnRow, mnTab, nValue, aValue).getStr(), nValue, aValue, 1e-10);
             }
         }
         ++mnCol;
diff --git a/sc/qa/unit/subsequent_filters-test.cxx b/sc/qa/unit/subsequent_filters-test.cxx
index 4df450c..636b864 100644
--- a/sc/qa/unit/subsequent_filters-test.cxx
+++ b/sc/qa/unit/subsequent_filters-test.cxx
@@ -402,6 +402,9 @@ void ScFiltersTest::testFunctionsODS()
     // statistical functions
     createCSVPath(OUString("statistical-functions."), aCSVFileName);
     testFile(aCSVFileName, pDoc, 5);
+    // financial functions
+    createCSVPath("financial-functions.", aCSVFileName);
+    testFile(aCSVFileName, pDoc, 6);
 
     xDocSh->DoClose();
 }
commit 35f39285991043a70f65c796c38624c9c51ec4b1
Author: Ken Biondi <kenbiondi at hotmail.com>
Date:   Wed Mar 5 08:16:01 2014 +0100

    add import test for financial functions
    
    Change-Id: Idda4de746db0c959ad31a6937a4aee877417e436

diff --git a/sc/qa/unit/data/contentCSV/financial-functions.csv b/sc/qa/unit/data/contentCSV/financial-functions.csv
new file mode 100644
index 0000000..814df6b
--- /dev/null
+++ b/sc/qa/unit/data/contentCSV/financial-functions.csv
@@ -0,0 +1,55 @@
+16.9444444444444
+20.5479452054794
+930
+375
+71
+92
+110
+37026
+2
+2
+-57.5412415342252
+-11135.2321307508,-937.5
+-3669.73551569782
+-934.107123420898,-68.2782711809783
+1075
+1721.80586824866
+0.0372448979591837
+1.125,1.125
+1.02,1.1
+79.4907946994012
+5.99195013802694
+0.0535426673707582
+0.10112312546402
+-4234
+1124.76
+0.0812374805252615
+-352.973422514773
+0.113321028236252
+-300
+4.02068710841898
+0.941647376706893
+0.127303166959042
+0.052500319868356
+-12.0207780851554
+49.432121038173
+99.8782860147214
+99.8782860147214
+0.0448731663302424
+-715.955334437392
+-350.992937038239
+95.0428743993921
+99.7958333333333
+99.984498875557
+-35019.3680845542
+0.00770147248823279
+1014.42026586264
+0.074569931823542
+553.571428571429
+13333.3333333333
+0.094151493565943
+98.45
+0.0914169629253423
+8603.80245372397
+0.194818475056105
+332.570918796713
diff --git a/sc/qa/unit/data/ods/functions.ods b/sc/qa/unit/data/ods/functions.ods
index 9a1cb46..97d3b16 100644
Binary files a/sc/qa/unit/data/ods/functions.ods and b/sc/qa/unit/data/ods/functions.ods differ