qadevOOo/tests/java/ifc/sheet/_XDataPilotTables.java

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2000, 2010 Oracle and/or its affiliates.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * This file is part of OpenOffice.org.
  10  *
  11  * OpenOffice.org is free software: you can redistribute it and/or modify
  12  * it under the terms of the GNU Lesser General Public License version 3
  13  * only, as published by the Free Software Foundation.
  14  *
  15  * OpenOffice.org is distributed in the hope that it will be useful,
  16  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  17  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  18  * GNU Lesser General Public License version 3 for more details
  19  * (a copy is included in the LICENSE file that accompanied this code).
  20  *
  21  * You should have received a copy of the GNU Lesser General Public License
  22  * version 3 along with OpenOffice.org.  If not, see
  23  * <http://www.openoffice.org/license.html>
  24  * for a copy of the LGPLv3 License.
  25  *
  26  ************************************************************************/
  27
  28 package ifc.sheet;
  29
  30 import lib.MultiMethodTest;
  31 import lib.Status;
  32 import lib.StatusException;
  33
  34 import com.sun.star.sheet.XDataPilotDescriptor;
  35 import com.sun.star.sheet.XDataPilotTables;
  36 import com.sun.star.sheet.XSpreadsheet;
  37 import com.sun.star.table.CellAddress;
  38
  39 /**
  40 * Testing <code>com.sun.star.sheet.XDataPilotTables</code>
  41 * interface methods :
  42 * <ul>
  43 *  <li><code> createDataPilotDescriptor()</code></li>
  44 *  <li><code> insertNewByName()</code></li>
  45 *  <li><code> removeByName()</code></li>
  46 * </ul> <p>
  47 * This test needs the following object relations :
  48 * <ul>
  49 *  <li> <code>'SHEET'</code> (of type <code>XSpreadsheet</code>):
  50 *   to have a spreadsheet document for document content checking</li>
  51 * <ul> <p>
  52 * @see com.sun.star.sheet.XDataPilotTables
  53 */
  54 public class _XDataPilotTables extends MultiMethodTest {
  55
  56     public XDataPilotTables oObj = null;
  57     XDataPilotDescriptor DPDscr = null;
  58     String name = "XDataPilotTables";
  59     CellAddress CA = new CellAddress((short)0, 9, 8);
  60     XSpreadsheet oSheet = null;
  61
  62     /**
  63     * Retrieves object relations.
  64     * @throws StatusException If one of relations not found.
  65     */
  66     protected void before() {
  67         oSheet = (XSpreadsheet)tEnv.getObjRelation("SHEET");
  68         if (oSheet == null) throw new StatusException(Status.failed
  69             ("Relation 'SHEET' not found"));
  70     }
  71
  72     /**
  73     * Test calls the method, stores returned value and checks returned value.
  74     * <p>Has <b> OK </b> status if returned value isn't null. <p>
  75     */
  76     public void _createDataPilotDescriptor(){
  77         DPDscr = oObj.createDataPilotDescriptor();
  78         tRes.tested("createDataPilotDescriptor()", DPDscr != null);
  79     }
  80
  81     /**
  82     * Test calls the method inserting new table with new name and then calls
  83     * the method inserting table with existent name. <p>
  84     * Has <b> OK </b> status if the cell content where table was inserted is
  85     * equal to 'Filter' after first call and exception was thrown during
  86     * second call. <p>
  87     * The following method tests are to be completed successfully before :
  88     * <ul>
  89     *  <li> <code> createDataPilotDescriptor() </code> : to have
  90     *  <code>XDataPilotDescriptor</code> created by this method</li>
  91     * </ul>
  92     */
  93     public void _insertNewByName(){
  94         requiredMethod("createDataPilotDescriptor()");
  95         boolean bResult = true;
  96         log.println("Inserting new Table \"" + name + "\"");
  97         try {
  98             oObj.insertNewByName(name, CA, DPDscr);
  99             bResult &= oSheet.getCellByPosition
 100                 (CA.Column, CA.Row).getFormula().equals("Filter");
 101         } catch (com.sun.star.uno.Exception e) {
 102             log.println("Exception occurred! " + e);
 103             bResult = false;
 104         }
 105
 106         log.println(bResult ? "OK" : "FAILED");
 107         log.println("Trying to insert element with existent name");
 108
 109         try {
 110             oObj.insertNewByName(name,new CellAddress((short)0, 7, 7), DPDscr);
 111             log.println("No exception! - FAILED");
 112             bResult = false;
 113         } catch (com.sun.star.uno.RuntimeException e) {
 114             log.println("Expected exception - OK " + e);
 115         }
 116
 117         log.println("Inserting new table " + (bResult ? "OK" : "FAILED"));
 118         tRes.tested("insertNewByName()", bResult);
 119     }
 120
 121     /**
 122     * Test calls the method for existent table and for unexistent table. <p>
 123     * Has <b> OK </b> status if the cell where table was removed from is empty
 124     * after first call and exception was thrown during second call. <p>
 125     * The following method tests are to be completed successfully before :
 126     * <ul>
 127     *  <li> <code>insertNewByName()</code>: to have name of existent table</li>
 128     * </ul>
 129     */
 130     public void _removeByName(){
 131         requiredMethod("insertNewByName()");
 132         boolean bResult = true;
 133         log.println("Remove table with name " + name);
 134         try {
 135             oObj.removeByName(name);
 136             bResult &= oSheet.getCellByPosition
 137                 (CA.Column, CA.Row).getFormula().equals("");
 138         } catch (com.sun.star.uno.Exception e) {
 139             log.println("Exception occurred ! " + e);
 140             bResult = false;
 141         }
 142         log.println(bResult ? "OK" : "FAILED");
 143         log.println("Removing unexistent element");
 144         try {
 145             oObj.removeByName(name);
 146             log.println("No exception! - FAILED");
 147             bResult = false;
 148         } catch (com.sun.star.uno.RuntimeException e) {
 149             log.println("Expected exception - OK " + e);
 150         }
 151
 152         log.println("Removing a table " + (bResult ? "OK" : "FAILED"));
 153         tRes.tested("removeByName()", bResult);
 154     }
 155
 156 }
 157