/************************************************************************* * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite * * This file is part of OpenOffice.org. * * OpenOffice.org is free software: you can redistribute it and/or modify * it under the terms of the GNU Lesser General Public License version 3 * only, as published by the Free Software Foundation. * * OpenOffice.org is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Lesser General Public License version 3 for more details * (a copy is included in the LICENSE file that accompanied this code). * * You should have received a copy of the GNU Lesser General Public License * version 3 along with OpenOffice.org. If not, see * * for a copy of the LGPLv3 License. * ************************************************************************/ package mod._sc; import com.sun.star.container.XIndexAccess; import com.sun.star.frame.XController; import com.sun.star.frame.XModel; import com.sun.star.lang.XComponent; import com.sun.star.lang.XMultiServiceFactory; import com.sun.star.sheet.XSpreadsheet; import com.sun.star.sheet.XSpreadsheetDocument; import com.sun.star.sheet.XSpreadsheets; import com.sun.star.table.XCell; import com.sun.star.uno.AnyConverter; import com.sun.star.uno.Type; import com.sun.star.uno.UnoRuntime; import com.sun.star.uno.XInterface; import com.sun.star.view.XSelectionSupplier; import ifc.view._XPrintJobBroadcaster; import java.io.File; import java.io.PrintWriter; import lib.StatusException; import lib.TestCase; import lib.TestEnvironment; import lib.TestParameters; import util.SOfficeFactory; import util.utils; /** * Test for object which is represented by service * com.sun.star.sheet.SpreadsheetDocument.

* Object implements the following interfaces : *

* @see com.sun.star.sheet.SpreadsheetDocument * @see com.sun.star.sheet.XSpreadsheetDocument * @see com.sun.star.sheet.SpreadsheetDocumentSettings * @see com.sun.star.lang.XComponent * @see com.sun.star.frame.XModel * @see com.sun.star.sheet.SpreadsheetDocument * @see com.sun.star.util.XNumberFormatsSupplier * @see com.sun.star.beans.XPropertySet * @see ifc.sheet._XSpreadsheetDocument * @see ifc.sheet._SpreadsheetDocumentSettings * @see ifc.lang._XComponent * @see ifc.frame._XModel * @see ifc.sheet._SpreadsheetDocument * @see ifc.util._XNumberFormatsSupplier * @see ifc.beans._XPropertySet */ public class ScModelObj extends TestCase { public static XSpreadsheetDocument xSpreadsheetDoc; public static XSpreadsheetDocument xSecondsheetDoc; /** * Disposes Spreadsheet documents. */ protected void cleanup(TestParameters tParam, PrintWriter log) { log.println(" disposing xSheetDoc "); XComponent oComp = (XComponent) UnoRuntime.queryInterface( XComponent.class, xSpreadsheetDoc); util.DesktopTools.closeDoc(oComp); oComp = (XComponent) UnoRuntime.queryInterface(XComponent.class, xSecondsheetDoc); util.DesktopTools.closeDoc(oComp); } /** * Creating a Testenvironment for the interfaces to be tested. * Disposes the spreadsheet documents if they was created already. * Creates two spreadsheet documents. Rertieves the current controller for * each of them. Obtains the collection of spreadsheets, takes one of them * and takes some cell from the spreadsheet. The created documents are the instances * of the service com.sun.star.sheet.SpreadsheetDocument. * Object relations created : * * @see */ protected synchronized TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) { // creation of the testobject here // first we write what we are intend to do to log file log.println("craeting a test environment"); // get a soffice factory object SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory) Param.getMSF()); if (xSpreadsheetDoc != null) { XComponent oComp = (XComponent) UnoRuntime.queryInterface( XComponent.class, xSpreadsheetDoc); util.DesktopTools.closeDoc(oComp); } if (xSecondsheetDoc != null) { XComponent oComp = (XComponent) UnoRuntime.queryInterface( XComponent.class, xSecondsheetDoc); util.DesktopTools.closeDoc(oComp); } try { log.println("creating two spreadsheet documents"); xSpreadsheetDoc = SOF.createCalcDoc(null); xSecondsheetDoc = SOF.createCalcDoc(null); } catch (com.sun.star.uno.Exception e) { e.printStackTrace(log); throw new StatusException("Couldn't create document ", e); } XModel model1 = (XModel) UnoRuntime.queryInterface(XModel.class, xSpreadsheetDoc); XModel model2 = (XModel) UnoRuntime.queryInterface(XModel.class, xSecondsheetDoc); XInterface oObj = model1; TestEnvironment tEnv = new TestEnvironment(oObj); XController cont1 = model1.getCurrentController(); XController cont2 = model2.getCurrentController(); cont1.getFrame().setName("cont1"); cont2.getFrame().setName("cont2"); XSelectionSupplier sel = (XSelectionSupplier) UnoRuntime.queryInterface( XSelectionSupplier.class, cont1); XCell toSel = null; XCell[] xCalculatableCells = null; try { log.println("Getting spreadsheet"); XSpreadsheets oSheets = xSpreadsheetDoc.getSheets(); XIndexAccess oIndexSheets = (XIndexAccess) UnoRuntime.queryInterface( XIndexAccess.class, oSheets); XSpreadsheet oSheet = (XSpreadsheet) AnyConverter.toObject( new Type(XSpreadsheet.class), oIndexSheets.getByIndex(0)); log.println("Getting a cell from sheet"); toSel = oSheet.getCellByPosition(2, 3); // create a simple formula for XCalculatable oSheet.getCellByPosition(4, 5).setValue(15); oSheet.getCellByPosition(5, 5).setValue(10); oSheet.getCellByPosition(6, 5).setFormula("= E6 * F6"); xCalculatableCells = new XCell[]{ oSheet.getCellByPosition(4, 5), oSheet.getCellByPosition(5, 5), oSheet.getCellByPosition(6, 5) }; // Make sure there are at least two sheets: oSheets.insertNewByName("Some Sheet", (short) 1); } catch (com.sun.star.lang.WrappedTargetException e) { e.printStackTrace(log); throw new StatusException( "Error getting cell object from spreadsheet document", e); } catch (com.sun.star.lang.IndexOutOfBoundsException e) { e.printStackTrace(log); throw new StatusException( "Error getting cell object from spreadsheet document", e); } catch (com.sun.star.lang.IllegalArgumentException e) { e.printStackTrace(log); throw new StatusException( "Error getting cell object from spreadsheet document", e); } log.println("Adding SelectionSupplier and Shape to select for XModel"); tEnv.addObjRelation("SELSUPP", sel); tEnv.addObjRelation("TOSELECT", toSel); log.println("Adding cells for XCalculatable"); tEnv.addObjRelation("XCalculatable.Cells", xCalculatableCells); log.println("adding Controller as ObjRelation for XModel"); tEnv.addObjRelation("CONT2", cont2); // create object relation for XPrintJobBroadcaster String fileName = utils.getOfficeTempDirSys((XMultiServiceFactory) Param.getMSF())+"printfile.prt" ; File f = new File(fileName); if (f.exists()) { f.delete(); } _XPrintJobBroadcaster.MyPrintJobListener listener = new _XPrintJobBroadcaster.MyPrintJobListener(oObj, fileName); tEnv.addObjRelation("XPrintJobBroadcaster.XPrintJobListener", listener); return tEnv; } } // finish class ScModelObj