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