[Libreoffice-commits] core.git: sc/qa

[Xisco Fauli (via logerrit)]

 sc/qa/unit/data/xlsx/tdf70455.xlsx      |binary
 sc/qa/unit/subsequent_filters_test2.cxx |   15 +++++++++++++++
 2 files changed, 15 insertions(+)

New commits:
commit f34994b20ecede29f03bf6c51bca2d48fda4ad1a
Author:     Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Thu Mar 24 19:29:05 2022 +0100
Commit:     Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Thu Mar 24 20:15:47 2022 +0100

    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 <xiscofa...@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 000000000000..6c946ef35493
Binary files /dev/null and b/sc/qa/unit/data/xlsx/tdf70455.xlsx differ
diff --git a/sc/qa/unit/subsequent_filters_test2.cxx 
b/sc/qa/unit/subsequent_filters_test2.cxx
index e8164070fd47..df6bb82fa518 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);