summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-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);