commit 437d30fa8e7daaf12990cf9672614e630e915ba5
author Xisco Fauli <xiscofauli@libreoffice.org> Tue Mar 31 16:25:10 2020 +0200
committer Xisco Faulí <xiscofauli@libreoffice.org> Tue Mar 31 18:28:15 2020 +0200
tree 9a006a6c18f6a8f5ace1993bcd1267d41bc27fd3
parent 6b568ab1cf9a47440a00b4e05ca82bd98e159555

tdf#131372: Add unittest

Change-Id: I7dbed0c28206ffd6a95ecedec74fdac044fe79cc
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/91432
Tested-by: Jenkins
Reviewed-by: Xisco Faulí <xiscofauli@libreoffice.org>

sc/qa/unit/data/ods/tdf131372.ods

diff --git a/sc/qa/unit/data/ods/tdf131372.ods b/sc/qa/unit/data/ods/tdf131372.ods
new file mode 100644
index 0000000..31d144f
--- /dev/null
+++ b/sc/qa/unit/data/ods/tdf131372.ods
Binary files differ

sc/qa/unit/subsequent_export-test.cxx

diff --git a/sc/qa/unit/subsequent_export-test.cxx b/sc/qa/unit/subsequent_export-test.cxx
index 5a1bba0..7ab066d 100644
--- a/sc/qa/unit/subsequent_export-test.cxx
+++ b/sc/qa/unit/subsequent_export-test.cxx
@@ -233,6 +233,7 @@ public:
    void testRotatedImageODS();
    void testTdf128976();
    void testTdf120502();
    void testTdf131372();
    void testTdf83779();

    CPPUNIT_TEST_SUITE(ScExportTest);
@@ -367,6 +368,7 @@ public:
    CPPUNIT_TEST(testRotatedImageODS);
    CPPUNIT_TEST(testTdf128976);
    CPPUNIT_TEST(testTdf120502);
    CPPUNIT_TEST(testTdf131372);
    CPPUNIT_TEST(testTdf83779);

    CPPUNIT_TEST_SUITE_END();
@@ -4723,6 +4725,22 @@ void ScExportTest::testTdf120502()
    assertXPath(pSheet1, "/x:worksheet/x:cols/x:col", "max", OUString::number(nMaxCol + 1));
}

void ScExportTest::testTdf131372()
{
    ScDocShellRef xShell = loadDoc("tdf131372.", FORMAT_ODS);
    CPPUNIT_ASSERT(xShell);

    auto pXPathFile = ScBootstrapFixture::exportTo(&(*xShell), FORMAT_XLSX);

    xmlDocPtr pSheet = XPathHelper::parseExport(pXPathFile, m_xSFactory, "xl/worksheets/sheet1.xml");
    CPPUNIT_ASSERT(pSheet);

    assertXPathContent(pSheet, "/x:worksheet/x:sheetData/x:row/x:c[1]/x:f", "NA()");
    assertXPathContent(pSheet, "/x:worksheet/x:sheetData/x:row/x:c[2]/x:f", "#N/A");

    xShell->DoClose();
}

void ScExportTest::testTdf83779()
{
    // Roundtripping TRUE/FALSE constants (not functions) must convert them to functions