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