qadevOOo/tests/java/ifc/sheet/_XArrayFormulaRange.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
  19 package ifc.sheet;
  20
  21 import lib.MultiMethodTest;
  22 import lib.Status;
  23 import lib.StatusException;
  24
  25 import com.sun.star.sheet.XArrayFormulaRange;
  26 import com.sun.star.sheet.XCellRangeAddressable;
  27 import com.sun.star.sheet.XSpreadsheet;
  28 import com.sun.star.table.CellRangeAddress;
  29 import com.sun.star.table.XCell;
  30 import com.sun.star.uno.UnoRuntime;
  31
  32 /**
  33 * Testing <code>com.sun.star.sheet.XArrayFormulaRange</code>
  34 * interface methods :
  35 * <ul>
  36 *  <li><code> getArrayFormula()</code></li>
  37 *  <li><code> setArrayFormula()</code></li>
  38 * </ul> <p>
  39 * This test needs the following object relations :
  40 * <ul>
  41 *  <li> <code>'SHEET'</code> (of type <code>XSpreadsheet</code>):
  42 *   to check contents of spreadsheet </li>
  43 *  <li> <code>'noArray'</code> (of type <code>Object</code>):
  44 *   if the relation is null then given component doesn't really support
  45 *   this interface </li>
  46 * <ul> <p>
  47 * Test object must implements interface <code>XCellRangeAddressable</code> also.
  48 * @see com.sun.star.sheet.XArrayFormulaRange
  49 * @see com.sun.star.sheet.XSpreadsheet
  50 * @see com.sun.star.sheet.XCellRangeAddressable
  51 */
  52 public class _XArrayFormulaRange extends MultiMethodTest {
  53
  54     public XArrayFormulaRange oObj = null;
  55     String formula = "=1 + 2 * 5";
  56
  57     /**
  58     * Test calls the method and then checks content sof spreadsheet using
  59     * object relation <code>'SHEET'</code>. <p>
  60     * Has <b> OK </b> status if values in cells of spreadsheet are equal to 11
  61     * or ArrayFormula not supported.<p>
  62     */
  63     public void _setArrayFormula() {
  64         Object noArray = tEnv.getObjRelation("noArray");
  65         if (noArray != null) {
  66             log.println("Component " + noArray.toString() +
  67                 " doesn't really support this Interface");
  68             log.println("It doesn't make sense to set an ArrayFormula over"
  69                 + " the whole sheet");
  70             tRes.tested("setArrayFormula()", true);
  71             return;
  72         }
  73
  74         boolean result = true;
  75         double dresult = 11;
  76
  77         log.println("setArrayFormula() ...");
  78
  79         oObj.setArrayFormula(formula);
  80
  81         log.println("checking that formula was set correctly...");
  82         XCellRangeAddressable crAddr =
  83             UnoRuntime.queryInterface(XCellRangeAddressable.class, oObj);
  84         CellRangeAddress addr = crAddr.getRangeAddress() ;
  85         XSpreadsheet oSheet = (XSpreadsheet)tEnv.getObjRelation("SHEET");
  86         if (oSheet == null) throw new StatusException(Status.failed
  87             ("Relation 'SHEET' not found"));
  88
  89         XCell oCell = null;
  90         double value;
  91
  92         for (int i = addr.StartColumn; i <= addr.EndColumn; i++)
  93             for (int j = addr.StartRow; j <= addr.EndRow; j++) {
  94                 try {
  95                     oCell = oSheet.getCellByPosition(i, j);
  96                 } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
  97                     e.printStackTrace(log);
  98                     result = false;
  99                     break;
 100                 }
 101
 102                 value = oCell.getValue();
 103                 result &= (value == dresult);
 104             }
 105
 106         tRes.tested("setArrayFormula()", result) ;
 107
 108     } // end setArrayFormula()
 109
 110     /**
 111     * Test calls the method and compare formula that set by method
 112     * <code>setArrayFormula</code> with returned value ignoring spaces. <p>
 113     *
 114     * Has <b> OK </b> status if values are equal or
 115     * ArrayFormula not supported. <p>
 116     *
 117     * The following method tests are to be completed successfully before :
 118     * <ul>
 119     *  <li> <code> setArrayFormula </code> : to set formula </li>
 120     * </ul>
 121     */
 122     public void _getArrayFormula() {
 123
 124         Object noArray = tEnv.getObjRelation("noArray");
 125         if (noArray != null) {
 126             log.println("Component "+noArray.toString()+" doesn't really support this Interface");
 127             log.println("It doesn't make sense to set an ArrayFormula over the whole sheet");
 128             log.println("and therefore 'getArrayFormula()' won't work");
 129             tRes.tested("getArrayFormula()",true);
 130             return;
 131         }
 132
 133         requiredMethod("setArrayFormula()");
 134         boolean result = true;
 135         log.println("Testing getArrayFormula() ...");
 136         String gFormula = oObj.getArrayFormula() ;
 137         result &= equalIgnoreSpaces("{" + formula + "}", gFormula);
 138         if (!result)
 139             log.println("Method returned : '" + oObj.getArrayFormula() + "'") ;
 140         tRes.tested("getArrayFormula()", result) ;
 141
 142     } // end getArrayFormula()
 143
 144     /**
 145      * Method compares two string ignoring spaces.
 146      * @return <code>true</code> if the argument
 147      * is not null and the Strings are equal,
 148      * ignoring spaces; <code>false</code> otherwise.
 149      */
 150     private boolean equalIgnoreSpaces(String s1, String s2) {
 151         int p1 = 0, p2 = 0 ;
 152         s1 = s1.trim() ;
 153         s2 = s2.trim() ;
 154         while (p1 < s1.length() && p2 < s2.length()) {
 155             while (s1.charAt(p1) == ' ') { p1 ++; }
 156             while (s2.charAt(p2) == ' ') { p2 ++; }
 157             if (s1.charAt(p1) != s2.charAt(p2)) return false ;
 158             p1 ++ ;
 159             p2 ++ ;
 160         }
 161
 162         return p1 == s1.length() && p2 == s2.length() ;
 163     }
 164
 165     /**
 166     * Forces environment recreation.
 167     */
 168     @Override
 169     protected void after() {
 170         disposeEnvironment();
 171     }
 172 }
 173