| /************************************************************** |
| * |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| * |
| *************************************************************/ |
| |
| |
| |
| package complex.dataPilot; |
| |
| import com.sun.star.beans.XPropertySet; |
| import com.sun.star.container.XIndexAccess; |
| import com.sun.star.container.XNamed; |
| import com.sun.star.lang.XMultiServiceFactory; |
| // import com.sun.star.sheet.TableFilterField; |
| import com.sun.star.sheet.XDataPilotDescriptor; |
| import com.sun.star.sheet.XDataPilotTable; |
| import com.sun.star.sheet.XDataPilotTables; |
| import com.sun.star.sheet.XDataPilotTablesSupplier; |
| // import com.sun.star.sheet.XSheetFilterDescriptor; |
| 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 com.sun.star.util.XCloseable; |
| import complex.dataPilot._XPropertySet; |
| import complex.dataPilot._XNamed; |
| import complex.dataPilot._XDataPilotDescriptor; |
| import complex.dataPilot._XDataPilotTable; |
| // import complexlib.ComplexTestCase; |
| import lib.StatusException; |
| import lib.TestParameters; |
| import util.SOfficeFactory; |
| |
| import org.junit.After; |
| import org.junit.AfterClass; |
| import org.junit.Before; |
| import org.junit.BeforeClass; |
| import org.junit.Test; |
| import org.openoffice.test.OfficeConnection; |
| import static org.junit.Assert.*; |
| |
| |
| /** |
| * check the DataPilot of Calc. |
| */ |
| public class CheckDataPilot { |
| /** The data pilot field object **/ |
| private XInterface mDataPilotFieldObject = null; |
| /** The data pilot table object **/ |
| private XInterface mDataPilotTableObject = null; |
| |
| |
| private 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; |
| |
| /** |
| * The test parameters |
| */ |
| private static TestParameters param = null; |
| |
| /** |
| * Get all test methods |
| * @return The test methods |
| */ |
| public String[] getTestMethodNames() { |
| return new String[]{"testDataPilotTableObject", |
| "testDataPilotFieldObject"}; |
| } |
| |
| /** |
| * Test the data pilot field object: |
| * simply execute the interface tests in a row |
| */ |
| @Test public void testDataPilotFieldObject() { |
| System.out.println("Starting 'testDataPilotFieldObject'"); |
| // _XNamed |
| XNamed xNamed = UnoRuntime.queryInterface( |
| XNamed.class, mDataPilotFieldObject); |
| |
| _XNamed _xNamed = new _XNamed(xNamed/*, log*/, param); |
| assertTrue("_getName failed.",_xNamed._getName()); |
| assertTrue("_setName failed.",_xNamed._setName()); |
| |
| // _XPropertySet |
| XPropertySet xProp = UnoRuntime.queryInterface( |
| XPropertySet.class, mDataPilotFieldObject); |
| _XPropertySet _xProp = new _XPropertySet(xProp/*, log*/, param); |
| assertTrue("_getPropertySetInfo failed.",_xProp._getPropertySetInfo()); |
| assertTrue("_addPropertyChangeListener failed.",_xProp._addPropertyChangeListener()); |
| assertTrue("_addVetoableChangeListener failed.",_xProp._addVetoableChangeListener()); |
| assertTrue("_setPropertyValue failed.",_xProp._setPropertyValue()); |
| assertTrue("_getPropertyValue failed.",_xProp._getPropertyValue()); |
| assertTrue("_removePropertyChangeListener failed.",_xProp._removePropertyChangeListener()); |
| assertTrue("_removeVetoableChangeListener failed.",_xProp._removeVetoableChangeListener()); |
| |
| } |
| |
| /** |
| * Test the data pilot table object: |
| * simply execute the interface tests in a row |
| */ |
| @Test public void testDataPilotTableObject() { |
| System.out.println("Starting 'testDataPilotTableObject'"); |
| // _XNamed |
| XNamed xNamed = UnoRuntime.queryInterface( |
| XNamed.class, mDataPilotTableObject); |
| _XNamed _xNamed = new _XNamed(xNamed/*, log*/, param); |
| assertTrue("_getName failed.",_xNamed._getName()); |
| assertTrue("_setName failed.",_xNamed._setName()); |
| |
| // _XDataPilotTable |
| XDataPilotTable xDataPilotTable = |
| UnoRuntime.queryInterface(XDataPilotTable.class, |
| mDataPilotTableObject); |
| _XDataPilotTable _xDataPilotTable = |
| new _XDataPilotTable(xDataPilotTable/*, log*/, param); |
| assertTrue("before failed.", _xDataPilotTable.before()); |
| assertTrue("_getOutputRange failed.", _xDataPilotTable._getOutputRange()) ; |
| // assertTrue("_refresh failed.", _xDataPilotTable._refresh()) ; |
| |
| // _XDataPilotDescriptor |
| XDataPilotDescriptor xDataPilotDescriptor = |
| UnoRuntime.queryInterface(XDataPilotDescriptor.class, |
| mDataPilotTableObject); |
| _XDataPilotDescriptor _xDataPilotDescriptor = |
| new _XDataPilotDescriptor(xDataPilotDescriptor/*, log*/, param); |
| assertTrue("before failed.", _xDataPilotDescriptor.before()); |
| assertTrue("_setTag failed.", _xDataPilotDescriptor._setTag()) ; |
| assertTrue("_getTag failed.", _xDataPilotDescriptor._getTag()) ; |
| assertTrue("_getFilterDescriptor failed.", _xDataPilotDescriptor._getFilterDescriptor()) ; |
| assertTrue("_getDataPilotFields failed.", _xDataPilotDescriptor._getDataPilotFields()) ; |
| assertTrue("_getColumnFields failed.", _xDataPilotDescriptor._getColumnFields()) ; |
| assertTrue("_getRowFields failed.", _xDataPilotDescriptor._getRowFields()) ; |
| assertTrue("_getDataFields failed.", _xDataPilotDescriptor._getDataFields()) ; |
| assertTrue("_getHiddenFields failed.", _xDataPilotDescriptor._getHiddenFields()) ; |
| assertTrue("_getPageFields failed.", _xDataPilotDescriptor._getPageFields()) ; |
| assertTrue("_setSourceRange failed.", _xDataPilotDescriptor._setSourceRange()) ; |
| assertTrue("_getSourceRange failed.", _xDataPilotDescriptor._getSourceRange()) ; |
| } |
| |
| /** |
| * create an environment for the test |
| */ |
| @Before public void before() { |
| // Object oInterface = null; |
| |
| // SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory)param.getMSF() ); |
| final XMultiServiceFactory xMsf = UnoRuntime.queryInterface(XMultiServiceFactory.class, connection.getComponentContext().getServiceManager()); |
| SOfficeFactory SOF = SOfficeFactory.getFactory(xMsf); |
| |
| param = new TestParameters(); |
| param.put("ServiceFactory", xMsf); |
| |
| // 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; |
| |
| try { |
| System.out.println( "Creating a Spreadsheet document" ); |
| xSheetDoc = SOF.createCalcDoc(null); |
| } catch (com.sun.star.uno.Exception e) { |
| // Some exception occures.FAILED |
| e.printStackTrace(); |
| throw new StatusException( "Couldn't create document", e ); |
| } |
| |
| System.out.println("Getting a sheet"); |
| XSpreadsheets xSpreadsheets = xSheetDoc.getSheets(); |
| XSpreadsheet oSheet = null; |
| XSpreadsheet oSheet2 = null; |
| XIndexAccess oIndexAccess = |
| 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 { |
| System.out.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)); |
| } |
| } |
| } 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 |
| System.out.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; |
| try { |
| Object oDataPilotField = DPDsc.getDataPilotFields().getByIndex(0); |
| fieldPropSet = |
| UnoRuntime.queryInterface(XPropertySet.class, oDataPilotField); |
| } catch (com.sun.star.lang.WrappedTargetException 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); |
| } |
| |
| try { |
| fieldPropSet.setPropertyValue("Function", |
| com.sun.star.sheet.GeneralFunction.SUM); |
| fieldPropSet.setPropertyValue("Orientation", |
| com.sun.star.sheet.DataPilotFieldOrientation.DATA); |
| } 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); |
| } |
| |
| System.out.println("Insert the DataPilotTable"); |
| if (DPT.hasByName("DataPilotTable")) { |
| DPT.removeByName("DataPilotTable"); |
| } |
| DPT.insertNewByName("DataPilotTable", sCellAdress, DPDsc); |
| try { |
| mDataPilotTableObject = (XInterface) AnyConverter.toObject( |
| new Type(XInterface.class),DPT.getByName(DPT.getElementNames()[0])); |
| } catch (com.sun.star.lang.WrappedTargetException e) { |
| e.printStackTrace(); |
| throw new StatusException("Couldn't create a test environment", e); |
| } catch (com.sun.star.container.NoSuchElementException 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); |
| } |
| |
| XIndexAccess IA = DPDsc.getDataPilotFields(); |
| try { |
| mDataPilotFieldObject = (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); |
| } |
| |
| // Other parameters required for interface tests |
| param.put("OUTPUTRANGE", sCellAdress); |
| param.put("CELLFORCHANGE", oChangeCell); |
| param.put("CELLFORCHECK", oCheckCell); |
| param.put("CHANGEVALUE", aChangeValue); |
| param.put("FIELDSAMOUNT", new Integer(5)); |
| |
| } |
| |
| /* |
| * this method closes a calc document and resets the corresponding class variable xSheetDoc |
| */ |
| protected boolean closeSpreadsheetDocument() { |
| boolean worked = true; |
| |
| System.out.println(" disposing xSheetDoc "); |
| |
| try { |
| XCloseable oCloser = UnoRuntime.queryInterface( |
| XCloseable.class, xSheetDoc); |
| oCloser.close(true); |
| } catch (com.sun.star.util.CloseVetoException e) { |
| worked = false; |
| System.out.println("Couldn't close document"); |
| } catch (com.sun.star.lang.DisposedException e) { |
| worked = false; |
| System.out.println("Document already disposed"); |
| } catch (java.lang.NullPointerException e) { |
| worked = false; |
| System.out.println("Couldn't get XCloseable"); |
| } |
| |
| xSheetDoc = null; |
| |
| return worked; |
| } |
| |
| @After public void after() |
| { |
| closeSpreadsheetDocument(); |
| } |
| |
| |
| @BeforeClass public static void setUpConnection() throws Exception { |
| System.out.println("setUpConnection()"); |
| connection.setUp(); |
| } |
| |
| @AfterClass public static void tearDownConnection() |
| throws InterruptedException, com.sun.star.uno.Exception |
| { |
| System.out.println("tearDownConnection()"); |
| connection.tearDown(); |
| } |
| |
| private static final OfficeConnection connection = new OfficeConnection(); |
| |
| |
| } |