summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorXisco Fauli <xiscofauli@libreoffice.org>2021-05-07 12:00:42 +0200
committerXisco Fauli <xiscofauli@libreoffice.org>2021-05-07 16:46:02 +0200
commit0b6a70c3d945a9bc34f8ac4970a1b80fbbbcc08a (patch)
treea030d3044447b5318f9914929c60fdb4e1d3d7b6
parentb30170661fb3a87d6b0491d748b8eb0d8f3dc99e (diff)
tdf#115022: sc_subsequent_filters: Add unittest
Change-Id: I29c633f991231af6b71a7c6e1565c9fdd1604a25 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/115233 Tested-by: Jenkins Reviewed-by: Xisco Fauli <xiscofauli@libreoffice.org>
-rw-r--r--sc/qa/unit/data/xlsx/tdf115022.xlsxbin0 -> 5699 bytes
-rw-r--r--sc/qa/unit/subsequent_filters-test.cxx21
2 files changed, 21 insertions, 0 deletions
diff --git a/sc/qa/unit/data/xlsx/tdf115022.xlsx b/sc/qa/unit/data/xlsx/tdf115022.xlsx
new file mode 100644
index 000000000000..34d893b9d85e
--- /dev/null
+++ b/sc/qa/unit/data/xlsx/tdf115022.xlsx
Binary files differ
diff --git a/sc/qa/unit/subsequent_filters-test.cxx b/sc/qa/unit/subsequent_filters-test.cxx
index a854f49f0774..0d8e08fd1813 100644
--- a/sc/qa/unit/subsequent_filters-test.cxx
+++ b/sc/qa/unit/subsequent_filters-test.cxx
@@ -303,6 +303,7 @@ public:
void testTdf72470();
void testTdf35636();
void testTdf98481();
+ void testTdf115022();
void testVBAMacroFunctionODS();
void testAutoheight2Rows();
void testXLSDefColWidth();
@@ -502,6 +503,7 @@ public:
CPPUNIT_TEST(testTdf72470);
CPPUNIT_TEST(testTdf35636);
CPPUNIT_TEST(testTdf98481);
+ CPPUNIT_TEST(testTdf115022);
CPPUNIT_TEST(testVBAMacroFunctionODS);
CPPUNIT_TEST(testAutoheight2Rows);
CPPUNIT_TEST(testXLSDefColWidth);
@@ -5380,6 +5382,25 @@ void ScFiltersTest::testTdf98481()
xDocSh->DoClose();
}
+void ScFiltersTest::testTdf115022()
+{
+ ScDocShellRef xDocSh = loadDoc(u"tdf115022.", FORMAT_XLSX);
+ CPPUNIT_ASSERT_MESSAGE("Failed to open doc", xDocSh.is());
+
+ ScDocument& rDoc = xDocSh->GetDocument();
+
+ CPPUNIT_ASSERT_EQUAL(6.0, rDoc.GetValue(ScAddress(1,8,0)));
+
+ xDocSh->DoHardRecalc();
+
+ // Without the fix in place, this test would have failed with
+ // - Expected: 6
+ // - Actual : 21
+ CPPUNIT_ASSERT_EQUAL(6.0, rDoc.GetValue(ScAddress(1,8,0)));
+
+ xDocSh->DoClose();
+}
+
void ScFiltersTest::testVBAMacroFunctionODS()
{
ScDocShellRef xDocSh = loadDoc(u"vba_macro_functions.", FORMAT_ODS);