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