sc/qa/extras/scdatapilottableobj.cxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
   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/xnamed.hxx>
  12 #include <test/sheet/xdatapilotdescriptor.hxx>
  13 #include <test/sheet/xdatapilottable.hxx>
  14 #include <test/sheet/xdatapilottable2.hxx>
  15
  16 #include <com/sun/star/lang/XComponent.hpp>
  17 #include <com/sun/star/sheet/XSpreadsheetDocument.hpp>
  18 #include <com/sun/star/sheet/XSpreadsheet.hpp>
  19 #include <com/sun/star/sheet/XDataPilotTablesSupplier.hpp>
  20 #include <com/sun/star/sheet/XDataPilotTables.hpp>
  21 #include <com/sun/star/sheet/XDataPilotTable.hpp>
  22
  23 using namespace css;
  24 using namespace css::uno;
  25
  26 namespace sc_apitest {
  27
  28 class ScDataPilotTableObj : public CalcUnoApiTest,
  29                             public apitest::XDataPilotDescriptor,
  30                             public apitest::XDataPilotTable,
  31                             public apitest::XDataPilotTable2,
  32                             public apitest::XNamed
  33 {
  34 public:
  35     ScDataPilotTableObj();
  36
  37     virtual void setUp() override;
  38     virtual void tearDown() override;
  39     virtual uno::Reference< uno::XInterface > init() override;
  40     virtual uno::Reference< uno::XInterface > initDP2() override;
  41     virtual uno::Reference< uno::XInterface > getSheets() override;
  42
  43     CPPUNIT_TEST_SUITE(ScDataPilotTableObj);
  44
  45     // XDataPilotDescriptor
  46     CPPUNIT_TEST(testSourceRange);
  47     CPPUNIT_TEST(testTag);
  48     CPPUNIT_TEST(testGetFilterDescriptor);
  49     CPPUNIT_TEST(testGetDataPilotFields);
  50     CPPUNIT_TEST(testGetColumnFields);
  51     CPPUNIT_TEST(testGetRowFields);
  52     CPPUNIT_TEST(testGetPageFields);
  53     CPPUNIT_TEST(testGetDataFields);
  54     //CPPUNIT_TEST(testGetHiddenFields);
  55
  56     // XDataPilotTable
  57     CPPUNIT_TEST(testGetOutputRange);
  58     CPPUNIT_TEST(testRefresh);
  59
  60     // XDataPilotTable2
  61     CPPUNIT_TEST(testGetDrillDownData);
  62     CPPUNIT_TEST(testInsertDrillDownSheet);
  63     CPPUNIT_TEST(testGetPositionData);
  64     CPPUNIT_TEST(testGetOutputRangeByType);
  65
  66     // XNamed
  67     CPPUNIT_TEST(testGetName);
  68     CPPUNIT_TEST(testSetName);
  69
  70     CPPUNIT_TEST_SUITE_END();
  71
  72 private:
  73     uno::Reference< lang::XComponent > mxComponent;
  74 };
  75
  76 ScDataPilotTableObj::ScDataPilotTableObj()
  77     : CalcUnoApiTest("/sc/qa/extras/testdocuments"),
  78       apitest::XNamed("DataPilotTable")
  79 {
  80 }
  81
  82 uno::Reference< uno::XInterface > ScDataPilotTableObj::init()
  83 {
  84     uno::Reference< sheet::XSpreadsheetDocument > xDoc(mxComponent, UNO_QUERY_THROW);
  85
  86     uno::Reference< container::XIndexAccess > xIndex (xDoc->getSheets(), UNO_QUERY_THROW);
  87     uno::Reference< sheet::XSpreadsheet > xSheet( xIndex->getByIndex(0), UNO_QUERY_THROW);
  88
  89     // set variables from xdatapilottable.[ch]xx
  90     xCellForChange = xSheet->getCellByPosition( 1, 5 );
  91     xCellForCheck = xSheet->getCellByPosition( 7, 11 );
  92     CPPUNIT_ASSERT(xCellForCheck.is());
  93     CPPUNIT_ASSERT(xCellForChange.is());
  94
  95     CPPUNIT_ASSERT_MESSAGE("Could not create interface of type XSpreadsheet", xSheet.is());
  96     uno::Reference< sheet::XDataPilotTablesSupplier > xDPTS(xSheet, UNO_QUERY_THROW);
  97     uno::Reference< sheet::XDataPilotTables > xDPT = xDPTS->getDataPilotTables();
  98     CPPUNIT_ASSERT(xDPT.is());
  99
 100     uno::Reference< sheet::XDataPilotTable > xDPTable(xDPT->getByName("DataPilotTable"),UNO_QUERY_THROW);
 101
 102     return xDPTable;
 103 }
 104
 105 uno::Reference< uno::XInterface > ScDataPilotTableObj::getSheets()
 106 {
 107     uno::Reference< sheet::XSpreadsheetDocument > xDoc(mxComponent, UNO_QUERY_THROW);
 108     uno::Reference< uno::XInterface > xSheets(xDoc->getSheets());
 109     return xSheets;
 110 }
 111
 112 uno::Reference< uno::XInterface > ScDataPilotTableObj::initDP2()
 113 {
 114     uno::Reference< sheet::XSpreadsheetDocument > xDoc(mxComponent, UNO_QUERY_THROW);
 115     uno::Reference< container::XIndexAccess > xIndex (xDoc->getSheets(), UNO_QUERY_THROW);
 116     uno::Reference< sheet::XSpreadsheet > xSheet( xIndex->getByIndex(0), UNO_QUERY_THROW);
 117
 118     // set variables from xdatapilottable.[ch]xx
 119     xCellForChange = xSheet->getCellByPosition( 1, 5 );
 120     xCellForCheck = xSheet->getCellByPosition( 7, 11 );
 121     CPPUNIT_ASSERT(xCellForCheck.is());
 122     CPPUNIT_ASSERT(xCellForChange.is());
 123
 124     CPPUNIT_ASSERT_MESSAGE("Could not create interface of type XSpreadsheet", xSheet.is());
 125     uno::Reference< sheet::XDataPilotTablesSupplier > xDPTS(xSheet, UNO_QUERY_THROW);
 126     uno::Reference< sheet::XDataPilotTables > xDPT = xDPTS->getDataPilotTables();
 127     CPPUNIT_ASSERT(xDPT.is());
 128
 129     uno::Reference< sheet::XDataPilotTable > xDPTable(xDPT->getByName("DataPilotTable2"),UNO_QUERY_THROW);
 130
 131     return xDPTable;
 132 }
 133
 134 void ScDataPilotTableObj::setUp()
 135 {
 136     CalcUnoApiTest::setUp();
 137     // create a calc document
 138     OUString aFileURL;
 139     createFileURL("ScDataPilotTableObj.ods", aFileURL);
 140     mxComponent = loadFromDesktop(aFileURL, "com.sun.star.sheet.SpreadsheetDocument");
 141 }
 142
 143 void ScDataPilotTableObj::tearDown()
 144 {
 145     closeDocument(mxComponent);
 146     CalcUnoApiTest::tearDown();
 147 }
 148
 149 CPPUNIT_TEST_SUITE_REGISTRATION(ScDataPilotTableObj);
 150
 151 }
 152
 153 CPPUNIT_PLUGIN_IMPLEMENT();
 154
 155 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */