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