sc/qa/unit/data/xlsx/tdf163554.xlsx |binary
sc/qa/unit/subsequent_export_test4.cxx | 20 ++++++++++++++++++++
2 files changed, 20 insertions(+)
New commits:
commit d8f71364a582e39a2fb04a09c9ae1bf8470c43c4
Author: Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Thu Oct 24 13:07:46 2024 +0200
Commit: Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Thu Oct 24 19:21:39 2024 +0200
tdf#163554: sc_subsequent_export_test4: Add unittest
Change-Id: Id27b893d1bbf80d2dee7c5b3a6c18656d84b7d30
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/175549
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofa...@libreoffice.org>
diff --git a/sc/qa/unit/data/xlsx/tdf163554.xlsx
b/sc/qa/unit/data/xlsx/tdf163554.xlsx
new file mode 100644
index 000000000000..f8d4cb753c14
Binary files /dev/null and b/sc/qa/unit/data/xlsx/tdf163554.xlsx differ
diff --git a/sc/qa/unit/subsequent_export_test4.cxx
b/sc/qa/unit/subsequent_export_test4.cxx
index 260c33a4dfbe..e6b5a6389af3 100644
--- a/sc/qa/unit/subsequent_export_test4.cxx
+++ b/sc/qa/unit/subsequent_export_test4.cxx
@@ -1979,6 +1979,26 @@ CPPUNIT_TEST_FIXTURE(ScExportTest4,
testChangesAuthorDateXLSX)
pBatch->commit();
}
+CPPUNIT_TEST_FIXTURE(ScExportTest4, testTdf163554)
+{
+ createScDoc("xlsx/tdf163554.xlsx");
+ ScDocument* pDoc = getScDoc();
+
+ // Without the fix in place, this test would have failed with
+ // - Expected: =SUM($'time (misc) - last'.B1:$'time (pnrst)'.B1)
+ // - Actual : =SUM('time (pnrst)':$'time (misc) - last'.B1:B1)
+ CPPUNIT_ASSERT_EQUAL(u"=SUM($'time (misc) - last'.B1:$'time
(pnrst)'.B1)"_ustr,
+ pDoc->GetFormula(0, 0, 0));
+ CPPUNIT_ASSERT_EQUAL(u"7"_ustr, pDoc->GetString(ScAddress(0, 0, 0)));
+
+ saveAndReload(u"Calc Office Open XML"_ustr);
+ pDoc = getScDoc();
+
+ CPPUNIT_ASSERT_EQUAL(u"=SUM($'time (misc) - last'.B1:$'time
(pnrst)'.B1)"_ustr,
+ pDoc->GetFormula(0, 0, 0));
+ CPPUNIT_ASSERT_EQUAL(u"7"_ustr, pDoc->GetString(ScAddress(0, 0, 0)));
+}
+
CPPUNIT_TEST_FIXTURE(ScExportTest4, testNotesAuthor)
{
createScDoc("xlsx/cell-note.xlsx");
