diff options
| author | Markus Mohrhard <markus.mohrhard@googlemail.com> | 2018-07-14 15:29:41 +0200 |
|---|---|---|
| committer | Markus Mohrhard <markus.mohrhard@googlemail.com> | 2018-07-15 00:36:25 +0200 |
| commit | 7e8dbbb02f25278d5afc51ae4a397831f5b21239 (patch) | |
| tree | 39fbdef8f3bcded67a24fcea3567eaf803081782 /sc/qa | |
| parent | e77596be879c25f5766b73a2f67cf0ddf7775ccc (diff) | |
add test for tdf#117816
Change-Id: I470b4137a3b4e23acf0f4e949a7a834fed8069db
Reviewed-on: https://gerrit.libreoffice.org/57433
Tested-by: Jenkins
Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
Diffstat (limited to 'sc/qa')
| -rw-r--r-- | sc/qa/unit/data/ods/conditionalformat_containstext.ods | bin | 0 -> 7739 bytes | |||
| -rw-r--r-- | sc/qa/unit/subsequent_export-test.cxx | 13 |
2 files changed, 13 insertions, 0 deletions
diff --git a/sc/qa/unit/data/ods/conditionalformat_containstext.ods b/sc/qa/unit/data/ods/conditionalformat_containstext.ods Binary files differnew file mode 100644 index 000000000000..fa3e21e29f5a --- /dev/null +++ b/sc/qa/unit/data/ods/conditionalformat_containstext.ods diff --git a/sc/qa/unit/subsequent_export-test.cxx b/sc/qa/unit/subsequent_export-test.cxx index 09364c8de62e..f6e151390a5e 100644 --- a/sc/qa/unit/subsequent_export-test.cxx +++ b/sc/qa/unit/subsequent_export-test.cxx @@ -107,6 +107,7 @@ public: void testDataBarExportODS(); void testDataBarExportXLSX(); void testConditionalFormatRangeListXLSX(); + void testConditionalFormatContainsTextXLSX(); void testMiscRowHeightExport(); void testNamedRangeBugfdo62729(); void testBuiltinRangesXLSX(); @@ -226,6 +227,7 @@ public: CPPUNIT_TEST(testDataBarExportODS); CPPUNIT_TEST(testDataBarExportXLSX); CPPUNIT_TEST(testConditionalFormatRangeListXLSX); + CPPUNIT_TEST(testConditionalFormatContainsTextXLSX); CPPUNIT_TEST(testMiscRowHeightExport); CPPUNIT_TEST(testNamedRangeBugfdo62729); CPPUNIT_TEST(testBuiltinRangesXLSX); @@ -3876,6 +3878,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::parseExport2(*this, *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::testEscapeCharInNumberFormatXLSX() { ScDocShellRef xDocSh = loadDoc("tdf81939.", FORMAT_XLSX); |