qadevOOo/tests/java/mod/_sc/ScDataPilotItemsObj.java

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: ScDataPilotItemsObj.java,v $
  10  * $Revision: 1.6 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30 package mod._sc;
  31
  32 import com.sun.star.beans.XPropertySet;
  33 import com.sun.star.container.XIndexAccess;
  34 import com.sun.star.container.XNamed;
  35 import com.sun.star.lang.XComponent;
  36 import com.sun.star.lang.XMultiServiceFactory;
  37 import com.sun.star.sheet.DataPilotFieldOrientation;
  38 import com.sun.star.sheet.XDataPilotDescriptor;
  39 import com.sun.star.sheet.XDataPilotField;
  40 import com.sun.star.sheet.XDataPilotTables;
  41 import com.sun.star.sheet.XDataPilotTablesSupplier;
  42 import com.sun.star.sheet.XSpreadsheet;
  43 import com.sun.star.sheet.XSpreadsheetDocument;
  44 import com.sun.star.sheet.XSpreadsheets;
  45 import com.sun.star.table.CellAddress;
  46 import com.sun.star.table.CellRangeAddress;
  47 import com.sun.star.uno.AnyConverter;
  48 import com.sun.star.uno.Type;
  49 import com.sun.star.uno.UnoRuntime;
  50 import com.sun.star.uno.XInterface;
  51
  52 import java.io.PrintWriter;
  53
  54 import lib.StatusException;
  55 import lib.TestCase;
  56 import lib.TestEnvironment;
  57 import lib.TestParameters;
  58
  59 import util.SOfficeFactory;
  60
  61
  62 /**
  63 * Test for object which is represented by service
  64 * <code>com.sun.star.sheet.DataPilotField</code>. <p>
  65 * Object implements the following interfaces :
  66 * <ul>
  67 *  <li> <code>com::sun::star::container::XNamed</code></li>
  68 *  <li> <code>com::sun::star::sheet::DataPilotField</code></li>
  69 *  <li> <code>com::sun::star::beans::XPropertySet</code></li>
  70 * </ul>
  71 * @see com.sun.star.sheet.DataPilotField
  72 * @see com.sun.star.container.XNamed
  73 * @see com.sun.star.sheet.DataPilotField
  74 * @see com.sun.star.beans.XPropertySet
  75 * @see ifc.container._XNamed
  76 * @see ifc.sheet._DataPilotField
  77 * @see ifc.beans._XPropertySet
  78 */
  79 public class ScDataPilotItemsObj extends TestCase {
  80     static XSpreadsheetDocument xSheetDoc = null;
  81
  82     /**
  83      * A field is filled some values. This integer determines the size of the
  84      * field in x and y direction.
  85      */
  86     private int mMaxFieldIndex = 6;
  87
  88     /**
  89     * Creates Spreadsheet document.
  90     */
  91     protected void initialize(TestParameters tParam, PrintWriter log) {
  92         SOfficeFactory SOF = SOfficeFactory.getFactory(
  93                                      (XMultiServiceFactory) tParam.getMSF());
  94
  95         try {
  96             log.println("creating a Spreadsheet document");
  97             xSheetDoc = SOF.createCalcDoc(null);
  98         } catch (com.sun.star.uno.Exception e) {
  99             // Some exception occures.FAILED
 100             e.printStackTrace(log);
 101             throw new StatusException("Couldn't create document", e);
 102         }
 103     }
 104
 105     /**
 106     * Disposes Spreadsheet document.
 107     */
 108     protected void cleanup(TestParameters tParam, PrintWriter log) {
 109         log.println("    disposing xSheetDoc ");
 110
 111         XComponent oComp = (XComponent) UnoRuntime.queryInterface(
 112                                    XComponent.class, xSheetDoc);
 113         util.DesktopTools.closeDoc(oComp);
 114     }
 115
 116     /**
 117     * Creating a Testenvironment for the interfaces to be tested.
 118     * Retrieves a collection of spreadsheets from a document
 119     * and takes one of them. Fills some table in the spreadsheet.
 120     * Obtains the collection of data pilot tables using the interface
 121     * <code>XDataPilotTablesSupplier</code>. Creates a data pilot descriptor
 122     * for the filled table and inserts new data pilot table with this descriptor
 123     * to the collection. Obtains the collection of all the data pilot fields
 124     * using the interface <code>XDataPilotDescriptor</code>. Retrieves from
 125     * the collection the data pilot field with index 0. This data pilot field
 126     * is the instance of the service <code>com.sun.star.sheet.DataPilotField</code>.
 127     * @see com.sun.star.sheet.DataPilotField
 128     * @see com.sun.star.sheet.XDataPilotTablesSupplier
 129     * @see com.sun.star.sheet.XDataPilotDescriptor
 130     */
 131     protected synchronized TestEnvironment createTestEnvironment(TestParameters Param,
 132                                                                  PrintWriter log) {
 133         XInterface oObj = null;
 134
 135
 136         // creation of testobject here
 137         // first we write what we are intend to do to log file
 138         log.println("Creating a test environment");
 139
 140         // the cell range
 141         CellRangeAddress sCellRangeAdress = new CellRangeAddress();
 142         sCellRangeAdress.Sheet = 0;
 143         sCellRangeAdress.StartColumn = 1;
 144         sCellRangeAdress.StartRow = 0;
 145         sCellRangeAdress.EndColumn = mMaxFieldIndex - 1;
 146         sCellRangeAdress.EndRow = mMaxFieldIndex - 1;
 147
 148         // position of the data pilot table
 149         CellAddress sCellAdress = new CellAddress();
 150         sCellAdress.Sheet = 0;
 151         sCellAdress.Column = 7;
 152         sCellAdress.Row = 8;
 153
 154         log.println("Getting a sheet");
 155
 156         XSpreadsheets xSpreadsheets = (XSpreadsheets) xSheetDoc.getSheets();
 157         XSpreadsheet oSheet = null;
 158         XSpreadsheet oSheet2 = null;
 159         XIndexAccess oIndexAccess = (XIndexAccess) UnoRuntime.queryInterface(
 160                                             XIndexAccess.class, xSpreadsheets);
 161
 162         try {
 163             oSheet = (XSpreadsheet) AnyConverter.toObject(
 164                              new Type(XSpreadsheet.class),
 165                              oIndexAccess.getByIndex(0));
 166             oSheet2 = (XSpreadsheet) AnyConverter.toObject(
 167                               new Type(XSpreadsheet.class),
 168                               oIndexAccess.getByIndex(1));
 169         } catch (com.sun.star.lang.WrappedTargetException e) {
 170             e.printStackTrace();
 171             throw new StatusException("Couldn't get a spreadsheet", e);
 172         } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
 173             e.printStackTrace();
 174             throw new StatusException("Couldn't get a spreadsheet", e);
 175         } catch (com.sun.star.lang.IllegalArgumentException e) {
 176             e.printStackTrace();
 177             throw new StatusException("Couldn't get a spreadsheet", e);
 178         }
 179
 180         try {
 181             log.println("Filling a table");
 182
 183             for (int i = 1; i < mMaxFieldIndex; i++) {
 184                 oSheet.getCellByPosition(i, 0).setFormula("Col" + i);
 185                 oSheet.getCellByPosition(0, i).setFormula("Row" + i);
 186                 oSheet2.getCellByPosition(i, 0).setFormula("Col" + i);
 187                 oSheet2.getCellByPosition(0, i).setFormula("Row" + i);
 188             }
 189
 190             for (int i = 1; i < mMaxFieldIndex; i++)
 191                 for (int j = 1; j < mMaxFieldIndex; j++) {
 192                     oSheet.getCellByPosition(i, j).setValue(i * (j + 1));
 193                     oSheet2.getCellByPosition(i, j).setValue(i * (j + 2));
 194                 }
 195         } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
 196             e.printStackTrace();
 197             throw new StatusException("Couldn't fill some cells", e);
 198         }
 199
 200         // change a value of a cell and check the change in the data pilot
 201         // (for the XDataPilotTable.refresh() test)
 202         Object oChangeCell = null;
 203         Object oCheckCell = null;
 204         Integer aChangeValue = null;
 205
 206         try {
 207             // cell of data
 208             oChangeCell = oSheet.getCellByPosition(1, 5);
 209
 210             int x = sCellAdress.Column;
 211             int y = sCellAdress.Row + 3;
 212
 213
 214             // cell of the data pilot output
 215             oCheckCell = oSheet.getCellByPosition(x, y);
 216             aChangeValue = new Integer(27);
 217         } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
 218             e.printStackTrace();
 219             throw new StatusException("Couldn't get cells for changeing.", e);
 220         }
 221
 222
 223         // create the test objects
 224         log.println("Getting test objects");
 225
 226         XDataPilotTablesSupplier DPTS = (XDataPilotTablesSupplier) UnoRuntime.queryInterface(
 227                                                 XDataPilotTablesSupplier.class,
 228                                                 oSheet);
 229         XDataPilotTables DPT = DPTS.getDataPilotTables();
 230         XDataPilotDescriptor DPDsc = DPT.createDataPilotDescriptor();
 231         DPDsc.setSourceRange(sCellRangeAdress);
 232
 233         XPropertySet fieldPropSet = null;
 234
 235         try {
 236             Object oDataPilotField = DPDsc.getDataPilotFields().getByIndex(0);
 237             fieldPropSet = (XPropertySet) UnoRuntime.queryInterface(
 238                                    XPropertySet.class, oDataPilotField);
 239         } catch (com.sun.star.lang.WrappedTargetException e) {
 240             e.printStackTrace();
 241             throw new StatusException("Couldn't create a test environment", e);
 242         } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
 243             e.printStackTrace();
 244             throw new StatusException("Couldn't create a test environment", e);
 245         }
 246
 247         try {
 248             fieldPropSet.setPropertyValue("Function",
 249                                           com.sun.star.sheet.GeneralFunction.SUM);
 250             fieldPropSet.setPropertyValue("Orientation",
 251                                           com.sun.star.sheet.DataPilotFieldOrientation.DATA);
 252         } catch (com.sun.star.lang.WrappedTargetException e) {
 253             e.printStackTrace();
 254             throw new StatusException("Couldn't create a test environment", e);
 255         } catch (com.sun.star.lang.IllegalArgumentException e) {
 256             e.printStackTrace();
 257             throw new StatusException("Couldn't create a test environment", e);
 258         } catch (com.sun.star.beans.PropertyVetoException e) {
 259             e.printStackTrace();
 260             throw new StatusException("Couldn't create a test environment", e);
 261         } catch (com.sun.star.beans.UnknownPropertyException e) {
 262             e.printStackTrace();
 263             throw new StatusException("Couldn't create a test environment", e);
 264         }
 265
 266         log.println("Insert the DataPilotTable");
 267
 268         if (DPT.hasByName("DataPilotTable")) {
 269             DPT.removeByName("DataPilotTable");
 270         }
 271
 272         XIndexAccess IA = DPDsc.getDataPilotFields();
 273         getSRange(IA);
 274
 275         DPT.insertNewByName("DataPilotTable", sCellAdress, DPDsc);
 276
 277         try {
 278             oObj = (XInterface) AnyConverter.toObject(
 279                            new Type(XInterface.class), IA.getByIndex(0));
 280         } catch (com.sun.star.lang.WrappedTargetException e) {
 281             e.printStackTrace();
 282             throw new StatusException("Couldn't get data pilot field", e);
 283         } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
 284             e.printStackTrace();
 285             throw new StatusException("Couldn't get data pilot field", e);
 286         } catch (com.sun.star.lang.IllegalArgumentException e) {
 287             e.printStackTrace();
 288             throw new StatusException("Couldn't get data pilot field", e);
 289         }
 290
 291         log.println("Creating object - " +
 292                     ((oObj == null) ? "FAILED" : "OK"));
 293
 294         XDataPilotField xDataPilotField = (XDataPilotField) UnoRuntime.queryInterface(
 295                                                   XDataPilotField.class, oObj);
 296
 297         oObj = xDataPilotField.getItems();
 298
 299         TestEnvironment tEnv = new TestEnvironment(oObj);
 300
 301         log.println("Implementationname: " + util.utils.getImplName(oObj));
 302
 303         // Other parameters required for interface tests
 304         return tEnv;
 305     }
 306
 307     private void getSRange(XIndexAccess IA) {
 308         int fieldsAmount = IA.getCount() + 1;
 309
 310         String[] fieldsNames = new String[fieldsAmount];
 311
 312         int i = -1;
 313         int cnt = 0;
 314
 315         while ((++i) < fieldsAmount) {
 316             Object field;
 317
 318             try {
 319                 field = IA.getByIndex(i);
 320             } catch (com.sun.star.lang.WrappedTargetException e) {
 321                 e.printStackTrace(log);
 322
 323                 return;
 324             } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
 325                 e.printStackTrace(log);
 326
 327                 return;
 328             }
 329
 330             XNamed named = (XNamed) UnoRuntime.queryInterface(XNamed.class,
 331                                                               field);
 332             String name = named.getName();
 333
 334             log.println("**Field : '" + name + "' ... ");
 335
 336             if (!name.equals("Data")) {
 337                 fieldsNames[cnt] = name;
 338
 339                 XPropertySet props = (XPropertySet) UnoRuntime.queryInterface(
 340                                              XPropertySet.class, field);
 341
 342                 try {
 343                     switch (cnt % 5) {
 344                     case 0:
 345                         props.setPropertyValue("Orientation",
 346                                                DataPilotFieldOrientation.COLUMN);
 347                         log.println("  Column");
 348
 349                         break;
 350
 351                     case 1:
 352                         props.setPropertyValue("Orientation",
 353                                                DataPilotFieldOrientation.ROW);
 354                         log.println("  Row");
 355
 356                         break;
 357
 358                     case 2:
 359                         props.setPropertyValue("Orientation",
 360                                                DataPilotFieldOrientation.DATA);
 361                         log.println("  Data");
 362
 363                         break;
 364
 365                     case 3:
 366                         props.setPropertyValue("Orientation",
 367                                                DataPilotFieldOrientation.HIDDEN);
 368                         log.println("  Hidden");
 369
 370                         break;
 371
 372                     case 4:
 373                         props.setPropertyValue("Orientation",
 374                                                DataPilotFieldOrientation.PAGE);
 375                         log.println("  Page");
 376
 377                         break;
 378                     }
 379                 } catch (com.sun.star.lang.WrappedTargetException e) {
 380                     e.printStackTrace(log);
 381
 382                     return;
 383                 } catch (com.sun.star.lang.IllegalArgumentException e) {
 384                     e.printStackTrace(log);
 385
 386                     return;
 387                 } catch (com.sun.star.beans.PropertyVetoException e) {
 388                     e.printStackTrace(log);
 389
 390                     return;
 391                 } catch (com.sun.star.beans.UnknownPropertyException e) {
 392                     e.printStackTrace(log);
 393
 394                     return;
 395                 }
 396
 397                 if ((++cnt) > 4) {
 398                     break;
 399                 }
 400             } else {
 401                 return;
 402             }
 403         }
 404     }
 405 }