qadevOOo/tests/java/mod/_sc/ScUniqueCellFormatsObj.java

   1 /*
   2  * This file is part of the LibreOffice project.
   3  *
   4  * This Source Code Form is subject to the terms of the Mozilla Public
   5  * License, v. 2.0. If a copy of the MPL was not distributed with this
   6  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   7  *
   8  * This file incorporates work covered by the following license notice:
   9  *
  10  *   Licensed to the Apache Software Foundation (ASF) under one or more
  11  *   contributor license agreements. See the NOTICE file distributed
  12  *   with this work for additional information regarding copyright
  13  *   ownership. The ASF licenses this file to you under the Apache
  14  *   License, Version 2.0 (the "License"); you may not use this file
  15  *   except in compliance with the License. You may obtain a copy of
  16  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  17  */
  18 package mod._sc;
  19
  20 import com.sun.star.beans.XPropertySet;
  21 import com.sun.star.container.XIndexAccess;
  22 import com.sun.star.lang.XMultiServiceFactory;
  23 import com.sun.star.sheet.XSpreadsheet;
  24 import com.sun.star.sheet.XSpreadsheetDocument;
  25 import com.sun.star.sheet.XUniqueCellFormatRangesSupplier;
  26 import com.sun.star.table.XCellRange;
  27 import com.sun.star.uno.UnoRuntime;
  28 import com.sun.star.uno.XInterface;
  29
  30 import java.awt.Color;
  31
  32 import java.io.PrintWriter;
  33
  34 import lib.StatusException;
  35 import lib.TestCase;
  36 import lib.TestEnvironment;
  37 import lib.TestParameters;
  38
  39 import util.SOfficeFactory;
  40
  41
  42 public class ScUniqueCellFormatsObj extends TestCase {
  43     private XSpreadsheetDocument xSheetDoc = null;
  44     static XSpreadsheet oSheet = null;
  45
  46     /**
  47     * Creates Spreadsheet document.
  48     */
  49     protected void initialize(TestParameters tParam, PrintWriter log) {
  50         // get a soffice factory object
  51         SOfficeFactory SOF = SOfficeFactory.getFactory(
  52                                      (XMultiServiceFactory) tParam.getMSF());
  53
  54         try {
  55             log.println("creating a sheetdocument");
  56             xSheetDoc = SOF.createCalcDoc(null);
  57         } catch (com.sun.star.uno.Exception e) {
  58             // Some exception occurs.FAILED
  59             e.printStackTrace(log);
  60             throw new StatusException("Couldn't create document", e);
  61         }
  62     }
  63
  64     /**
  65     * Disposes Spreadsheet document.
  66     */
  67     protected void cleanup(TestParameters tParam, PrintWriter log) {
  68         util.DesktopTools.closeDoc(xSheetDoc);
  69     }
  70
  71     protected TestEnvironment createTestEnvironment(TestParameters tParam,
  72                                                     PrintWriter log) {
  73         log.println("Getting the first sheet");
  74
  75         XIndexAccess xIA = UnoRuntime.queryInterface(
  76                                    XIndexAccess.class, xSheetDoc.getSheets());
  77
  78         try {
  79             oSheet = UnoRuntime.queryInterface(
  80                              XSpreadsheet.class, xIA.getByIndex(0));
  81         } catch (com.sun.star.lang.WrappedTargetException e) {
  82             e.printStackTrace(log);
  83             throw new StatusException("Couldn't get a spreadsheet", e);
  84         } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
  85             e.printStackTrace(log);
  86             throw new StatusException("Couldn't get a spreadsheet", e);
  87         }
  88
  89         changeColor("A1:A5", 0, 255, 0);
  90         changeColor("A6:B10", 255, 0, 0);
  91         changeColor("B1:B6", 0, 0, 255);
  92         changeColor("B7", 0, 255, 0);
  93         changeColor("B8:B10", 0, 0, 255);
  94         changeColor("C1:C10", 0, 0, 255);
  95         changeColor("D1:D10", 0, 255, 0);
  96
  97         XUniqueCellFormatRangesSupplier xUCRS = UnoRuntime.queryInterface(
  98                                                         XUniqueCellFormatRangesSupplier.class,
  99                                                         oSheet);
 100
 101         XInterface oObj = xUCRS.getUniqueCellFormatRanges();
 102         log.println("Implementationname: " + util.utils.getImplName(oObj));
 103
 104         TestEnvironment tEnv = new TestEnvironment(oObj);
 105
 106         return tEnv;
 107     }
 108
 109     protected void changeColor(String RangeName, int r, int g, int b) {
 110         XCellRange xRange = oSheet.getCellRangeByName(RangeName);
 111         XPropertySet xPropertySet = UnoRuntime.queryInterface(
 112                                             XPropertySet.class, xRange);
 113         Color c = new Color(r, g, b);
 114         int c2int = 16777216 + c.hashCode();
 115
 116         try {
 117             xPropertySet.setPropertyValue("CellBackColor", new Integer(c2int));
 118         } catch (com.sun.star.beans.UnknownPropertyException e) {
 119             log.println("Couldn't change CellFormat");
 120         } catch (com.sun.star.beans.PropertyVetoException e) {
 121             log.println("Couldn't change CellFormat");
 122         } catch (com.sun.star.lang.IllegalArgumentException e) {
 123             log.println("Couldn't change CellFormat");
 124         } catch (com.sun.star.lang.WrappedTargetException e) {
 125             log.println("Couldn't change CellFormat");
 126         }
 127     }
 128 }