diff options
Diffstat (limited to 'qadevOOo/tests/java/mod/_sc/ScDataPilotFieldGroupsObj.java')
| -rw-r--r-- | qadevOOo/tests/java/mod/_sc/ScDataPilotFieldGroupsObj.java | 367 |
1 files changed, 367 insertions, 0 deletions
diff --git a/qadevOOo/tests/java/mod/_sc/ScDataPilotFieldGroupsObj.java b/qadevOOo/tests/java/mod/_sc/ScDataPilotFieldGroupsObj.java new file mode 100644 index 000000000000..152c1d82a09a --- /dev/null +++ b/qadevOOo/tests/java/mod/_sc/ScDataPilotFieldGroupsObj.java @@ -0,0 +1,367 @@ +/************************************************************************* + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************/ +package mod._sc; + +import com.sun.star.beans.XPropertySet; +import com.sun.star.container.XIndexAccess; +import com.sun.star.container.XNamed; +import com.sun.star.lang.XComponent; +import com.sun.star.lang.XMultiServiceFactory; +import com.sun.star.sheet.DataPilotFieldGroupInfo; +import com.sun.star.sheet.XDataPilotDescriptor; +import com.sun.star.sheet.XDataPilotFieldGrouping; +import com.sun.star.sheet.XDataPilotTables; +import com.sun.star.sheet.XDataPilotTablesSupplier; +import com.sun.star.sheet.XSpreadsheet; +import com.sun.star.sheet.XSpreadsheetDocument; +import com.sun.star.sheet.XSpreadsheets; +import com.sun.star.table.CellAddress; +import com.sun.star.table.CellRangeAddress; +import com.sun.star.uno.AnyConverter; +import com.sun.star.uno.Type; +import com.sun.star.uno.UnoRuntime; +import com.sun.star.uno.XInterface; + +import java.io.PrintWriter; + +import lib.StatusException; +import lib.TestCase; +import lib.TestEnvironment; +import lib.TestParameters; + +import util.SOfficeFactory; + + + +public class ScDataPilotFieldGroupsObj extends TestCase +{ + static XSpreadsheetDocument xSheetDoc = null; + + /** + * A field is filled some values. This integer determines the size of the + * field in x and y direction. + */ + private int mMaxFieldIndex = 6; + + /** + * Creates Spreadsheet document. + */ + protected void initialize (TestParameters tParam, PrintWriter log) + { + SOfficeFactory SOF = SOfficeFactory.getFactory ( + (XMultiServiceFactory) tParam.getMSF ()); + + try + { + log.println ("creating a Spreadsheet document"); + xSheetDoc = SOF.createCalcDoc (null); + } + catch (com.sun.star.uno.Exception e) + { + // Some exception occures.FAILED + e.printStackTrace (log); + throw new StatusException ("Couldn't create document", e); + } + } + + /** + * Disposes Spreadsheet document. + */ + protected void cleanup (TestParameters tParam, PrintWriter log) + { + log.println (" disposing xSheetDoc "); + + XComponent oComp = (XComponent) UnoRuntime.queryInterface ( + XComponent.class, xSheetDoc); + util.DesktopTools.closeDoc (oComp); + } + + protected synchronized TestEnvironment createTestEnvironment (TestParameters Param, + PrintWriter log) + { + 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 = (XSpreadsheets) xSheetDoc.getSheets (); + XSpreadsheet oSheet = null; + XSpreadsheet oSheet2 = null; + XIndexAccess oIndexAccess = (XIndexAccess) UnoRuntime.queryInterface ( + XIndexAccess.class, xSpreadsheets); + + try + { + oSheet = (XSpreadsheet) AnyConverter.toObject ( + new Type (XSpreadsheet.class), + oIndexAccess.getByIndex (0)); + oSheet2 = (XSpreadsheet) AnyConverter.toObject ( + new Type (XSpreadsheet.class), + oIndexAccess.getByIndex (1)); + } + catch (com.sun.star.lang.WrappedTargetException e) + { + e.printStackTrace (); + throw new StatusException ("Couldn't get a spreadsheet", e); + } + catch (com.sun.star.lang.IndexOutOfBoundsException e) + { + e.printStackTrace (); + throw new StatusException ("Couldn't get a spreadsheet", e); + } + catch (com.sun.star.lang.IllegalArgumentException e) + { + e.printStackTrace (); + throw new StatusException ("Couldn't get a spreadsheet", e); + } + + try + { + 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"); + + } + catch (com.sun.star.lang.IndexOutOfBoundsException e) + { + e.printStackTrace (); + throw new StatusException ("Couldn't fill some cells", e); + } + + // change a value of a cell and check the change in the data pilot + // (for the XDataPilotTable.refresh() test) + Object oChangeCell = null; + Object oCheckCell = null; + Integer aChangeValue = null; + + try + { + // cell of data + oChangeCell = oSheet.getCellByPosition (1, 5); + + int x = sCellAdress.Column; + int y = sCellAdress.Row + 3; + + + // cell of the data pilot output + oCheckCell = oSheet.getCellByPosition (x, y); + aChangeValue = new Integer (27); + } + catch (com.sun.star.lang.IndexOutOfBoundsException e) + { + e.printStackTrace (); + throw new StatusException ("Couldn't get cells for changeing.", e); + } + + + // create the test objects + log.println ("Getting test objects"); + + XDataPilotTablesSupplier DPTS = (XDataPilotTablesSupplier) UnoRuntime.queryInterface ( + XDataPilotTablesSupplier.class, + oSheet); + XDataPilotTables DPT = DPTS.getDataPilotTables (); + XDataPilotDescriptor DPDsc = DPT.createDataPilotDescriptor (); + DPDsc.setSourceRange (sCellRangeAdress); + + XPropertySet fieldPropSet = null; + + try + { + Object oDataPilotField = DPDsc.getDataPilotFields ().getByIndex (0); + fieldPropSet = (XPropertySet) UnoRuntime.queryInterface ( + XPropertySet.class, oDataPilotField); + fieldPropSet.setPropertyValue ("Orientation", + com.sun.star.sheet.DataPilotFieldOrientation.ROW); + oDataPilotField = DPDsc.getDataPilotFields ().getByIndex (1); + fieldPropSet = (XPropertySet) 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 = (XPropertySet) UnoRuntime.queryInterface ( + XPropertySet.class, oDataPilotField); + fieldPropSet.setPropertyValue ("Orientation", + com.sun.star.sheet.DataPilotFieldOrientation.COLUMN); + } + catch (com.sun.star.lang.WrappedTargetException e) + { + e.printStackTrace (); + throw new StatusException ("Couldn't create a test environment", e); + } + catch (com.sun.star.lang.IllegalArgumentException e) + { + e.printStackTrace (); + throw new StatusException ("Couldn't create a test environment", e); + } + catch (com.sun.star.beans.PropertyVetoException e) + { + e.printStackTrace (); + throw new StatusException ("Couldn't create a test environment", e); + } + catch (com.sun.star.beans.UnknownPropertyException e) + { + e.printStackTrace (); + throw new StatusException ("Couldn't create a test environment", e); + } + catch (com.sun.star.lang.IndexOutOfBoundsException e) + { + e.printStackTrace (); + throw new StatusException ("Couldn't create a test environment", e); + } + + log.println ("Insert the DataPilotTable"); + + if (DPT.hasByName ("DataPilotTable")) + { + DPT.removeByName ("DataPilotTable"); + } + + DPT.insertNewByName ("DataPilotTable", sCellAdress, DPDsc); + XIndexAccess xIA = (XIndexAccess) UnoRuntime.queryInterface (XIndexAccess.class,DPTS.getDataPilotTables ()); + XIndexAccess IA = null; + try + { + XDataPilotDescriptor xDPT = (XDataPilotDescriptor) UnoRuntime.queryInterface (XDataPilotDescriptor.class,xIA.getByIndex (0)); + IA = xDPT.getRowFields (); + //getSRange(IA); + System.out.println ("COUNT: "+IA.getCount ()); + datapilotfield = (XInterface) AnyConverter.toObject ( + new Type (XInterface.class), IA.getByIndex (0)); + } + catch (com.sun.star.lang.WrappedTargetException e) + { + e.printStackTrace (); + throw new StatusException ("Couldn't get data pilot field", e); + } + catch (com.sun.star.lang.IndexOutOfBoundsException e) + { + e.printStackTrace (); + throw new StatusException ("Couldn't get data pilot field", e); + } + catch (com.sun.star.lang.IllegalArgumentException e) + { + e.printStackTrace (); + throw new StatusException ("Couldn't get data pilot field", e); + } + + try + { + XDataPilotFieldGrouping dpfg = (XDataPilotFieldGrouping) UnoRuntime.queryInterface (XDataPilotFieldGrouping.class, datapilotfield); + String[] elements = new String[]{"aName","otherName"}; + dpfg.createNameGroup (elements); + DataPilotFieldGroupInfo dpgi=null; + xIA = (XIndexAccess) UnoRuntime.queryInterface (XIndexAccess.class,DPTS.getDataPilotTables ()); + try + { + XDataPilotDescriptor xDPT = (XDataPilotDescriptor) UnoRuntime.queryInterface (XDataPilotDescriptor.class,xIA.getByIndex (0)); + IA = xDPT.getRowFields (); + } + catch (com.sun.star.lang.WrappedTargetException e) + { + e.printStackTrace (); + throw new StatusException ("Couldn't get data pilot field", e); + } + catch (com.sun.star.lang.IndexOutOfBoundsException e) + { + e.printStackTrace (); + throw new StatusException ("Couldn't get data pilot field", e); + } + for (int i=0;i<IA.getCount ();i++) + { + datapilotfield = (XInterface) AnyConverter.toObject ( + new Type (XInterface.class), IA.getByIndex (i)); + XPropertySet xPropertySet = (XPropertySet) UnoRuntime.queryInterface (XPropertySet.class, IA.getByIndex (i)); + if (((Boolean)xPropertySet.getPropertyValue ("IsGroupField")).booleanValue ()) + { + xPropertySet = (XPropertySet) UnoRuntime.queryInterface (XPropertySet.class, datapilotfield); + XNamed 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; + } + +} |