public void _createDateGroup() { boolean result = true; try { DataPilotFieldGroupInfo aInfo = new DataPilotFieldGroupInfo(); aInfo.GroupBy = DataPilotFieldGroupBy.MONTHS; aInfo.HasDateValues = true; oObj.createDateGroup(aInfo); } catch (com.sun.star.lang.IllegalArgumentException e) { log.println("Exception while checking createDateGroup" + e); result = false; } tRes.tested("createDateGroup()", result); }
public void _createNameGroup() { boolean result = true; try { XDataPilotField xDataPilotField = UnoRuntime.queryInterface(XDataPilotField.class, oObj); XNameAccess xNameAccess = UnoRuntime.queryInterface(XNameAccess.class, xDataPilotField.getItems()); String[] elements = xNameAccess.getElementNames(); oObj.createNameGroup(elements); } catch (com.sun.star.lang.IllegalArgumentException e) { log.println("Exception while checking createNameGroup" + e); result = false; } tRes.tested("createNameGroup()", result); }
@Override protected TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) throws Exception { XInterface oObj = null; XInterface datapilotfield = null; // creation of testobject here // first we write what we are intend to do to log file log.println("Creating a test environment"); // the cell range CellRangeAddress sCellRangeAdress = new CellRangeAddress(); sCellRangeAdress.Sheet = 0; sCellRangeAdress.StartColumn = 1; sCellRangeAdress.StartRow = 0; sCellRangeAdress.EndColumn = mMaxFieldIndex - 1; sCellRangeAdress.EndRow = mMaxFieldIndex - 1; // position of the data pilot table CellAddress sCellAdress = new CellAddress(); sCellAdress.Sheet = 0; sCellAdress.Column = 7; sCellAdress.Row = 8; log.println("Getting a sheet"); XSpreadsheets xSpreadsheets = xSheetDoc.getSheets(); XSpreadsheet oSheet = null; XSpreadsheet oSheet2 = null; XIndexAccess oIndexAccess = UnoRuntime.queryInterface(XIndexAccess.class, xSpreadsheets); // Make sure there are at least two sheets xSpreadsheets.insertNewByName("Some Sheet", (short) 0); oSheet = (XSpreadsheet) AnyConverter.toObject(new Type(XSpreadsheet.class), oIndexAccess.getByIndex(0)); oSheet2 = (XSpreadsheet) AnyConverter.toObject(new Type(XSpreadsheet.class), oIndexAccess.getByIndex(1)); log.println("Filling a table"); for (int i = 1; i < mMaxFieldIndex; i++) { oSheet.getCellByPosition(i, 0).setFormula("Col" + i); oSheet.getCellByPosition(0, i).setFormula("Row" + i); oSheet2.getCellByPosition(i, 0).setFormula("Col" + i); oSheet2.getCellByPosition(0, i).setFormula("Row" + i); } for (int i = 1; i < mMaxFieldIndex; i++) { for (int j = 1; j < mMaxFieldIndex; j++) { oSheet.getCellByPosition(i, j).setValue(i * (j + 1)); oSheet2.getCellByPosition(i, j).setValue(i * (j + 2)); } } oSheet.getCellByPosition(1, 1).setFormula("aName"); oSheet.getCellByPosition(1, 2).setFormula("otherName"); oSheet.getCellByPosition(1, 3).setFormula("una"); oSheet.getCellByPosition(1, 4).setFormula("otherName"); oSheet.getCellByPosition(1, 5).setFormula("somethingelse"); oSheet.getCellByPosition(1, 5); int x = sCellAdress.Column; int y = sCellAdress.Row + 3; oSheet.getCellByPosition(x, y); // create the test objects log.println("Getting test objects"); XDataPilotTablesSupplier DPTS = UnoRuntime.queryInterface(XDataPilotTablesSupplier.class, oSheet); XDataPilotTables DPT = DPTS.getDataPilotTables(); XDataPilotDescriptor DPDsc = DPT.createDataPilotDescriptor(); DPDsc.setSourceRange(sCellRangeAdress); XPropertySet fieldPropSet = null; Object oDataPilotField = DPDsc.getDataPilotFields().getByIndex(0); fieldPropSet = UnoRuntime.queryInterface(XPropertySet.class, oDataPilotField); fieldPropSet.setPropertyValue("Orientation", com.sun.star.sheet.DataPilotFieldOrientation.ROW); oDataPilotField = DPDsc.getDataPilotFields().getByIndex(1); fieldPropSet = UnoRuntime.queryInterface(XPropertySet.class, oDataPilotField); fieldPropSet.setPropertyValue("Function", com.sun.star.sheet.GeneralFunction.SUM); fieldPropSet.setPropertyValue("Orientation", com.sun.star.sheet.DataPilotFieldOrientation.DATA); oDataPilotField = DPDsc.getDataPilotFields().getByIndex(2); fieldPropSet = UnoRuntime.queryInterface(XPropertySet.class, oDataPilotField); fieldPropSet.setPropertyValue( "Orientation", com.sun.star.sheet.DataPilotFieldOrientation.COLUMN); log.println("Insert the DataPilotTable"); if (DPT.hasByName("DataPilotTable")) { DPT.removeByName("DataPilotTable"); } DPT.insertNewByName("DataPilotTable", sCellAdress, DPDsc); XIndexAccess xIA = UnoRuntime.queryInterface(XIndexAccess.class, DPTS.getDataPilotTables()); XIndexAccess IA = null; XDataPilotDescriptor xDPT = UnoRuntime.queryInterface(XDataPilotDescriptor.class, xIA.getByIndex(0)); IA = xDPT.getRowFields(); System.out.println("COUNT: " + IA.getCount()); datapilotfield = (XInterface) AnyConverter.toObject(new Type(XInterface.class), IA.getByIndex(0)); try { XDataPilotFieldGrouping dpfg = UnoRuntime.queryInterface(XDataPilotFieldGrouping.class, datapilotfield); String[] elements = new String[] {"aName", "otherName"}; dpfg.createNameGroup(elements); DataPilotFieldGroupInfo dpgi = null; xIA = UnoRuntime.queryInterface(XIndexAccess.class, DPTS.getDataPilotTables()); XDataPilotDescriptor xDPT2 = UnoRuntime.queryInterface(XDataPilotDescriptor.class, xIA.getByIndex(0)); IA = xDPT2.getRowFields(); for (int i = 0; i < IA.getCount(); i++) { datapilotfield = (XInterface) AnyConverter.toObject(new Type(XInterface.class), IA.getByIndex(i)); XPropertySet xPropertySet = UnoRuntime.queryInterface(XPropertySet.class, IA.getByIndex(i)); if (((Boolean) xPropertySet.getPropertyValue("IsGroupField")).booleanValue()) { xPropertySet = UnoRuntime.queryInterface(XPropertySet.class, datapilotfield); XNamed xNamed = UnoRuntime.queryInterface(XNamed.class, IA.getByIndex(i)); System.out.println("name: " + xNamed.getName()); dpgi = (DataPilotFieldGroupInfo) xPropertySet.getPropertyValue("GroupInfo"); } } oObj = dpgi.Groups; } catch (Exception e) { e.printStackTrace(); } log.println("Creating object - " + ((oObj == null) ? "FAILED" : "OK")); TestEnvironment tEnv = new TestEnvironment(oObj); log.println("Implementationname: " + util.utils.getImplName(oObj)); // Other parameters required for interface tests return tEnv; }