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 24*b1cdbd2cSJim Jagielski package mod._sc; 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski import java.io.PrintWriter; 27*b1cdbd2cSJim Jagielski 28*b1cdbd2cSJim Jagielski import lib.StatusException; 29*b1cdbd2cSJim Jagielski import lib.TestCase; 30*b1cdbd2cSJim Jagielski import lib.TestEnvironment; 31*b1cdbd2cSJim Jagielski import lib.TestParameters; 32*b1cdbd2cSJim Jagielski import util.SOfficeFactory; 33*b1cdbd2cSJim Jagielski 34*b1cdbd2cSJim Jagielski import com.sun.star.beans.XPropertySet; 35*b1cdbd2cSJim Jagielski import com.sun.star.container.XIndexAccess; 36*b1cdbd2cSJim Jagielski import com.sun.star.lang.XComponent; 37*b1cdbd2cSJim Jagielski import com.sun.star.lang.XMultiServiceFactory; 38*b1cdbd2cSJim Jagielski import com.sun.star.sheet.TableFilterField; 39*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XDataPilotDescriptor; 40*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XDataPilotTables; 41*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XDataPilotTablesSupplier; 42*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSheetFilterDescriptor; 43*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheet; 44*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheetDocument; 45*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheets; 46*b1cdbd2cSJim Jagielski import com.sun.star.table.CellAddress; 47*b1cdbd2cSJim Jagielski import com.sun.star.table.CellRangeAddress; 48*b1cdbd2cSJim Jagielski import com.sun.star.uno.AnyConverter; 49*b1cdbd2cSJim Jagielski import com.sun.star.uno.Type; 50*b1cdbd2cSJim Jagielski import com.sun.star.uno.UnoRuntime; 51*b1cdbd2cSJim Jagielski import com.sun.star.uno.XInterface; 52*b1cdbd2cSJim Jagielski 53*b1cdbd2cSJim Jagielski /** 54*b1cdbd2cSJim Jagielski * Test for object which is represented by service 55*b1cdbd2cSJim Jagielski * <code>com.sun.star.sheet.DataPilotTable</code>. <p> 56*b1cdbd2cSJim Jagielski * Object implements the following interfaces : 57*b1cdbd2cSJim Jagielski * <ul> 58*b1cdbd2cSJim Jagielski * <li> <code>com::sun::star::container::XNamed</code></li> 59*b1cdbd2cSJim Jagielski * <li> <code>com::sun::star::sheet::XDataPilotTable</code></li> 60*b1cdbd2cSJim Jagielski * <li> <code>com::sun::star::sheet::XDataPilotDescriptor</code></li> 61*b1cdbd2cSJim Jagielski * </ul> 62*b1cdbd2cSJim Jagielski * @see com.sun.star.sheet.DataPilotTable 63*b1cdbd2cSJim Jagielski * @see com.sun.star.container.XNamed 64*b1cdbd2cSJim Jagielski * @see com.sun.star.sheet.XDataPilotTable 65*b1cdbd2cSJim Jagielski * @see com.sun.star.sheet.XDataPilotDescriptor 66*b1cdbd2cSJim Jagielski * @see ifc.container._XNamed 67*b1cdbd2cSJim Jagielski * @see ifc.sheet._XDataPilotTable 68*b1cdbd2cSJim Jagielski * @see ifc.sheet._XDataPilotDescriptor 69*b1cdbd2cSJim Jagielski */ 70*b1cdbd2cSJim Jagielski public class ScDataPilotTableObj extends TestCase { 71*b1cdbd2cSJim Jagielski static XSpreadsheetDocument xSheetDoc = null; 72*b1cdbd2cSJim Jagielski 73*b1cdbd2cSJim Jagielski /** 74*b1cdbd2cSJim Jagielski * Creates Spreadsheet document. 75*b1cdbd2cSJim Jagielski */ initialize( TestParameters tParam, PrintWriter log )76*b1cdbd2cSJim Jagielski protected void initialize( TestParameters tParam, PrintWriter log ) { 77*b1cdbd2cSJim Jagielski SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory)tParam.getMSF() ); 78*b1cdbd2cSJim Jagielski 79*b1cdbd2cSJim Jagielski try { 80*b1cdbd2cSJim Jagielski log.println( "creating a Spreadsheet document" ); 81*b1cdbd2cSJim Jagielski xSheetDoc = SOF.createCalcDoc(null); 82*b1cdbd2cSJim Jagielski } catch ( com.sun.star.uno.Exception e ) { 83*b1cdbd2cSJim Jagielski // Some exception occures.FAILED 84*b1cdbd2cSJim Jagielski e.printStackTrace( log ); 85*b1cdbd2cSJim Jagielski throw new StatusException( "Couldn't create document", e ); 86*b1cdbd2cSJim Jagielski } 87*b1cdbd2cSJim Jagielski 88*b1cdbd2cSJim Jagielski } 89*b1cdbd2cSJim Jagielski 90*b1cdbd2cSJim Jagielski /** 91*b1cdbd2cSJim Jagielski * Disposes Spreadsheet document. 92*b1cdbd2cSJim Jagielski */ cleanup( TestParameters tParam, PrintWriter log )93*b1cdbd2cSJim Jagielski protected void cleanup( TestParameters tParam, PrintWriter log ) { 94*b1cdbd2cSJim Jagielski log.println( " disposing xSheetDoc " ); 95*b1cdbd2cSJim Jagielski XComponent oComp = (XComponent) 96*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XComponent.class, xSheetDoc) ; 97*b1cdbd2cSJim Jagielski util.DesktopTools.closeDoc(oComp); 98*b1cdbd2cSJim Jagielski } 99*b1cdbd2cSJim Jagielski 100*b1cdbd2cSJim Jagielski /** 101*b1cdbd2cSJim Jagielski * Creating a Testenvironment for the interfaces to be tested. 102*b1cdbd2cSJim Jagielski * Retrieves a collection of spreadsheets from a document 103*b1cdbd2cSJim Jagielski * and takes one of them. Fills some table in the spreadsheet. 104*b1cdbd2cSJim Jagielski * Obtains the collection of data pilot tables using the interface 105*b1cdbd2cSJim Jagielski * <code>XDataPilotTablesSupplier</code>. Creates a data pilot descriptor 106*b1cdbd2cSJim Jagielski * for the filled table. Obtains the collection of all the data pilot fields 107*b1cdbd2cSJim Jagielski * using the interface <code>XDataPilotDescriptor</code>. Sets field 108*b1cdbd2cSJim Jagielski * orientation for every of the data pilot fields. Sets the definitions of 109*b1cdbd2cSJim Jagielski * the filter fields for the created description. Inserts new data pilot 110*b1cdbd2cSJim Jagielski * table with this descriptor to the collection. 111*b1cdbd2cSJim Jagielski * This new data pilot table is the instance of the service 112*b1cdbd2cSJim Jagielski * <code>com.sun.star.sheet.DataPilotTable</code>. 113*b1cdbd2cSJim Jagielski * Object relations created : 114*b1cdbd2cSJim Jagielski * <ul> 115*b1cdbd2cSJim Jagielski * <li> <code>'OUTPUTRANGE'</code> for 116*b1cdbd2cSJim Jagielski * {@link ifc.sheet._XDataPilotTable}(the cell range address of the 117*b1cdbd2cSJim Jagielski * created data pilot table) </li> 118*b1cdbd2cSJim Jagielski * <li> <code>'FIELDSAMOUNT'</code> for 119*b1cdbd2cSJim Jagielski * {@link ifc.sheet._XDataPilotDescriptor}(the number of filled fields 120*b1cdbd2cSJim Jagielski * which descriptor was created for) </li> 121*b1cdbd2cSJim Jagielski * <li> <code>'CELLFORCHANGE'</code> for 122*b1cdbd2cSJim Jagielski * {@link ifc.sheet._XDataPilotTable}(value of this cell will be changed)</li> 123*b1cdbd2cSJim Jagielski * <li> <code>'CELLFORCHECK'</code> for 124*b1cdbd2cSJim Jagielski * {@link ifc.sheet._XDataPilotTable}(value of this cell must be changed 125*b1cdbd2cSJim Jagielski * after refresh call)</li> 126*b1cdbd2cSJim Jagielski * </ul> 127*b1cdbd2cSJim Jagielski * @see com.sun.star.sheet.DataPilotTable 128*b1cdbd2cSJim Jagielski * @see com.sun.star.sheet.XDataPilotTablesSupplier 129*b1cdbd2cSJim Jagielski * @see com.sun.star.sheet.XDataPilotDescriptor 130*b1cdbd2cSJim Jagielski */ createTestEnvironment(TestParameters Param, PrintWriter log)131*b1cdbd2cSJim Jagielski protected synchronized TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) { 132*b1cdbd2cSJim Jagielski 133*b1cdbd2cSJim Jagielski XInterface oObj = null; 134*b1cdbd2cSJim Jagielski 135*b1cdbd2cSJim Jagielski CellAddress sCellAddress = new CellAddress(); 136*b1cdbd2cSJim Jagielski sCellAddress.Sheet = 0; 137*b1cdbd2cSJim Jagielski sCellAddress.Column = 7; 138*b1cdbd2cSJim Jagielski sCellAddress.Row = 8; 139*b1cdbd2cSJim Jagielski 140*b1cdbd2cSJim Jagielski // creation of testobject here 141*b1cdbd2cSJim Jagielski // first we write what we are intend to do to log file 142*b1cdbd2cSJim Jagielski log.println( "Creating a test environment" ); 143*b1cdbd2cSJim Jagielski log.println("getting sheets"); 144*b1cdbd2cSJim Jagielski XSpreadsheets xSpreadsheets = xSheetDoc.getSheets(); 145*b1cdbd2cSJim Jagielski XIndexAccess oIndexAccess = (XIndexAccess) 146*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XIndexAccess.class, xSpreadsheets); 147*b1cdbd2cSJim Jagielski XSpreadsheet oSheet = null; 148*b1cdbd2cSJim Jagielski Object oChangeCell = null; 149*b1cdbd2cSJim Jagielski Object oCheckCell = null; 150*b1cdbd2cSJim Jagielski try { 151*b1cdbd2cSJim Jagielski oSheet = (XSpreadsheet) AnyConverter.toObject( 152*b1cdbd2cSJim Jagielski new Type(XSpreadsheet.class),oIndexAccess.getByIndex(0)); 153*b1cdbd2cSJim Jagielski oChangeCell = oSheet.getCellByPosition(1, 5); 154*b1cdbd2cSJim Jagielski oCheckCell = oSheet.getCellByPosition( 155*b1cdbd2cSJim Jagielski sCellAddress.Column, sCellAddress.Row + 3); 156*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.WrappedTargetException e) { 157*b1cdbd2cSJim Jagielski e.printStackTrace(log); 158*b1cdbd2cSJim Jagielski throw new StatusException( "Couldn't get a spreadsheet", e); 159*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 160*b1cdbd2cSJim Jagielski e.printStackTrace(log); 161*b1cdbd2cSJim Jagielski throw new StatusException( "Couldn't get a spreadsheet", e); 162*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IllegalArgumentException e) { 163*b1cdbd2cSJim Jagielski e.printStackTrace(log); 164*b1cdbd2cSJim Jagielski throw new StatusException( "Couldn't get a spreadsheet", e); 165*b1cdbd2cSJim Jagielski } 166*b1cdbd2cSJim Jagielski log.println("Getting sheet - " + (oSheet == null ? "FAILED" : "OK")); 167*b1cdbd2cSJim Jagielski try { 168*b1cdbd2cSJim Jagielski log.println("Filing a table"); 169*b1cdbd2cSJim Jagielski for (int i = 1; i < 6; i++) { 170*b1cdbd2cSJim Jagielski oSheet.getCellByPosition(0, i).setFormula("Row" + i); 171*b1cdbd2cSJim Jagielski oSheet.getCellByPosition(i, 0).setFormula("Col" + i); 172*b1cdbd2cSJim Jagielski } 173*b1cdbd2cSJim Jagielski 174*b1cdbd2cSJim Jagielski for (int i = 1; i < 6; i++) 175*b1cdbd2cSJim Jagielski for (int j = 1; j < 6; j++) { 176*b1cdbd2cSJim Jagielski oSheet.getCellByPosition(i, j).setValue(2.5 * j + i); 177*b1cdbd2cSJim Jagielski } 178*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 179*b1cdbd2cSJim Jagielski e.printStackTrace(log); 180*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't fill some cells", e); 181*b1cdbd2cSJim Jagielski } 182*b1cdbd2cSJim Jagielski 183*b1cdbd2cSJim Jagielski CellRangeAddress sCellRangeAddress = new CellRangeAddress(); 184*b1cdbd2cSJim Jagielski sCellRangeAddress.Sheet = 0; 185*b1cdbd2cSJim Jagielski sCellRangeAddress.StartColumn = 1; 186*b1cdbd2cSJim Jagielski sCellRangeAddress.StartRow = 0; 187*b1cdbd2cSJim Jagielski sCellRangeAddress.EndColumn = 5; 188*b1cdbd2cSJim Jagielski sCellRangeAddress.EndRow = 5; 189*b1cdbd2cSJim Jagielski 190*b1cdbd2cSJim Jagielski TableFilterField[] filterFields = new TableFilterField[2]; 191*b1cdbd2cSJim Jagielski filterFields[0] = new TableFilterField(); 192*b1cdbd2cSJim Jagielski filterFields[0].Connection = com.sun.star.sheet.FilterConnection.AND; 193*b1cdbd2cSJim Jagielski filterFields[0].Field = 1; 194*b1cdbd2cSJim Jagielski filterFields[0].IsNumeric = true; 195*b1cdbd2cSJim Jagielski filterFields[0].NumericValue = 4; 196*b1cdbd2cSJim Jagielski filterFields[0].Operator = com.sun.star.sheet.FilterOperator.GREATER; 197*b1cdbd2cSJim Jagielski filterFields[1] = new TableFilterField(); 198*b1cdbd2cSJim Jagielski filterFields[1].Connection = com.sun.star.sheet.FilterConnection.AND; 199*b1cdbd2cSJim Jagielski filterFields[1].Field = 1; 200*b1cdbd2cSJim Jagielski filterFields[1].IsNumeric = true; 201*b1cdbd2cSJim Jagielski filterFields[1].NumericValue = 12; 202*b1cdbd2cSJim Jagielski filterFields[1].Operator = com.sun.star.sheet.FilterOperator.LESS_EQUAL; 203*b1cdbd2cSJim Jagielski 204*b1cdbd2cSJim Jagielski XDataPilotTablesSupplier DPTS = (XDataPilotTablesSupplier) 205*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XDataPilotTablesSupplier.class, oSheet); 206*b1cdbd2cSJim Jagielski log.println("Getting test object"); 207*b1cdbd2cSJim Jagielski XDataPilotTables DPT = DPTS.getDataPilotTables(); 208*b1cdbd2cSJim Jagielski XDataPilotDescriptor DPDsc = DPT.createDataPilotDescriptor(); 209*b1cdbd2cSJim Jagielski DPDsc.setSourceRange(sCellRangeAddress); 210*b1cdbd2cSJim Jagielski 211*b1cdbd2cSJim Jagielski XSheetFilterDescriptor SFD = DPDsc.getFilterDescriptor(); 212*b1cdbd2cSJim Jagielski SFD.setFilterFields(filterFields); 213*b1cdbd2cSJim Jagielski 214*b1cdbd2cSJim Jagielski XPropertySet fieldPropSet = null; 215*b1cdbd2cSJim Jagielski try { 216*b1cdbd2cSJim Jagielski Object oDataPilotField = DPDsc.getDataPilotFields().getByIndex(0); 217*b1cdbd2cSJim Jagielski fieldPropSet = (XPropertySet) 218*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XPropertySet.class, oDataPilotField); 219*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.WrappedTargetException e) { 220*b1cdbd2cSJim Jagielski e.printStackTrace(log); 221*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create a test environment", e); 222*b1cdbd2cSJim Jagielski } catch(com.sun.star.lang.IndexOutOfBoundsException e) { 223*b1cdbd2cSJim Jagielski e.printStackTrace(log); 224*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create a test environment", e); 225*b1cdbd2cSJim Jagielski } 226*b1cdbd2cSJim Jagielski 227*b1cdbd2cSJim Jagielski try { 228*b1cdbd2cSJim Jagielski fieldPropSet.setPropertyValue("Function", 229*b1cdbd2cSJim Jagielski com.sun.star.sheet.GeneralFunction.SUM); 230*b1cdbd2cSJim Jagielski fieldPropSet.setPropertyValue("Orientation", 231*b1cdbd2cSJim Jagielski com.sun.star.sheet.DataPilotFieldOrientation.DATA); 232*b1cdbd2cSJim Jagielski } catch(com.sun.star.lang.WrappedTargetException e) { 233*b1cdbd2cSJim Jagielski e.printStackTrace(log); 234*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create a test environment", e); 235*b1cdbd2cSJim Jagielski } catch(com.sun.star.lang.IllegalArgumentException e) { 236*b1cdbd2cSJim Jagielski e.printStackTrace(log); 237*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create a test environment", e); 238*b1cdbd2cSJim Jagielski } catch(com.sun.star.beans.PropertyVetoException e) { 239*b1cdbd2cSJim Jagielski e.printStackTrace(log); 240*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create a test environment", e); 241*b1cdbd2cSJim Jagielski } catch(com.sun.star.beans.UnknownPropertyException e) { 242*b1cdbd2cSJim Jagielski e.printStackTrace(log); 243*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create a test environment", e); 244*b1cdbd2cSJim Jagielski } 245*b1cdbd2cSJim Jagielski 246*b1cdbd2cSJim Jagielski if (DPT.hasByName("DataPilotTable")) { 247*b1cdbd2cSJim Jagielski DPT.removeByName("DataPilotTable"); 248*b1cdbd2cSJim Jagielski } 249*b1cdbd2cSJim Jagielski DPT.insertNewByName("DataPilotTable", sCellAddress, DPDsc); 250*b1cdbd2cSJim Jagielski try { 251*b1cdbd2cSJim Jagielski oObj = (XInterface) AnyConverter.toObject( 252*b1cdbd2cSJim Jagielski new Type(XInterface.class),DPT.getByName(DPT.getElementNames()[0])); 253*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.WrappedTargetException e) { 254*b1cdbd2cSJim Jagielski e.printStackTrace(log); 255*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create a test environment", e); 256*b1cdbd2cSJim Jagielski } catch (com.sun.star.container.NoSuchElementException e) { 257*b1cdbd2cSJim Jagielski e.printStackTrace(log); 258*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create a test environment", e); 259*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IllegalArgumentException e) { 260*b1cdbd2cSJim Jagielski e.printStackTrace(log); 261*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create a test environment", e); 262*b1cdbd2cSJim Jagielski } 263*b1cdbd2cSJim Jagielski 264*b1cdbd2cSJim Jagielski log.println("Creating object - " + 265*b1cdbd2cSJim Jagielski ((oObj == null) ? "FAILED" : "OK")); 266*b1cdbd2cSJim Jagielski 267*b1cdbd2cSJim Jagielski TestEnvironment tEnv = new TestEnvironment( oObj ); 268*b1cdbd2cSJim Jagielski 269*b1cdbd2cSJim Jagielski // Other parameters required for interface tests 270*b1cdbd2cSJim Jagielski tEnv.addObjRelation("OUTPUTRANGE", sCellAddress); 271*b1cdbd2cSJim Jagielski tEnv.addObjRelation("CELLFORCHANGE", oChangeCell); 272*b1cdbd2cSJim Jagielski tEnv.addObjRelation("CELLFORCHECK", oCheckCell); 273*b1cdbd2cSJim Jagielski tEnv.addObjRelation("FIELDSAMOUNT", new Integer(5)); 274*b1cdbd2cSJim Jagielski tEnv.addObjRelation("SHEETDOCUMENT", xSheetDoc); 275*b1cdbd2cSJim Jagielski 276*b1cdbd2cSJim Jagielski createTable2(oSheet, sCellRangeAddress, tEnv); 277*b1cdbd2cSJim Jagielski 278*b1cdbd2cSJim Jagielski return tEnv; 279*b1cdbd2cSJim Jagielski } 280*b1cdbd2cSJim Jagielski 281*b1cdbd2cSJim Jagielski /** 282*b1cdbd2cSJim Jagielski * Create a new DataPilot table output for use with testing XDataPilotTable2 283*b1cdbd2cSJim Jagielski * interface. 284*b1cdbd2cSJim Jagielski * 285*b1cdbd2cSJim Jagielski * @param oSheet current sheet instance 286*b1cdbd2cSJim Jagielski * @param srcRange source range 287*b1cdbd2cSJim Jagielski * @param tEnv test environment instance 288*b1cdbd2cSJim Jagielski */ createTable2(XSpreadsheet oSheet, CellRangeAddress srcRange, TestEnvironment tEnv)289*b1cdbd2cSJim Jagielski private void createTable2(XSpreadsheet oSheet, CellRangeAddress srcRange, TestEnvironment tEnv) 290*b1cdbd2cSJim Jagielski { 291*b1cdbd2cSJim Jagielski XDataPilotTablesSupplier DPTS = (XDataPilotTablesSupplier) 292*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XDataPilotTablesSupplier.class, oSheet); 293*b1cdbd2cSJim Jagielski log.println("Creating test table object"); 294*b1cdbd2cSJim Jagielski XDataPilotTables DPT = DPTS.getDataPilotTables(); 295*b1cdbd2cSJim Jagielski XDataPilotDescriptor DPDsc = DPT.createDataPilotDescriptor(); 296*b1cdbd2cSJim Jagielski DPDsc.setSourceRange(srcRange); 297*b1cdbd2cSJim Jagielski 298*b1cdbd2cSJim Jagielski XIndexAccess xIA = DPDsc.getDataPilotFields(); 299*b1cdbd2cSJim Jagielski int fieldCount = xIA.getCount() - 1; // skip the last field because it's always hidden. 300*b1cdbd2cSJim Jagielski try 301*b1cdbd2cSJim Jagielski { 302*b1cdbd2cSJim Jagielski for (int i = 0; i < fieldCount; ++i) 303*b1cdbd2cSJim Jagielski { 304*b1cdbd2cSJim Jagielski Object o = xIA.getByIndex(i); 305*b1cdbd2cSJim Jagielski XPropertySet fieldPropSet = (XPropertySet)UnoRuntime.queryInterface( 306*b1cdbd2cSJim Jagielski XPropertySet.class, o); 307*b1cdbd2cSJim Jagielski 308*b1cdbd2cSJim Jagielski if (i == fieldCount - 1) 309*b1cdbd2cSJim Jagielski { 310*b1cdbd2cSJim Jagielski // last field 311*b1cdbd2cSJim Jagielski fieldPropSet.setPropertyValue( 312*b1cdbd2cSJim Jagielski "Function", com.sun.star.sheet.GeneralFunction.SUM); 313*b1cdbd2cSJim Jagielski fieldPropSet.setPropertyValue( 314*b1cdbd2cSJim Jagielski "Orientation", com.sun.star.sheet.DataPilotFieldOrientation.DATA); 315*b1cdbd2cSJim Jagielski } 316*b1cdbd2cSJim Jagielski else if (i%2 == 0) 317*b1cdbd2cSJim Jagielski { 318*b1cdbd2cSJim Jagielski // even number fields 319*b1cdbd2cSJim Jagielski fieldPropSet.setPropertyValue( 320*b1cdbd2cSJim Jagielski "Orientation", com.sun.star.sheet.DataPilotFieldOrientation.COLUMN); 321*b1cdbd2cSJim Jagielski } 322*b1cdbd2cSJim Jagielski else if (i%2 == 1) 323*b1cdbd2cSJim Jagielski { 324*b1cdbd2cSJim Jagielski // odd number fields 325*b1cdbd2cSJim Jagielski fieldPropSet.setPropertyValue( 326*b1cdbd2cSJim Jagielski "Orientation", com.sun.star.sheet.DataPilotFieldOrientation.ROW); 327*b1cdbd2cSJim Jagielski } 328*b1cdbd2cSJim Jagielski } 329*b1cdbd2cSJim Jagielski 330*b1cdbd2cSJim Jagielski if (DPT.hasByName("DataPilotTable2")) 331*b1cdbd2cSJim Jagielski DPT.removeByName("DataPilotTable2"); 332*b1cdbd2cSJim Jagielski 333*b1cdbd2cSJim Jagielski CellAddress destAddr = new CellAddress(); 334*b1cdbd2cSJim Jagielski destAddr.Sheet = 0; 335*b1cdbd2cSJim Jagielski destAddr.Column = 0; 336*b1cdbd2cSJim Jagielski destAddr.Row = 14; 337*b1cdbd2cSJim Jagielski DPT.insertNewByName("DataPilotTable2", destAddr, DPDsc); 338*b1cdbd2cSJim Jagielski 339*b1cdbd2cSJim Jagielski Object o = DPT.getByName("DataPilotTable2"); 340*b1cdbd2cSJim Jagielski tEnv.addObjRelation("DATAPILOTTABLE2", o); 341*b1cdbd2cSJim Jagielski } 342*b1cdbd2cSJim Jagielski catch (com.sun.star.uno.Exception e) 343*b1cdbd2cSJim Jagielski { 344*b1cdbd2cSJim Jagielski e.printStackTrace(log); 345*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create a test environment", e); 346*b1cdbd2cSJim Jagielski } 347*b1cdbd2cSJim Jagielski } 348*b1cdbd2cSJim Jagielski 349*b1cdbd2cSJim Jagielski } 350*b1cdbd2cSJim Jagielski 351*b1cdbd2cSJim Jagielski 352