sc/qa/unit/ucalc_formula.cxx | 77 +++++++++++++++++++++++++++++++++++++++++++
1 file changed, 77 insertions(+)
New commits:
commit 51648c8de8dc060abc8dff1af105acfccadab77d
Author: Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Thu Feb 17 12:15:38 2022 +0100
Commit: Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Thu Feb 17 14:41:59 2022 +0100
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 <xiscofa...@libreoffice.org>
diff --git a/sc/qa/unit/ucalc_formula.cxx b/sc/qa/unit/ucalc_formula.cxx
index 1dd7b1f70ecd..ef12df67748f 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.
