1ef39d40dSAndrew Rist /************************************************************** 2cdf0e10cSrcweir * 3ef39d40dSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4ef39d40dSAndrew Rist * or more contributor license agreements. See the NOTICE file 5ef39d40dSAndrew Rist * distributed with this work for additional information 6ef39d40dSAndrew Rist * regarding copyright ownership. The ASF licenses this file 7ef39d40dSAndrew Rist * to you under the Apache License, Version 2.0 (the 8ef39d40dSAndrew Rist * "License"); you may not use this file except in compliance 9ef39d40dSAndrew Rist * with the License. You may obtain a copy of the License at 10ef39d40dSAndrew Rist * 11ef39d40dSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12ef39d40dSAndrew Rist * 13ef39d40dSAndrew Rist * Unless required by applicable law or agreed to in writing, 14ef39d40dSAndrew Rist * software distributed under the License is distributed on an 15ef39d40dSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16ef39d40dSAndrew Rist * KIND, either express or implied. See the License for the 17ef39d40dSAndrew Rist * specific language governing permissions and limitations 18ef39d40dSAndrew Rist * under the License. 19ef39d40dSAndrew Rist * 20ef39d40dSAndrew Rist *************************************************************/ 21ef39d40dSAndrew Rist 22ef39d40dSAndrew Rist 23cdf0e10cSrcweir package mod._sc; 24cdf0e10cSrcweir 25cdf0e10cSrcweir import com.sun.star.beans.XPropertySet; 26cdf0e10cSrcweir import com.sun.star.container.XEnumerationAccess; 27cdf0e10cSrcweir import com.sun.star.container.XIndexAccess; 28cdf0e10cSrcweir import com.sun.star.lang.XMultiServiceFactory; 29cdf0e10cSrcweir import com.sun.star.sheet.XSpreadsheet; 30cdf0e10cSrcweir import com.sun.star.sheet.XSpreadsheetDocument; 31cdf0e10cSrcweir import com.sun.star.sheet.XUniqueCellFormatRangesSupplier; 32cdf0e10cSrcweir import com.sun.star.table.XCellRange; 33cdf0e10cSrcweir import com.sun.star.uno.UnoRuntime; 34cdf0e10cSrcweir import com.sun.star.uno.XInterface; 35cdf0e10cSrcweir 36cdf0e10cSrcweir import java.awt.Color; 37cdf0e10cSrcweir 38cdf0e10cSrcweir import java.io.PrintWriter; 39cdf0e10cSrcweir 40cdf0e10cSrcweir import lib.StatusException; 41cdf0e10cSrcweir import lib.TestCase; 42cdf0e10cSrcweir import lib.TestEnvironment; 43cdf0e10cSrcweir import lib.TestParameters; 44cdf0e10cSrcweir 45cdf0e10cSrcweir import util.SOfficeFactory; 46cdf0e10cSrcweir 47cdf0e10cSrcweir 48cdf0e10cSrcweir public class ScUniqueCellFormatsEnumeration extends TestCase { 49cdf0e10cSrcweir static XSpreadsheetDocument xSheetDoc = null; 50cdf0e10cSrcweir static XSpreadsheet oSheet = null; 51cdf0e10cSrcweir 52cdf0e10cSrcweir /** 53cdf0e10cSrcweir * Creates Spreadsheet document. 54cdf0e10cSrcweir */ initialize(TestParameters tParam, PrintWriter log)55cdf0e10cSrcweir protected void initialize(TestParameters tParam, PrintWriter log) { 56cdf0e10cSrcweir // get a soffice factory object 57cdf0e10cSrcweir SOfficeFactory SOF = SOfficeFactory.getFactory( 58cdf0e10cSrcweir (XMultiServiceFactory) tParam.getMSF()); 59cdf0e10cSrcweir 60cdf0e10cSrcweir try { 61cdf0e10cSrcweir log.println("creating a sheetdocument"); 62cdf0e10cSrcweir xSheetDoc = SOF.createCalcDoc(null); 63cdf0e10cSrcweir } catch (com.sun.star.uno.Exception e) { 64*30acf5e8Spfg // Some exception occured.FAILED 65cdf0e10cSrcweir e.printStackTrace(log); 66cdf0e10cSrcweir throw new StatusException("Couldn't create document", e); 67cdf0e10cSrcweir } 68cdf0e10cSrcweir } 69cdf0e10cSrcweir 70cdf0e10cSrcweir /** 71cdf0e10cSrcweir * Disposes Spreadsheet document. 72cdf0e10cSrcweir */ cleanup(TestParameters tParam, PrintWriter log)73cdf0e10cSrcweir protected void cleanup(TestParameters tParam, PrintWriter log) { 74cdf0e10cSrcweir //add this lines after synchronisation 75cdf0e10cSrcweir //log.println(" disposing xSheetDoc "); 76cdf0e10cSrcweir //DesktopTools.closeDoc(xSheetDoc); 77cdf0e10cSrcweir } 78cdf0e10cSrcweir createTestEnvironment(TestParameters tParam, PrintWriter log)79cdf0e10cSrcweir protected TestEnvironment createTestEnvironment(TestParameters tParam, 80cdf0e10cSrcweir PrintWriter log) { 81cdf0e10cSrcweir log.println("Getting the first sheet"); 82cdf0e10cSrcweir 83cdf0e10cSrcweir XIndexAccess xIA = (XIndexAccess) UnoRuntime.queryInterface( 84cdf0e10cSrcweir XIndexAccess.class, xSheetDoc.getSheets()); 85cdf0e10cSrcweir 86cdf0e10cSrcweir try { 87cdf0e10cSrcweir oSheet = (XSpreadsheet) UnoRuntime.queryInterface( 88cdf0e10cSrcweir XSpreadsheet.class, xIA.getByIndex(0)); 89cdf0e10cSrcweir } catch (com.sun.star.lang.WrappedTargetException e) { 90cdf0e10cSrcweir e.printStackTrace(log); 91cdf0e10cSrcweir throw new StatusException("Couldn't get a spreadsheet", e); 92cdf0e10cSrcweir } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 93cdf0e10cSrcweir e.printStackTrace(log); 94cdf0e10cSrcweir throw new StatusException("Couldn't get a spreadsheet", e); 95cdf0e10cSrcweir } 96cdf0e10cSrcweir 97cdf0e10cSrcweir changeColor("A1:A5", 0, 255, 0); 98cdf0e10cSrcweir changeColor("A6:B10", 255, 0, 0); 99cdf0e10cSrcweir changeColor("B1:B6", 0, 0, 255); 100cdf0e10cSrcweir changeColor("B7", 0, 255, 0); 101cdf0e10cSrcweir changeColor("B8:B10", 0, 0, 255); 102cdf0e10cSrcweir changeColor("C1:C10", 0, 0, 255); 103cdf0e10cSrcweir changeColor("D1:D10", 0, 255, 0); 104cdf0e10cSrcweir 105cdf0e10cSrcweir XUniqueCellFormatRangesSupplier xUCRS = (XUniqueCellFormatRangesSupplier) UnoRuntime.queryInterface( 106cdf0e10cSrcweir XUniqueCellFormatRangesSupplier.class, 107cdf0e10cSrcweir oSheet); 108cdf0e10cSrcweir 109cdf0e10cSrcweir XEnumerationAccess xEnum = (XEnumerationAccess) UnoRuntime.queryInterface( 110cdf0e10cSrcweir XEnumerationAccess.class, 111cdf0e10cSrcweir xUCRS.getUniqueCellFormatRanges()); 112cdf0e10cSrcweir XInterface oObj = xEnum.createEnumeration(); 113cdf0e10cSrcweir log.println("Implementationname: " + util.utils.getImplName(oObj)); 114cdf0e10cSrcweir 115cdf0e10cSrcweir TestEnvironment tEnv = new TestEnvironment(oObj); 116cdf0e10cSrcweir 117cdf0e10cSrcweir tEnv.addObjRelation("ExpectedCount", new Integer(4)); 118cdf0e10cSrcweir 119cdf0e10cSrcweir return tEnv; 120cdf0e10cSrcweir } 121cdf0e10cSrcweir changeColor(String RangeName, int r, int g, int b)122cdf0e10cSrcweir protected void changeColor(String RangeName, int r, int g, int b) { 123cdf0e10cSrcweir XCellRange xRange = oSheet.getCellRangeByName(RangeName); 124cdf0e10cSrcweir XPropertySet xPropertySet = (XPropertySet) UnoRuntime.queryInterface( 125cdf0e10cSrcweir XPropertySet.class, xRange); 126cdf0e10cSrcweir Color c = new Color(r, g, b); 127cdf0e10cSrcweir int c2int = 16777216 + c.hashCode(); 128cdf0e10cSrcweir 129cdf0e10cSrcweir try { 130cdf0e10cSrcweir xPropertySet.setPropertyValue("CellBackColor", new Integer(c2int)); 131cdf0e10cSrcweir } catch (com.sun.star.beans.UnknownPropertyException e) { 132cdf0e10cSrcweir log.println("Couldn't change CellFormat"); 133cdf0e10cSrcweir } catch (com.sun.star.beans.PropertyVetoException e) { 134cdf0e10cSrcweir log.println("Couldn't change CellFormat"); 135cdf0e10cSrcweir } catch (com.sun.star.lang.IllegalArgumentException e) { 136cdf0e10cSrcweir log.println("Couldn't change CellFormat"); 137cdf0e10cSrcweir } catch (com.sun.star.lang.WrappedTargetException e) { 138cdf0e10cSrcweir log.println("Couldn't change CellFormat"); 139cdf0e10cSrcweir } 140cdf0e10cSrcweir } 141cdf0e10cSrcweir } 142