GPU Calc: unit test cases for SUMIF
turn NO_FALLBACK_TO_SWINTERP on in formulagroupcl.cxx for test
AMLOEXT-377 BUG
Change-Id: I0980604d643f3875e4dfe7dcd20f3cad186d72f6
Signed-off-by: haochen <haochen@multicorewareinc.com>
Signed-off-by: I-Jui (Ray) Sung <ray@multicorewareinc.com>
diff --git a/sc/qa/unit/data/xls/opencl/math/sumif.xls b/sc/qa/unit/data/xls/opencl/math/sumif.xls
new file mode 100644
index 0000000..ef8ef8c
--- /dev/null
+++ b/sc/qa/unit/data/xls/opencl/math/sumif.xls
Binary files differ
diff --git a/sc/qa/unit/opencl-test.cxx b/sc/qa/unit/opencl-test.cxx
index 9704e7f..65528df 100644
--- a/sc/qa/unit/opencl-test.cxx
+++ b/sc/qa/unit/opencl-test.cxx
@@ -282,6 +282,7 @@ public:
void testMathFormulaMROUND();
void testMathFormulaSeriesSum();
void testMathFormulaQuotient();
void testMathFormulaSumIf();
CPPUNIT_TEST_SUITE(ScOpenclTest);
CPPUNIT_TEST(testSharedFormulaXLS);
CPPUNIT_TEST(testFinacialFormula);
@@ -494,6 +495,7 @@ public:
CPPUNIT_TEST(testMathFormulaMROUND);
CPPUNIT_TEST(testMathFormulaQuotient);
CPPUNIT_TEST(testMathFormulaSeriesSum);
CPPUNIT_TEST(testMathFormulaSumIf);
CPPUNIT_TEST_SUITE_END();
private:
@@ -5837,6 +5839,28 @@ void ScOpenclTest::testMathFormulaSeriesSum()
xDocSh->DoClose();
xDocShRes->DoClose();
}
//[AMLOEXT-377]
void ScOpenclTest::testMathFormulaSumIf()
{
if (!detectOpenCLDevice())
return;
ScDocShellRef xDocSh = loadDoc("opencl/math/sumif.", XLS);
ScDocument* pDoc = xDocSh->GetDocument();
CPPUNIT_ASSERT(pDoc);
enableOpenCL();
pDoc->CalcAll();
ScDocShellRef xDocShRes = loadDoc("opencl/math/sumif.", XLS);
ScDocument* pDocRes = xDocShRes->GetDocument();
CPPUNIT_ASSERT(pDocRes);
for (SCROW i = 0; i <= 26; ++i)
{
double fLibre = pDoc->GetValue(ScAddress(2,i,0));
double fExcel = pDocRes->GetValue(ScAddress(2,i,0));
CPPUNIT_ASSERT_DOUBLES_EQUAL(fExcel, fLibre, fabs(0.0001*fExcel));
}
xDocSh->DoClose();
xDocShRes->DoClose();
}
ScOpenclTest::ScOpenclTest()
: ScBootstrapFixture( "/sc/qa/unit/data" )
{
diff --git a/sc/source/core/tool/token.cxx b/sc/source/core/tool/token.cxx
index a7b95e5..af4f142 100644
--- a/sc/source/core/tool/token.cxx
+++ b/sc/source/core/tool/token.cxx
@@ -1504,6 +1504,7 @@ void ScTokenArray::CheckToken( const FormulaToken& r )
case ocStDevPA:
case ocSecant:
case ocSecantHyp:
case ocSumIf:
// Don't change the state.
break;
default:
