commit 51648c8de8dc060abc8dff1af105acfccadab77d
author Xisco Fauli <xiscofauli@libreoffice.org> Thu Feb 17 12:15:38 2022 +0100
committer Xisco Fauli <xiscofauli@libreoffice.org> Thu Feb 17 14:41:59 2022 +0100
tree 56ca144825418b1900e8d4069ce08b6a582c607f
parent d4758f3d3d083b6b59fa0c0f37dae473770f3c45

tdf#147398: sc_ucalc_formula: Add unittest

Change-Id: I28c8a4614edf577e1f8f101ba55327fd9f358973
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/130068
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofauli@libreoffice.org>

sc/qa/unit/ucalc_formula.cxx

diff --git a/sc/qa/unit/ucalc_formula.cxx b/sc/qa/unit/ucalc_formula.cxx
index 1dd7b1f..ef12df6 100644
--- a/sc/qa/unit/ucalc_formula.cxx
+++ b/sc/qa/unit/ucalc_formula.cxx
@@ -259,6 +259,7 @@ public:
    void testRefR1C1WholeRow();
    void testIterations();
    void testInsertColCellStoreEventSwap();
    void testTdf147398();
    void testFormulaAfterDeleteRows();
    void testMultipleOperations();
    void testFuncCOLUMN();
@@ -376,6 +377,7 @@ public:
    CPPUNIT_TEST(testRefR1C1WholeRow);
    CPPUNIT_TEST(testIterations);
    CPPUNIT_TEST(testInsertColCellStoreEventSwap);
    CPPUNIT_TEST(testTdf147398);
    CPPUNIT_TEST(testFormulaAfterDeleteRows);
    CPPUNIT_TEST(testMultipleOperations);
    CPPUNIT_TEST(testFuncCOLUMN);
@@ -9504,6 +9506,81 @@ void TestFormula::testInsertColCellStoreEventSwap()
    m_pDoc->DeleteTab(0);
}

void TestFormula::testTdf147398()
{
    m_pDoc->InsertTab(0, "Test");

    m_pDoc->SetString(0, 0, 0, "=SUM(A3:A5)");
    m_pDoc->SetString(0, 1, 0, "=COUNT(A3:A5)");
    m_pDoc->SetString(1, 0, 0, "=SUM(B3:B5)");
    m_pDoc->SetString(1, 1, 0, "=COUNT(B3:B5)");
    m_pDoc->SetString(2, 0, 0, "=SUM(C3:C5)");
    m_pDoc->SetString(2, 1, 0, "=COUNT(C3:C5)");
    m_pDoc->SetString(3, 0, 0, "=SUM(D3:D5)");
    m_pDoc->SetString(3, 1, 0, "=COUNT(D3:D5)");
    m_pDoc->SetString(4, 0, 0, "=SUM(E3:E5)");
    m_pDoc->SetString(4, 1, 0, "=COUNT(E3:E5)");

    m_pDoc->SetString(5, 0, 0, "=SUM(A1:E1)/SUM(A2:E2)");

    m_pDoc->SetValue(ScAddress(0, 2, 0), 50.0);
    m_pDoc->SetValue(ScAddress(0, 3, 0), 100.0);

    CPPUNIT_ASSERT_EQUAL(150.0, m_pDoc->GetValue(ScAddress(0, 0, 0)));
    CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(0, 1, 0)));
    CPPUNIT_ASSERT_EQUAL(75.0, m_pDoc->GetValue(ScAddress(5, 0, 0)));

    m_pDoc->SetValue(ScAddress(1, 2, 0), 150.0);
    m_pDoc->SetValue(ScAddress(1, 3, 0), 200.0);

    CPPUNIT_ASSERT_EQUAL(150.0, m_pDoc->GetValue(ScAddress(0, 0, 0)));
    CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(0, 1, 0)));
    CPPUNIT_ASSERT_EQUAL(350.0, m_pDoc->GetValue(ScAddress(1, 0, 0)));
    CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(1, 1, 0)));
    CPPUNIT_ASSERT_EQUAL(125.0, m_pDoc->GetValue(ScAddress(5, 0, 0)));

    m_pDoc->SetValue(ScAddress(2, 2, 0), 250.0);
    m_pDoc->SetValue(ScAddress(2, 3, 0), 300.0);

    CPPUNIT_ASSERT_EQUAL(150.0, m_pDoc->GetValue(ScAddress(0, 0, 0)));
    CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(0, 1, 0)));
    CPPUNIT_ASSERT_EQUAL(350.0, m_pDoc->GetValue(ScAddress(1, 0, 0)));
    CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(1, 1, 0)));
    CPPUNIT_ASSERT_EQUAL(550.0, m_pDoc->GetValue(ScAddress(2, 0, 0)));
    CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(2, 1, 0)));
    CPPUNIT_ASSERT_EQUAL(175.0, m_pDoc->GetValue(ScAddress(5, 0, 0)));

    m_pDoc->SetValue(ScAddress(3, 2, 0), 350.0);
    m_pDoc->SetValue(ScAddress(3, 3, 0), 400.0);

    CPPUNIT_ASSERT_EQUAL(150.0, m_pDoc->GetValue(ScAddress(0, 0, 0)));
    CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(0, 1, 0)));
    CPPUNIT_ASSERT_EQUAL(350.0, m_pDoc->GetValue(ScAddress(1, 0, 0)));
    CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(1, 1, 0)));
    CPPUNIT_ASSERT_EQUAL(550.0, m_pDoc->GetValue(ScAddress(2, 0, 0)));
    CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(2, 1, 0)));
    CPPUNIT_ASSERT_EQUAL(750.0, m_pDoc->GetValue(ScAddress(3, 0, 0)));
    CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(3, 1, 0)));
    CPPUNIT_ASSERT_EQUAL(225.0, m_pDoc->GetValue(ScAddress(5, 0, 0)));

    m_pDoc->SetValue(ScAddress(4, 2, 0), 450.0);
    m_pDoc->SetValue(ScAddress(4, 3, 0), 500.0);

    CPPUNIT_ASSERT_EQUAL(150.0, m_pDoc->GetValue(ScAddress(0, 0, 0)));
    CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(0, 1, 0)));
    CPPUNIT_ASSERT_EQUAL(350.0, m_pDoc->GetValue(ScAddress(1, 0, 0)));
    CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(1, 1, 0)));
    CPPUNIT_ASSERT_EQUAL(550.0, m_pDoc->GetValue(ScAddress(2, 0, 0)));
    CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(2, 1, 0)));
    CPPUNIT_ASSERT_EQUAL(750.0, m_pDoc->GetValue(ScAddress(3, 0, 0)));
    CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(3, 1, 0)));
    CPPUNIT_ASSERT_EQUAL(950.0, m_pDoc->GetValue(ScAddress(4, 0, 0)));
    CPPUNIT_ASSERT_EQUAL(2.0, m_pDoc->GetValue(ScAddress(4, 1, 0)));
    CPPUNIT_ASSERT_EQUAL(275.0, m_pDoc->GetValue(ScAddress(5, 0, 0)));

    m_pDoc->DeleteTab(0);
}

void TestFormula::testFormulaAfterDeleteRows()
{
    sc::AutoCalcSwitch aACSwitch(*m_pDoc, true); // turn auto calc on.