diff options
-rw-r--r-- | include/test/sheet/xsheetlinkable.hxx | 40 | ||||
-rw-r--r-- | qadevOOo/Jar_OOoRunner.mk | 1 | ||||
-rw-r--r-- | qadevOOo/objdsc/sc/com.sun.star.comp.office.ScTableSheetObj.csv | 7 | ||||
-rw-r--r-- | qadevOOo/tests/java/ifc/sheet/_XSheetLinkable.java | 104 | ||||
-rw-r--r-- | sc/qa/extras/sctablesheetobj.cxx | 47 | ||||
-rw-r--r-- | test/Library_subsequenttest.mk | 1 | ||||
-rw-r--r-- | test/source/sheet/xsheetlinkable.cxx | 50 |
7 files changed, 121 insertions, 129 deletions
diff --git a/include/test/sheet/xsheetlinkable.hxx b/include/test/sheet/xsheetlinkable.hxx new file mode 100644 index 000000000000..2abd87335799 --- /dev/null +++ b/include/test/sheet/xsheetlinkable.hxx @@ -0,0 +1,40 @@ +/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ +/* + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + */ + +#ifndef INCLUDED_TEST_SHEET_XSHEETLINKABLE_HXX +#define INCLUDED_TEST_SHEET_XSHEETLINKABLE_HXX + + +#include <com/sun/star/uno/XInterface.hpp> +#include <com/sun/star/uno/Reference.hxx> + +#include <test/testdllapi.hxx> + +namespace apitest { + +class OOO_DLLPUBLIC_TEST XSheetLinkable +{ +public: + virtual css::uno::Reference< css::uno::XInterface > init() =0; + virtual OUString getFileURL() =0; + + void testSheetLinkable(); + +protected: + ~XSheetLinkable() {} + +private: + OUString maFileName; +}; + +} + +#endif // INCLUDED_TEST_SHEET_XSHEETLINKABLE_HXX + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/qadevOOo/Jar_OOoRunner.mk b/qadevOOo/Jar_OOoRunner.mk index a6ebf3502b72..42108bb54891 100644 --- a/qadevOOo/Jar_OOoRunner.mk +++ b/qadevOOo/Jar_OOoRunner.mk @@ -627,7 +627,6 @@ $(eval $(call gb_Jar_add_sourcefiles,OOoRunner,\ qadevOOo/tests/java/ifc/sheet/_XSheetFilterable \ qadevOOo/tests/java/ifc/sheet/_XSheetFilterableEx \ qadevOOo/tests/java/ifc/sheet/_XSheetFilterDescriptor \ - qadevOOo/tests/java/ifc/sheet/_XSheetLinkable \ qadevOOo/tests/java/ifc/sheet/_XSpreadsheetView \ qadevOOo/tests/java/ifc/style/_CharacterProperties \ qadevOOo/tests/java/ifc/style/_CharacterPropertiesAsian \ diff --git a/qadevOOo/objdsc/sc/com.sun.star.comp.office.ScTableSheetObj.csv b/qadevOOo/objdsc/sc/com.sun.star.comp.office.ScTableSheetObj.csv index 16ddec448d96..89344e1ff08a 100644 --- a/qadevOOo/objdsc/sc/com.sun.star.comp.office.ScTableSheetObj.csv +++ b/qadevOOo/objdsc/sc/com.sun.star.comp.office.ScTableSheetObj.csv @@ -172,13 +172,6 @@ "ScTableSheetObj";"com::sun::star::beans::XTolerantMultiPropertySet#optional";"setPropertyValuesTolerant()" "ScTableSheetObj";"com::sun::star::beans::XTolerantMultiPropertySet#optional";"getPropertyValuesTolerant()" "ScTableSheetObj";"com::sun::star::beans::XTolerantMultiPropertySet#optional";"getDirectPropertyValuesTolerant()" -"ScTableSheetObj";"com::sun::star::sheet::XSheetLinkable";"getLinkMode()" -"ScTableSheetObj";"com::sun::star::sheet::XSheetLinkable";"setLinkMode()" -"ScTableSheetObj";"com::sun::star::sheet::XSheetLinkable";"getLinkUrl()" -"ScTableSheetObj";"com::sun::star::sheet::XSheetLinkable";"setLinkUrl()" -"ScTableSheetObj";"com::sun::star::sheet::XSheetLinkable";"getLinkSheetName()" -"ScTableSheetObj";"com::sun::star::sheet::XSheetLinkable";"setLinkSheetName()" -"ScTableSheetObj";"com::sun::star::sheet::XSheetLinkable";"link()" "ScTableSheetObj";"com::sun::star::container::XNamed";"getName()" "ScTableSheetObj";"com::sun::star::container::XNamed";"setName()" "ScTableSheetObj";"com::sun::star::sheet::XCellRangeMovement";"insertCells()" diff --git a/qadevOOo/tests/java/ifc/sheet/_XSheetLinkable.java b/qadevOOo/tests/java/ifc/sheet/_XSheetLinkable.java deleted file mode 100644 index 8494525b40d5..000000000000 --- a/qadevOOo/tests/java/ifc/sheet/_XSheetLinkable.java +++ /dev/null @@ -1,104 +0,0 @@ -/* - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * This file incorporates work covered by the following license notice: - * - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed - * with this work for additional information regarding copyright - * ownership. The ASF licenses this file to you under the Apache - * License, Version 2.0 (the "License"); you may not use this file - * except in compliance with the License. You may obtain a copy of - * the License at http://www.apache.org/licenses/LICENSE-2.0 . - */ -package ifc.sheet; - -import com.sun.star.sheet.SheetLinkMode; -import com.sun.star.sheet.XSheetLinkable; -import lib.MultiMethodTest; -import util.utils; - -/** - * - */ -public class _XSheetLinkable extends MultiMethodTest { - public XSheetLinkable oObj = null; - SheetLinkMode slm = null; - String linkSheetName = null; - String linkUrl = null; - String linkUrl2 = null; - - @Override - public void before() { - // get a document for linking. - linkUrl = (String)tEnv.getObjRelation("XSheetLinkable.LinkSheet"); - linkUrl = utils.getFullTestURL(linkUrl); - - // get a second sheet for changing the link url: if it's not set, - // this part of the test is omitted. - linkUrl2 = (String)tEnv.getObjRelation("XSheetLinkable.LinkSheet2"); - if (linkUrl2 != null) - linkUrl = utils.getFullTestURL(linkUrl); - - // set a name for the sheet. - linkSheetName = "Sheet1"; - } - - public void _getLinkMode() { - requiredMethod("link()"); - slm = oObj.getLinkMode(); - tRes.tested("getLinkMode()", slm == SheetLinkMode.VALUE); - } - - public void _getLinkSheetName() { - requiredMethod("link()"); - String lSheetName = oObj.getLinkSheetName(); - tRes.tested("getLinkSheetName()", linkSheetName.equals(lSheetName)); - } - - public void _getLinkUrl() { - requiredMethod("link()"); - String lUrl = oObj.getLinkUrl(); - System.out.println("URL: " + lUrl); - tRes.tested("getLinkUrl()", lUrl.equals(linkUrl)); - } - - public void _link() { - oObj.link(linkUrl, linkSheetName, "", "", SheetLinkMode.VALUE); - tRes.tested("link()", true); - } - - public void _setLinkMode() { - requiredMethod("getLinkMode()"); - oObj.setLinkMode(SheetLinkMode.NONE); - slm = oObj.getLinkMode(); - tRes.tested("setLinkMode()", slm == SheetLinkMode.NONE); - } - - public void _setLinkSheetName() { - requiredMethod("getLinkSheetName()"); - oObj.setLinkSheetName("Sheet2"); - linkSheetName = oObj.getLinkSheetName(); - tRes.tested("setLinkSheetName()", linkSheetName.equals("Sheet2")); - } - - public void _setLinkUrl() { - requiredMethod("getLinkUrl()"); - boolean result = false; - if (linkUrl2 == null) { - // set back to the original value - oObj.setLinkUrl(linkUrl); - result = true; - } - else { - oObj.setLinkUrl(linkUrl2); - linkUrl = oObj.getLinkUrl(); - result = linkUrl.equals(linkUrl2); - } - tRes.tested("setLinkUrl()", result); - } -} diff --git a/sc/qa/extras/sctablesheetobj.cxx b/sc/qa/extras/sctablesheetobj.cxx index a3b246055965..277cd54cbddf 100644 --- a/sc/qa/extras/sctablesheetobj.cxx +++ b/sc/qa/extras/sctablesheetobj.cxx @@ -10,6 +10,7 @@ #include <test/calc_unoapi_test.hxx> #include <test/sheet/xcellseries.hxx> #include <test/sheet/xprintareas.hxx> +#include <test/sheet/xsheetlinkable.hxx> #include <test/sheet/xsheetoperation.hxx> #include <test/sheet/xsheetpagebreak.hxx> #include <test/sheet/xspreadsheet.hxx> @@ -27,12 +28,13 @@ using namespace css::uno; namespace sc_apitest { -#define NUMBER_OF_TESTS 19 +#define NUMBER_OF_TESTS 20 class ScTableSheetObj : public CalcUnoApiTest, public apitest::XCellSeries, public apitest::XPrintAreas, public apitest::XReplaceable, public apitest::XSearchable, + public apitest::XSheetLinkable, public apitest::XSheetOperation, public apitest::XSheetPageBreak, public apitest::XSpreadsheet, @@ -45,27 +47,32 @@ public: virtual void setUp() override; virtual void tearDown() override; + virtual OUString getFileURL() override; + virtual uno::Reference< uno::XInterface > init() override; virtual uno::Reference< uno::XInterface > getXSpreadsheet() override; CPPUNIT_TEST_SUITE(ScTableSheetObj); - // XSearchable - CPPUNIT_TEST(testFindAll); - CPPUNIT_TEST(testFindNext); - CPPUNIT_TEST(testFindFirst); + // XCellSeries + CPPUNIT_TEST(testFillAuto); + CPPUNIT_TEST(testFillSeries); + + // XPrintAreas + CPPUNIT_TEST(testSetAndGetPrintTitleColumns); + CPPUNIT_TEST(testSetAndGetPrintTitleRows); // XReplaceable CPPUNIT_TEST(testReplaceAll); CPPUNIT_TEST(testCreateReplaceDescriptor); - // XPrintAreas - CPPUNIT_TEST(testSetAndGetPrintTitleColumns); - CPPUNIT_TEST(testSetAndGetPrintTitleRows); + // XSearchable + CPPUNIT_TEST(testFindAll); + CPPUNIT_TEST(testFindNext); + CPPUNIT_TEST(testFindFirst); - // XCellSeries - CPPUNIT_TEST(testFillAuto); - CPPUNIT_TEST(testFillSeries); + // XSheetLinkable + CPPUNIT_TEST(testSheetLinkable); // XSheetOperation CPPUNIT_TEST(testComputeFunction); @@ -76,9 +83,6 @@ public: CPPUNIT_TEST(testGetRowPageBreaks); CPPUNIT_TEST(testRemoveAllManualPageBreaks); - // XUniqueCellFormatRangesSupplier - CPPUNIT_TEST(testGetUniqueCellFormatRanges); - // XSpreadsheet CPPUNIT_TEST(testCreateCursor); CPPUNIT_TEST(testCreateCursorByRange); @@ -87,9 +91,13 @@ public: CPPUNIT_TEST(testCreateSubTotalDescriptor); CPPUNIT_TEST(testApplyRemoveSubTotals); + // XUniqueCellFormatRangesSupplier + CPPUNIT_TEST(testGetUniqueCellFormatRanges); + CPPUNIT_TEST_SUITE_END(); private: + OUString maFileURL; static sal_Int32 nTest; static uno::Reference< lang::XComponent > mxComponent; }; @@ -107,10 +115,10 @@ ScTableSheetObj::ScTableSheetObj(): uno::Reference< uno::XInterface > ScTableSheetObj::init() { - OUString aFileURL; - createFileURL("ScTableSheetObj.ods", aFileURL); + //OUString aFileURL; + createFileURL("ScTableSheetObj.ods", maFileURL); if(!mxComponent.is()) - mxComponent = loadFromDesktop(aFileURL, "com.sun.star.sheet.SpreadsheetDocument"); + mxComponent = loadFromDesktop(maFileURL, "com.sun.star.sheet.SpreadsheetDocument"); CPPUNIT_ASSERT(mxComponent.is()); uno::Reference< sheet::XSpreadsheetDocument > xDoc(mxComponent, UNO_QUERY_THROW); @@ -135,6 +143,11 @@ uno::Reference< uno::XInterface > ScTableSheetObj::getXSpreadsheet() return xSheet; } +OUString ScTableSheetObj::getFileURL() +{ + return maFileURL; +} + void ScTableSheetObj::setUp() { nTest++; diff --git a/test/Library_subsequenttest.mk b/test/Library_subsequenttest.mk index 98f4ce9d566d..79463d688958 100644 --- a/test/Library_subsequenttest.mk +++ b/test/Library_subsequenttest.mk @@ -71,6 +71,7 @@ $(eval $(call gb_Library_add_exception_objects,subsequenttest,\ test/source/sheet/xsheetannotations \ test/source/sheet/xsheetannotationshapesupplier \ test/source/sheet/xsheetoutline \ + test/source/sheet/xsheetlinkable \ test/source/sheet/xsheetoperation \ test/source/sheet/xsheetpagebreak \ test/source/sheet/xstyleloader \ diff --git a/test/source/sheet/xsheetlinkable.cxx b/test/source/sheet/xsheetlinkable.cxx new file mode 100644 index 000000000000..6608d439514a --- /dev/null +++ b/test/source/sheet/xsheetlinkable.cxx @@ -0,0 +1,50 @@ +/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ +/* + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + */ + +#include <test/sheet/xsheetlinkable.hxx> + +#include <com/sun/star/sheet/SheetLinkMode.hpp> +#include <com/sun/star/sheet/XSheetLinkable.hpp> +#include <com/sun/star/uno/Reference.hxx> + +#include <cppunit/extensions/HelperMacros.h> + +using namespace css; +using namespace css::uno; + +namespace apitest { + +void XSheetLinkable::testSheetLinkable() +{ + uno::Reference< sheet::XSheetLinkable > xSheetLinkable(init(), UNO_QUERY_THROW); + + xSheetLinkable->link(getFileURL(), "Sheet1", "", "", sheet::SheetLinkMode_VALUE); + CPPUNIT_ASSERT_EQUAL_MESSAGE("Unable to get link mode", + sheet::SheetLinkMode_VALUE, xSheetLinkable->getLinkMode()); + CPPUNIT_ASSERT_EQUAL_MESSAGE("Unable to get link URL", + getFileURL(), xSheetLinkable->getLinkUrl()); + CPPUNIT_ASSERT_EQUAL_MESSAGE("Unable to get sheet name", + OUString("Sheet1"), xSheetLinkable->getLinkSheetName()); + + xSheetLinkable->setLinkMode(sheet::SheetLinkMode_NONE); + CPPUNIT_ASSERT_EQUAL_MESSAGE("Unable to set link mode", + sheet::SheetLinkMode_NONE, xSheetLinkable->getLinkMode()); + + xSheetLinkable->setLinkSheetName("Sheet2"); + CPPUNIT_ASSERT_EQUAL_MESSAGE("Unable to set sheet name", + OUString("Sheet2"), xSheetLinkable->getLinkSheetName()); + + xSheetLinkable->setLinkUrl(getFileURL()); + CPPUNIT_ASSERT_EQUAL_MESSAGE("Unable to set link URL", + getFileURL(), xSheetLinkable->getLinkUrl()); +} + +} + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |