sc/qa/unit/data/xlsx/tdf131575.xlsx |binary sc/qa/unit/data/xlsx/tdf76115.xlsx |binary sc/qa/unit/subsequent_filters_test4.cxx | 29 +++++++++++++++++++++++++++++ 3 files changed, 29 insertions(+)
New commits: commit f6083293f4de9ac9037066d51f0ad1ab6a420eda Author: Xisco Fauli <[email protected]> AuthorDate: Thu Feb 1 11:22:32 2024 +0100 Commit: Xisco Fauli <[email protected]> CommitDate: Thu Feb 1 13:40:43 2024 +0100 tdf#131575: sc_subsequent_filters: Add unittest Change-Id: I6f4bcc3da028dc9b2cd86ed06e309bed8d808ca9 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/162872 Tested-by: Jenkins Reviewed-by: Xisco Fauli <[email protected]> diff --git a/sc/qa/unit/data/xlsx/tdf131575.xlsx b/sc/qa/unit/data/xlsx/tdf131575.xlsx new file mode 100644 index 000000000000..307d7dea5cf8 Binary files /dev/null and b/sc/qa/unit/data/xlsx/tdf131575.xlsx differ diff --git a/sc/qa/unit/subsequent_filters_test4.cxx b/sc/qa/unit/subsequent_filters_test4.cxx index e9590b3dee73..41d3333303d5 100644 --- a/sc/qa/unit/subsequent_filters_test4.cxx +++ b/sc/qa/unit/subsequent_filters_test4.cxx @@ -119,6 +119,20 @@ CPPUNIT_TEST_FIXTURE(ScFiltersTest4, testControlImport) UNO_QUERY_THROW); } +CPPUNIT_TEST_FIXTURE(ScFiltersTest4, testTdf131575) +{ + // It expectedly fails to load normally + CPPUNIT_ASSERT_ASSERTION_FAIL(createScDoc("xlsx/tdf131575.xlsx")); + + // importing it must succeed with RepairPackage set to true. + uno::Sequence<beans::PropertyValue> aParams + = { comphelper::makePropertyValue(u"RepairPackage"_ustr, true) }; + loadWithParams(createFileURL(u"xlsx/tdf131575.xlsx"), aParams); + ScDocument* pDoc = getScDoc(); + + CPPUNIT_ASSERT_EQUAL(OUString("ETAT DES SORTIES"), pDoc->GetString(1, 0, 0)); +} + CPPUNIT_TEST_FIXTURE(ScFiltersTest4, testTdf76115) { // It expectedly fails to load normally commit c9cbcd21edbde84d793a45295f9df7196d1893d8 Author: Xisco Fauli <[email protected]> AuthorDate: Thu Feb 1 10:59:09 2024 +0100 Commit: Xisco Fauli <[email protected]> CommitDate: Thu Feb 1 13:40:33 2024 +0100 tdf#76115: sc_subsequent_filters: Add unittest Change-Id: I355eef6b0f145da8aacdd3b395ce3dcbecfb3e42 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/162870 Tested-by: Jenkins Reviewed-by: Xisco Fauli <[email protected]> diff --git a/sc/qa/unit/data/xlsx/tdf76115.xlsx b/sc/qa/unit/data/xlsx/tdf76115.xlsx new file mode 100644 index 000000000000..ebc6126dcbde Binary files /dev/null and b/sc/qa/unit/data/xlsx/tdf76115.xlsx differ diff --git a/sc/qa/unit/subsequent_filters_test4.cxx b/sc/qa/unit/subsequent_filters_test4.cxx index 47de6248aecc..e9590b3dee73 100644 --- a/sc/qa/unit/subsequent_filters_test4.cxx +++ b/sc/qa/unit/subsequent_filters_test4.cxx @@ -55,6 +55,7 @@ #include <com/sun/star/drawing/XDrawPageSupplier.hpp> #include <com/sun/star/drawing/XControlShape.hpp> +#include <comphelper/propertyvalue.hxx> #include <com/sun/star/sheet/XSpreadsheetDocument.hpp> #include <com/sun/star/container/XIndexAccess.hpp> @@ -118,6 +119,20 @@ CPPUNIT_TEST_FIXTURE(ScFiltersTest4, testControlImport) UNO_QUERY_THROW); } +CPPUNIT_TEST_FIXTURE(ScFiltersTest4, testTdf76115) +{ + // It expectedly fails to load normally + CPPUNIT_ASSERT_ASSERTION_FAIL(createScDoc("xlsx/tdf76115.xlsx")); + + // importing it must succeed with RepairPackage set to true. + uno::Sequence<beans::PropertyValue> aParams + = { comphelper::makePropertyValue(u"RepairPackage"_ustr, true) }; + loadWithParams(createFileURL(u"xlsx/tdf76115.xlsx"), aParams); + ScDocument* pDoc = getScDoc(); + + CPPUNIT_ASSERT_EQUAL(OUString("Filial"), pDoc->GetString(0, 0, 0)); +} + CPPUNIT_TEST_FIXTURE(ScFiltersTest4, testLegacyOptionButtonGroupBox) { createScDoc("xls/tdf79542_radioGroupBox.xls");
