diff options
author | dechuang <dechuang@multicorewareinc.com> | 2013-12-11 15:06:26 +0800 |
---|---|---|
committer | I-Jui (Ray) Sung <ray@multicorewareinc.com> | 2013-12-31 17:36:33 -0600 |
commit | 0900b01a788e68da8b03a87345db91bad871ad8c (patch) | |
tree | 2390193a527511bb3fe5e07e0d47ec13b0d06984 | |
parent | 40a19f9f42f4954e777cc6a11e0d9658dd77b7f7 (diff) |
GPU Calc: unit test cases for DSTDEV
Need turn NO_FALLBACK_TO_SWINTERP on in formulagroupcl.cxx for test
AMLOEXT-339 BUG
Change-Id: Ia32b8d88ebbd4021fccf1eef3320f3ce9a4b0933
Signed-off-by: haochen <haochen@multicorewareinc.com>
Signed-off-by: Wei Wei <weiwei@multicorewareinc.com>
Signed-off-by: I-Jui (Ray) Sung <ray@multicorewareinc.com>
Signed-off-by: Wei Wei <weiwei@multicorewareinc.com>
-rw-r--r-- | sc/qa/unit/data/xls/opencl/database/dstdev.xls | bin | 0 -> 31232 bytes | |||
-rw-r--r-- | sc/qa/unit/opencl-test.cxx | 28 | ||||
-rw-r--r-- | sc/source/core/tool/token.cxx | 1 |
3 files changed, 29 insertions, 0 deletions
diff --git a/sc/qa/unit/data/xls/opencl/database/dstdev.xls b/sc/qa/unit/data/xls/opencl/database/dstdev.xls Binary files differnew file mode 100644 index 000000000000..4c3253605867 --- /dev/null +++ b/sc/qa/unit/data/xls/opencl/database/dstdev.xls diff --git a/sc/qa/unit/opencl-test.cxx b/sc/qa/unit/opencl-test.cxx index aaeddfec18db..0ea81b316551 100644 --- a/sc/qa/unit/opencl-test.cxx +++ b/sc/qa/unit/opencl-test.cxx @@ -252,6 +252,7 @@ public: void testDatabaseFormulaDmin(); void testDatabaseFormulaDproduct(); void testDatabaseFormulaDaverage(); + void testDatabaseFormulaDstdev(); CPPUNIT_TEST_SUITE(ScOpenclTest); CPPUNIT_TEST(testSharedFormulaXLS); CPPUNIT_TEST(testFinacialFormula); @@ -435,6 +436,7 @@ public: CPPUNIT_TEST(testDatabaseFormulaDmin); CPPUNIT_TEST(testDatabaseFormulaDproduct); CPPUNIT_TEST(testDatabaseFormulaDaverage); + CPPUNIT_TEST(testDatabaseFormulaDstdev); CPPUNIT_TEST_SUITE_END(); private: @@ -5078,6 +5080,32 @@ void ScOpenclTest::testDatabaseFormulaDaverage() xDocShRes->DoClose(); } +//[AMLOEXT-339] +void ScOpenclTest::testDatabaseFormulaDstdev() +{ + if (!detectOpenCLDevice()) + return; + ScDocShellRef xDocSh = loadDoc("opencl/database/dstdev.", XLS); + ScDocument* pDoc = xDocSh->GetDocument(); + CPPUNIT_ASSERT(pDoc); + enableOpenCL(); + pDoc->CalcAll(); + ScDocShellRef xDocShRes = loadDoc("opencl/database/dstdev.", XLS); + ScDocument* pDocRes = xDocShRes->GetDocument(); + CPPUNIT_ASSERT(pDocRes); + // Check the results of formula cells in the shared formula range. + for (SCROW i = 1; i <= 32; ++i) + { + double fLibre = pDoc->GetValue(ScAddress(9,i,0)); + double fExcel = pDocRes->GetValue(ScAddress(10,i,0)); + //CPPUNIT_ASSERT_DOUBLES_EQUAL(fExcel, fLibre, fabs(0.0001*fExcel)); + CPPUNIT_ASSERT_DOUBLES_EQUAL(fExcel, fLibre, fabs(0.00000000001)); + } + xDocSh->DoClose(); + xDocShRes->DoClose(); +} + + diff --git a/sc/source/core/tool/token.cxx b/sc/source/core/tool/token.cxx index 731a7d769a10..10d51ea15aaa 100644 --- a/sc/source/core/tool/token.cxx +++ b/sc/source/core/tool/token.cxx @@ -1480,6 +1480,7 @@ void ScTokenArray::CheckToken( const FormulaToken& r ) case ocDBMin: case ocDBProduct: case ocDBAverage: + case ocDBStdDev: // Don't change the state. break; default: |