sc/qa/unit/data/xlsx/tdf160371.xlsx |binary
sc/qa/unit/subsequent_filters_test2.cxx | 13 +++++++++++++
2 files changed, 13 insertions(+)
New commits:
commit e10ca8d250b39cc2778e9df47a06fd6ba4f2fced
Author: Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Mon Jun 3 15:58:57 2024 +0200
Commit: Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Mon Jun 3 20:52:58 2024 +0200
tdf#160371: sc_subsequent_filters_test2: Add unittest
Change-Id: Ife3a319359391f0614260170c9ddfbac16e13cbd
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/168379
Reviewed-by: Xisco Fauli <xiscofa...@libreoffice.org>
Tested-by: Jenkins
diff --git a/sc/qa/unit/data/xlsx/tdf160371.xlsx
b/sc/qa/unit/data/xlsx/tdf160371.xlsx
new file mode 100644
index 000000000000..798db83d9c18
Binary files /dev/null and b/sc/qa/unit/data/xlsx/tdf160371.xlsx differ
diff --git a/sc/qa/unit/subsequent_filters_test2.cxx
b/sc/qa/unit/subsequent_filters_test2.cxx
index 74eea5b91efa..60966f08bc5c 100644
--- a/sc/qa/unit/subsequent_filters_test2.cxx
+++ b/sc/qa/unit/subsequent_filters_test2.cxx
@@ -730,6 +730,19 @@ CPPUNIT_TEST_FIXTURE(ScFiltersTest2,
testErrorOnExternalReferences)
pDoc->GetFormula(0, 0, 0));
}
+CPPUNIT_TEST_FIXTURE(ScFiltersTest2, testTdf160371)
+{
+ createScDoc("xlsx/tdf160371.xlsx");
+
+ ScDocument* pDoc = getScDoc();
+
+ // Without the fix in place, this test would have failed with
+ // - Expected: =INDIRECT(B2)!INDIRECT(B3)
+ // - Actual : =INDIRECT(B2) INDIRECT(B3)
+ CPPUNIT_ASSERT_EQUAL(u"=INDIRECT(B2)!INDIRECT(B3)"_ustr,
pDoc->GetFormula(1, 3, 0));
+ CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(ScAddress(1, 3, 0)));
+}
+
CPPUNIT_TEST_FIXTURE(ScFiltersTest2, testTdf145054)
{
createScDoc("xlsx/tdf145054.xlsx");
