sc/qa/unit/data/ods/conditionalformat_containstext.ods |binary sc/qa/unit/subsequent_export-test.cxx | 13 +++++++++++++ 2 files changed, 13 insertions(+)
New commits: commit 02a57aa51d71680ed64ce6519d77e28db06b03b3 Author: Markus Mohrhard <markus.mohrh...@googlemail.com> AuthorDate: Sat Jul 14 15:29:41 2018 +0200 Commit: Andras Timar <andras.ti...@collabora.com> CommitDate: Fri May 10 08:25:01 2019 +0200 add test for tdf#117816 Reviewed-on: https://gerrit.libreoffice.org/57433 Tested-by: Jenkins Reviewed-by: Markus Mohrhard <markus.mohrh...@googlemail.com> (cherry picked from commit 7e8dbbb02f25278d5afc51ae4a397831f5b21239) Change-Id: I470b4137a3b4e23acf0f4e949a7a834fed8069db Reviewed-on: https://gerrit.libreoffice.org/72005 Reviewed-by: Andras Timar <andras.ti...@collabora.com> Tested-by: Andras Timar <andras.ti...@collabora.com> diff --git a/sc/qa/unit/data/ods/conditionalformat_containstext.ods b/sc/qa/unit/data/ods/conditionalformat_containstext.ods new file mode 100644 index 000000000000..fa3e21e29f5a Binary files /dev/null and b/sc/qa/unit/data/ods/conditionalformat_containstext.ods differ diff --git a/sc/qa/unit/subsequent_export-test.cxx b/sc/qa/unit/subsequent_export-test.cxx index c095e9fb3847..831c98750454 100644 --- a/sc/qa/unit/subsequent_export-test.cxx +++ b/sc/qa/unit/subsequent_export-test.cxx @@ -110,6 +110,7 @@ public: void testDataBarExportODS(); void testDataBarExportXLSX(); void testConditionalFormatRangeListXLSX(); + void testConditionalFormatContainsTextXLSX(); void testConditionalFormatPriorityCheckXLSX(); void testMiscRowHeightExport(); void testNamedRangeBugfdo62729(); @@ -237,6 +238,7 @@ public: CPPUNIT_TEST(testDataBarExportODS); CPPUNIT_TEST(testDataBarExportXLSX); CPPUNIT_TEST(testConditionalFormatRangeListXLSX); + CPPUNIT_TEST(testConditionalFormatContainsTextXLSX); CPPUNIT_TEST(testConditionalFormatPriorityCheckXLSX); CPPUNIT_TEST(testMiscRowHeightExport); CPPUNIT_TEST(testNamedRangeBugfdo62729); @@ -3922,6 +3924,17 @@ void ScExportTest::testConditionalFormatRangeListXLSX() assertXPath(pDoc, "//x:conditionalFormatting", "sqref", "F4 F10"); } +void ScExportTest::testConditionalFormatContainsTextXLSX() +{ + ScDocShellRef xDocSh = loadDoc("conditionalformat_containstext.", FORMAT_ODS); + CPPUNIT_ASSERT(xDocSh.is()); + + xmlDocPtr pDoc = XPathHelper::parseExport(*xDocSh, m_xSFactory, "xl/worksheets/sheet1.xml", FORMAT_XLSX); + CPPUNIT_ASSERT(pDoc); + + assertXPathContent(pDoc, "//x:conditionalFormatting/x:cfRule/x:formula", "NOT(ISERROR(SEARCH(\"test\",A1)))"); +} + void ScExportTest::testConditionalFormatPriorityCheckXLSX() { ScDocShellRef xDocSh = loadDoc("conditional_fmt_checkpriority.", FORMAT_XLSX); _______________________________________________ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits