diff options
Diffstat (limited to 'sc')
-rw-r--r-- | sc/qa/unit/data/xlsx/totalsRowFunction.xlsx | bin | 0 -> 18719 bytes | |||
-rw-r--r-- | sc/qa/unit/subsequent_export_test2.cxx | 25 |
2 files changed, 25 insertions, 0 deletions
diff --git a/sc/qa/unit/data/xlsx/totalsRowFunction.xlsx b/sc/qa/unit/data/xlsx/totalsRowFunction.xlsx Binary files differnew file mode 100644 index 000000000000..3731caf86491 --- /dev/null +++ b/sc/qa/unit/data/xlsx/totalsRowFunction.xlsx diff --git a/sc/qa/unit/subsequent_export_test2.cxx b/sc/qa/unit/subsequent_export_test2.cxx index b3d46d1cdd58..628401167d5a 100644 --- a/sc/qa/unit/subsequent_export_test2.cxx +++ b/sc/qa/unit/subsequent_export_test2.cxx @@ -188,6 +188,7 @@ public: void testTdf91286(); void testTdf148820(); void testEmbeddedTextInDecimal(); + void testTotalsRowFunction(); CPPUNIT_TEST_SUITE(ScExportTest2); @@ -313,6 +314,7 @@ public: CPPUNIT_TEST(testTdf91286); CPPUNIT_TEST(testTdf148820); CPPUNIT_TEST(testEmbeddedTextInDecimal); + CPPUNIT_TEST(testTotalsRowFunction); CPPUNIT_TEST_SUITE_END(); }; @@ -2824,6 +2826,29 @@ void ScExportTest2::testEmbeddedTextInDecimal() lcl_TestEmbeddedTextInDecimal(*getScDoc()); } +void ScExportTest2::testTotalsRowFunction() +{ + createScDoc("xlsx/totalsRowFunction.xlsx"); + saveAndReload("Calc Office Open XML"); + { + xmlDocUniquePtr pDocXml = parseExport("xl/tables/table1.xml"); + CPPUNIT_ASSERT(pDocXml); + assertXPath(pDocXml, "/x:table/x:tableColumns/x:tableColumn[5]", "totalsRowFunction", + "sum"); + } + ScDocument* pDoc = getScDoc(); + pDoc->InsertCol(ScRange(3, 0, 0, 3, pDoc->MaxRow(), 0)); // Insert col 4 + saveAndReload("Calc Office Open XML"); + { + xmlDocUniquePtr pDocXml = parseExport("xl/tables/table1.xml"); + CPPUNIT_ASSERT(pDocXml); + assertXPathNoAttribute(pDocXml, "/x:table/x:tableColumns/x:tableColumn[5]", + "totalsRowFunction"); + assertXPath(pDocXml, "/x:table/x:tableColumns/x:tableColumn[6]", "totalsRowFunction", + "sum"); + } +} + CPPUNIT_TEST_SUITE_REGISTRATION(ScExportTest2); CPPUNIT_PLUGIN_IMPLEMENT(); |