diff options
| author | Eike Rathke <erack@redhat.com> | 2018-03-10 21:03:09 +0100 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2018-03-10 21:03:16 +0100 |
| commit | 5f23f94cdef660909e105176a8c7ae83780baa71 (patch) | |
| tree | e07c5b570ea40bccc634cc413f32b434052f8b47 | |
| parent | 8930f8f530b4879226a6bac55bfeb551ac9e7489 (diff) | |
Unit test tdf#116324
Change-Id: Ib1f0f8fe2308c075477903d4f981046a939d4b79
| -rw-r--r-- | sc/qa/unit/ucalc_formula.cxx | 7 |
1 files changed, 7 insertions, 0 deletions
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); } |