sc/qa/extras/scdatabaserangeobj.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/unoapi_test.hxx>
  11 #include <test/sheet/databaserange.hxx>
  12 #include <test/sheet/xcellrangereferrer.hxx>
  13 #include <test/sheet/xdatabaserange.hxx>
  14
  15 #include <com/sun/star/beans/XPropertySet.hpp>
  16 #include <com/sun/star/container/XNameAccess.hpp>
  17 #include <com/sun/star/sheet/XCellRangeAddressable.hpp>
  18 #include <com/sun/star/sheet/XCellRangeReferrer.hpp>
  19 #include <com/sun/star/sheet/XDatabaseRange.hpp>
  20 #include <com/sun/star/sheet/XSpreadsheetDocument.hpp>
  21
  22 using namespace css;
  23 using namespace css::uno;
  24
  25 namespace sc_apitest {
  26
  27 class ScDatabaseRangeObj : public UnoApiTest,
  28                            public apitest::DatabaseRange,
  29                            public apitest::XCellRangeReferrer,
  30                            public apitest::XDatabaseRange
  31 {
  32 public:
  33     virtual void setUp() override;
  34
  35     virtual uno::Reference< uno::XInterface > init() override;
  36     virtual uno::Reference< uno::XInterface > init( const OUString& rDBName ) override;
  37
  38     ScDatabaseRangeObj();
  39
  40     CPPUNIT_TEST_SUITE(ScDatabaseRangeObj);
  41
  42     // DatabaseRange
  43     CPPUNIT_TEST(testMoveCells);
  44     CPPUNIT_TEST(testKeepFormats);
  45     CPPUNIT_TEST(testStripData);
  46     CPPUNIT_TEST(testAutoFilter);
  47     CPPUNIT_TEST(testUseFilterCriteriaSource);
  48     CPPUNIT_TEST(testFilterCriteriaSource);
  49     CPPUNIT_TEST(testRefreshPeriod);
  50     CPPUNIT_TEST(testFromSelection);
  51     CPPUNIT_TEST(testTokenIndex);
  52     CPPUNIT_TEST(testTotalsRow);
  53     CPPUNIT_TEST(testContainsHeader);
  54
  55     // XCellRangeReferrer
  56     CPPUNIT_TEST(testGetReferredCells);
  57
  58     // XDatabaseRange
  59     CPPUNIT_TEST(testDataArea);
  60     CPPUNIT_TEST(testGetSortDescriptor);
  61     CPPUNIT_TEST(testGetSubtotalDescriptor);
  62     CPPUNIT_TEST(testGetImportDescriptor);
  63     CPPUNIT_TEST(testGetFilterDescriptor);
  64     CPPUNIT_TEST(testRefresh);
  65
  66     CPPUNIT_TEST_SUITE_END();
  67 };
  68
  69 ScDatabaseRangeObj::ScDatabaseRangeObj()
  70       : UnoApiTest("/sc/qa/extras/testdocuments")
  71 {
  72 }
  73
  74 uno::Reference<uno::XInterface> ScDatabaseRangeObj::init()
  75 {
  76     return init("DataArea");
  77 }
  78
  79 uno::Reference< uno::XInterface > ScDatabaseRangeObj::init( const OUString& rDBName )
  80 {
  81     uno::Reference< sheet::XSpreadsheetDocument > xDoc(mxComponent, UNO_QUERY_THROW);
  82
  83     uno::Reference< beans::XPropertySet > xPropSet(xDoc, UNO_QUERY_THROW);
  84     uno::Reference< container::XNameAccess > xNameAccess( xPropSet->getPropertyValue("DatabaseRanges"), UNO_QUERY_THROW);
  85
  86     uno::Reference<sheet::XCellRangeReferrer> xCRR(xNameAccess->getByName(rDBName), UNO_QUERY_THROW);
  87     uno::Reference<sheet::XCellRangeAddressable> xCRA(xCRR->getReferredCells(), UNO_QUERY_THROW);
  88     setCellRange(xCRA->getRangeAddress());
  89
  90     uno::Reference< sheet::XDatabaseRange > xDBRange( xNameAccess->getByName(rDBName), UNO_QUERY_THROW);
  91     CPPUNIT_ASSERT(xDBRange.is());
  92
  93     return xDBRange;
  94 }
  95
  96 void ScDatabaseRangeObj::setUp()
  97 {
  98     UnoApiTest::setUp();
  99
 100     loadFromURL(u"ScDatabaseRangeObj.ods");
 101 }
 102
 103 CPPUNIT_TEST_SUITE_REGISTRATION(ScDatabaseRangeObj);
 104
 105 }
 106
 107 CPPUNIT_PLUGIN_IMPLEMENT();
 108
 109 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */