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.DataPilotFieldOrientation; 31*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XDataPilotDescriptor; 32*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XDataPilotTables; 33*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XDataPilotTablesSupplier; 34*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheet; 35*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheetDocument; 36*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheets; 37*b1cdbd2cSJim Jagielski import com.sun.star.table.CellAddress; 38*b1cdbd2cSJim Jagielski import com.sun.star.table.CellRangeAddress; 39*b1cdbd2cSJim Jagielski import com.sun.star.uno.AnyConverter; 40*b1cdbd2cSJim Jagielski import com.sun.star.uno.Type; 41*b1cdbd2cSJim Jagielski import com.sun.star.uno.UnoRuntime; 42*b1cdbd2cSJim Jagielski import com.sun.star.uno.XInterface; 43*b1cdbd2cSJim Jagielski 44*b1cdbd2cSJim Jagielski import java.io.PrintWriter; 45*b1cdbd2cSJim Jagielski 46*b1cdbd2cSJim Jagielski import lib.StatusException; 47*b1cdbd2cSJim Jagielski import lib.TestCase; 48*b1cdbd2cSJim Jagielski import lib.TestEnvironment; 49*b1cdbd2cSJim Jagielski import lib.TestParameters; 50*b1cdbd2cSJim Jagielski 51*b1cdbd2cSJim Jagielski import util.SOfficeFactory; 52*b1cdbd2cSJim Jagielski 53*b1cdbd2cSJim Jagielski 54*b1cdbd2cSJim Jagielski /** 55*b1cdbd2cSJim Jagielski * Test for object which is represented by service 56*b1cdbd2cSJim Jagielski * <code>com.sun.star.sheet.DataPilotField</code>. <p> 57*b1cdbd2cSJim Jagielski * Object implements the following interfaces : 58*b1cdbd2cSJim Jagielski * <ul> 59*b1cdbd2cSJim Jagielski * <li> <code>com::sun::star::container::XNamed</code></li> 60*b1cdbd2cSJim Jagielski * <li> <code>com::sun::star::sheet::DataPilotField</code></li> 61*b1cdbd2cSJim Jagielski * <li> <code>com::sun::star::beans::XPropertySet</code></li> 62*b1cdbd2cSJim Jagielski * </ul> 63*b1cdbd2cSJim Jagielski * @see com.sun.star.sheet.DataPilotField 64*b1cdbd2cSJim Jagielski * @see com.sun.star.container.XNamed 65*b1cdbd2cSJim Jagielski * @see com.sun.star.sheet.DataPilotField 66*b1cdbd2cSJim Jagielski * @see com.sun.star.beans.XPropertySet 67*b1cdbd2cSJim Jagielski * @see ifc.container._XNamed 68*b1cdbd2cSJim Jagielski * @see ifc.sheet._DataPilotField 69*b1cdbd2cSJim Jagielski * @see ifc.beans._XPropertySet 70*b1cdbd2cSJim Jagielski */ 71*b1cdbd2cSJim Jagielski public class ScDataPilotFieldObj extends TestCase { 72*b1cdbd2cSJim Jagielski static XSpreadsheetDocument xSheetDoc = null; 73*b1cdbd2cSJim Jagielski 74*b1cdbd2cSJim Jagielski /** 75*b1cdbd2cSJim Jagielski * A field is filled some values. This integer determines the size of the 76*b1cdbd2cSJim Jagielski * field in x and y direction. 77*b1cdbd2cSJim Jagielski */ 78*b1cdbd2cSJim Jagielski private int mMaxFieldIndex = 6; 79*b1cdbd2cSJim Jagielski 80*b1cdbd2cSJim Jagielski /** 81*b1cdbd2cSJim Jagielski * Creates Spreadsheet document. 82*b1cdbd2cSJim Jagielski */ initialize(TestParameters tParam, PrintWriter log)83*b1cdbd2cSJim Jagielski protected void initialize(TestParameters tParam, PrintWriter log) { 84*b1cdbd2cSJim Jagielski SOfficeFactory SOF = SOfficeFactory.getFactory( 85*b1cdbd2cSJim Jagielski (XMultiServiceFactory) tParam.getMSF()); 86*b1cdbd2cSJim Jagielski 87*b1cdbd2cSJim Jagielski try { 88*b1cdbd2cSJim Jagielski log.println("creating a Spreadsheet document"); 89*b1cdbd2cSJim Jagielski xSheetDoc = SOF.createCalcDoc(null); 90*b1cdbd2cSJim Jagielski } catch (com.sun.star.uno.Exception e) { 91*b1cdbd2cSJim Jagielski // Some exception occures.FAILED 92*b1cdbd2cSJim Jagielski e.printStackTrace(log); 93*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create document", e); 94*b1cdbd2cSJim Jagielski } 95*b1cdbd2cSJim Jagielski } 96*b1cdbd2cSJim Jagielski 97*b1cdbd2cSJim Jagielski /** 98*b1cdbd2cSJim Jagielski * Disposes Spreadsheet document. 99*b1cdbd2cSJim Jagielski */ cleanup(TestParameters tParam, PrintWriter log)100*b1cdbd2cSJim Jagielski protected void cleanup(TestParameters tParam, PrintWriter log) { 101*b1cdbd2cSJim Jagielski log.println(" disposing xSheetDoc "); 102*b1cdbd2cSJim Jagielski 103*b1cdbd2cSJim Jagielski XComponent oComp = (XComponent) UnoRuntime.queryInterface( 104*b1cdbd2cSJim Jagielski XComponent.class, xSheetDoc); 105*b1cdbd2cSJim Jagielski util.DesktopTools.closeDoc(oComp); 106*b1cdbd2cSJim Jagielski } 107*b1cdbd2cSJim Jagielski 108*b1cdbd2cSJim Jagielski /** 109*b1cdbd2cSJim Jagielski * Creating a Testenvironment for the interfaces to be tested. 110*b1cdbd2cSJim Jagielski * Retrieves a collection of spreadsheets from a document 111*b1cdbd2cSJim Jagielski * and takes one of them. Fills some table in the spreadsheet. 112*b1cdbd2cSJim Jagielski * Obtains the collection of data pilot tables using the interface 113*b1cdbd2cSJim Jagielski * <code>XDataPilotTablesSupplier</code>. Creates a data pilot descriptor 114*b1cdbd2cSJim Jagielski * for the filled table and inserts new data pilot table with this descriptor 115*b1cdbd2cSJim Jagielski * to the collection. Obtains the collection of all the data pilot fields 116*b1cdbd2cSJim Jagielski * using the interface <code>XDataPilotDescriptor</code>. Retrieves from 117*b1cdbd2cSJim Jagielski * the collection the data pilot field with index 0. This data pilot field 118*b1cdbd2cSJim Jagielski * is the instance of the service <code>com.sun.star.sheet.DataPilotField</code>. 119*b1cdbd2cSJim Jagielski * @see com.sun.star.sheet.DataPilotField 120*b1cdbd2cSJim Jagielski * @see com.sun.star.sheet.XDataPilotTablesSupplier 121*b1cdbd2cSJim Jagielski * @see com.sun.star.sheet.XDataPilotDescriptor 122*b1cdbd2cSJim Jagielski */ createTestEnvironment(TestParameters Param, PrintWriter log)123*b1cdbd2cSJim Jagielski protected synchronized TestEnvironment createTestEnvironment(TestParameters Param, 124*b1cdbd2cSJim Jagielski PrintWriter log) { 125*b1cdbd2cSJim Jagielski XInterface oObj = null; 126*b1cdbd2cSJim Jagielski 127*b1cdbd2cSJim Jagielski 128*b1cdbd2cSJim Jagielski // creation of testobject here 129*b1cdbd2cSJim Jagielski // first we write what we are intend to do to log file 130*b1cdbd2cSJim Jagielski log.println("Creating a test environment"); 131*b1cdbd2cSJim Jagielski 132*b1cdbd2cSJim Jagielski // the cell range 133*b1cdbd2cSJim Jagielski CellRangeAddress sCellRangeAdress = new CellRangeAddress(); 134*b1cdbd2cSJim Jagielski sCellRangeAdress.Sheet = 0; 135*b1cdbd2cSJim Jagielski sCellRangeAdress.StartColumn = 1; 136*b1cdbd2cSJim Jagielski sCellRangeAdress.StartRow = 0; 137*b1cdbd2cSJim Jagielski sCellRangeAdress.EndColumn = mMaxFieldIndex - 1; 138*b1cdbd2cSJim Jagielski sCellRangeAdress.EndRow = mMaxFieldIndex - 1; 139*b1cdbd2cSJim Jagielski 140*b1cdbd2cSJim Jagielski // position of the data pilot table 141*b1cdbd2cSJim Jagielski CellAddress sCellAdress = new CellAddress(); 142*b1cdbd2cSJim Jagielski sCellAdress.Sheet = 0; 143*b1cdbd2cSJim Jagielski sCellAdress.Column = 7; 144*b1cdbd2cSJim Jagielski sCellAdress.Row = 8; 145*b1cdbd2cSJim Jagielski 146*b1cdbd2cSJim Jagielski log.println("Getting a sheet"); 147*b1cdbd2cSJim Jagielski 148*b1cdbd2cSJim Jagielski XSpreadsheets xSpreadsheets = (XSpreadsheets) xSheetDoc.getSheets(); 149*b1cdbd2cSJim Jagielski XSpreadsheet oSheet = null; 150*b1cdbd2cSJim Jagielski XSpreadsheet oSheet2 = null; 151*b1cdbd2cSJim Jagielski XIndexAccess oIndexAccess = (XIndexAccess) UnoRuntime.queryInterface( 152*b1cdbd2cSJim Jagielski XIndexAccess.class, xSpreadsheets); 153*b1cdbd2cSJim Jagielski 154*b1cdbd2cSJim Jagielski try { 155*b1cdbd2cSJim Jagielski oSheet = (XSpreadsheet) AnyConverter.toObject( 156*b1cdbd2cSJim Jagielski new Type(XSpreadsheet.class), 157*b1cdbd2cSJim Jagielski oIndexAccess.getByIndex(0)); 158*b1cdbd2cSJim Jagielski oSheet2 = (XSpreadsheet) AnyConverter.toObject( 159*b1cdbd2cSJim Jagielski new Type(XSpreadsheet.class), 160*b1cdbd2cSJim Jagielski oIndexAccess.getByIndex(1)); 161*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.WrappedTargetException e) { 162*b1cdbd2cSJim Jagielski e.printStackTrace(); 163*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't get a spreadsheet", e); 164*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 165*b1cdbd2cSJim Jagielski e.printStackTrace(); 166*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't get a spreadsheet", e); 167*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IllegalArgumentException e) { 168*b1cdbd2cSJim Jagielski e.printStackTrace(); 169*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't get a spreadsheet", e); 170*b1cdbd2cSJim Jagielski } 171*b1cdbd2cSJim Jagielski 172*b1cdbd2cSJim Jagielski try { 173*b1cdbd2cSJim Jagielski log.println("Filling a table"); 174*b1cdbd2cSJim Jagielski 175*b1cdbd2cSJim Jagielski for (int i = 1; i < mMaxFieldIndex; i++) { 176*b1cdbd2cSJim Jagielski oSheet.getCellByPosition(i, 0).setFormula("Col" + i); 177*b1cdbd2cSJim Jagielski oSheet.getCellByPosition(0, i).setFormula("Row" + i); 178*b1cdbd2cSJim Jagielski oSheet2.getCellByPosition(i, 0).setFormula("Col" + i); 179*b1cdbd2cSJim Jagielski oSheet2.getCellByPosition(0, i).setFormula("Row" + i); 180*b1cdbd2cSJim Jagielski } 181*b1cdbd2cSJim Jagielski 182*b1cdbd2cSJim Jagielski for (int i = 1; i < mMaxFieldIndex; i++) 183*b1cdbd2cSJim Jagielski for (int j = 1; j < mMaxFieldIndex; j++) { 184*b1cdbd2cSJim Jagielski oSheet.getCellByPosition(i, j).setValue(i * (j + 1)); 185*b1cdbd2cSJim Jagielski oSheet2.getCellByPosition(i, j).setValue(i * (j + 2)); 186*b1cdbd2cSJim Jagielski } 187*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 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 // 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 } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 210*b1cdbd2cSJim Jagielski e.printStackTrace(); 211*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't get cells for changeing.", e); 212*b1cdbd2cSJim Jagielski } 213*b1cdbd2cSJim Jagielski 214*b1cdbd2cSJim Jagielski 215*b1cdbd2cSJim Jagielski // create the test objects 216*b1cdbd2cSJim Jagielski log.println("Getting test objects"); 217*b1cdbd2cSJim Jagielski 218*b1cdbd2cSJim Jagielski XDataPilotTablesSupplier DPTS = (XDataPilotTablesSupplier) UnoRuntime.queryInterface( 219*b1cdbd2cSJim Jagielski XDataPilotTablesSupplier.class, 220*b1cdbd2cSJim Jagielski oSheet); 221*b1cdbd2cSJim Jagielski XDataPilotTables DPT = DPTS.getDataPilotTables(); 222*b1cdbd2cSJim Jagielski XDataPilotDescriptor DPDsc = DPT.createDataPilotDescriptor(); 223*b1cdbd2cSJim Jagielski DPDsc.setSourceRange(sCellRangeAdress); 224*b1cdbd2cSJim Jagielski 225*b1cdbd2cSJim Jagielski XPropertySet fieldPropSet = null; 226*b1cdbd2cSJim Jagielski 227*b1cdbd2cSJim Jagielski try { 228*b1cdbd2cSJim Jagielski Object oDataPilotField = DPDsc.getDataPilotFields().getByIndex(0); 229*b1cdbd2cSJim Jagielski fieldPropSet = (XPropertySet) UnoRuntime.queryInterface( 230*b1cdbd2cSJim Jagielski XPropertySet.class, oDataPilotField); 231*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.WrappedTargetException e) { 232*b1cdbd2cSJim Jagielski e.printStackTrace(); 233*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create a test environment", e); 234*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 235*b1cdbd2cSJim Jagielski e.printStackTrace(); 236*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create a test environment", e); 237*b1cdbd2cSJim Jagielski } 238*b1cdbd2cSJim Jagielski 239*b1cdbd2cSJim Jagielski try { 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 } catch (com.sun.star.lang.WrappedTargetException e) { 245*b1cdbd2cSJim Jagielski e.printStackTrace(); 246*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create a test environment", e); 247*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IllegalArgumentException e) { 248*b1cdbd2cSJim Jagielski e.printStackTrace(); 249*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create a test environment", e); 250*b1cdbd2cSJim Jagielski } catch (com.sun.star.beans.PropertyVetoException e) { 251*b1cdbd2cSJim Jagielski e.printStackTrace(); 252*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create a test environment", e); 253*b1cdbd2cSJim Jagielski } catch (com.sun.star.beans.UnknownPropertyException e) { 254*b1cdbd2cSJim Jagielski e.printStackTrace(); 255*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create a test environment", e); 256*b1cdbd2cSJim Jagielski } 257*b1cdbd2cSJim Jagielski 258*b1cdbd2cSJim Jagielski log.println("Insert the DataPilotTable"); 259*b1cdbd2cSJim Jagielski 260*b1cdbd2cSJim Jagielski if (DPT.hasByName("DataPilotTable")) { 261*b1cdbd2cSJim Jagielski DPT.removeByName("DataPilotTable"); 262*b1cdbd2cSJim Jagielski } 263*b1cdbd2cSJim Jagielski 264*b1cdbd2cSJim Jagielski XIndexAccess IA = DPDsc.getDataPilotFields(); 265*b1cdbd2cSJim Jagielski getSRange(IA); 266*b1cdbd2cSJim Jagielski 267*b1cdbd2cSJim Jagielski DPT.insertNewByName("DataPilotTable", sCellAdress, DPDsc); 268*b1cdbd2cSJim Jagielski 269*b1cdbd2cSJim Jagielski try { 270*b1cdbd2cSJim Jagielski oObj = (XInterface) AnyConverter.toObject( 271*b1cdbd2cSJim Jagielski new Type(XInterface.class), IA.getByIndex(0)); 272*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.WrappedTargetException e) { 273*b1cdbd2cSJim Jagielski e.printStackTrace(); 274*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't get data pilot field", e); 275*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 276*b1cdbd2cSJim Jagielski e.printStackTrace(); 277*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't get data pilot field", e); 278*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IllegalArgumentException e) { 279*b1cdbd2cSJim Jagielski e.printStackTrace(); 280*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't get data pilot field", e); 281*b1cdbd2cSJim Jagielski } 282*b1cdbd2cSJim Jagielski 283*b1cdbd2cSJim Jagielski log.println("Creating object - " + 284*b1cdbd2cSJim Jagielski ((oObj == null) ? "FAILED" : "OK")); 285*b1cdbd2cSJim Jagielski 286*b1cdbd2cSJim Jagielski TestEnvironment tEnv = new TestEnvironment(oObj); 287*b1cdbd2cSJim Jagielski 288*b1cdbd2cSJim Jagielski log.println("Implementationname: " + util.utils.getImplName(oObj)); 289*b1cdbd2cSJim Jagielski 290*b1cdbd2cSJim Jagielski // Other parameters required for interface tests 291*b1cdbd2cSJim Jagielski return tEnv; 292*b1cdbd2cSJim Jagielski } 293*b1cdbd2cSJim Jagielski getSRange(XIndexAccess IA)294*b1cdbd2cSJim Jagielski private void getSRange(XIndexAccess IA) { 295*b1cdbd2cSJim Jagielski int fieldsAmount = IA.getCount() + 1; 296*b1cdbd2cSJim Jagielski 297*b1cdbd2cSJim Jagielski String[] fieldsNames = new String[fieldsAmount]; 298*b1cdbd2cSJim Jagielski 299*b1cdbd2cSJim Jagielski int i = -1; 300*b1cdbd2cSJim Jagielski int cnt = 0; 301*b1cdbd2cSJim Jagielski 302*b1cdbd2cSJim Jagielski while ((++i) < fieldsAmount) { 303*b1cdbd2cSJim Jagielski Object field; 304*b1cdbd2cSJim Jagielski 305*b1cdbd2cSJim Jagielski try { 306*b1cdbd2cSJim Jagielski field = IA.getByIndex(i); 307*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.WrappedTargetException e) { 308*b1cdbd2cSJim Jagielski e.printStackTrace(log); 309*b1cdbd2cSJim Jagielski 310*b1cdbd2cSJim Jagielski return; 311*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 312*b1cdbd2cSJim Jagielski e.printStackTrace(log); 313*b1cdbd2cSJim Jagielski 314*b1cdbd2cSJim Jagielski return; 315*b1cdbd2cSJim Jagielski } 316*b1cdbd2cSJim Jagielski 317*b1cdbd2cSJim Jagielski XNamed named = (XNamed) UnoRuntime.queryInterface(XNamed.class, 318*b1cdbd2cSJim Jagielski field); 319*b1cdbd2cSJim Jagielski String name = named.getName(); 320*b1cdbd2cSJim Jagielski 321*b1cdbd2cSJim Jagielski log.println("**Field : '" + name + "' ... "); 322*b1cdbd2cSJim Jagielski 323*b1cdbd2cSJim Jagielski if (!name.equals("Data")) { 324*b1cdbd2cSJim Jagielski fieldsNames[cnt] = name; 325*b1cdbd2cSJim Jagielski 326*b1cdbd2cSJim Jagielski XPropertySet props = (XPropertySet) UnoRuntime.queryInterface( 327*b1cdbd2cSJim Jagielski XPropertySet.class, field); 328*b1cdbd2cSJim Jagielski 329*b1cdbd2cSJim Jagielski try { 330*b1cdbd2cSJim Jagielski switch (cnt % 5) { 331*b1cdbd2cSJim Jagielski case 0: 332*b1cdbd2cSJim Jagielski props.setPropertyValue("Orientation", 333*b1cdbd2cSJim Jagielski DataPilotFieldOrientation.COLUMN); 334*b1cdbd2cSJim Jagielski log.println(" Column"); 335*b1cdbd2cSJim Jagielski 336*b1cdbd2cSJim Jagielski break; 337*b1cdbd2cSJim Jagielski 338*b1cdbd2cSJim Jagielski case 1: 339*b1cdbd2cSJim Jagielski props.setPropertyValue("Orientation", 340*b1cdbd2cSJim Jagielski DataPilotFieldOrientation.ROW); 341*b1cdbd2cSJim Jagielski log.println(" Row"); 342*b1cdbd2cSJim Jagielski 343*b1cdbd2cSJim Jagielski break; 344*b1cdbd2cSJim Jagielski 345*b1cdbd2cSJim Jagielski case 2: 346*b1cdbd2cSJim Jagielski props.setPropertyValue("Orientation", 347*b1cdbd2cSJim Jagielski DataPilotFieldOrientation.DATA); 348*b1cdbd2cSJim Jagielski log.println(" Data"); 349*b1cdbd2cSJim Jagielski 350*b1cdbd2cSJim Jagielski break; 351*b1cdbd2cSJim Jagielski 352*b1cdbd2cSJim Jagielski case 3: 353*b1cdbd2cSJim Jagielski props.setPropertyValue("Orientation", 354*b1cdbd2cSJim Jagielski DataPilotFieldOrientation.HIDDEN); 355*b1cdbd2cSJim Jagielski log.println(" Hidden"); 356*b1cdbd2cSJim Jagielski 357*b1cdbd2cSJim Jagielski break; 358*b1cdbd2cSJim Jagielski 359*b1cdbd2cSJim Jagielski case 4: 360*b1cdbd2cSJim Jagielski props.setPropertyValue("Orientation", 361*b1cdbd2cSJim Jagielski DataPilotFieldOrientation.PAGE); 362*b1cdbd2cSJim Jagielski log.println(" Page"); 363*b1cdbd2cSJim Jagielski 364*b1cdbd2cSJim Jagielski break; 365*b1cdbd2cSJim Jagielski } 366*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.WrappedTargetException e) { 367*b1cdbd2cSJim Jagielski e.printStackTrace(log); 368*b1cdbd2cSJim Jagielski 369*b1cdbd2cSJim Jagielski return; 370*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IllegalArgumentException e) { 371*b1cdbd2cSJim Jagielski e.printStackTrace(log); 372*b1cdbd2cSJim Jagielski 373*b1cdbd2cSJim Jagielski return; 374*b1cdbd2cSJim Jagielski } catch (com.sun.star.beans.PropertyVetoException e) { 375*b1cdbd2cSJim Jagielski e.printStackTrace(log); 376*b1cdbd2cSJim Jagielski 377*b1cdbd2cSJim Jagielski return; 378*b1cdbd2cSJim Jagielski } catch (com.sun.star.beans.UnknownPropertyException e) { 379*b1cdbd2cSJim Jagielski e.printStackTrace(log); 380*b1cdbd2cSJim Jagielski 381*b1cdbd2cSJim Jagielski return; 382*b1cdbd2cSJim Jagielski } 383*b1cdbd2cSJim Jagielski 384*b1cdbd2cSJim Jagielski if ((++cnt) > 4) { 385*b1cdbd2cSJim Jagielski break; 386*b1cdbd2cSJim Jagielski } 387*b1cdbd2cSJim Jagielski } else { 388*b1cdbd2cSJim Jagielski return; 389*b1cdbd2cSJim Jagielski } 390*b1cdbd2cSJim Jagielski } 391*b1cdbd2cSJim Jagielski } 392*b1cdbd2cSJim Jagielski } 393