diff options
| author | Dennis Francis <dennis.francis@collabora.com> | 2019-11-21 14:17:22 +0530 |
|---|---|---|
| committer | Dennis Francis <dennis.francis@collabora.com> | 2019-11-22 13:24:32 +0100 |
| commit | 626d1527267ab856e516f2424173104f781b8f09 (patch) | |
| tree | 429e1e191b3d889086c3a70031f5508dcec3f746 /sc/qa | |
| parent | b30251ca0d102ced36799ee18d4bbcd9e8530fa0 (diff) | |
tdf#128894: unit test for the bugfix
Change-Id: Ic6d3910f12409f5af541c887760caefcb78b30f9
Reviewed-on: https://gerrit.libreoffice.org/83362
Tested-by: Jenkins
Reviewed-by: Dennis Francis <dennis.francis@collabora.com>
Diffstat (limited to 'sc/qa')
| -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 d747edcbd7a2..4551ee4d9fb7 100644 --- a/sc/qa/unit/filters-test.cxx +++ b/sc/qa/unit/filters-test.cxx @@ -68,6 +68,7 @@ public: void testContentGnumeric(); void testSharedFormulaXLS(); void testSharedFormulaXLSX(); + void testSharedFormulaRefUpdateXLSX(); void testSheetNamesXLSX(); void testLegacyCellAnchoredRotatedShape(); void testEnhancedProtectionXLS(); @@ -92,6 +93,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, rDoc.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); |