sc/qa/unit/ucalc_formula.cxx | 7 +++++++
1 file changed, 7 insertions(+)
New commits:
commit 5f23f94cdef660909e105176a8c7ae83780baa71
Author: Eike Rathke <er...@redhat.com>
Date: Sat Mar 10 21:03:09 2018 +0100
Unit test tdf#116324
Change-Id: Ib1f0f8fe2308c075477903d4f981046a939d4b79
diff --git a/sc/qa/unit/ucalc_formula.cxx b/sc/qa/unit/ucalc_formula.cxx
index 639dac3527db..5d3bdd5aafbc 100644
--- a/sc/qa/unit/ucalc_formula.cxx
+++ b/sc/qa/unit/ucalc_formula.cxx
@@ -4432,6 +4432,13 @@ void Test::testFuncIF()
// Result must be 16, only the first row matches all criteria.
CPPUNIT_ASSERT_EQUAL(16.0, m_pDoc->GetValue(ScAddress(3,3,0)));
+ // A11:B11
+ // Test nested IF in array/matrix if the nested IF has no Else path.
+ m_pDoc->InsertMatrixFormula(0,10, 1,10, aMark, "=IF(IF({1;0};12);34;56)");
+ // Results must be 34 and 56.
+ CPPUNIT_ASSERT_EQUAL(34.0, m_pDoc->GetValue(ScAddress(0,10,0)));
+ CPPUNIT_ASSERT_EQUAL(56.0, m_pDoc->GetValue(ScAddress(1,10,0)));
+
m_pDoc->DeleteTab(0);
}
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
