sc/qa/unit/data/xlsx/tdf170201.xlsx |binary sc/qa/unit/subsequent_export_test2.cxx | 14 ++++++++++++++ 2 files changed, 14 insertions(+)
New commits: commit b423455d30d24b43ed7bf8fbcd09e1a6da39b5ef Author: Xisco Fauli <[email protected]> AuthorDate: Thu Jan 29 14:13:39 2026 +0100 Commit: Xisco Fauli <[email protected]> CommitDate: Thu Jan 29 16:43:20 2026 +0100 tdf#170201: sc_subsequent_export_test2: Add test Change-Id: I84dd263fc6db0c3367482129937530f0515c4ce9 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/198356 Reviewed-by: Xisco Fauli <[email protected]> Tested-by: Jenkins diff --git a/sc/qa/unit/data/xlsx/tdf170201.xlsx b/sc/qa/unit/data/xlsx/tdf170201.xlsx new file mode 100644 index 000000000000..d0b68a9fce64 Binary files /dev/null and b/sc/qa/unit/data/xlsx/tdf170201.xlsx differ diff --git a/sc/qa/unit/subsequent_export_test2.cxx b/sc/qa/unit/subsequent_export_test2.cxx index 5fa4d0a426bd..ff1dfda81a4f 100644 --- a/sc/qa/unit/subsequent_export_test2.cxx +++ b/sc/qa/unit/subsequent_export_test2.cxx @@ -1249,6 +1249,20 @@ CPPUNIT_TEST_FIXTURE(ScExportTest2, testTdf115159) assertXPath(pDoc, "/x:workbook/x:definedNames/x:definedName", 1); } +CPPUNIT_TEST_FIXTURE(ScExportTest2, testTdf170201_empty_values_in_array_formulas) +{ + createScDoc("xlsx/tdf170201.xlsx"); + + save(TestFilter::XLSX); + xmlDocUniquePtr pDoc = parseExport(u"xl/workbook.xml"_ustr); + CPPUNIT_ASSERT(pDoc); + + // Without the fix in place, this test would have failed with + // - Expected: {1,#N/A,3} + // - Actual : {1,,3} + assertXPathContent(pDoc, "/x:workbook/x:definedNames/x:definedName", u"{1,#N/A,3}"); +} + CPPUNIT_TEST_FIXTURE(ScExportTest2, testTdf112567) { // Set the system locale to Hungarian (a language with different range separator)
