diff options
Diffstat (limited to 'sc/qa/unit')
-rw-r--r-- | sc/qa/unit/data/xlsx/shared-formula/refupdate.xlsx | bin | 0 -> 8671 bytes | |||
-rw-r--r-- | sc/qa/unit/filters-test.cxx | 31 |
2 files changed, 31 insertions, 0 deletions
diff --git a/sc/qa/unit/data/xlsx/shared-formula/refupdate.xlsx b/sc/qa/unit/data/xlsx/shared-formula/refupdate.xlsx Binary files differnew file mode 100644 index 000000000000..fa386d3a4384 --- /dev/null +++ b/sc/qa/unit/data/xlsx/shared-formula/refupdate.xlsx diff --git a/sc/qa/unit/filters-test.cxx b/sc/qa/unit/filters-test.cxx index 24250db69aed..5f86c6581746 100644 --- a/sc/qa/unit/filters-test.cxx +++ b/sc/qa/unit/filters-test.cxx @@ -77,6 +77,7 @@ public: void testContentGnumeric(); void testSharedFormulaXLS(); void testSharedFormulaXLSX(); + void testSharedFormulaRefUpdateXLSX(); void testSheetNamesXLSX(); void testLegacyCellAnchoredRotatedShape(); void testEnhancedProtectionXLS(); @@ -100,6 +101,7 @@ public: CPPUNIT_TEST(testContentGnumeric); CPPUNIT_TEST(testSharedFormulaXLS); CPPUNIT_TEST(testSharedFormulaXLSX); + CPPUNIT_TEST(testSharedFormulaRefUpdateXLSX); CPPUNIT_TEST(testSheetNamesXLSX); CPPUNIT_TEST(testLegacyCellAnchoredRotatedShape); CPPUNIT_TEST(testEnhancedProtectionXLS); @@ -419,6 +421,35 @@ void ScFiltersTest::testSharedFormulaXLSX() xDocSh->DoClose(); } +void ScFiltersTest::testSharedFormulaRefUpdateXLSX() +{ + ScDocShellRef xDocSh = loadDoc("shared-formula/refupdate.", FORMAT_XLSX); + ScDocument& rDoc = xDocSh->GetDocument(); + sc::AutoCalcSwitch aACSwitch(rDoc, true); // turn auto calc on. + rDoc.DeleteRow(ScRange(0, 4, 0, MAXCOL, 4, 0)); // delete row 5. + + struct TestCase { + ScAddress aPos; + const char* pExpectedFormula; + const char* pErrorMsg; + }; + + TestCase aCases[4] = { + { ScAddress(1, 0, 0), "B29+1", "Wrong formula in B1" }, + { ScAddress(2, 0, 0), "C29+1", "Wrong formula in C1" }, + { ScAddress(3, 0, 0), "D29+1", "Wrong formula in D1" }, + { ScAddress(4, 0, 0), "E29+1", "Wrong formula in E1" }, + }; + + for (size_t nIdx = 0; nIdx < 4; ++nIdx) + { + TestCase& rCase = aCases[nIdx]; + ASSERT_FORMULA_EQUAL(rDoc, rCase.aPos, rCase.pExpectedFormula, rCase.pErrorMsg); + } + + xDocSh->DoClose(); +} + void ScFiltersTest::testSheetNamesXLSX() { ScDocShellRef xDocSh = loadDoc("sheet-names.", FORMAT_XLSX); |