sc/qa/unit/ucalc.hxx | 2 +
sc/qa/unit/ucalc_formula.cxx | 48 +++++++++++++++++++++++++++++++++++++++++++
2 files changed, 50 insertions(+)
New commits:
commit 724a8ccd81567a2ad93111a9cac257eb7ec7819f
Author: Kohei Yoshida <kohei.yosh...@collabora.com>
Date: Fri Jan 3 09:47:01 2014 -0500
fdo#73113: Write unit test for LOOKUP.
Change-Id: I1486b6ba9604c97601df142a32b211ce0aec7f09
diff --git a/sc/qa/unit/ucalc.hxx b/sc/qa/unit/ucalc.hxx
index 5cf8306..9ccc85a 100644
--- a/sc/qa/unit/ucalc.hxx
+++ b/sc/qa/unit/ucalc.hxx
@@ -103,6 +103,7 @@ public:
void testFuncN();
void testFuncCOUNTIF();
void testFuncNUMBERVALUE();
+ void testFuncLOOKUP();
void testFuncVLOOKUP();
void testFuncMATCH();
void testFuncCELL();
@@ -317,6 +318,7 @@ public:
CPPUNIT_TEST(testFuncN);
CPPUNIT_TEST(testFuncCOUNTIF);
CPPUNIT_TEST(testFuncNUMBERVALUE);
+ CPPUNIT_TEST(testFuncLOOKUP);
CPPUNIT_TEST(testFuncVLOOKUP);
CPPUNIT_TEST(testFuncMATCH);
CPPUNIT_TEST(testFuncCELL);
diff --git a/sc/qa/unit/ucalc_formula.cxx b/sc/qa/unit/ucalc_formula.cxx
index b07fffc..199494a 100644
--- a/sc/qa/unit/ucalc_formula.cxx
+++ b/sc/qa/unit/ucalc_formula.cxx
@@ -2017,6 +2017,54 @@ void Test::testFuncNUMBERVALUE()
m_pDoc->DeleteTab(0);
}
+void Test::testFuncLOOKUP()
+{
+ FormulaGrammarSwitch aFGSwitch(m_pDoc,
formula::FormulaGrammar::GRAM_ENGLISH_XL_R1C1);
+
+ m_pDoc->InsertTab(0, "Test");
+
+ // Raw data
+ const char* aData[][2] = {
+ { "=CONCATENATE(\"A\")", "1" },
+ { "=CONCATENATE(\"B\")", "2" },
+ { "=CONCATENATE(\"C\")", "3" },
+ { 0, 0 } // terminator
+ };
+
+ // Insert raw data into A1:B3.
+ for (SCROW i = 0; aData[i][0]; ++i)
+ {
+ m_pDoc->SetString(0, i, 0, OUString::createFromAscii(aData[i][0]));
+ m_pDoc->SetString(1, i, 0, OUString::createFromAscii(aData[i][1]));
+ }
+
+ const char* aData2[][2] = {
+ { "A", "=LOOKUP(RC[-1];R1C1:R3C1;R1C2:R3C2)" },
+ { "B", "=LOOKUP(RC[-1];R1C1:R3C1;R1C2:R3C2)" },
+ { "C", "=LOOKUP(RC[-1];R1C1:R3C1;R1C2:R3C2)" },
+ };
+
+ // Insert check formulas into A5:B7.
+ for (SCROW i = 0; aData2[i][0]; ++i)
+ {
+ m_pDoc->SetString(0, i+4, 0, OUString::createFromAscii(aData2[i][0]));
+ m_pDoc->SetString(1, i+4, 0, OUString::createFromAscii(aData2[i][1]));
+ }
+
+ printRange(m_pDoc, ScRange(0,4,0,1,6,0), "Data range for LOOKUP.");
+
+ // Values for B5:B7 should be 1, 2, and 3.
+ CPPUNIT_ASSERT_MESSAGE("This formula should not have an error code.",
m_pDoc->GetErrCode(ScAddress(1,4,0)) == 0);
+ CPPUNIT_ASSERT_MESSAGE("This formula should not have an error code.",
m_pDoc->GetErrCode(ScAddress(1,5,0)) == 0);
+ CPPUNIT_ASSERT_MESSAGE("This formula should not have an error code.",
m_pDoc->GetErrCode(ScAddress(1,6,0)) == 0);
+
+ CPPUNIT_ASSERT_EQUAL(1.0, m_pDoc->GetValue(ScAddress(1,4,0)));
+ CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(1,5,0)));
+ CPPUNIT_ASSERT_EQUAL(3.0, m_pDoc->GetValue(ScAddress(1,6,0)));
+
+ m_pDoc->DeleteTab(0);
+}
+
void Test::testFuncVLOOKUP()
{
// VLOOKUP
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
