tdf#70455: sc_subsequent_filters2: Add unittest
Change-Id: I757bef506eff21071de8b8b40f5e1fc9d82b1ab7
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/132083
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofauli@libreoffice.org>
diff --git a/sc/qa/unit/data/xlsx/tdf70455.xlsx b/sc/qa/unit/data/xlsx/tdf70455.xlsx
new file mode 100644
index 0000000..6c946ef
--- /dev/null
+++ b/sc/qa/unit/data/xlsx/tdf70455.xlsx
Binary files differ
diff --git a/sc/qa/unit/subsequent_filters_test2.cxx b/sc/qa/unit/subsequent_filters_test2.cxx
index e816407..df6bb82 100644
--- a/sc/qa/unit/subsequent_filters_test2.cxx
+++ b/sc/qa/unit/subsequent_filters_test2.cxx
@@ -154,6 +154,7 @@ public:
void testColumnWidthRowHeightXLSXML();
void testCharacterSetXLSXML();
void testTdf137091();
void testTdf70455();
void testTdf62268();
void testTdf137453();
void testTdf112780();
@@ -265,6 +266,7 @@ public:
CPPUNIT_TEST(testCharacterSetXLSXML);
CPPUNIT_TEST(testCondFormatFormulaListenerXLSX);
CPPUNIT_TEST(testTdf137091);
CPPUNIT_TEST(testTdf70455);
CPPUNIT_TEST(testTdf62268);
CPPUNIT_TEST(testTdf137453);
CPPUNIT_TEST(testTdf112780);
@@ -2322,6 +2324,19 @@ void ScFiltersTest2::testTdf137091()
xDocSh->DoClose();
}
void ScFiltersTest2::testTdf70455()
{
ScDocShellRef xDocSh = loadDoc(u"tdf70455.", FORMAT_XLSX);
ScDocument& rDoc = xDocSh->GetDocument();
// Without the fix in place, this test would have failed with
// - Expected: €780.00
// - Actual : Err:509
CPPUNIT_ASSERT_EQUAL(OUString(OUStringChar(u'\x20AC') + "780.00"),
rDoc.GetString(ScAddress(7, 7, 0)));
xDocSh->DoClose();
}
void ScFiltersTest2::testTdf62268()
{
ScDocShellRef xDocSh = loadDoc(u"tdf62268.", FORMAT_ODS);
