diff options
| author | Xisco Fauli <xiscofauli@libreoffice.org> | 2024-10-24 13:07:46 +0200 |
|---|---|---|
| committer | Xisco Fauli <xiscofauli@libreoffice.org> | 2024-10-24 19:21:39 +0200 |
| commit | d8f71364a582e39a2fb04a09c9ae1bf8470c43c4 (patch) | |
| tree | 2589028ef3f0ab124f25e8a57c3ed74d085b0c5a /sc | |
| parent | 500060c71a0ac2457fcf917b34206d9641a49327 (diff) | |
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 <xiscofauli@libreoffice.org>
Diffstat (limited to 'sc')
| -rw-r--r-- | sc/qa/unit/data/xlsx/tdf163554.xlsx | bin | 0 -> 8661 bytes | |||
| -rw-r--r-- | sc/qa/unit/subsequent_export_test4.cxx | 20 |
2 files changed, 20 insertions, 0 deletions
diff --git a/sc/qa/unit/data/xlsx/tdf163554.xlsx b/sc/qa/unit/data/xlsx/tdf163554.xlsx Binary files differnew file mode 100644 index 000000000000..f8d4cb753c14 --- /dev/null +++ b/sc/qa/unit/data/xlsx/tdf163554.xlsx 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"); |