qadevOOo/tests/java/mod/_sc/ScDataPilotFieldGroupObj.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: ScDataPilotFieldGroupObj.java,v $
  10  * $Revision: 1.5 $
  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.DataPilotFieldGroupInfo;
  38 import com.sun.star.sheet.XDataPilotDescriptor;
  39 import com.sun.star.sheet.XDataPilotFieldGrouping;
  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 public class ScDataPilotFieldGroupObj extends TestCase
  64 {
  65     static XSpreadsheetDocument xSheetDoc = null;
  66
  67     /**
  68      * A field is filled some values. This integer determines the size of the
  69      * field in x and y direction.
  70      */
  71     private int mMaxFieldIndex = 6;
  72
  73     /**
  74      * Creates Spreadsheet document.
  75      */
  76     protected void initialize (TestParameters tParam, PrintWriter log)
  77     {
  78         SOfficeFactory SOF = SOfficeFactory.getFactory (
  79             (XMultiServiceFactory) tParam.getMSF ());
  80
  81         try
  82         {
  83             log.println ("creating a Spreadsheet document");
  84             xSheetDoc = SOF.createCalcDoc (null);
  85         }
  86         catch (com.sun.star.uno.Exception e)
  87         {
  88             // Some exception occures.FAILED
  89             e.printStackTrace (log);
  90             throw new StatusException ("Couldn't create document", e);
  91         }
  92     }
  93
  94     /**
  95      * Disposes Spreadsheet document.
  96      */
  97     protected void cleanup (TestParameters tParam, PrintWriter log)
  98     {
  99         log.println ("    disposing xSheetDoc ");
 100
 101         XComponent oComp = (XComponent) UnoRuntime.queryInterface (
 102             XComponent.class, xSheetDoc);
 103         util.DesktopTools.closeDoc (oComp);
 104     }
 105
 106     protected synchronized TestEnvironment createTestEnvironment (TestParameters Param,
 107         PrintWriter log)
 108     {
 109         XInterface oObj = null;
 110         XInterface datapilotfield = null;
 111         XInterface groups = null;
 112
 113         // creation of testobject here
 114         // first we write what we are intend to do to log file
 115         log.println ("Creating a test environment");
 116
 117         // the cell range
 118         CellRangeAddress sCellRangeAdress = new CellRangeAddress ();
 119         sCellRangeAdress.Sheet = 0;
 120         sCellRangeAdress.StartColumn = 1;
 121         sCellRangeAdress.StartRow = 0;
 122         sCellRangeAdress.EndColumn = mMaxFieldIndex - 1;
 123         sCellRangeAdress.EndRow = mMaxFieldIndex - 1;
 124
 125         // position of the data pilot table
 126         CellAddress sCellAdress = new CellAddress ();
 127         sCellAdress.Sheet = 0;
 128         sCellAdress.Column = 7;
 129         sCellAdress.Row = 8;
 130
 131         log.println ("Getting a sheet");
 132
 133         XSpreadsheets xSpreadsheets = (XSpreadsheets) xSheetDoc.getSheets ();
 134         XSpreadsheet oSheet = null;
 135         XSpreadsheet oSheet2 = null;
 136         XIndexAccess oIndexAccess = (XIndexAccess) UnoRuntime.queryInterface (
 137             XIndexAccess.class, xSpreadsheets);
 138
 139         try
 140         {
 141             oSheet = (XSpreadsheet) AnyConverter.toObject (
 142                 new Type (XSpreadsheet.class),
 143                 oIndexAccess.getByIndex (0));
 144             oSheet2 = (XSpreadsheet) AnyConverter.toObject (
 145                 new Type (XSpreadsheet.class),
 146                 oIndexAccess.getByIndex (1));
 147         }
 148         catch (com.sun.star.lang.WrappedTargetException e)
 149         {
 150             e.printStackTrace ();
 151             throw new StatusException ("Couldn't get a spreadsheet", e);
 152         }
 153         catch (com.sun.star.lang.IndexOutOfBoundsException e)
 154         {
 155             e.printStackTrace ();
 156             throw new StatusException ("Couldn't get a spreadsheet", e);
 157         }
 158         catch (com.sun.star.lang.IllegalArgumentException e)
 159         {
 160             e.printStackTrace ();
 161             throw new StatusException ("Couldn't get a spreadsheet", e);
 162         }
 163
 164         try
 165         {
 166             log.println ("Filling a table");
 167
 168             for (int i = 1; i < mMaxFieldIndex; i++)
 169             {
 170                 oSheet.getCellByPosition (i, 0).setFormula ("Col" + i);
 171                 oSheet.getCellByPosition (0, i).setFormula ("Row" + i);
 172                 oSheet2.getCellByPosition (i, 0).setFormula ("Col" + i);
 173                 oSheet2.getCellByPosition (0, i).setFormula ("Row" + i);
 174             }
 175
 176             for (int i = 1; i < mMaxFieldIndex; i++)
 177             {
 178                 for (int j = 1; j < mMaxFieldIndex; j++)
 179                 {
 180                     oSheet.getCellByPosition (i, j).setValue (i * (j + 1));
 181                     oSheet2.getCellByPosition (i, j).setValue (i * (j + 2));
 182                 }
 183             }
 184
 185             oSheet.getCellByPosition (1, 1).setFormula ("aName");
 186             oSheet.getCellByPosition (1, 2).setFormula ("otherName");
 187             oSheet.getCellByPosition (1, 3).setFormula ("una");
 188             oSheet.getCellByPosition (1, 4).setFormula ("otherName");
 189             oSheet.getCellByPosition (1, 5).setFormula ("somethingelse");
 190
 191         }
 192         catch (com.sun.star.lang.IndexOutOfBoundsException e)
 193         {
 194             e.printStackTrace ();
 195             throw new StatusException ("Couldn't fill some cells", e);
 196         }
 197
 198         // change a value of a cell and check the change in the data pilot
 199         // (for the XDataPilotTable.refresh() test)
 200         Object oChangeCell = null;
 201         Object oCheckCell = null;
 202         Integer aChangeValue = null;
 203
 204         try
 205         {
 206             // cell of data
 207             oChangeCell = oSheet.getCellByPosition (1, 5);
 208
 209             int x = sCellAdress.Column;
 210             int y = sCellAdress.Row + 3;
 211
 212
 213             // cell of the data pilot output
 214             oCheckCell = oSheet.getCellByPosition (x, y);
 215             aChangeValue = new Integer (27);
 216         }
 217         catch (com.sun.star.lang.IndexOutOfBoundsException e)
 218         {
 219             e.printStackTrace ();
 220             throw new StatusException ("Couldn't get cells for changeing.", e);
 221         }
 222
 223
 224         // create the test objects
 225         log.println ("Getting test objects");
 226
 227         XDataPilotTablesSupplier DPTS = (XDataPilotTablesSupplier) UnoRuntime.queryInterface (
 228             XDataPilotTablesSupplier.class,
 229             oSheet);
 230         XDataPilotTables DPT = DPTS.getDataPilotTables ();
 231         XDataPilotDescriptor DPDsc = DPT.createDataPilotDescriptor ();
 232         DPDsc.setSourceRange (sCellRangeAdress);
 233
 234         XPropertySet fieldPropSet = null;
 235
 236         try
 237         {
 238             Object oDataPilotField = DPDsc.getDataPilotFields ().getByIndex (0);
 239             fieldPropSet = (XPropertySet) UnoRuntime.queryInterface (
 240                 XPropertySet.class, oDataPilotField);
 241             fieldPropSet.setPropertyValue ("Orientation",
 242                 com.sun.star.sheet.DataPilotFieldOrientation.ROW);
 243             oDataPilotField = DPDsc.getDataPilotFields ().getByIndex (1);
 244             fieldPropSet = (XPropertySet) UnoRuntime.queryInterface (
 245                 XPropertySet.class, oDataPilotField);
 246             fieldPropSet.setPropertyValue ("Function",
 247                 com.sun.star.sheet.GeneralFunction.SUM);
 248             fieldPropSet.setPropertyValue ("Orientation",
 249                 com.sun.star.sheet.DataPilotFieldOrientation.DATA);
 250             oDataPilotField = DPDsc.getDataPilotFields ().getByIndex (2);
 251             fieldPropSet = (XPropertySet) UnoRuntime.queryInterface (
 252                 XPropertySet.class, oDataPilotField);
 253             fieldPropSet.setPropertyValue ("Orientation",
 254                 com.sun.star.sheet.DataPilotFieldOrientation.COLUMN);
 255         }
 256         catch (com.sun.star.lang.WrappedTargetException e)
 257         {
 258             e.printStackTrace ();
 259             throw new StatusException ("Couldn't create a test environment", e);
 260         }
 261         catch (com.sun.star.lang.IllegalArgumentException e)
 262         {
 263             e.printStackTrace ();
 264             throw new StatusException ("Couldn't create a test environment", e);
 265         }
 266         catch (com.sun.star.beans.PropertyVetoException e)
 267         {
 268             e.printStackTrace ();
 269             throw new StatusException ("Couldn't create a test environment", e);
 270         }
 271         catch (com.sun.star.beans.UnknownPropertyException e)
 272         {
 273             e.printStackTrace ();
 274             throw new StatusException ("Couldn't create a test environment", e);
 275         }
 276         catch (com.sun.star.lang.IndexOutOfBoundsException e)
 277         {
 278             e.printStackTrace ();
 279             throw new StatusException ("Couldn't create a test environment", e);
 280         }
 281
 282         log.println ("Insert the DataPilotTable");
 283
 284         if (DPT.hasByName ("DataPilotTable"))
 285         {
 286             DPT.removeByName ("DataPilotTable");
 287         }
 288
 289         DPT.insertNewByName ("DataPilotTable", sCellAdress, DPDsc);
 290         XIndexAccess xIA = (XIndexAccess) UnoRuntime.queryInterface (XIndexAccess.class,DPTS.getDataPilotTables ());
 291         XIndexAccess IA = null;
 292         try
 293         {
 294             XDataPilotDescriptor xDPT = (XDataPilotDescriptor) UnoRuntime.queryInterface (XDataPilotDescriptor.class,xIA.getByIndex (0));
 295             IA = xDPT.getRowFields ();
 296             //getSRange(IA);
 297             System.out.println ("COUNT: "+IA.getCount ());
 298             datapilotfield = (XInterface) AnyConverter.toObject (
 299                 new Type (XInterface.class), IA.getByIndex (0));
 300         }
 301         catch (com.sun.star.lang.WrappedTargetException e)
 302         {
 303             e.printStackTrace ();
 304             throw new StatusException ("Couldn't get data pilot field", e);
 305         }
 306         catch (com.sun.star.lang.IndexOutOfBoundsException e)
 307         {
 308             e.printStackTrace ();
 309             throw new StatusException ("Couldn't get data pilot field", e);
 310         }
 311         catch (com.sun.star.lang.IllegalArgumentException e)
 312         {
 313             e.printStackTrace ();
 314             throw new StatusException ("Couldn't get data pilot field", e);
 315         }
 316
 317         try
 318         {
 319             XDataPilotFieldGrouping  dpfg = (XDataPilotFieldGrouping) UnoRuntime.queryInterface (XDataPilotFieldGrouping.class, datapilotfield);
 320             String[] elements = new String[]{"aName","otherName"};
 321             dpfg.createNameGroup (elements);
 322             DataPilotFieldGroupInfo dpgi=null;
 323             xIA = (XIndexAccess) UnoRuntime.queryInterface (XIndexAccess.class,DPTS.getDataPilotTables ());
 324         try
 325         {
 326             XDataPilotDescriptor xDPT = (XDataPilotDescriptor) UnoRuntime.queryInterface (XDataPilotDescriptor.class,xIA.getByIndex (0));
 327             IA = xDPT.getRowFields ();
 328         }
 329         catch (com.sun.star.lang.WrappedTargetException e)
 330         {
 331             e.printStackTrace ();
 332             throw new StatusException ("Couldn't get data pilot field", e);
 333         }
 334         catch (com.sun.star.lang.IndexOutOfBoundsException e)
 335         {
 336             e.printStackTrace ();
 337             throw new StatusException ("Couldn't get data pilot field", e);
 338         }
 339             for (int i=0;i<IA.getCount ();i++)
 340             {
 341                 datapilotfield = (XInterface) AnyConverter.toObject (
 342                     new Type (XInterface.class), IA.getByIndex (i));
 343                 XPropertySet xPropertySet = (XPropertySet) UnoRuntime.queryInterface (XPropertySet.class, IA.getByIndex (i));
 344                 if (((Boolean)xPropertySet.getPropertyValue ("IsGroupField")).booleanValue ())
 345                 {
 346                     xPropertySet = (XPropertySet) UnoRuntime.queryInterface (XPropertySet.class, datapilotfield);
 347                     XNamed xNamed = (XNamed) UnoRuntime.queryInterface (XNamed.class, IA.getByIndex (i));
 348                     System.out.println ("name: "+xNamed.getName ());
 349                     dpgi = (DataPilotFieldGroupInfo) xPropertySet.getPropertyValue ("GroupInfo");
 350                 }
 351             }
 352             groups = dpgi.Groups;
 353             XIndexAccess groupAccess = (XIndexAccess) UnoRuntime.queryInterface(XIndexAccess.class, groups);
 354             oObj = (XInterface) UnoRuntime.queryInterface(XInterface.class, groupAccess.getByIndex(0));
 355         }
 356         catch (Exception e)
 357         {
 358             e.printStackTrace ();
 359         }
 360
 361         log.println ("Creating object - " +
 362             ((oObj == null) ? "FAILED" : "OK"));
 363
 364         TestEnvironment tEnv = new TestEnvironment (oObj);
 365
 366         log.println ("Implementationname: " + util.utils.getImplName (oObj));
 367
 368         // Other parameters required for interface tests
 369         return tEnv;
 370     }
 371
 372 }