sc/qa/unit/ucalc_formula.cxx | 10 ++++++++++
1 file changed, 10 insertions(+)
New commits:
commit 4f35cb303583a66de3b5df548bcad9c24f126f34
Author: Eike Rathke <er...@redhat.com>
AuthorDate: Fri Aug 24 09:55:29 2018 +0200
Commit: Eike Rathke <er...@redhat.com>
CommitDate: Fri Aug 24 11:45:52 2018 +0200
tdf#117016 unit test for LOOKUP() interim array omitted errors
Change-Id: I764e39876dd0a870cbe88054311899f0cc2a3181
Reviewed-on: https://gerrit.libreoffice.org/59541
Reviewed-by: Eike Rathke <er...@redhat.com>
Tested-by: Jenkins
diff --git a/sc/qa/unit/ucalc_formula.cxx b/sc/qa/unit/ucalc_formula.cxx
index 5be2404d484f..342ef56f2ce1 100644
--- a/sc/qa/unit/ucalc_formula.cxx
+++ b/sc/qa/unit/ucalc_formula.cxx
@@ -5135,6 +5135,16 @@ void Test::testFuncLOOKUParrayWithError()
m_pDoc->SetString(4,1,0, ""); // E2
CPPUNIT_ASSERT_EQUAL_MESSAGE("Should find match for second last column.",
OUString("b"), m_pDoc->GetString(0,0,0));
+ m_pDoc->SetString(6,1,0, "one"); // G2
+ m_pDoc->SetString(6,5,0, "two"); // G6
+ // Creates an interim array
{1,#DIV/0!,#DIV/0!,#DIV/0!,1,#DIV/0!,#DIV/0!,#DIV/0!}
+ m_pDoc->SetString(7,8,0, "=LOOKUP(2;1/(NOT(ISBLANK(G2:G9)));G2:G9)"); // H9
+ CPPUNIT_ASSERT_EQUAL_MESSAGE("Should find match for last row.",
OUString("two"), m_pDoc->GetString(7,8,0));
+
+ // Lookup on empty range.
+ m_pDoc->SetString(9,8,0, "=LOOKUP(2;1/(NOT(ISBLANK(I2:I9)));I2:I9)"); // J9
+ CPPUNIT_ASSERT_EQUAL_MESSAGE("Should find no match.", OUString("#N/A"),
m_pDoc->GetString(9,8,0));
+
m_pDoc->DeleteTab(0);
}
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
