From 940b4d1848e8c70ab7642901a68594e8016caffc Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 27 Apr 2024 18:51:28 +0200 Subject: Adding upstream version 1:7.0.4. Signed-off-by: Daniel Baumann --- qadevOOo/tests/java/mod/_sc/ScSheetLinkObj.java | 143 ++++++++++++++++++++++++ 1 file changed, 143 insertions(+) create mode 100644 qadevOOo/tests/java/mod/_sc/ScSheetLinkObj.java (limited to 'qadevOOo/tests/java/mod/_sc/ScSheetLinkObj.java') diff --git a/qadevOOo/tests/java/mod/_sc/ScSheetLinkObj.java b/qadevOOo/tests/java/mod/_sc/ScSheetLinkObj.java new file mode 100644 index 000000000..5e30fa9e5 --- /dev/null +++ b/qadevOOo/tests/java/mod/_sc/ScSheetLinkObj.java @@ -0,0 +1,143 @@ +/* + * 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 mod._sc; + +import java.io.PrintWriter; + +import lib.TestCase; +import lib.TestEnvironment; +import lib.TestParameters; +import util.SOfficeFactory; +import util.utils; + +import com.sun.star.beans.XPropertySet; +import com.sun.star.container.XIndexAccess; +import com.sun.star.container.XNameAccess; +import com.sun.star.lang.XComponent; +import com.sun.star.sheet.XSheetLinkable; +import com.sun.star.sheet.XSpreadsheet; +import com.sun.star.sheet.XSpreadsheetDocument; +import com.sun.star.sheet.XSpreadsheets; +import com.sun.star.uno.AnyConverter; +import com.sun.star.uno.Type; +import com.sun.star.uno.UnoRuntime; +import com.sun.star.uno.XInterface; + +/** +* Test for object which is represented by service +* com.sun.star.sheet.SheetLink.

+* Object implements the following interfaces : +*

+* The following files used by this test : +*

+* @see com.sun.star.sheet.SheetLink +* @see com.sun.star.container.XNamed +* @see com.sun.star.util.XRefreshable +* @see com.sun.star.sheet.SheetLink +* @see com.sun.star.beans.XPropertySet +* @see ifc.container._XNamed +* @see ifc.util._XRefreshable +* @see ifc.sheet._SheetLink +* @see ifc.beans._XPropertySet +*/ +public class ScSheetLinkObj extends TestCase { + private XSpreadsheetDocument xSheetDoc = null; + + /** + * Creates Spreadsheet document. + */ + @Override + protected void initialize( TestParameters tParam, PrintWriter log ) throws Exception { + SOfficeFactory SOF = SOfficeFactory.getFactory( tParam.getMSF() ); + + log.println( "creating a Spreadsheet document" ); + xSheetDoc = SOF.createCalcDoc(null); + } + + /** + * Disposes Spreadsheet document. + */ + @Override + protected void cleanup( TestParameters tParam, PrintWriter log ) { + log.println( " disposing xSheetDoc " ); + XComponent oComp = UnoRuntime.queryInterface(XComponent.class, xSheetDoc); + util.DesktopTools.closeDoc(oComp); + } + + /** + * Creating a TestEnvironment for the interfaces to be tested. + * Retrieves a collection of spreadsheets from a document + * and takes one of them. Links the sheet to another sheet in another + * document using the interface XSheetLinkable. Obtains the + * value of the property 'SheetLinks' that is the collection of + * sheet links. Retrieves from the collection one of the sheet link that + * is the instance of the service com.sun.star.sheet.SheetLink. + * @see com.sun.star.sheet.SheetLink + * @see com.sun.star.sheet.XSheetLinkable + */ + @Override + protected TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) throws Exception { + + XInterface oObj = null; + + // creation of testobject here + // first we write what we are intend to do to log file + log.println( "Creating a test environment" ); + XSpreadsheet oSheet = null; + + log.println("Getting test object ") ; + XSpreadsheets oSheets = xSheetDoc.getSheets() ; + XIndexAccess oIndexSheets = UnoRuntime.queryInterface(XIndexAccess.class, oSheets); + oSheet = (XSpreadsheet) AnyConverter.toObject( + new Type(XSpreadsheet.class),oIndexSheets.getByIndex(0)); + + XSheetLinkable SL = UnoRuntime.queryInterface(XSheetLinkable.class, oSheet); + + // creating link. Doesn't matter that it refers to unexistent object. + // this is for proper work of XAccess tests. + String sURL = utils.getFullTestDocName("ScSheetLinksObj.ods"); + SL.link(sURL, "Sheet1", "", "", com.sun.star.sheet.SheetLinkMode.VALUE); + + // Getting links. + XPropertySet docProps = UnoRuntime.queryInterface(XPropertySet.class, xSheetDoc); + Object oLinks = docProps.getPropertyValue("SheetLinks"); + + XNameAccess links = UnoRuntime.queryInterface(XNameAccess.class, oLinks); + + String[] names = links.getElementNames(); + + oObj = (XInterface)AnyConverter.toObject( + new Type(XInterface.class),links.getByName(names[0])); + + log.println("Creating object - " + + ((oObj == null) ? "FAILED" : "OK")); + + TestEnvironment tEnv = new TestEnvironment( oObj ); + + return tEnv; + } + +} -- cgit v1.2.3