sc/qa/extras/sctablesheetsobj.cxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4; fill-column: 100 -*- */
   2 /*
   3  * This file is part of the LibreOffice project.
   4  *
   5  * This Source Code Form is subject to the terms of the Mozilla Public
   6  * License, v. 2.0. If a copy of the MPL was not distributed with this
   7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   8  */
   9
  10 #include <test/calc_unoapi_test.hxx>
  11 #include <test/container/xelementaccess.hxx>
  12 #include <test/container/xenumerationaccess.hxx>
  13 #include <test/container/xindexaccess.hxx>
  14 #include <test/container/xnameaccess.hxx>
  15 #include <test/container/xnamecontainer.hxx>
  16 #include <test/container/xnamereplace.hxx>
  17 #include <test/lang/xserviceinfo.hxx>
  18 #include <test/sheet/xspreadsheets.hxx>
  19 #include <test/sheet/xspreadsheets2.hxx>
  20
  21 #include <com/sun/star/lang/XComponent.hpp>
  22 #include <com/sun/star/sheet/XSpreadsheet.hpp>
  23 #include <com/sun/star/sheet/XSpreadsheetDocument.hpp>
  24 #include <com/sun/star/uno/XInterface.hpp>
  25
  26 #include <com/sun/star/uno/Any.hxx>
  27 #include <com/sun/star/uno/Reference.hxx>
  28
  29 #include <cppu/unotype.hxx>
  30
  31 using namespace css;
  32 using namespace css::uno;
  33
  34 namespace sc_apitest
  35 {
  36 class ScTableSheetsObj : public CalcUnoApiTest,
  37                          public ::apitest::XElementAccess,
  38                          public ::apitest::XEnumerationAccess,
  39                          public ::apitest::XIndexAccess,
  40                          public ::apitest::XNameAccess,
  41                          public ::apitest::XNameContainer,
  42                          public ::apitest::XNameReplace,
  43                          public ::apitest::XServiceInfo,
  44                          public ::apitest::XSpreadsheets,
  45                          public ::apitest::XSpreadsheets2
  46 {
  47 public:
  48     ScTableSheetsObj();
  49
  50     virtual void setUp() override;
  51     virtual void tearDown() override;
  52     virtual uno::Reference<uno::XInterface> init() override;
  53
  54     CPPUNIT_TEST_SUITE(ScTableSheetsObj);
  55
  56     // XElementAccess
  57     CPPUNIT_TEST(testGetElementType);
  58     CPPUNIT_TEST(testHasElements);
  59
  60     // XEnumerationAccess
  61     CPPUNIT_TEST(testCreateEnumeration);
  62
  63     // XIndexAccess
  64     CPPUNIT_TEST(testGetByIndex);
  65     CPPUNIT_TEST(testGetCount);
  66
  67     // XNameAccess
  68     CPPUNIT_TEST(testGetByName);
  69     CPPUNIT_TEST(testGetElementNames);
  70     CPPUNIT_TEST(testHasByName);
  71
  72     // XNameContainer
  73     CPPUNIT_TEST(testInsertByName);
  74     CPPUNIT_TEST(testInsertByNameEmptyName);
  75     CPPUNIT_TEST(testInsertByNameDuplicate);
  76     CPPUNIT_TEST(testRemoveByName);
  77     CPPUNIT_TEST(testRemoveByNameNoneExistingElement);
  78
  79     // XNameReplace
  80     CPPUNIT_TEST(testReplaceByName);
  81
  82     // XServiceInfo
  83     CPPUNIT_TEST(testGetImplementationName);
  84     CPPUNIT_TEST(testGetSupportedServiceNames);
  85     CPPUNIT_TEST(testSupportsService);
  86
  87     // XSpreadsheets
  88     CPPUNIT_TEST(testInsertNewByName);
  89     CPPUNIT_TEST(testInsertNewByNameBadName);
  90     CPPUNIT_TEST(testCopyByName);
  91     CPPUNIT_TEST(testMoveByName);
  92
  93     // XSpreadsheets2
  94     CPPUNIT_TEST(testImportedSheetNameAndIndex);
  95     CPPUNIT_TEST(testImportString);
  96     CPPUNIT_TEST(testImportValue);
  97     CPPUNIT_TEST(testImportFormulaBasicMath);
  98     CPPUNIT_TEST(testImportFormulaWithNamedRange);
  99     CPPUNIT_TEST(testImportOverExistingNamedRange);
 100     CPPUNIT_TEST(testImportNamedRangeDefinedInSource);
 101     CPPUNIT_TEST(testImportNamedRangeRedefinedInSource);
 102     CPPUNIT_TEST(testImportNewNamedRange);
 103     CPPUNIT_TEST(testImportCellStyle);
 104     CPPUNIT_TEST(testLastAfterInsertCopy);
 105
 106     CPPUNIT_TEST_SUITE_END();
 107
 108     virtual uno::Reference<lang::XComponent> getComponent() override;
 109     virtual void createFileURL(const OUString& rFileBase, OUString& rFileURL) override;
 110     virtual uno::Reference<lang::XComponent> loadFromDesktop(const OUString& rString) override;
 111
 112 protected:
 113     uno::Reference<lang::XComponent> mxComponent;
 114 };
 115
 116 ScTableSheetsObj::ScTableSheetsObj()
 117     : CalcUnoApiTest("/sc/qa/extras/testdocuments")
 118     , ::apitest::XElementAccess(cppu::UnoType<sheet::XSpreadsheet>::get())
 119     , ::apitest::XIndexAccess(3)
 120     , ::apitest::XNameAccess("Sheet1")
 121     , ::apitest::XNameContainer("Sheet2")
 122     , ::apitest::XNameReplace("Sheet2")
 123     , ::apitest::XServiceInfo("ScTableSheetsObj", "com.sun.star.sheet.Spreadsheets")
 124 {
 125 }
 126
 127 uno::Reference<lang::XComponent> ScTableSheetsObj::getComponent() { return mxComponent; }
 128
 129 void ScTableSheetsObj::createFileURL(const OUString& rFileBase, OUString& rFileURL)
 130 {
 131     CalcUnoApiTest::createFileURL(rFileBase, rFileURL);
 132 }
 133
 134 uno::Reference<lang::XComponent> ScTableSheetsObj::loadFromDesktop(const OUString& rString)
 135 {
 136     return CalcUnoApiTest::loadFromDesktop(rString);
 137 }
 138
 139 uno::Reference<uno::XInterface> ScTableSheetsObj::init()
 140 {
 141     xDocument.set(mxComponent, UNO_QUERY_THROW);
 142     uno::Reference<uno::XInterface> xReturn(xDocument->getSheets(), UNO_QUERY_THROW);
 143
 144     uno::Reference<lang::XMultiServiceFactory> xMSF(mxComponent, uno::UNO_QUERY_THROW);
 145     XNameContainer::setElement(
 146         uno::makeAny(xMSF->createInstance("com.sun.star.sheet.Spreadsheet")));
 147     // XNameReplace
 148     XNameReplace::setElement(uno::makeAny(xMSF->createInstance("com.sun.star.sheet.Spreadsheet")));
 149
 150     return xReturn;
 151 }
 152
 153 void ScTableSheetsObj::setUp()
 154 {
 155     CalcUnoApiTest::setUp();
 156     // create a calc document
 157     OUString aFileURL;
 158     createFileURL("rangenamessrc.ods", aFileURL);
 159     mxComponent = loadFromDesktop(aFileURL);
 160 }
 161
 162 void ScTableSheetsObj::tearDown()
 163 {
 164     closeDocument(mxComponent);
 165     CalcUnoApiTest::tearDown();
 166 }
 167
 168 CPPUNIT_TEST_SUITE_REGISTRATION(ScTableSheetsObj);
 169 } // namespace sc_apitest
 170
 171 CPPUNIT_PLUGIN_IMPLEMENT();
 172
 173 /* vim:set shiftwidth=4 softtabstop=4 expandtab cinoptions=b1,g0,N-s cinkeys+=0=break: */