/************************************************************** * * 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 * * Unless required by applicable law or agreed to in writing, * software distributed under the License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY * KIND, either express or implied. See the License for the * specific language governing permissions and limitations * under the License. * *************************************************************/ package mod._sc; import java.io.PrintWriter; import lib.StatusException; import lib.TestCase; import lib.TestEnvironment; import lib.TestParameters; import util.SOfficeFactory; import com.sun.star.container.XEnumerationAccess; import com.sun.star.container.XIndexAccess; import com.sun.star.container.XNameContainer; 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.uno.AnyConverter; import com.sun.star.uno.Type; import com.sun.star.uno.UnoRuntime; import com.sun.star.uno.XInterface; public class ScIndexEnumeration_SheetCellRangesEnumeration extends TestCase { static XSpreadsheetDocument xSheetDoc = null; /** * Creates Spreadsheet document. */ protected void initialize( TestParameters tParam, PrintWriter log ) { // get a soffice factory object SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory)tParam.getMSF()); try { log.println( "creating a sheetdocument" ); xSheetDoc = SOF.createCalcDoc(null); } catch (com.sun.star.uno.Exception e) { // Some exception occures.FAILED e.printStackTrace( log ); throw new StatusException( "Couldn't create document", e ); } } /** * Disposes Spreadsheet document. */ protected void cleanup( TestParameters tParam, PrintWriter log ) { log.println( " disposing xSheetDoc " ); XComponent oComp = (XComponent) UnoRuntime.queryInterface (XComponent.class, xSheetDoc); util.DesktopTools.closeDoc(oComp); } protected synchronized TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) { XInterface oObj = null; Object oRange = null ; // creation of testobject here // first we write what we are intend to do to log file log.println( "Creating a test environment" ); // get a soffice factory object SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory)Param.getMSF() ); log.println("Getting test object "); XComponent oComp = (XComponent) UnoRuntime.queryInterface (XComponent.class, xSheetDoc); oObj = (XInterface) SOF.createInstance(oComp, "com.sun.star.sheet.SheetCellRanges"); XSpreadsheets oSheets = xSheetDoc.getSheets() ; XIndexAccess oIndSheets = (XIndexAccess) UnoRuntime.queryInterface (XIndexAccess.class, oSheets); XSpreadsheet oSheet = null; try { oSheet = (XSpreadsheet) AnyConverter.toObject( new Type(XSpreadsheet.class),oIndSheets.getByIndex(0)); XNameContainer oRanges = (XNameContainer) UnoRuntime.queryInterface(XNameContainer.class, oObj); oRange = oSheet.getCellRangeByName("C1:D4"); oRanges.insertByName("Range1", oRange); oRange = oSheet.getCellRangeByName("E2:F5"); oRanges.insertByName("Range2", oRange); oRange = oSheet.getCellRangeByName("G2:H3"); oRanges.insertByName("Range3", oRange); oRange = oSheet.getCellRangeByName("I7:J8"); oRanges.insertByName("Range4", oRange); } catch(com.sun.star.lang.WrappedTargetException e) { e.printStackTrace(log); throw new StatusException("Couldn't create test object", e); } catch(com.sun.star.lang.IndexOutOfBoundsException e) { e.printStackTrace(log); throw new StatusException("Couldn't create test object", e); } catch(com.sun.star.container.ElementExistException e) { e.printStackTrace(log); throw new StatusException("Couldn't create test object", e); } catch(com.sun.star.lang.IllegalArgumentException e) { e.printStackTrace(log); throw new StatusException("Couldn't create test object", e); } log.println("filling some cells"); try { for (int i = 0; i < 10; i++) { for (int j = 0; j < 5; j++) { oSheet.getCellByPosition(i, j).setFormula("a"); } } for (int i = 0; i < 10; i++) { for (int j = 5; j < 10; j++) { oSheet.getCellByPosition(i, j).setValue(i + j); } } } catch (com.sun.star.lang.IndexOutOfBoundsException e) { e.printStackTrace(log); throw new StatusException ( "Exception occurred while filling cells", e); } XEnumerationAccess ea = (XEnumerationAccess) UnoRuntime.queryInterface(XEnumerationAccess.class,oObj); oObj = ea.createEnumeration(); log.println("ImplementationName: "+util.utils.getImplName(oObj)); // creating test environment TestEnvironment tEnv = new TestEnvironment( oObj ); tEnv.addObjRelation("ENUM",ea); return tEnv ; } }