[Libreoffice-commits] core.git: sc/qa

[Eike Rathke]

 sc/qa/unit/ucalc_formula.cxx |    7 +++++++
 1 file changed, 7 insertions(+)

New commits:
commit 5f23f94cdef660909e105176a8c7ae83780baa71
Author: Eike Rathke <erack at 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);
 }