summaryrefslogtreecommitdiff
path: root/sc/qa/complex
diff options
context:
space:
mode:
Diffstat (limited to 'sc/qa/complex')
-rw-r--r--sc/qa/complex/calcPreview/TestDocument.java39
-rwxr-xr-xsc/qa/complex/calcPreview/ViewForwarder.java1102
-rwxr-xr-xsc/qa/complex/calcPreview/makefile.mk123
-rw-r--r--sc/qa/complex/calcPreview/test_documents/calcshapes.sxcbin13030 -> 0 bytes
-rwxr-xr-xsc/qa/complex/cellRanges/CheckXCellRangesQuery.java286
-rwxr-xr-xsc/qa/complex/cellRanges/makefile.mk51
-rw-r--r--sc/qa/complex/dataPilot/CheckDataPilot.java403
-rw-r--r--sc/qa/complex/dataPilot/_XDataPilotDescriptor.java464
-rw-r--r--sc/qa/complex/dataPilot/_XDataPilotTable.java135
-rw-r--r--sc/qa/complex/dataPilot/_XNamed.java159
-rw-r--r--sc/qa/complex/dataPilot/_XPropertySet.java631
-rw-r--r--sc/qa/complex/dataPilot/interfaceTests/beans/makefile.mk46
-rw-r--r--sc/qa/complex/dataPilot/interfaceTests/container/makefile.mk46
-rw-r--r--sc/qa/complex/dataPilot/interfaceTests/sheet/makefile.mk46
-rw-r--r--sc/qa/complex/dataPilot/makefile.mk59
-rw-r--r--sc/qa/complex/sc/CalcRTL.java601
-rw-r--r--sc/qa/complex/sc/makefile.mk51
17 files changed, 0 insertions, 4242 deletions
diff --git a/sc/qa/complex/calcPreview/TestDocument.java b/sc/qa/complex/calcPreview/TestDocument.java
deleted file mode 100644
index a568556e6..000000000
--- a/sc/qa/complex/calcPreview/TestDocument.java
+++ /dev/null
@@ -1,39 +0,0 @@
-/*************************************************************************
-*
-* 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 complex.calcPreview;
-
-import java.io.File;
-import org.openoffice.test.OfficeFileUrl;
-
-final class TestDocument {
- public static String getUrl(String name) {
- return OfficeFileUrl.getAbsolute(new File("test_documents", name));
- }
-
- private TestDocument() {}
-}
diff --git a/sc/qa/complex/calcPreview/ViewForwarder.java b/sc/qa/complex/calcPreview/ViewForwarder.java
deleted file mode 100755
index 3f2b707e0..000000000
--- a/sc/qa/complex/calcPreview/ViewForwarder.java
+++ /dev/null
@@ -1,1102 +0,0 @@
-/*************************************************************************
- *
- * 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 complex.calcPreview;
-
-// import complexlib.ComplexTestCase;
-
-import com.sun.star.awt.XWindow;
-import com.sun.star.container.XIndexAccess;
-import com.sun.star.frame.XController;
-import com.sun.star.frame.XDispatch;
-import com.sun.star.frame.XDispatchProvider;
-import com.sun.star.frame.XModel;
-// import com.sun.star.lang.XComponent;
-import com.sun.star.lang.XMultiServiceFactory;
-import com.sun.star.sheet.XSpreadsheet;
-// import com.sun.star.sheet.XSpreadsheetDocument;
-import com.sun.star.sheet.XSpreadsheets;
-import com.sun.star.table.XCell;
-// import com.sun.star.uno.Any;
-import com.sun.star.uno.AnyConverter;
-import com.sun.star.uno.UnoRuntime;
-import com.sun.star.uno.XInterface;
-import com.sun.star.util.URL;
-import com.sun.star.util.XURLTransformer;
-import com.sun.star.accessibility.AccessibleRole;
-import com.sun.star.accessibility.XAccessible;
-import com.sun.star.accessibility.XAccessibleText;
-import com.sun.star.accessibility.XAccessibleValue;
-import com.sun.star.accessibility.XAccessibleComponent;
-import com.sun.star.accessibility.XAccessibleContext;
-
-import util.AccessibilityTools;
-import util.SOfficeFactory;
-import util.utils;
-
-import com.sun.star.beans.XPropertySet;
-// import com.sun.star.beans.XPropertySetInfo;
-import com.sun.star.container.XNameAccess;
-import com.sun.star.lang.XComponent;
-import com.sun.star.sheet.XHeaderFooterContent;
-import com.sun.star.sheet.XSpreadsheetDocument;
-import com.sun.star.style.XStyle;
-import com.sun.star.style.XStyleFamiliesSupplier;
-import com.sun.star.text.XText;
-// import com.sun.star.drawing.XDrawPageSupplier;
-// import com.sun.star.drawing.XDrawPage;
-// import com.sun.star.drawing.XShape;
-// import com.sun.star.drawing.XShapes;
-
-
-// import com.sun.star.beans.Property;
-// import com.sun.star.lang.XServiceInfo;
-
-
-
-// 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.*;
-
-/**
- * A complex test for the preview of Calc documents. This complex test
- * needs interaction from the user: documents have to be resized and moved.
- */
-public class ViewForwarder {
-
- /** The MultiServiceFactory **/
- private XMultiServiceFactory mXMSF = null;
-
- /** Get all test methods.
- * @return The test methods.
- */
-// public String[] getTestMethodNames() {
-// return new String[]{"checkPositiveViewForwarder",
-// "checkNegativeViewForwarder",
-// "checkPreviewHeaderCells",
-// "checkPreviewShape"
-// };
-// }
-
- /**
- * Get a MultiServiceFactory from the Office before the test.
- */
- @Before public void before()
- {
- mXMSF = UnoRuntime.queryInterface(XMultiServiceFactory.class, connection.getComponentContext().getServiceManager());
- // SOfficeFactory SOF = SOfficeFactory.getFactory(mXMSF);
-
- // param = new TestParameters();
- // param.put("ServiceFactory", xMsf);
- // mXMSF = (XMultiServiceFactory)param.getMSF();
- }
-
-
- /** Create a spreadsheet document, insert some text, header and footer.
- * Let the user resize the document and check the contents.
- */
- @Test public void checkPositiveViewForwarder() {
- SOfficeFactory SOF = SOfficeFactory.getFactory( mXMSF );
- XSpreadsheetDocument xSpreadsheetDoc = null;
-
- try {
- System.out.println("Creating a spreadsheet document");
- xSpreadsheetDoc = SOF.createCalcDoc(null);
- } catch (com.sun.star.uno.Exception e) {
- fail(e.getMessage());
- return;
- }
-
- XInterface oObj = null;
-
- // inserting some content to have non-empty page preview
- XCell xCell = null;
- try {
- XSpreadsheets oSheets = xSpreadsheetDoc.getSheets() ;
- XIndexAccess oIndexSheets =
- UnoRuntime.queryInterface(XIndexAccess.class, oSheets);
- Object o = oIndexSheets.getByIndex(0);
- XSpreadsheet oSheet = (XSpreadsheet)AnyConverter.toObject(
- new com.sun.star.uno.Type(XSpreadsheet.class), o);
- xCell = oSheet.getCellByPosition(0, 0) ;
- xCell.setFormula("ScAccessiblePageHeader");
-
- xCell = oSheet.getCellByPosition(0, 1) ;
- xCell.setFormula("Cell 1");
- xCell = oSheet.getCellByPosition(0, 2) ;
- xCell.setFormula("Cell 2");
- } catch(com.sun.star.lang.IllegalArgumentException e) {
- System.out.println("Exception ceating relation :");
- fail(e.getMessage());
- } catch(com.sun.star.lang.WrappedTargetException e) {
- System.out.println("Exception ceating relation :");
- fail(e.getMessage());
- } catch(com.sun.star.lang.IndexOutOfBoundsException e) {
- System.out.println("Exception ceating relation :");
- fail(e.getMessage());
- }
-
- XModel aModel =
- UnoRuntime.queryInterface(XModel.class, xSpreadsheetDoc);
-
- XController xController = aModel.getCurrentController();
-
- // get page styles
- XStyleFamiliesSupplier StyleFam =
- UnoRuntime.queryInterface(
- XStyleFamiliesSupplier.class,
- xSpreadsheetDoc );
- XNameAccess StyleFamNames = StyleFam.getStyleFamilies();
- XStyle StdStyle = null;
-
- try{
- Object o = StyleFamNames.getByName("PageStyles");
- XNameAccess PageStyles = (XNameAccess)AnyConverter.toObject(
- new com.sun.star.uno.Type(XNameAccess.class), o);
-
- o = PageStyles.getByName("Default");
- StdStyle = (XStyle)AnyConverter.toObject(
- new com.sun.star.uno.Type(XStyle.class), o);
- } catch(com.sun.star.lang.IllegalArgumentException e) {
- fail(e.getMessage());
- } catch(com.sun.star.lang.WrappedTargetException e){
- fail(e.getMessage());
- return;
- } catch(com.sun.star.container.NoSuchElementException e){
- fail(e.getMessage());
- return;
- }
-
- //get the property-set
- final XPropertySet PropSet =
- UnoRuntime.queryInterface(XPropertySet.class, StdStyle);
-
- XHeaderFooterContent RPHFC = null;
-
- // get the header
- try {
- Object o = PropSet.getPropertyValue("RightPageHeaderContent");
- RPHFC = (XHeaderFooterContent)AnyConverter.toObject(
- new com.sun.star.uno.Type(XHeaderFooterContent.class), o);
-
- } catch(com.sun.star.lang.IllegalArgumentException e) {
- fail(e.getMessage());
- } catch(com.sun.star.lang.WrappedTargetException e){
- fail(e.getMessage());
- return;
- } catch(com.sun.star.beans.UnknownPropertyException e){
- fail(e.getMessage());
- return;
- }
-
- // insert text into header
- XText center = RPHFC.getCenterText();
- center.setString("First line \n\r Second line \n\r third line ");
- try {
- PropSet.setPropertyValue("RightPageHeaderContent",RPHFC);
- } catch (com.sun.star.beans.UnknownPropertyException e) {
- } catch (com.sun.star.beans.PropertyVetoException e) {
- } catch (com.sun.star.lang.IllegalArgumentException e) {
- } catch (com.sun.star.lang.WrappedTargetException e) {}
-
- // get footer
- RPHFC = null;
- try {
- Object o = PropSet.getPropertyValue("RightPageHeaderContent");
- RPHFC = (XHeaderFooterContent)AnyConverter.toObject(
- new com.sun.star.uno.Type(XHeaderFooterContent.class), o);
- } catch(com.sun.star.lang.IllegalArgumentException e) {
- fail(e.getMessage());
- } catch(com.sun.star.lang.WrappedTargetException e){
- fail(e.getMessage());
- return;
- } catch(com.sun.star.beans.UnknownPropertyException e){
- fail(e.getMessage());
- return;
- }
-
- // insert text into footer
- center = RPHFC.getCenterText();
- center.setString("Third last line\n\r Second last line\n\r last line");
- try {
- PropSet.setPropertyValue("RightPageFooterContent",RPHFC);
- } catch (com.sun.star.beans.UnknownPropertyException e) {
- } catch (com.sun.star.beans.PropertyVetoException e) {
- } catch (com.sun.star.lang.IllegalArgumentException e) {
- } catch (com.sun.star.lang.WrappedTargetException e) {}
-
- // switching to 'Page Preview' mode
- try {
- XDispatchProvider xDispProv =
- UnoRuntime.queryInterface(XDispatchProvider.class, xController);
- XURLTransformer xParser =
- UnoRuntime.queryInterface(XURLTransformer.class,
- mXMSF.createInstance("com.sun.star.util.URLTransformer"));
- // Because it's an in/out parameter we must use an
- // array of URL objects.
- URL[] aParseURL = new URL[1];
- aParseURL[0] = new URL();
- aParseURL[0].Complete = ".uno:PrintPreview";
- xParser.parseStrict(aParseURL);
- URL aURL = aParseURL[0];
- XDispatch xDispatcher = xDispProv.queryDispatch(aURL, "", 0);
- if(xDispatcher != null)
- {
- xDispatcher.dispatch( aURL, null );
- }
- } catch (com.sun.star.uno.Exception e) {
- fail("Couldn't change mode");
- return;
- }
-
- try {
- Thread.sleep(500);
- } catch (InterruptedException ex) {}
-
- System.out.println("Press any key after resizing ");
- try{
- byte[]b = new byte[16];
- System.in.read(b);
- } catch (Exception e) {
- e.printStackTrace();
- }
-
- // get the accessible content
- AccessibilityTools at = new AccessibilityTools();
-
- XWindow xWindow = at.getCurrentWindow(mXMSF, aModel);
- XAccessible xRoot = at.getAccessibleObject(xWindow);
- XAccessible parent = null;
-
- try {
- parent = at.getAccessibleObjectForRole
- (xRoot, AccessibleRole.HEADER, "").getAccessibleChild(0);
- oObj = parent.getAccessibleContext().getAccessibleChild(0);
- } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
- fail(iabe.getMessage());
- return;
- }
-
- System.out.println("ImplementationName " + utils.getImplName(oObj));
-
- XAccessibleComponent accPC =
- UnoRuntime.queryInterface(XAccessibleComponent.class, parent);
-
- System.out.println("Parent-BoundsX= "+accPC.getBounds().X);
- System.out.println("Parent-BoundsY= "+accPC.getBounds().Y);
- System.out.println("Parent-BoundsWidth= "+accPC.getBounds().Width);
- System.out.println("Parent-BoundsHeight= "+accPC.getBounds().Height);
-
- XAccessibleComponent accPPC =
- UnoRuntime.queryInterface(XAccessibleComponent.class,
- parent.getAccessibleContext().getAccessibleParent());
-
- System.out.println("P-Parent-BoundsX= "+accPPC.getBounds().X);
- System.out.println("P-Parent-BoundsY= "+accPPC.getBounds().Y);
- System.out.println("P-Parent-BoundsWidth= "+accPPC.getBounds().Width);
- System.out.println("P-Parent-BoundsHeight= "+accPPC.getBounds().Height);
-
- try {
- Thread.sleep(500);
- } catch (InterruptedException ex) {}
-
- System.out.println("Press any key when the second line is on top");
- try{
- byte[]b = new byte[16];
- System.in.read(b);
- } catch (Exception e) {
- e.printStackTrace();
- }
-
- try {
- System.out.println("ChildCount: "+
- parent.getAccessibleContext().getAccessibleChildCount());
- System.out.println("Getting child 0 again");
- oObj = parent.getAccessibleContext().getAccessibleChild(0);
- } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
- fail(iabe.getMessage());
- return;
- }
-
- XAccessibleText accT =
- UnoRuntime.queryInterface(XAccessibleText.class, oObj);
- System.out.println("Getting the text: "+accT.getText());
-
- XAccessibleComponent accC =
- UnoRuntime.queryInterface(XAccessibleComponent.class, oObj);
- System.out.println("BoundsX= "+accC.getBounds().X);
- System.out.println("BoundsY= "+accC.getBounds().Y);
- System.out.println("BoundsWidth= "+accC.getBounds().Width);
- System.out.println("BoundsHeight= "+accC.getBounds().Height);
-
- accPC =
- UnoRuntime.queryInterface(XAccessibleComponent.class, parent);
-
- System.out.println("Parent-BoundsX= "+accPC.getBounds().X);
- System.out.println("Parent-BoundsY= "+accPC.getBounds().Y);
- System.out.println("Parent-BoundsWidth= "+accPC.getBounds().Width);
- System.out.println("Parent-BoundsHeight= "+accPC.getBounds().Height);
-
- accPPC =
- UnoRuntime.queryInterface(XAccessibleComponent.class,
- parent.getAccessibleContext().getAccessibleParent());
-
- System.out.println("P-Parent-BoundsX= "+accPPC.getBounds().X);
- System.out.println("P-Parent-BoundsY= "+accPPC.getBounds().Y);
- System.out.println("P-Parent-BoundsWidth= "+accPPC.getBounds().Width);
- System.out.println("P-Parent-BoundsHeight= "+accPPC.getBounds().Height);
-
-
-
- System.out.println("Press any key when the footer is visible.");
- try{
- byte[]b = new byte[16];
- System.in.read(b);
- } catch (Exception e) {
- e.printStackTrace();
- }
-
- try {
- parent = at.getAccessibleObjectForRole
- (xRoot, AccessibleRole.FOOTER, "").getAccessibleChild(0);
- } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
- fail(iabe.getMessage());
- return;
- }
-
- accPC =
- UnoRuntime.queryInterface(XAccessibleComponent.class, parent);
-
- try {
- System.out.println("ChildCount: "+
- parent.getAccessibleContext().getAccessibleChildCount());
- System.out.println("Getting child 0 again");
- oObj = parent.getAccessibleContext().getAccessibleChild(0);
- } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
- fail(iabe.getMessage());
- return;
- }
-
- accT =
- UnoRuntime.queryInterface(XAccessibleText.class, oObj);
- System.out.println("Getting the text: "+accT.getText());
-
- accC =
- UnoRuntime.queryInterface(XAccessibleComponent.class, oObj);
- System.out.println("BoundsX= "+accC.getBounds().X);
- System.out.println("BoundsY= "+accC.getBounds().Y);
- System.out.println("BoundsWidth= "+accC.getBounds().Width);
- System.out.println("BoundsHeight= "+accC.getBounds().Height);
-
- accPC =
- UnoRuntime.queryInterface(XAccessibleComponent.class, parent);
-
- System.out.println("Parent-BoundsX= "+accPC.getBounds().X);
- System.out.println("Parent-BoundsY= "+accPC.getBounds().Y);
- System.out.println("Parent-BoundsWidth= "+accPC.getBounds().Width);
- System.out.println("Parent-BoundsHeight= "+accPC.getBounds().Height);
-
- accPPC =
- UnoRuntime.queryInterface(XAccessibleComponent.class,
- parent.getAccessibleContext().getAccessibleParent());
-
- System.out.println("P-Parent-BoundsX= "+accPPC.getBounds().X);
- System.out.println("P-Parent-BoundsY= "+accPPC.getBounds().Y);
- System.out.println("P-Parent-BoundsWidth= "+accPPC.getBounds().Width);
- System.out.println("P-Parent-BoundsHeight= "+accPPC.getBounds().Height);
-
-
- System.out.println("Press any key when the page content is on top");
- try{
- byte[]b = new byte[16];
- System.in.read(b);
- } catch (Exception e) {
- e.printStackTrace();
- }
-
- try {
- parent = at.getAccessibleObjectForRole
- (xRoot, AccessibleRole.DOCUMENT, "").getAccessibleChild(0);
- } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
- fail(iabe.getMessage());
- return;
- }
- System.out.println("PARENT: " + parent.getAccessibleContext().getAccessibleName());
- accPC =
- UnoRuntime.queryInterface(XAccessibleComponent.class, parent);
-
- int cCount = 0;
- try {
- cCount =
- parent.getAccessibleContext().getAccessibleChildCount();
- System.out.println("ChildCount: "+cCount);
- System.out.println("Getting child 0 again");
- oObj = parent.getAccessibleContext().getAccessibleChild(0);
- } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
- fail(iabe.getMessage());
- return;
- }
-
- for (int i=0; i<cCount; i++) {
- try {
- XAccessible xA = parent.getAccessibleContext().getAccessibleChild(i);
- System.out.println("NAME object " + i + ": " + xA.getAccessibleContext().getAccessibleName());
- } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
- fail(iabe.getMessage());
- return;
- }
- }
-
- System.out.println("SERVICES:");
- util.dbg.getSuppServices(oObj);
-
- XAccessibleValue accV =
- UnoRuntime.queryInterface(XAccessibleValue.class, oObj);
- Object o = accV.getCurrentValue();
- if (o instanceof String)
- {
- System.out.println("Value: " + (String)o);
- }
- else
- {
- System.out.println("Name of Object: " + o.getClass().getName());
- }
- System.out.println("Getting the value: "+accV.getCurrentValue());
-
-
-
-
- accC =
- UnoRuntime.queryInterface(XAccessibleComponent.class, oObj);
- System.out.println("BoundsX= "+accC.getBounds().X);
- System.out.println("BoundsY= "+accC.getBounds().Y);
- System.out.println("BoundsWidth= "+accC.getBounds().Width);
- System.out.println("BoundsHeight= "+accC.getBounds().Height);
-
- accPC =
- UnoRuntime.queryInterface(XAccessibleComponent.class, parent);
-
- System.out.println("Parent-BoundsX= "+accPC.getBounds().X);
- System.out.println("Parent-BoundsY= "+accPC.getBounds().Y);
- System.out.println("Parent-BoundsWidth= "+accPC.getBounds().Width);
- System.out.println("Parent-BoundsHeight= "+accPC.getBounds().Height);
-
- accPPC =
- UnoRuntime.queryInterface(XAccessibleComponent.class,
- parent.getAccessibleContext().getAccessibleParent());
-
- System.out.println("P-Parent-BoundsX= "+accPPC.getBounds().X);
- System.out.println("P-Parent-BoundsY= "+accPPC.getBounds().Y);
- System.out.println("P-Parent-BoundsWidth= "+accPPC.getBounds().Width);
- System.out.println("P-Parent-BoundsHeight= "+accPPC.getBounds().Height);
-
- XComponent xComp = UnoRuntime.queryInterface(
- XComponent.class, xSpreadsheetDoc);
- xComp.dispose();
- }
-
-
-
-
-
-
-
-
- /**
- * Create a spreadsheet document, insert some text, header and footer.
- * Let the user resize the document and check the contents.
- */
- @Test public void checkNegativeViewForwarder() {
- SOfficeFactory SOF = SOfficeFactory.getFactory( mXMSF );
- XSpreadsheetDocument xSpreadsheetDoc = null;
-
- try {
- System.out.println("Creating a spreadsheet document");
- xSpreadsheetDoc = SOF.createCalcDoc(null);
- } catch (com.sun.star.uno.Exception e) {
- fail(e.getMessage());
- return;
- }
-
- XInterface oObj = null;
-
- // inserting some content to have non-empty page preview
- XCell xCell = null;
- try {
- XSpreadsheets oSheets = xSpreadsheetDoc.getSheets() ;
- XIndexAccess oIndexSheets =
- UnoRuntime.queryInterface(XIndexAccess.class, oSheets);
- Object o = oIndexSheets.getByIndex(0);
- XSpreadsheet oSheet = (XSpreadsheet)AnyConverter.toObject(
- new com.sun.star.uno.Type(XSpreadsheet.class), o);
- xCell = oSheet.getCellByPosition(0, 0) ;
- xCell.setFormula("ScAccessiblePageHeader");
-
- xCell = oSheet.getCellByPosition(0, 1) ;
- xCell.setFormula("Cell 1");
- xCell = oSheet.getCellByPosition(0, 2) ;
- xCell.setFormula("Cell 2");
- } catch(com.sun.star.lang.IllegalArgumentException e) {
- System.out.println("Exception ceating relation :");
- fail(e.getMessage());
- } catch(com.sun.star.lang.WrappedTargetException e) {
- System.out.println("Exception ceating relation :");
- fail(e.getMessage());
- } catch(com.sun.star.lang.IndexOutOfBoundsException e) {
- System.out.println("Exception ceating relation :");
- fail(e.getMessage());
- }
-
- XModel aModel =
- UnoRuntime.queryInterface(XModel.class, xSpreadsheetDoc);
-
- XController xController = aModel.getCurrentController();
-
- // get page styles
- XStyleFamiliesSupplier StyleFam =
- UnoRuntime.queryInterface(
- XStyleFamiliesSupplier.class,
- xSpreadsheetDoc );
- XNameAccess StyleFamNames = StyleFam.getStyleFamilies();
- XStyle StdStyle = null;
-
- try{
- Object o = StyleFamNames.getByName("PageStyles");
- XNameAccess PageStyles = (XNameAccess)AnyConverter.toObject(
- new com.sun.star.uno.Type(XNameAccess.class), o);
-
- o = PageStyles.getByName("Default");
- StdStyle = (XStyle)AnyConverter.toObject(
- new com.sun.star.uno.Type(XStyle.class), o);
- } catch(com.sun.star.lang.IllegalArgumentException e) {
- fail(e.getMessage());
- } catch(com.sun.star.lang.WrappedTargetException e){
- fail(e.getMessage());
- return;
- } catch(com.sun.star.container.NoSuchElementException e){
- fail(e.getMessage());
- return;
- }
-
- //get the property-set
- final XPropertySet PropSet =
- UnoRuntime.queryInterface(XPropertySet.class, StdStyle);
-
- XHeaderFooterContent RPHFC = null;
-
- // get the header
- System.out.println( "Creating a test environment" );
- try {
- Object o = PropSet.getPropertyValue("RightPageHeaderContent");
- RPHFC = (XHeaderFooterContent)AnyConverter.toObject(
- new com.sun.star.uno.Type(XHeaderFooterContent.class), o);
- } catch(com.sun.star.lang.IllegalArgumentException e) {
- fail(e.getMessage());
- } catch(com.sun.star.lang.WrappedTargetException e){
- fail(e.getMessage());
- return;
- } catch(com.sun.star.beans.UnknownPropertyException e){
- fail(e.getMessage());
- return;
- }
-
- // insert text into header
- XText center = RPHFC.getCenterText();
- center.setString("First line \n\r Second line \n\r third line ");
- try {
- PropSet.setPropertyValue("RightPageHeaderContent",RPHFC);
- } catch (com.sun.star.beans.UnknownPropertyException e) {
- } catch (com.sun.star.beans.PropertyVetoException e) {
- } catch (com.sun.star.lang.IllegalArgumentException e) {
- } catch (com.sun.star.lang.WrappedTargetException e) {}
-
- // get footer
- RPHFC = null;
- try {
- Object o = PropSet.getPropertyValue("RightPageFooterContent");
- RPHFC = (XHeaderFooterContent)AnyConverter.toObject(
- new com.sun.star.uno.Type(XHeaderFooterContent.class), o);
- } catch(com.sun.star.lang.IllegalArgumentException e) {
- fail(e.getMessage());
- } catch(com.sun.star.lang.WrappedTargetException e){
- fail(e.getMessage());
- return;
- } catch(com.sun.star.beans.UnknownPropertyException e){
- fail(e.getMessage());
- return;
- }
-
- // insert text into footer
- center = RPHFC.getCenterText();
- center.setString("Third last line\n\r Second last line\n\r last line");
- try {
- PropSet.setPropertyValue("RightPageFooterContent",RPHFC);
- } catch (com.sun.star.beans.UnknownPropertyException e) {
- } catch (com.sun.star.beans.PropertyVetoException e) {
- } catch (com.sun.star.lang.IllegalArgumentException e) {
- } catch (com.sun.star.lang.WrappedTargetException e) {}
-
- // switching to 'Page Preview' mode
- try {
- XDispatchProvider xDispProv =
- UnoRuntime.queryInterface(XDispatchProvider.class, xController);
- XURLTransformer xParser =
- UnoRuntime.queryInterface(XURLTransformer.class,
- mXMSF.createInstance("com.sun.star.util.URLTransformer"));
- // Because it's an in/out parameter we must use an
- // array of URL objects.
- URL[] aParseURL = new URL[1];
- aParseURL[0] = new URL();
- aParseURL[0].Complete = ".uno:PrintPreview";
- xParser.parseStrict(aParseURL);
- URL aURL = aParseURL[0];
- XDispatch xDispatcher = xDispProv.queryDispatch(aURL, "", 0);
- if(xDispatcher != null)
- {
- xDispatcher.dispatch( aURL, null );
- }
- } catch (com.sun.star.uno.Exception e) {
- fail("Couldn't change mode");
- return;
- }
-
- try {
- Thread.sleep(500);
- } catch (InterruptedException ex) {}
-
- System.out.println("Press any key after resizing ");
- try{
- byte[]b = new byte[16];
- System.in.read(b);
- } catch (Exception e) {
- e.printStackTrace();
- }
-
- // get the accessible content
- AccessibilityTools at = new AccessibilityTools();
-
- XWindow xWindow = at.getCurrentWindow(mXMSF, aModel);
- XAccessible xRoot = at.getAccessibleObject(xWindow);
- XAccessible parent = null;
-
- try {
- parent = at.getAccessibleObjectForRole
- (xRoot, AccessibleRole.HEADER, "").getAccessibleChild(0);
- oObj = parent.getAccessibleContext().getAccessibleChild(0);
- } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
- fail(iabe.getMessage());
- return;
- }
-
- System.out.println("ImplementationName " + utils.getImplName(oObj));
-
- XAccessibleComponent accPC =
- UnoRuntime.queryInterface(XAccessibleComponent.class, parent);
-
- System.out.println("Parent-BoundsX= "+accPC.getBounds().X);
- System.out.println("Parent-BoundsY= "+accPC.getBounds().Y);
- System.out.println("Parent-BoundsWidth= "+accPC.getBounds().Width);
- System.out.println("Parent-BoundsHeight= "+accPC.getBounds().Height);
-
- XAccessibleComponent accPPC =
- UnoRuntime.queryInterface(XAccessibleComponent.class,
- parent.getAccessibleContext().getAccessibleParent());
-
- System.out.println("P-Parent-BoundsX= "+accPPC.getBounds().X);
- System.out.println("P-Parent-BoundsY= "+accPPC.getBounds().Y);
- System.out.println("P-Parent-BoundsWidth= "+accPPC.getBounds().Width);
- System.out.println("P-Parent-BoundsHeight= "+accPPC.getBounds().Height);
-
- try {
- Thread.sleep(500);
- } catch (InterruptedException ex) {}
-
- System.out.println("Press any key when the header is not visible.");
- try{
- byte[]b = new byte[16];
- System.in.read(b);
- } catch (Exception e) {
- e.printStackTrace();
- }
-
- int childCount = 0;
- childCount =
- parent.getAccessibleContext().getAccessibleChildCount();
- System.out.println("ChildCount: "+childCount);
-
- if (childCount != 0)
- {
- fail("Could access header although it was not visible on page.");
- }
-
-
- try {
- parent = at.getAccessibleObjectForRole
- (xRoot, AccessibleRole.FOOTER, "").getAccessibleChild(0);
- } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
- fail(iabe.getMessage());
- return;
- }
-
- accPC =
- UnoRuntime.queryInterface(XAccessibleComponent.class, parent);
-
- System.out.println("Press any key when the footer is not visible.");
- try{
- byte[]b = new byte[16];
- System.in.read(b);
- } catch (Exception e) {
- e.printStackTrace();
- }
-
- childCount =
- parent.getAccessibleContext().getAccessibleChildCount();
- System.out.println("ChildCount: "+childCount);
-
- if (childCount != 0)
- {
- fail("Could access footer although it was not visible on page.");
- }
-
- XComponent xComp =UnoRuntime.queryInterface(
- XComponent.class, xSpreadsheetDoc);
- xComp.dispose();
-
- }
-
-
-
-
- /**
- * Check the preview of header cells
- */
- @Test public void checkPreviewHeaderCells() {
-
- XInterface oObj = null;
- SOfficeFactory SOF = SOfficeFactory.getFactory( mXMSF);
- XSpreadsheetDocument xSpreadsheetDoc = null;
-
- try {
- System.out.println("Creating a spreadsheet document");
- xSpreadsheetDoc = SOF.createCalcDoc(null);
- } catch (com.sun.star.uno.Exception e) {
- fail(e.getMessage());
- return;
- }
-
- XModel xModel =
- UnoRuntime.queryInterface(XModel.class, xSpreadsheetDoc);
-
- XController xController = xModel.getCurrentController();
-
- //setting value of cell A1
- XCell xCell = null;
- try {
- System.out.println("Getting spreadsheet") ;
- XSpreadsheets oSheets = xSpreadsheetDoc.getSheets() ;
- XIndexAccess oIndexSheets =
- UnoRuntime.queryInterface(XIndexAccess.class, oSheets);
- Object o = oIndexSheets.getByIndex(0);
- XSpreadsheet oSheet = (XSpreadsheet)AnyConverter.toObject(
- new com.sun.star.uno.Type(XSpreadsheet.class), o);
-
- System.out.println("Getting a cell from sheet") ;
- xCell = oSheet.getCellByPosition(0, 0);
- } catch(com.sun.star.lang.IllegalArgumentException e) {
- fail(e.getMessage());
- } catch (com.sun.star.lang.WrappedTargetException e) {
- fail(e.getMessage());
- return;
- } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
- fail(e.getMessage());
- return;
- }
-
- xCell.setFormula("Value");
-
- //setting property 'PrintHeaders' of the style 'Default'
- XStyleFamiliesSupplier xSFS =
- UnoRuntime.queryInterface(XStyleFamiliesSupplier.class,
- xSpreadsheetDoc);
- XNameAccess xNA = xSFS.getStyleFamilies();
- XPropertySet xPropSet = null;
- try {
- Object oPageStyles = xNA.getByName("PageStyles");
- xNA =
- UnoRuntime.queryInterface(XNameAccess.class, oPageStyles);
- Object oDefStyle = xNA.getByName("Default");
- xPropSet =
- UnoRuntime.queryInterface(XPropertySet.class, oDefStyle);
- } catch(com.sun.star.lang.WrappedTargetException e) {
- fail(e.getMessage());
- return;
- } catch(com.sun.star.container.NoSuchElementException e) {
- fail(e.getMessage());
- return;
- }
-
- try {
- xPropSet.setPropertyValue("PrintHeaders", new Boolean(true));
- } catch(com.sun.star.lang.WrappedTargetException e) {
- fail(e.getMessage());
- return;
- } catch(com.sun.star.lang.IllegalArgumentException e) {
- fail(e.getMessage());
- return;
- } catch(com.sun.star.beans.PropertyVetoException e) {
- fail(e.getMessage());
- return;
- } catch(com.sun.star.beans.UnknownPropertyException e) {
- fail(e.getMessage());
- return;
- }
-
- //switching to 'Print Preview' mode
- try {
- XDispatchProvider xDispProv =
- UnoRuntime.queryInterface(XDispatchProvider.class, xController);
- XURLTransformer xParser =
- UnoRuntime.queryInterface(XURLTransformer.class,
- mXMSF.createInstance("com.sun.star.util.URLTransformer"));
- URL[] aParseURL = new URL[1];
- aParseURL[0] = new URL();
- aParseURL[0].Complete = ".uno:PrintPreview";
- xParser.parseStrict(aParseURL);
- URL aURL = aParseURL[0];
- XDispatch xDispatcher = xDispProv.queryDispatch(aURL, "", 0);
- if(xDispatcher != null)
- {
- xDispatcher.dispatch( aURL, null );
- }
- } catch (com.sun.star.uno.Exception e) {
- fail(e.getMessage());
- return;
- }
-
- try {
- Thread.currentThread().sleep(500) ;
- } catch (InterruptedException e) {
- System.out.println("While waiting :" + e) ;
- }
-
- AccessibilityTools at = new AccessibilityTools();
-
- XWindow xWindow = at.getCurrentWindow(mXMSF, xModel);
- XAccessible xRoot = at.getAccessibleObject(xWindow);
-
-// System.out.println("ImplementationName " + utils.getImplName(oObj));
-
- System.out.println("Press any key when the header cell is on top.");
- try{
- byte[]b = new byte[16];
- System.in.read(b);
- } catch (Exception e) {
- e.printStackTrace();
- }
-
-
- XAccessible parent = null;
-
- try {
- System.out.println("Count: " +at.getAccessibleObjectForRole
- (xRoot, AccessibleRole.TABLE, "").getAccessibleChildCount());
-// parent = at.getAccessibleObjectForRole
-// (xRoot, AccessibleRole.TABLE, "").getAccessibleChild(0);
-// oObj = parent.getAccessibleContext().getAccessibleChild(1);
- System.out.println("Getting child 2");
- oObj = at.getAccessibleObjectForRole
- (xRoot, AccessibleRole.TABLE, "").getAccessibleChild(2);
- } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
- fail(iabe.getMessage());
- return;
- }
-
- System.out.println("*** DEBUG INFO ***");
- util.dbg.getSuppServices(oObj);
- System.out.println("****** IFC ******");
- util.dbg.printInterfaces(oObj);
- System.out.println("*****************");
-
-
-/* XAccessibleContext accCtx = (XAccessibleContext)
- UnoRuntime.queryInterface(XAccessibleContext.class, oObj);
- try {
- System.out.println("Children now: " + accCtx.getAccessibleChild(0).getAccessibleContext().getAccessibleChildCount());
- } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
- fail(iabe.getMessage());
- return;
- }
-*/
-
- XAccessibleValue accV =
- UnoRuntime.queryInterface(XAccessibleValue.class, oObj);
- Object o = accV.getCurrentValue();
- System.out.println("Getting the value: "+o + " is void " + util.utils.isVoid(o));
-
-
- XAccessibleComponent accC =
- UnoRuntime.queryInterface(XAccessibleComponent.class, oObj);
-
- System.out.println("BoundsX= "+accC.getBounds().X);
- System.out.println("BoundsY= "+accC.getBounds().Y);
- System.out.println("BoundsWidth= "+accC.getBounds().Width);
- System.out.println("BoundsHeight= "+accC.getBounds().Height);
-
- XComponent xComp = UnoRuntime.queryInterface(
- XComponent.class, xSpreadsheetDoc);
- xComp.dispose();
-
- }
-
-
-
-
-
- /**
- * Check the preview of Shapes: load a document with shapes and see, if they
- * are accessible.
- */
- @Test public void checkPreviewShape() {
- SOfficeFactory SOF = SOfficeFactory.getFactory( mXMSF );
- XSpreadsheetDocument xSpreadsheetDoc = null;
- XComponent xComp = null;
- XInterface oObj = null;
-
- try {
- String docName = "calcshapes.sxc";
- System.out.println("Loading a spreadsheetdocument.");
- // String url = utils.getFullURL((String)param.get("TestDocumentPath") + "/" + docName);
- String url = TestDocument.getUrl(docName);
- System.out.println("loading document '" + url + "'");
- xComp = SOF.loadDocument(url);
- assertNotNull(xComp);
- }
- catch (com.sun.star.uno.Exception e) {
- fail(e.getMessage());
- return;
- }
-
- try {
- Thread.currentThread().sleep(500) ;
- } catch (InterruptedException e) {
- System.out.println("While waiting :" + e) ;
- }
-
- if (xComp == null) {
- fail("loading document failed.");
- return;
- }
-
- xSpreadsheetDoc = UnoRuntime.queryInterface(
- XSpreadsheetDocument.class, xComp);
- XModel aModel =
- UnoRuntime.queryInterface(XModel.class, xSpreadsheetDoc);
-
- XController xController = aModel.getCurrentController();
-
- // switching to 'Page Preview' mode
- try {
- XDispatchProvider xDispProv =
- UnoRuntime.queryInterface(XDispatchProvider.class, xController);
- XURLTransformer xParser =
- UnoRuntime.queryInterface(XURLTransformer.class,
- mXMSF.createInstance("com.sun.star.util.URLTransformer"));
- // Because it's an in/out parameter we must use an
- // array of URL objects.
- URL[] aParseURL = new URL[1];
- aParseURL[0] = new URL();
- aParseURL[0].Complete = ".uno:PrintPreview";
- xParser.parseStrict(aParseURL);
- URL aURL = aParseURL[0];
- XDispatch xDispatcher = xDispProv.queryDispatch(aURL, "", 0);
- if(xDispatcher != null)
- {
- xDispatcher.dispatch( aURL, null );
- }
- } catch (com.sun.star.uno.Exception e) {
- fail("Couldn't change mode");
- return;
- }
-
- try {
- Thread.currentThread().sleep(500) ;
- } catch (InterruptedException e) {
- System.out.println("While waiting :" + e) ;
- }
-
-
-
- System.out.println("Press any key when a shape is on top.");
- try{
- byte[]b = new byte[16];
- System.in.read(b);
- } catch (Exception e) {
- e.printStackTrace();
- }
-
- // get the accessible content
- AccessibilityTools at = new AccessibilityTools();
-
- XWindow xWindow = at.getCurrentWindow(mXMSF, aModel);
- XAccessible xRoot = at.getAccessibleObject(xWindow);
- XAccessible parent = null;
-
- try {
- XAccessibleContext con = at.getAccessibleObjectForRole
- (xRoot, AccessibleRole.SHAPE, "");
- System.out.println("Name of AccessibleContext: " + con.getAccessibleName());
- oObj = con;
- } catch (Exception e) {
- fail(e.getMessage());
- return;
- }
-
- System.out.println("ImplementationName: " + utils.getImplName(oObj));
- util.dbg.printInterfaces(oObj);
-
- xComp.dispose();
- }
-
- @BeforeClass public static void setUpConnection() throws Exception {
- connection.setUp();
- }
-
- @AfterClass public static void tearDownConnection()
- throws InterruptedException, com.sun.star.uno.Exception
- {
- connection.tearDown();
- }
-
- private static final OfficeConnection connection = new OfficeConnection();
-
-}
-
-
diff --git a/sc/qa/complex/calcPreview/makefile.mk b/sc/qa/complex/calcPreview/makefile.mk
deleted file mode 100755
index 864e14976..000000000
--- a/sc/qa/complex/calcPreview/makefile.mk
+++ /dev/null
@@ -1,123 +0,0 @@
-#*************************************************************************
-#
-# 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.
-#
-#*************************************************************************
-
-.IF "$(OOO_SUBSEQUENT_TESTS)" == ""
-nothing .PHONY:
-.ELSE
-
-PRJ = ../../..
-PRJNAME = sc
-TARGET = qa_complex_calcpreview
-
-.IF "$(OOO_JUNIT_JAR)" != ""
-PACKAGE = complex/calcPreview
-JAVATESTFILES = \
- TestDocument.java \
- ViewForwarder.java
-
-JAVAFILES = $(JAVATESTFILES)
-JARFILES = OOoRunner.jar ridl.jar test.jar unoil.jar jurt.jar
-EXTRAJARFILES = $(OOO_JUNIT_JAR)
-.END
-
-.INCLUDE: settings.mk
-.INCLUDE: target.mk
-.INCLUDE: installationtest.mk
-
-ALLTAR : javatest
-
-.END
-
-
-
-
-# PRJ = ..$/..$/..
-# TARGET = ViewForward
-# PRJNAME = $(TARGET)
-# PACKAGE = complex$/calcPreview
-#
-# # --- Settings -----------------------------------------------------
-# .INCLUDE: settings.mk
-#
-#
-# #----- compile .java files -----------------------------------------
-#
-# JARFILES = mysql.jar ridl.jar unoil.jar jurt.jar juh.jar java_uno.jar OOoRunner.jar mysql.jar
-# JAVAFILES = ViewForwarder.java
-# JAVACLASSFILES = $(foreach,i,$(JAVAFILES) $(CLASSDIR)$/$(PACKAGE)$/$(i:b).class)
-#
-# #----- make a jar from compiled files ------------------------------
-#
-# MAXLINELENGTH = 100000
-#
-# JARCLASSDIRS = $(PACKAGE)
-# JARTARGET = $(TARGET).jar
-# JARCOMPRESS = TRUE
-#
-# # --- Parameters for the test --------------------------------------
-#
-# # start an office if the parameter is set for the makefile
-# .IF "$(OFFICE)" == ""
-# CT_APPEXECCOMMAND =
-# .ELSE
-# CT_APPEXECCOMMAND = -AppExecutionCommand "$(OFFICE)$/soffice -accept=socket,host=localhost,port=8100;urp;"
-# .ENDIF
-#
-# # test base is java complex
-# CT_TESTBASE = -TestBase java_complex
-#
-# # set test document path
-# CT_TESTDOCS = -tdoc $(PWD)$/test_documents
-#
-# # test looks something like the.full.package.TestName
-# CT_TEST = -o $(PACKAGE:s\$/\.\).$(JAVAFILES:b)
-#
-# # start the runner application
-# CT_APP = org.openoffice.Runner
-#
-# # set the timeout to a bigger value
-# CT_TIMEOUT = -TimeOut 120000
-#
-# # --- Targets ------------------------------------------------------
-#
-# .IF "$(depend)" == ""
-# $(CLASSDIR)$/$(PACKAGE)$/$(JAVAFILES:b).props : ALLTAR
-# .ELSE
-# $(CLASSDIR)$/$(PACKAGE)$/$(JAVAFILES:b).props : ALLDEP
-# .ENDIF
-#
-# .INCLUDE : target.mk
-#
-#
-# RUN:
-# +java -cp "$(CLASSPATH)" $(CT_APP) $(CT_APPEXECCOMMAND) $(CT_TESTDOCS) $(CT_TESTBASE) $(CT_WORKDIR) $(CT_TIMEOUT) $(CT_TEST)
-#
-# run: RUN
-#
-# tst:
-# +@echo $(CT_TESTDOCS)
-#
diff --git a/sc/qa/complex/calcPreview/test_documents/calcshapes.sxc b/sc/qa/complex/calcPreview/test_documents/calcshapes.sxc
deleted file mode 100644
index 7f98b1a50..000000000
--- a/sc/qa/complex/calcPreview/test_documents/calcshapes.sxc
+++ /dev/null
Binary files differ
diff --git a/sc/qa/complex/cellRanges/CheckXCellRangesQuery.java b/sc/qa/complex/cellRanges/CheckXCellRangesQuery.java
deleted file mode 100755
index dfc9e4a39..000000000
--- a/sc/qa/complex/cellRanges/CheckXCellRangesQuery.java
+++ /dev/null
@@ -1,286 +0,0 @@
-/*************************************************************************
- *
- * 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 complex.cellRanges;
-
-import com.sun.star.container.XIndexAccess;
-// import complexlib.ComplexTestCase;
-import com.sun.star.lang.XMultiServiceFactory;
-// import com.sun.star.sheet.CellFlags;
-import com.sun.star.sheet.XCellRangesQuery;
-import com.sun.star.sheet.XSheetCellRanges;
-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.XColumnRowRange;
-// import com.sun.star.table.XTableColumns;
-// import com.sun.star.table.XTableRows;
-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 com.sun.star.util.XCloseable;
-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 XCellRangesQuery interface on the SheetCell service. test was
- * created for bug i20044.
- */
-public class CheckXCellRangesQuery /* extends ComplexTestCase */ {
- XSpreadsheetDocument m_xSheetDoc = null;
- XCellRangesQuery m_xCell = null;
- XSpreadsheet m_xSpreadSheet = null;
-
- /**
- * Get all test methods.
- * @return The test methods.
- */
-// public String[] getTestMethodNames() {
-// return new String[] {"checkEmptyCell", "checkFilledCell"};
-// }
-
- /**
- * Creates Spreadsheet document and the test object,
- * before the actual test starts.
- */
- @Before public void before() {
- // create a calc document
- // SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory)param.getMSF() );
- final XMultiServiceFactory xMsf = UnoRuntime.queryInterface(XMultiServiceFactory.class, connection.getComponentContext().getServiceManager());
- SOfficeFactory SOF = SOfficeFactory.getFactory(xMsf);
-
- try {
- System.out.println( "creating a Spreadsheet document" );
- m_xSheetDoc = SOF.createCalcDoc(null);
- } catch ( com.sun.star.uno.Exception e ) {
- // Some exception occures.FAILED
- e.printStackTrace( );
- fail( "Couldn?t create document");
- }
- XInterface oObj = null;
-
- try {
- System.out.println("Getting spreadsheet") ;
- XSpreadsheets oSheets = m_xSheetDoc.getSheets() ;
- XIndexAccess oIndexSheets =
- UnoRuntime.queryInterface(XIndexAccess.class, oSheets);
- m_xSpreadSheet = (XSpreadsheet) AnyConverter.toObject(
- new Type(XSpreadsheet.class),oIndexSheets.getByIndex(0));
-
- // get the cell
- System.out.println("Getting a cell from sheet") ;
- oObj = m_xSpreadSheet.getCellByPosition(2, 3);
- m_xCell = UnoRuntime.queryInterface(XCellRangesQuery.class, oObj);
-
- } catch (com.sun.star.lang.WrappedTargetException e) {
- e.printStackTrace();
- fail("Error getting cell object from spreadsheet document");
- } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
- e.printStackTrace();
- fail("Error getting cell object from spreadsheet document");
- } catch (com.sun.star.lang.IllegalArgumentException e) {
- e.printStackTrace();
- fail("Error getting cell object from spreadsheet document");
- }
-
- // set one value for comparison.
- try {
- m_xSpreadSheet.getCellByPosition(1, 1).setValue(15);
- m_xSpreadSheet.getCellByPosition(1, 3).setValue(5);
- m_xSpreadSheet.getCellByPosition(2, 1).setFormula("=B2+B4");
-/* m_xSpreadSheet.getCellByPosition(2, 1).setFormula("=B2+B3");
- m_xSpreadSheet.getCellByPosition(3, 2).setFormula("");
- m_xSpreadSheet.getCellByPosition(3, 3).setFormula(""); */
- } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
- e.printStackTrace();
- fail("Could not fill cell (1, 1) with a value.");
- }
-
- }
-
- /*
- * 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, m_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");
- }
-
- m_xSheetDoc = null;
-
- return worked;
- }
-
- @After public void after()
- {
- closeSpreadsheetDocument();
- }
-
- /**
- * Perform some tests on an empty cell:
- * <ol>
- * <li>compare an empty cell with a cell with a value in the same column</li>
- * <li>compare an empty cell with a cell with a value in the same row</li>
- * <li>query for empty cells</li>
- * <ol>
- */
- @Test public void checkEmptyCell() {
- System.out.println("Checking an empty cell...");
- // compare an empty cell with a cell with a value
- assertTrue("\tQuery column differences did not return the correct value.", _queryColumnDifferences("Sheet1.C4"));
- // compare an empty cell with a cell with a value
- assertTrue("\tQuery column differences did not return the correct value.", _queryRowDifferences("Sheet1.C4"));
- // try to get this cell
-// assertTrue("\tQuery empty cells did not return the correct value.", _queryEmptyCells("Sheet1.C4"));
- System.out.println("...done");
- }
-
- /**
- * Perform some tests on a filled cell:
- * <ol>
- * <li>compare an cell with value 5 with a cell with value 15 in the same column</li>
- * <li>compare an cell with value 5 with a cell with value 15 in the same row</li>
- * <li>query for an empty cell.</li>
- * <ol>
- */
- @Test public void checkFilledCell() {
- System.out.println("Checking a filled cell...");
-
- // fill the cell with a value
- try {
- m_xSpreadSheet.getCellByPosition(2, 3).setValue(15);
- } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
- e.printStackTrace();
- fail("Could not fill cell (2, 3) with a value.");
- }
-
- // compare an cell with value 5 with a cell with value 15
- assertTrue("\tQuery column differences did not return the correct value.", _queryColumnDifferences("Sheet1.C4"));
- // compare an cell with value 5 with a cell with value 15
- assertTrue("\tQuery column differences did not return the correct value.", _queryRowDifferences("Sheet1.C4"));
- // try to get nothing
- assertTrue("\tQuery empty cells did not return the correct value.", _queryEmptyCells(""));
- System.out.println("...done");
- }
-
-
- /**
- * Query column differences between my cell(2,3) and (1,1).
- * @param expected The expected outcome value.
- * @return True, if the result equals the expected result.
- */
- public boolean _queryColumnDifferences(String expected) {
- System.out.println("\tQuery column differences");
- XSheetCellRanges ranges = m_xCell.queryColumnDifferences(
- new CellAddress((short) 0, 1, 1));
- String getting = ranges.getRangeAddressesAsString();
-
- if (!getting.equals(expected)) {
- System.out.println("\tGetting: " + getting);
- System.out.println("\tShould have been: " + expected);
- return false;
- }
- return true;
- }
-
- /**
- * Query for an empty cell.
- * @param expected The expected outcome value.
- * @return True, if the result equals the expected result.
- */
- public boolean _queryEmptyCells(String expected) {
- System.out.println("\tQuery empty cells");
- XSheetCellRanges ranges = m_xCell.queryEmptyCells();
- String getting = ranges.getRangeAddressesAsString();
-
- if (!getting.equals(expected)) {
- System.out.println("\tGetting: " + getting);
- System.out.println("\tShould have been: " + expected);
- return false;
- }
- return true;
- }
-
- /**
- * Query row differences between my cell(2,3) and (1,1).
- * @param expected The expected outcome value.
- * @return True, if the result equals the expected result.
- */
- public boolean _queryRowDifferences(String expected) {
- System.out.println("\tQuery row differences");
- XSheetCellRanges ranges = m_xCell.queryRowDifferences(
- new CellAddress((short) 0, 1, 1));
- String getting = ranges.getRangeAddressesAsString();
-
- if (!getting.equals(expected)) {
- System.out.println("\tGetting: " + getting);
- System.out.println("\tShould have been: " + expected);
- return false;
- }
-
- return true;
- }
-
-
- @BeforeClass public static void setUpConnection() throws Exception {
- connection.setUp();
- }
-
- @AfterClass public static void tearDownConnection()
- throws InterruptedException, com.sun.star.uno.Exception
- {
- connection.tearDown();
- }
-
- private static final OfficeConnection connection = new OfficeConnection();
-
-}
diff --git a/sc/qa/complex/cellRanges/makefile.mk b/sc/qa/complex/cellRanges/makefile.mk
deleted file mode 100755
index a0beb3839..000000000
--- a/sc/qa/complex/cellRanges/makefile.mk
+++ /dev/null
@@ -1,51 +0,0 @@
-#*************************************************************************
-#
-# 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.
-#
-#*************************************************************************
-
-.IF "$(OOO_SUBSEQUENT_TESTS)" == ""
-nothing .PHONY:
-.ELSE
-
-PRJ = ../../..
-PRJNAME = sc
-TARGET = qa_complex_cellRanges
-
-.IF "$(OOO_JUNIT_JAR)" != ""
-PACKAGE = complex/cellRanges
-JAVATESTFILES = \
- CheckXCellRangesQuery.java
-JAVAFILES = $(JAVATESTFILES)
-JARFILES = OOoRunner.jar ridl.jar test.jar unoil.jar
-EXTRAJARFILES = $(OOO_JUNIT_JAR)
-.END
-
-.INCLUDE: settings.mk
-.INCLUDE: target.mk
-.INCLUDE: installationtest.mk
-
-ALLTAR : javatest
-
-.END
diff --git a/sc/qa/complex/dataPilot/CheckDataPilot.java b/sc/qa/complex/dataPilot/CheckDataPilot.java
deleted file mode 100644
index 26a2ff202..000000000
--- a/sc/qa/complex/dataPilot/CheckDataPilot.java
+++ /dev/null
@@ -1,403 +0,0 @@
-/*************************************************************************
- *
- * 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 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();
-
-
-}
diff --git a/sc/qa/complex/dataPilot/_XDataPilotDescriptor.java b/sc/qa/complex/dataPilot/_XDataPilotDescriptor.java
deleted file mode 100644
index 2d8267961..000000000
--- a/sc/qa/complex/dataPilot/_XDataPilotDescriptor.java
+++ /dev/null
@@ -1,464 +0,0 @@
-/*************************************************************************
- *
- * 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 complex.dataPilot;
-
-import com.sun.star.beans.XPropertySet;
-import com.sun.star.container.XIndexAccess;
-import com.sun.star.container.XNamed;
-import com.sun.star.sheet.DataPilotFieldOrientation;
-import com.sun.star.sheet.XDataPilotDescriptor;
-import com.sun.star.table.CellRangeAddress;
-import com.sun.star.uno.UnoRuntime;
-// import lib.MultiMethodTest;
-// import lib.Status;
-//import lib.StatusException;
-import lib.TestParameters;
-// import share.LogWriter;
-
-/**
-* Testing <code>com.sun.star.sheet.XDataPilotDescriptor</code>
-* interface methods :
-* <ul>
-* <li><code> getTag()</code></li>
-* <li><code> setTag()</code></li>
-* <li><code> getSourceRange()</code></li>
-* <li><code> setSourceRange()</code></li>
-* <li><code> getFilterDescriptor()</code></li>
-* <li><code> getDataPilotFields()</code></li>
-* <li><code> getColumnFields()</code></li>
-* <li><code> getRowFields()</code></li>
-* <li><code> getPageFields()</code></li>
-* <li><code> getDataFields()</code></li>
-* <li><code> getHiddenFields()</code></li>
-* </ul> <p>
-* This test needs the following object relations :
-* <ul>
-* <li> <code>'FIELDSAMOUNT'</code> (of type <code>Integer</code>):
-* to have number of fields </li>
-* <ul> <p>
-* @see com.sun.star.sheet.XDataPilotDescriptor
-*/
-public class _XDataPilotDescriptor {
-
- public XDataPilotDescriptor oObj = null;
- CellRangeAddress CRA = new CellRangeAddress((short)1, 0, 0, 5, 5);
- CellRangeAddress oldCRA = null ;
- String sTag = new String ("XDataPilotDescriptor_Tag");
- String fieldsNames[];
- int fieldsAmount = 0;
- int tEnvFieldsAmount = 0;
-
- /**
- * The test parameters
- */
- private TestParameters param = null;
-
- /**
- * The log writer
- */
-// private LogWriter log = null;
-
- /**
- * Constructor: gets the object to test, a logger and the test parameters
- * @param xObj The test object
- * @param param The test parameters
- */
- public _XDataPilotDescriptor(XDataPilotDescriptor xObj/*,
- LogWriter log*/, TestParameters param) {
- oObj = xObj;
- // this.log = log;
- this.param = param;
- }
-
- /**
- * Retrieves object relations.
-
- * @return
- */
- public boolean before() {
- Integer amount = (Integer)param.get("FIELDSAMOUNT");
- if (amount == null) {
- System.out.println("Relation 'FIELDSAMOUNT' not found");
- return false;
- }
- tEnvFieldsAmount = amount.intValue();
- return true;
- }
-
- /**
- * Test calls the method and compares returned value with value that was set
- * in method <code>setSourceRange()</code>. <p>
- * Has <b> OK </b> status if all fields of cell range addresses are equal. <p>
- * The following method tests are to be completed successfully before :
- * <ul>
- * <li> <code> setSourceRange() </code> : to have current source range </li>
- * </ul>
- * @return
- */
- public boolean _getSourceRange(){
-// requiredMethod("setSourceRange()");
- boolean bResult = true;
-
- CellRangeAddress objRA = oObj.getSourceRange();
- bResult &= objRA.Sheet == CRA.Sheet;
- bResult &= objRA.StartRow == CRA.StartRow;
- bResult &= objRA.StartColumn == CRA.StartColumn;
- bResult &= objRA.EndRow == CRA.EndRow;
- bResult &= objRA.EndColumn == CRA.EndColumn;
-
- return bResult;
- }
-
- /**
- * Test gets the current source range, stores it and sets new source range.<p>
- * Has <b> OK </b> status if the method successfully returns. <p>
- * The following method tests are to be executed before :
- * <ul>
- * <li> <code> getColumnFields() </code> </li>
- * <li> <code> getRowFields() </code> </li>
- * <li> <code> getDataFields() </code> </li>
- * <li> <code> getHiddenFields() </code> </li>
- * <li> <code> getPageFields() </code> </li>
- * </ul>
- * @return
- */
- public boolean _setSourceRange(){
-/* executeMethod("getColumnFields()") ;
- executeMethod("getRowFields()") ;
- executeMethod("getDataFields()") ;
- executeMethod("getHiddenFields()") ;
- executeMethod("getPageFields()") ; */
-
- oldCRA = oObj.getSourceRange() ;
- oObj.setSourceRange(CRA);
-
- return true;
- }
-
- /**
- * Test calls the method and checks returned value with value that was set
- * by method <code>setTag()</code>. <p>
- * Has <b> OK </b> status if returned value is equal to value that was set
- * by method <code>setTag()</code>. <p>
- * The following method tests are to be completed successfully before :
- * <ul>
- * <li> <code> setTag() </code> : to have current tag </li>
- * </ul>
- * @return
- */
- public boolean _getTag(){
-// requiredMethod("setTag()");
- boolean bResult = true;
-
- String objTag = oObj.getTag();
- bResult &= objTag.equals(sTag);
-
- return bResult;
- }
-
- /**
- * Test just calls the method. <p>
- * Has <b> OK </b> status if the method successfully returns. <p>
- * @return
- */
- public boolean _setTag(){
- oObj.setTag(sTag);
- return true;
- }
-
- /**
- * Test calls the method , checks returned value, compares
- * number of fields goten from returned value and obtained by object
- * relation <code>'FIELDSAMOUNT'</code> and set property
- * <code>Orientation</code> to one of DataPilotFieldOrientation values. <p>
- * Has <b> OK </b> status if returned value isn't null, number of fields
- * goten from returned value is less than number of fields obtained by relation
- * and no exceptions were thrown. <p>
- * @return
- */
- public boolean _getDataPilotFields(){
- boolean bResult = true;
- XIndexAccess IA = null;
-
- IA = oObj.getDataPilotFields();
- if (IA == null) {
- System.out.println("Returned value is null.");
- return false;
- } else {System.out.println("getDataPilotFields returned not Null value -- OK");}
-
- fieldsAmount = IA.getCount();
- if (fieldsAmount < tEnvFieldsAmount) {
- System.out.println("Number of fields is less than number goten by relation.");
- return false;
- } else {System.out.println("count of returned fields -- OK");}
-
- fieldsNames = new String[tEnvFieldsAmount];
- int i = -1 ;
- int cnt = 0 ;
- while (++i < fieldsAmount) {
- Object field;
- try {
- field = IA.getByIndex(i);
- } catch(com.sun.star.lang.WrappedTargetException e) {
- e.printStackTrace();
- return false;
- } catch(com.sun.star.lang.IndexOutOfBoundsException e) {
- e.printStackTrace();
- return false;
- }
-
- XNamed named = UnoRuntime.queryInterface(XNamed.class, field);
- String name = named.getName();
-
- System.out.println("Field : '" + name + "' ... ") ;
-
- if (!name.equals("Data")) {
-
- fieldsNames[cnt] = name ;
-
- XPropertySet props =
- UnoRuntime.queryInterface(XPropertySet.class, field);
-
- try {
- switch (cnt % 5) {
- case 0 :
- props.setPropertyValue("Orientation",
- DataPilotFieldOrientation.COLUMN);
- System.out.println(" Column") ;
- break;
- case 1 :
- props.setPropertyValue("Orientation",
- DataPilotFieldOrientation.ROW);
- System.out.println(" Row") ;
- break;
- case 2 :
- props.setPropertyValue("Orientation",
- DataPilotFieldOrientation.DATA);
- System.out.println(" Data") ;
- break;
- case 3 :
- props.setPropertyValue("Orientation",
- DataPilotFieldOrientation.HIDDEN);
- System.out.println(" Hidden") ;
- break;
- case 4 :
- props.setPropertyValue("Orientation",
- DataPilotFieldOrientation.PAGE);
- System.out.println(" Page") ;
- props.setPropertyValue("CurrentPage", "20");
- break;
- } } catch (com.sun.star.lang.WrappedTargetException e) {
- e.printStackTrace();
- return false;
- } catch (com.sun.star.lang.IllegalArgumentException e) {
- e.printStackTrace();
- return false;
- } catch (com.sun.star.beans.PropertyVetoException e) {
- e.printStackTrace();
- return false;
- } catch (com.sun.star.beans.UnknownPropertyException e) {
- e.printStackTrace();
- return false;
- }
- if (++cnt > 4)
- {
- break;
- }
- }
- else
- {
- return false;
- }
- }
-
- return bResult;
- }
-
- /**
- * Test calls the method and checks returned collection using the method
- * <code>CheckNames()</code>. <p>
- * Has <b> OK </b> status if the method <code>CheckNames()</code> returns true
- * and no exceptions were thrown. <p>
- * The following method tests are to be completed successfully before :
- * <ul>
- * <li> <code> getDataPilotFields() </code> : to have array of field names </li>
- * </ul>
- * @return
- */
- public boolean _getColumnFields(){
-// requiredMethod("getDataPilotFields()");
- System.out.println("getColumnFields") ;
- XIndexAccess IA = oObj.getColumnFields();
- return CheckNames(IA, 0);
- }
-
- /**
- * Test calls the method and checks returned collection using the method
- * <code>CheckNames()</code>. <p>
- * Has <b> OK </b> status if the method <code>CheckNames()</code> returned true
- * and no exceptions were thrown. <p>
- * The following method tests are to be completed successfully before :
- * <ul>
- * <li> <code> getDataPilotFields() </code> : to have array of field names </li>
- * </ul>
- * @return
- */
- public boolean _getDataFields(){
-// requiredMethod("getDataPilotFields()");
- System.out.println("getDataFields") ;
- XIndexAccess IA = oObj.getDataFields();
- return CheckNames(IA, 2);
- }
-
- /**
- * Test calls the method and checks returned collection using the method
- * <code>CheckNames()</code>. <p>
- * Has <b> OK </b> status if the method <code>CheckNames()</code> returned true
- * and no exceptions were thrown. <p>
- * The following method tests are to be completed successfully before :
- * <ul>
- * <li> <code> getDataPilotFields() </code> : to have array of field names </li>
- * </ul>
- * @return
- */
- public boolean _getHiddenFields(){
-// requiredMethod("getDataPilotFields()");
- System.out.println("getHiddenFields") ;
- XIndexAccess IA = oObj.getHiddenFields();
- return CheckNames(IA, 3);
- }
-
- /**
- * Test calls the method and checks returned collection using the method
- * <code>CheckNames()</code>. <p>
- * Has <b> OK </b> status if the method <code>CheckNames()</code> returned true
- * and no exceptions were thrown. <p>
- * The following method tests are to be completed successfully before :
- * <ul>
- * <li> <code> getDataPilotFields() </code> : to have array of field names </li>
- * </ul>
- * @return
- */
- public boolean _getRowFields(){
-// requiredMethod("getDataPilotFields()");
- System.out.println("getRowFields") ;
- XIndexAccess IA = oObj.getRowFields();
- boolean bResult = CheckNames(IA, 1);
- return bResult;
- }
-
- /**
- * setting of PageFields isn't supported by StarOffice Calc
- * Has <b> OK </b> status if the returned IndexAccess
- * isn't NULL. <p>
- * The following method tests are to be completed successfully before :
- * <ul>
- * <li> <code> getDataPilotFields() </code> : to have array of field names </li>
- * </ul>
- * @return
- */
- public boolean _getPageFields(){
-// requiredMethod("getDataPilotFields()");
- System.out.println("getPageFields") ;
- XIndexAccess IA = oObj.getPageFields();
- boolean bResult = CheckNames(IA, 4);
- return bResult;
- }
-
- /**
- * Test calls the method and checks returned value. <p>
- * Has <b> OK </b> status if returned value isn't null
- * and no exceptions were thrown. <p>
- * @return
- */
- public boolean _getFilterDescriptor(){
- boolean bResult = oObj.getFilterDescriptor() != null;
- return bResult;
- }
-
- /**
- * Method checks that the field with index <code>rem</code> exists
- * in the array <code>IA</code>.
- * @param IA collection of elements that support interface <code>XNamed</code>
- * @param rem index of field in the array of field names that was stored in
- * the method <code>getDataPilotFields()</code>
- * @return true if required field name exists in passed collection;
- * false otherwise
- * @see com.sun.star.container.XNamed
- */
- private boolean CheckNames(XIndexAccess IA, int rem) {
- String name = null;
-
- if (IA == null) {
- System.out.println("Null retruned.") ;
- return false ;
- }
-
- if (fieldsNames[rem] == null) {
- System.out.println("No fields were set to this orientation - cann't check result") ;
- return true ;
- }
-
- if (IA.getCount() == 0) {
- System.out.println("No fields found. Must be at least '"
- + fieldsNames[rem] + "'") ;
- return false ;
- }
-
- try {
- System.out.println("Fields returned ") ;
- for (int i = 0; i < IA.getCount(); i++) {
- Object field = IA.getByIndex(i);
- XNamed named = UnoRuntime.queryInterface
- (XNamed.class, field);
- name = named.getName();
- System.out.println(" " + name) ;
- if (fieldsNames[rem].equals(name)) {
- System.out.println(" - OK") ;
- return true ;
- }
- }
- } catch (com.sun.star.lang.WrappedTargetException e) {
- e.printStackTrace();
- return false ;
- } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
- e.printStackTrace();
- return false ;
- }
- System.out.println(" - FAILED (field " + fieldsNames[rem] + " was not found.") ;
- return false ;
- }
-
- /**
- * Recreates object(to back old orientations of the fields).
- *
- protected void after() {
- disposeEnvironment();
- }*/
-}
-
diff --git a/sc/qa/complex/dataPilot/_XDataPilotTable.java b/sc/qa/complex/dataPilot/_XDataPilotTable.java
deleted file mode 100644
index 0f164a654..000000000
--- a/sc/qa/complex/dataPilot/_XDataPilotTable.java
+++ /dev/null
@@ -1,135 +0,0 @@
-/*************************************************************************
- *
- * 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 complex.dataPilot;
-
-import com.sun.star.sheet.XDataPilotTable;
-import com.sun.star.table.CellAddress;
-import com.sun.star.table.CellRangeAddress;
-import com.sun.star.table.XCell;
-// import lib.Status;
-//import lib.StatusException;
-import lib.TestParameters;
-// import share.LogWriter;
-
-/**
-* Testing <code>com.sun.star.sheet.XDataPilotTable</code>
-* interface methods :
-* <ul>
-* <li><code> getOutputRange()</code></li>
-* <li><code> refresh()</code></li>
-* </ul> <p>
-* This test needs the following object relations :
-* <ul>
-* <li> <code>'OUTPUTRANGE'</code> (of type <code>CellAddress</code>):
-* to check value returned by method <code>getOutputRange()</code> </li>
-* <li> <code>'CELLFORCHANGE'</code> (of type <code>XCell</code>):
-* to check the method refresh(value of this cell will be changed)</li>
-* <li> <code>'CELLFORCHECK'</code> (of type <code>XCell</code>):
-* to check the method refresh (value of this cell must be changed after refresh
-* call) </li><ul> <p>
-* @see com.sun.star.sheet.XDataPilotTable
-* @see com.sun.star.table.CellAddress
-*/
-public class _XDataPilotTable {
-
- public XDataPilotTable oObj = null;
- XCell xCellForChange = null;
- XCell xCellForCheck = null;
- CellAddress OutputRange = null;
- int changeValue = 0;
-
- /**
- * The test parameters
- */
- private TestParameters param = null;
-
- /**
- * The log writer
- */
- // private LogWriter log = null;
-
- /**
- * Constructor: gets the object to test, a logger and the test parameters
- * @param xObj The test object
-
- * @param param The test parameters
- */
- public _XDataPilotTable(XDataPilotTable xObj/*,
- LogWriter log*/, TestParameters param) {
- oObj = xObj;
- // this.log = log;
- this.param = param;
- }
-
- public boolean before() {
- xCellForChange = (XCell)param.get("CELLFORCHANGE");
- xCellForCheck = (XCell)param.get("CELLFORCHECK");
- OutputRange = (CellAddress)param.get("OUTPUTRANGE");
- changeValue = ((Integer)param.get("CHANGEVALUE")).intValue();
-
- if (xCellForChange == null || OutputRange == null ||
- xCellForCheck == null) {
- System.out.println("Relation not found");
- return false;
- }
- return true;
- }
- /**
- * Test calls the method and checks returned value using value obtained by
- * object relation <code>'OUTPUTRANGE'</code>. <p>
- * Has <b> OK </b> status if values are equal. <p>
- * @return
- */
- public boolean _getOutputRange(){
- boolean bResult = true;
- CellRangeAddress objRange = oObj.getOutputRange();
- bResult &= OutputRange.Sheet == objRange.Sheet;
- bResult &= OutputRange.Row == objRange.StartRow;
- bResult &= OutputRange.Column == objRange.StartColumn;
- return bResult;
- }
-
- /**
- * Test sets new value of the cell obtained by object relation
- * 'CELLFORCHANGE', and checks value of the cell obtained by object
- * relation 'CELLFORCHECK'.<p>
- * Has <b>OK</b> status if value of the cell obtained by object relation
- * 'CELLFORCHECK' is changed. <p>
- * @return
- */
- public boolean _refresh(){
- xCellForChange.setValue(changeValue);
- double oldData = xCellForCheck.getValue();
- oObj.refresh();
- double newData = xCellForCheck.getValue();
- System.out.println("Old data:" + oldData + "; new data:" + newData);
-
- return oldData != newData;
- }
-}
-
diff --git a/sc/qa/complex/dataPilot/_XNamed.java b/sc/qa/complex/dataPilot/_XNamed.java
deleted file mode 100644
index 48433d8c8..000000000
--- a/sc/qa/complex/dataPilot/_XNamed.java
+++ /dev/null
@@ -1,159 +0,0 @@
-/*************************************************************************
- *
- * 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 complex.dataPilot;
-
-import com.sun.star.container.XNamed;
-import lib.TestParameters;
-// import share.LogWriter;
-// import util.utils;
-
-/**
-* Testing <code>com.sun.star.container.XNamed</code>
-* interface methods :
-* <ul>
-* <li><code> getName()</code></li>
-* <li><code> setName()</code></li>
-* </ul>
-* This test need the following object relations :
-* <ul>
-* <li> <code>'setName'</code> : of <code>Boolean</code>
-* type. If it exists then <code>setName</code> method
-* isn't to be tested and result of this test will be
-* equal to relation value.</li>
-* <ul> <p>
-* Test is <b> NOT </b> multithread compilant. <p>
-* @see com.sun.star.container.XNamed
-*/
-public class _XNamed {
-
- /**
- * The object that is testsed.
- */
- public XNamed oObj = null;
-
- /**
- * The test parameters
- */
- private TestParameters param = null;
-
- /**
- * The log writer
- */
- // private LogWriter log = null;
-
- /**
- * Constructor: gets the object to test, a logger and the test parameters
- * @param xObj The test object
- * @param log A log writer
- * @param param The test parameters
- */
- public _XNamed(XNamed xObj/*, LogWriter log*/, TestParameters param) {
- oObj = xObj;
- // this.log = log;
- this.param = param;
- }
-
- /**
- * Test calls the method and checks return value and that
- * no exceptions were thrown. <p>
- * Has <b> OK </b> status if the method returns non null value
- * and no exceptions were thrown. <p>
- */
- public boolean _getName() {
-
- // write to log what we try next
- System.out.println( "test for getName()" );
-
- boolean result = true;
- boolean loc_result = true;
- String name = null;
- String NewName = null;
-
- loc_result = ((name = oObj.getName()) != null);
- System.out.println("getting the name \"" + name + "\"");
-
- if (loc_result)
- {
- System.out.println("... getName() - OK");
- }
- else
- {
- System.out.println("... getName() - FAILED");
- }
- result &= loc_result;
- return result;
- }
-
- /**
- * Sets a new name for object and checks if it was properly
- * set. Special cases for the following objects :
- * <ul>
- * <li><code>ScSheetLinkObj</code> : name must be in form of URL.</li>
- * <li><code>ScDDELinkObj</code> : name must contain link to cell in
- * some external Sheet.</li>
- * </ul>
- * Has <b> OK </b> status if new name was successfully set, or if
- * object environment contains relation <code>'setName'</code> with
- * value <code>true</code>. <p>
- * The following method tests are to be completed successfully before :
- * <ul>
- * <li> <code> getName() </code> : to be sure the method works</li>
- * </ul>
- */
- public boolean _setName(){
-// requiredMethod("getName()");
- System.out.println("testing setName() ... ");
-
- String oldName = oObj.getName();
- String NewName = oldName == null ? "XNamed" : oldName + "X" ;
-
- boolean result = true;
- boolean loc_result = true;
- System.out.println("set the name of object to \"" + NewName + "\"");
- oObj.setName(NewName);
- System.out.println("check that container has element with this name");
-
- String name = oObj.getName();
- System.out.println("getting the name \"" + name + "\"");
- loc_result = name.equals(NewName);
-
- if (loc_result)
- {
- System.out.println("... setName() - OK");
- }
- else
- {
- System.out.println("... setName() - FAILED");
- }
- result &= loc_result;
- oObj.setName(oldName);
- return result;
- }
-}
-
-
diff --git a/sc/qa/complex/dataPilot/_XPropertySet.java b/sc/qa/complex/dataPilot/_XPropertySet.java
deleted file mode 100644
index 33dc592af..000000000
--- a/sc/qa/complex/dataPilot/_XPropertySet.java
+++ /dev/null
@@ -1,631 +0,0 @@
-/*************************************************************************
- *
- * 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 complex.dataPilot;
-
-import com.sun.star.beans.Property;
-import com.sun.star.beans.PropertyAttribute;
-import com.sun.star.beans.PropertyChangeEvent;
-import com.sun.star.beans.XPropertyChangeListener;
-import com.sun.star.beans.XPropertySet;
-import com.sun.star.beans.XPropertySetInfo;
-import com.sun.star.beans.XVetoableChangeListener;
-import com.sun.star.lang.EventObject;
-import java.util.Random;
-import java.util.StringTokenizer;
-import lib.TestParameters;
-// import share.LogWriter;
-//import lib.MultiMethodTest;
-import util.ValueChanger;
-import util.utils;
-
-/**
-* Testing <code>com.sun.star.beans.XPropertySet</code>
-* interface methods :
-* <ul>
-* <li><code>getPropertySetInfo()</code></li>
-* <li><code>setPropertyValue()</code></li>
-* <li><code>getPropertyValue()</code></li>
-* <li><code>addPropertyChangeListener()</code></li>
-* <li><code>removePropertyChangeListener()</code></li>
-* <li><code>addVetoableChangeListener()</code></li>
-* <li><code>removeVetoableChangeListener()</code></li>
-* </ul>
-* @see com.sun.star.beans.XPropertySet
-*/
-public class _XPropertySet {
-
- /**
- * The object that is testsed.
- */
- private XPropertySet oObj = null;
-
- /**
- * The test parameters
- */
- private TestParameters param = null;
-
- /**
- * The log writer
- */
- // private LogWriter log = null;
-
- /**
- * Flag that indicates change listener was called.
- */
- boolean propertyChanged = false;
-
-
- /**
- * The own property change listener
- */
- XPropertyChangeListener PClistener = new MyChangeListener();
-
- /**
- * Listener that must be called on bound property changing.
- */
- public class MyChangeListener implements XPropertyChangeListener {
- /**
- * Just set <code>propertyChanged</code> flag to true.
- */
- public void propertyChange(PropertyChangeEvent e) {
- propertyChanged = true;
- }
- public void disposing (EventObject obj) {}
- };
-
-
- /**
- * Flag that indicates veto listener was called.
- */
- boolean vetoableChanged = false;
-
- /**
- * The own vetoable change listener
- */
- XVetoableChangeListener VClistener = new MyVetoListener();
-
- /**
- * Listener that must be called on constrained property changing.
- */
- public class MyVetoListener implements XVetoableChangeListener {
- /**
- * Just set <code>vetoableChanged</code> flag to true.
- */
- public void vetoableChange(PropertyChangeEvent e) {
- vetoableChanged = true;
- }
- public void disposing (EventObject obj) {}
- };
-
-
- /**
- * Properties to test
- */
- PropsToTest PTT = new PropsToTest();
-
- /**
- * Structure that collects three properties of each type to test :
- * Constrained, Bound and Normal.
- */
- public class PropsToTest {
- String constrained = null;
- String bound = null;
- String normal = null;
- }
-
- /**
- * Constructor: gets the object to test, a logger and the test parameters
- * @param xObj The test object
- * @param log A log writer
- * @param param The test parameters
- */
- public _XPropertySet(XPropertySet xObj/*, LogWriter log*/, TestParameters param) {
- oObj = xObj;
- // this.log = log;
- this.param = param;
- }
-
- /**
- * Tests method <code>getPropertySetInfo</code>. After test completed
- * call {@link #getPropsToTest} method to retrieve different kinds
- * of properties to test then. <p>
- * Has OK status if not null <code>XPropertySetInfo</code>
- * object returned.<p>
- * Since <code>getPropertySetInfo</code> is optional, it may return null,
- * if it is not implemented. This method uses then an object relation
- * <code>PTT</code> (Properties To Test) to determine available properties.
- * All tests for services without <code>getPropertySetInfo</code> must
- * provide this object relation.
- */
- public boolean _getPropertySetInfo() {
- XPropertySetInfo propertySetInfo = oObj.getPropertySetInfo();
-
- if (propertySetInfo == null) {
- System.out.println("getPropertySetInfo() method returned null");
- String[] ptt = (String[]) param.get("PTT");
- PTT.normal=ptt[0];
- PTT.bound=ptt[1];
- PTT.constrained=ptt[2];
- } else {
- getPropsToTest(propertySetInfo);
- }
-
- return true;
-
- } // end of getPropertySetInfo()
-
- /**
- * Tests change listener which added for bound properties.
- * Adds listener to bound property (if it exists), then changes
- * its value and check if listener was called. <p>
- * Method tests to be successfully completed before :
- * <ul>
- * <li> <code>getPropertySetInfo</code> : in this method test
- * one of bound properties is retrieved. </li>
- * </ul> <p>
- * Has OK status if NO bound properties exist or if listener
- * was successfully called.
- */
- public boolean _addPropertyChangeListener() {
-
- propertyChanged = false;
- boolean result = true;
-
- if ( PTT.bound.equals("none") ) {
- System.out.println("*** No bound properties found ***");
- } else {
- try {
- oObj.addPropertyChangeListener(PTT.bound,PClistener);
- Object gValue = oObj.getPropertyValue(PTT.bound);
- oObj.setPropertyValue(PTT.bound,
- ValueChanger.changePValue(gValue));
- } catch (com.sun.star.beans.PropertyVetoException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.bound+"'");
- e.printStackTrace();
- } catch (com.sun.star.lang.IllegalArgumentException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.bound+"'");
- e.printStackTrace();
- } catch (com.sun.star.beans.UnknownPropertyException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.bound+"'");
- e.printStackTrace();
- } catch (com.sun.star.lang.WrappedTargetException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.bound+"'");
- e.printStackTrace();
- } // end of try-catch
- result = propertyChanged;
- if (!propertyChanged) {
- System.out.println("propertyChangeListener wasn't called for '"+
- PTT.bound+"'");
- }
- } //endif
-
- return result;
-
- } // end of addPropertyChangeListener()
-
- /**
- * Tests vetoable listener which added for constrained properties.
- * Adds listener to constrained property (if it exists), then changes
- * its value and check if listener was called. <p>
- * Method tests to be successfully completed before :
- * <ul>
- * <li> <code>getPropertySetInfo</code> : in this method test
- * one of constrained properties is retrieved. </li>
- * </ul> <p>
- * Has OK status if NO constrained properties exist or if listener
- * was successfully called.
- */
- public boolean _addVetoableChangeListener() {
-
-// requiredMethod("getPropertySetInfo()");
-
- vetoableChanged = false;
- boolean result = true;
-
- if ( PTT.constrained.equals("none") ) {
- System.out.println("*** No constrained properties found ***");
- } else {
- try {
- oObj.addVetoableChangeListener(PTT.constrained,VClistener);
- Object gValue = oObj.getPropertyValue(PTT.constrained);
- oObj.setPropertyValue(PTT.constrained,
- ValueChanger.changePValue(gValue));
- } catch (com.sun.star.beans.PropertyVetoException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.constrained+"'");
- e.printStackTrace();
- } catch (com.sun.star.lang.IllegalArgumentException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.constrained+"'");
- e.printStackTrace();
- } catch (com.sun.star.beans.UnknownPropertyException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.constrained+"'");
- e.printStackTrace();
- } catch (com.sun.star.lang.WrappedTargetException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.constrained+"'");
- e.printStackTrace();
- } // end of try-catch
- result = vetoableChanged;
- if (!vetoableChanged) {
- System.out.println("vetoableChangeListener wasn't called for '"+
- PTT.constrained+"'");
- }
- } //endif
-
- return result;
-
- } // end of addVetoableChangeListener()
-
-
- /**
- * Tests <code>setPropertyValue</code> method.
- * Stores value before call, and compares it with value after
- * call. <p>
- * Method tests to be successfully completed before :
- * <ul>
- * <li> <code>getPropertySetInfo</code> : in this method test
- * one of normal properties is retrieved. </li>
- * </ul> <p>
- * Has OK status if NO normal properties exist or if value before
- * method call is not equal to value after.
- */
- public boolean _setPropertyValue() {
-
-// requiredMethod("getPropertySetInfo()");
-
- Object gValue = null;
- Object sValue = null;
-
- boolean result = true;
-
- if ( PTT.normal.equals("none") ) {
- System.out.println("*** No changeable properties found ***");
- } else {
- try {
- gValue = oObj.getPropertyValue(PTT.normal);
- sValue = ValueChanger.changePValue(gValue);
- oObj.setPropertyValue(PTT.normal, sValue);
- sValue = oObj.getPropertyValue(PTT.normal);
- } catch (com.sun.star.beans.PropertyVetoException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.normal+"'");
- e.printStackTrace();
- } catch (com.sun.star.lang.IllegalArgumentException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.normal+"'");
- e.printStackTrace();
- } catch (com.sun.star.beans.UnknownPropertyException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.normal+"'");
- e.printStackTrace();
- } catch (com.sun.star.lang.WrappedTargetException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.normal+"'");
- e.printStackTrace();
- } // end of try-catch
- result = !gValue.equals(sValue);
- } //endif
-
- return result;
-
- } // end of setPropertyValue()
-
- /**
- * Tests <code>getPropertyValue</code> method.
- * Just call this method and checks for no exceptions <p>
- * Method tests to be successfully completed before :
- * <ul>
- * <li> <code>getPropertySetInfo</code> : in this method test
- * one of normal properties is retrieved. </li>
- * </ul> <p>
- * Has OK status if NO normal properties exist or if no
- * exceptions were thrown.
- */
- public boolean _getPropertyValue() {
-
-// requiredMethod("getPropertySetInfo()");
-
- boolean result = true;
- String toCheck = PTT.normal;
-
- if ( PTT.normal.equals("none") ) {
- toCheck = oObj.getPropertySetInfo().getProperties()[0].Name;
- System.out.println("All properties are Read Only");
- System.out.println("Using: "+toCheck);
- }
-
- try {
- Object gValue = oObj.getPropertyValue(toCheck);
- } catch (com.sun.star.beans.UnknownPropertyException e) {
- System.out.println("Exception occured while trying to get property '"+
- PTT.normal+"'");
- e.printStackTrace();
- result = false;
- } catch (com.sun.star.lang.WrappedTargetException e) {
- System.out.println("Exception occured while trying to get property '"+
- PTT.normal+"'");
- e.printStackTrace();
- result = false;
- } // end of try-catch
-
- return result;
- }
-
- /**
- * Tests <code>removePropertyChangeListener</code> method.
- * Removes change listener, then changes bound property value
- * and checks if the listener was NOT called.
- * Method tests to be successfully completed before :
- * <ul>
- * <li> <code>addPropertyChangeListener</code> : here listener
- * was added. </li>
- * </ul> <p>
- * Has OK status if NO bound properties exist or if listener
- * was not called and no exceptions arose.
- */
- public boolean _removePropertyChangeListener() {
-
-// requiredMethod("addPropertyChangeListener()");
-
- propertyChanged = false;
- boolean result = true;
-
- if ( PTT.bound.equals("none") ) {
- System.out.println("*** No bound properties found ***");
- } else {
- try {
- propertyChanged = false;
- oObj.removePropertyChangeListener(PTT.bound,PClistener);
- Object gValue = oObj.getPropertyValue(PTT.bound);
- oObj.setPropertyValue(PTT.bound,
- ValueChanger.changePValue(gValue));
- } catch (com.sun.star.beans.PropertyVetoException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.bound+"'");
- e.printStackTrace();
- } catch (com.sun.star.lang.IllegalArgumentException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.bound+"'");
- e.printStackTrace();
- } catch (com.sun.star.beans.UnknownPropertyException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.bound+"'");
- e.printStackTrace();
- } catch (com.sun.star.lang.WrappedTargetException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.bound+"'");
- e.printStackTrace();
- } // end of try-catch
-
- result = !propertyChanged;
- if (propertyChanged) {
- System.out.println("propertyChangeListener was called after removing"+
- " for '"+PTT.bound+"'");
- }
- } //endif
-
- return result;
-
- } // end of removePropertyChangeListener()
-
-
- /**
- * Tests <code>removeVetoableChangeListener</code> method.
- * Removes vetoable listener, then changes constrained property value
- * and checks if the listener was NOT called.
- * Method tests to be successfully completed before :
- * <ul>
- * <li> <code>addPropertyChangeListener</code> : here vetoable listener
- * was added. </li>
- * </ul> <p>
- * Has OK status if NO constrained properties exist or if listener
- * was NOT called and no exceptions arose.
- */
- public boolean _removeVetoableChangeListener() {
-
-// requiredMethod("addVetoableChangeListener()");
-
- vetoableChanged = false;
- boolean result = true;
-
- if ( PTT.constrained.equals("none") ) {
- System.out.println("*** No constrained properties found ***");
- } else {
- try {
- oObj.removeVetoableChangeListener(PTT.constrained,VClistener);
- Object gValue = oObj.getPropertyValue(PTT.constrained);
- oObj.setPropertyValue(PTT.constrained,
- ValueChanger.changePValue(gValue));
- } catch (com.sun.star.beans.PropertyVetoException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.constrained+"'");
- e.printStackTrace();
- } catch (com.sun.star.lang.IllegalArgumentException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.constrained+"'");
- e.printStackTrace();
- } catch (com.sun.star.beans.UnknownPropertyException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.constrained+"'");
- e.printStackTrace();
- } catch (com.sun.star.lang.WrappedTargetException e) {
- System.out.println("Exception occured while trying to change "+
- "property '"+ PTT.constrained+"'");
- e.printStackTrace();
- } // end of try-catch
-
- result = !vetoableChanged;
- if (vetoableChanged) {
- System.out.println("vetoableChangeListener was called after "+
- "removing for '"+PTT.constrained+"'");
- }
- } //endif
-
- return result;
-
- } // end of removeVetoableChangeListener()
-
-
- /**
- * Gets the properties being tested. Searches and stores by one
- * property of each kind (Bound, Vetoable, Normal).
- */
- public PropsToTest getPropsToTest(XPropertySetInfo xPSI) {
-
- Property[] properties = xPSI.getProperties();
- String bound = "";
- String constrained = "";
- String normal = "";
-
- for (int i = 0; i < properties.length; i++) {
-
- Property property = properties[i];
- String name = property.Name;
- System.out.println("Checking '"+name+"'");
- boolean isWritable = ((property.Attributes &
- PropertyAttribute.READONLY) == 0);
- boolean isNotNull = ((property.Attributes &
- PropertyAttribute.MAYBEVOID) == 0);
- boolean isBound = ((property.Attributes &
- PropertyAttribute.BOUND) != 0);
- boolean isConstr = ((property.Attributes &
- PropertyAttribute.CONSTRAINED) != 0);
- boolean canChange = false;
-
- if ( !isWritable ) System.out.println("Property '"+name+"' is READONLY");
-
- if (name.endsWith("URL")) isWritable = false;
- if (name.startsWith("Fill")) isWritable = false;
- if (name.startsWith("Font")) isWritable = false;
- if (name.startsWith("IsNumbering")) isWritable = false;
- if (name.startsWith("LayerName")) isWritable = false;
- if (name.startsWith("Line")) isWritable = false;
-
- //if (name.equals("xinterfaceA") || name.equals("xtypeproviderA")
- //|| name.equals("arAnyA")) isWritable=false;
-
- if ( isWritable && isNotNull ) canChange = isChangeable(name);
-
- if ( isWritable && isNotNull && isBound && canChange) {
- bound+=name+";";
- }
-
- if ( isWritable && isNotNull && isConstr && canChange) {
- constrained+=name+";";
- }
-
- if ( isWritable && isNotNull && canChange) normal+=name+";";
-
-
- } // endfor
-
- //get a random bound property
- PTT.bound=getRandomString(bound);
- System.out.println("Bound: "+PTT.bound);
-
- //get a random constrained property
- PTT.constrained=getRandomString(constrained);
- System.out.println("Constrained: "+PTT.constrained);
-
- //get a random normal property
- PTT.normal=getRandomString(normal);
-
- return PTT;
-
- }
-
- /**
- * Retrieves one random property name from list (property names separated
- * by ';') of property names.
- */
- public String getRandomString(String str) {
-
- String gRS = "none";
- Random rnd = new Random();
-
- if (str.equals("")) str = "none";
- StringTokenizer ST=new StringTokenizer(str,";");
- int nr = rnd.nextInt(ST.countTokens());
- if (nr < 1) nr+=1;
- for (int i=1; i<nr+1; i++) gRS = ST.nextToken();
-
- return gRS;
-
- }
-
- public boolean isChangeable(String name) {
- boolean hasChanged = false;
- try {
- Object getProp = oObj.getPropertyValue(name);
- System.out.println("Getting: "+getProp);
-
- Object setValue = null;
- if (getProp != null) {
- if (!utils.isVoid(getProp))
- setValue = ValueChanger.changePValue(getProp);
- else System.out.println("Property '"+name+
- "' is void but MAYBEVOID isn't set");
- } else System.out.println("Property '"+name+"'is null and can't be changed");
- if (name.equals("LineStyle")) setValue = null;
- if (setValue != null) {
- oObj.setPropertyValue(name, setValue);
- System.out.println("Setting to :"+setValue);
- hasChanged = (! getProp.equals(oObj.getPropertyValue(name)));
- } else System.out.println("Couldn't change Property '"+name+"'");
- } catch (com.sun.star.beans.PropertyVetoException e) {
- System.out.println("'" + name + "' throws exception '" + e + "'");
- e.printStackTrace();
- } catch (com.sun.star.lang.IllegalArgumentException e) {
- System.out.println("'" + name + "' throws exception '" + e + "'");
- e.printStackTrace();
- } catch (com.sun.star.beans.UnknownPropertyException e) {
- System.out.println("'" + name + "' throws exception '" + e + "'");
- e.printStackTrace();
- } catch (com.sun.star.lang.WrappedTargetException e) {
- System.out.println("'" + name + "' throws exception '" + e + "'");
- e.printStackTrace();
- } catch (com.sun.star.uno.RuntimeException e) {
- System.out.println("'" + name + "' throws exception '" + e + "'");
- e.printStackTrace();
- } catch (java.lang.ArrayIndexOutOfBoundsException e) {
- System.out.println("'" + name + "' throws exception '" + e + "'");
- e.printStackTrace();
- }
-
- return hasChanged;
- }
-
-
-} // finish class _XPropertySet
-
diff --git a/sc/qa/complex/dataPilot/interfaceTests/beans/makefile.mk b/sc/qa/complex/dataPilot/interfaceTests/beans/makefile.mk
deleted file mode 100644
index 22b29f5e0..000000000
--- a/sc/qa/complex/dataPilot/interfaceTests/beans/makefile.mk
+++ /dev/null
@@ -1,46 +0,0 @@
-#*************************************************************************
-#
-# 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.
-#
-#*************************************************************************
-
-PRJ = ../../../../..
-TARGET = DataPilotInterfaceBeans
-PRJNAME = sc
-PACKAGE = complex/dataPilot/interfaceTests/beans
-
-# --- Settings -----------------------------------------------------
-.INCLUDE: settings.mk
-
-
-#----- compile .java files -----------------------------------------
-
-JARFILES = ridl.jar unoil.jar jurt.jar juh.jar java_uno.jar OOoRunner.jar
-JAVAFILES = _XPropertySet.java
-JAVACLASSFILES = $(foreach,i,$(JAVAFILES) $(CLASSDIR)/$(PACKAGE)/$(i:b).class)
-
-# --- Targets ------------------------------------------------------
-
-.INCLUDE : target.mk
-
diff --git a/sc/qa/complex/dataPilot/interfaceTests/container/makefile.mk b/sc/qa/complex/dataPilot/interfaceTests/container/makefile.mk
deleted file mode 100644
index d8b4321f0..000000000
--- a/sc/qa/complex/dataPilot/interfaceTests/container/makefile.mk
+++ /dev/null
@@ -1,46 +0,0 @@
-#*************************************************************************
-#
-# 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.
-#
-#*************************************************************************
-
-PRJ = ../../../../..
-TARGET = DataPilotInterfaceContainer
-PRJNAME = sc
-PACKAGE = complex/dataPilot/interfaceTests/container
-
-# --- Settings -----------------------------------------------------
-.INCLUDE: settings.mk
-
-
-#----- compile .java files -----------------------------------------
-
-JARFILES = ridl.jar unoil.jar jurt.jar juh.jar java_uno.jar OOoRunner.jar
-JAVAFILES = _XNamed.java
-JAVACLASSFILES = $(foreach,i,$(JAVAFILES) $(CLASSDIR)/$(PACKAGE)/$(i:b).class)
-
-# --- Targets ------------------------------------------------------
-
-.INCLUDE : target.mk
-
diff --git a/sc/qa/complex/dataPilot/interfaceTests/sheet/makefile.mk b/sc/qa/complex/dataPilot/interfaceTests/sheet/makefile.mk
deleted file mode 100644
index f62d17614..000000000
--- a/sc/qa/complex/dataPilot/interfaceTests/sheet/makefile.mk
+++ /dev/null
@@ -1,46 +0,0 @@
-#*************************************************************************
-#
-# 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.
-#
-#*************************************************************************
-
-PRJ = ../../../../..
-TARGET = DataPilotInterfaceSheet
-PRJNAME = sc
-PACKAGE = complex/dataPilot/interfaceTests/sheet
-
-# --- Settings -----------------------------------------------------
-.INCLUDE: settings.mk
-
-
-#----- compile .java files -----------------------------------------
-
-JARFILES = ridl.jar unoil.jar jurt.jar juh.jar java_uno.jar OOoRunner.jar
-JAVAFILES = _XDataPilotDescriptor.java _XDataPilotTable.java
-JAVACLASSFILES = $(foreach,i,$(JAVAFILES) $(CLASSDIR)/$(PACKAGE)/$(i:b).class)
-
-# --- Targets ------------------------------------------------------
-
-.INCLUDE : target.mk
-
diff --git a/sc/qa/complex/dataPilot/makefile.mk b/sc/qa/complex/dataPilot/makefile.mk
deleted file mode 100644
index 85512f8e5..000000000
--- a/sc/qa/complex/dataPilot/makefile.mk
+++ /dev/null
@@ -1,59 +0,0 @@
-#*************************************************************************
-#
-# 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.
-#
-#*************************************************************************
-
-.IF "$(OOO_SUBSEQUENT_TESTS)" == ""
-nothing .PHONY:
-.ELSE
-
-PRJ = ../../..
-PRJNAME = sc
-TARGET = qa_complex_datapilot
-
-.IF "$(OOO_JUNIT_JAR)" != ""
-PACKAGE = complex/dataPilot
-JAVATESTFILES = \
- CheckDataPilot.java
-
-JAVAFILES = $(JAVATESTFILES) \
- _XDataPilotDescriptor.java \
- _XDataPilotTable.java \
- _XNamed.java \
- _XPropertySet.java
-
-JARFILES = OOoRunner.jar ridl.jar test.jar unoil.jar
-EXTRAJARFILES = $(OOO_JUNIT_JAR)
-
-.END
-
-.INCLUDE: settings.mk
-.INCLUDE: target.mk
-.INCLUDE: installationtest.mk
-
-ALLTAR : javatest
-
-.END
-
diff --git a/sc/qa/complex/sc/CalcRTL.java b/sc/qa/complex/sc/CalcRTL.java
deleted file mode 100644
index 3288d4aac..000000000
--- a/sc/qa/complex/sc/CalcRTL.java
+++ /dev/null
@@ -1,601 +0,0 @@
-/*************************************************************************
- *
- * 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 complex.sc;
-
-import com.sun.star.beans.Property;
-import com.sun.star.beans.PropertyAttribute;
-import com.sun.star.beans.PropertyVetoException;
-import com.sun.star.beans.UnknownPropertyException;
-import com.sun.star.beans.XPropertySet;
-import com.sun.star.beans.XPropertySetInfo;
-import com.sun.star.container.XIndexAccess;
-import com.sun.star.drawing.XDrawPage;
-import com.sun.star.drawing.XDrawPages;
-import com.sun.star.drawing.XDrawPagesSupplier;
-import com.sun.star.drawing.XShape;
-import com.sun.star.lang.WrappedTargetException;
-import com.sun.star.lang.XComponent;
-import com.sun.star.lang.XMultiServiceFactory;
-import com.sun.star.sheet.XCellRangeAddressable;
-import com.sun.star.sheet.XSpreadsheet;
-import com.sun.star.sheet.XSpreadsheetDocument;
-import com.sun.star.sheet.XSpreadsheets;
-// import com.sun.star.table.XCell;
-import com.sun.star.uno.Any;
-import com.sun.star.uno.AnyConverter;
-import com.sun.star.uno.Type;
-import com.sun.star.uno.UnoRuntime;
-import com.sun.star.util.XCloseable;
-
-// import complexlib.ComplexTestCase;
-
-// import java.io.PrintWriter;
-
-import util.DrawTools;
-import util.SOfficeFactory;
-import util.ValueComparer;
-
-// 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.*;
-
-
-public class CalcRTL /* extends ComplexTestCase */
-{
- XSpreadsheetDocument xSheetDoc = null;
-
- /*
- * This testcase checks the calcrtl feature added to cws_calcrtl in three steps
- * <br>
- * (<b>REMARK: </b> the testcases expects the TableLayout to be LR_TB)
- * <br>
- * 1. A calc document is opened and the properties in css.sheet.Spreadsheet are checked
- * <br>
- * 2. A calc document is opened and a shape inserted, afterwards the properties in css.sheet.Shape are checked
- * <br>
- * 3. A calc document is opened and a shape inserted, afterwards the effect of changing the TableLayout to the shape is checked
- */
-// public String[] getTestMethodNames() {
-// return new String[] {
-// "checkSpreadsheetProperties", "checkShapeProperties",
-// "checkInfluenceOfSpreadsheetChange"
-// };
-// }
-
- /*
- * In this method a spreadsheet document is opened<br>
- * afterwards all properties of the Spreadsheet are checked.<br>
- * <p>
- * These are
- * <ul>
- *<li> IsVisible
- *<li> PageStyle
- *<li> TableLayout
- *</ul>
- */
- @Test public void checkSpreadsheetProperties() {
- assertTrue("Couldn't open document", openSpreadsheetDocument());
-
- XPropertySet set = UnoRuntime.queryInterface(
- XPropertySet.class, getSpreadsheet());
- assertTrue("Problems when setting property 'IsVisible'",
- changeProperty(set, "IsVisible", Boolean.FALSE));
- assertTrue("Problems when setting property 'IsVisible'",
- changeProperty(set, "IsVisible", Boolean.TRUE));
- assertTrue("Problems when setting property 'PageStyle'",
- changeProperty(set, "PageStyle", "Report"));
- assertTrue("Problems when setting property 'PageStyle'",
- changeProperty(set, "PageStyle", "Default"));
- assertTrue("Problems when setting property 'TableLayout'",
- changeProperty(set, "TableLayout",
- new Short(com.sun.star.text.WritingMode2.RL_TB)));
- assertTrue("Problems when setting property 'TableLayout'",
- changeProperty(set, "TableLayout",
- new Short(com.sun.star.text.WritingMode2.LR_TB)));
- assertTrue("Couldn't close document", closeSpreadsheetDocument());
- }
-
- /*
- * In this method a spreadsheet document is opened and a shape inserted<br>
- * afterwards all calc specific properties of the Shape are checked.<br>
- * <p>
- * These are
- * <ul>
- *<li> Anchor
- *<li> HoriOrientPosition
- *<li> VertOrientPosition
- *</ul>
- */
- @Test public void checkShapeProperties() {
- assertTrue("Couldn't open document", openSpreadsheetDocument());
-
- XPropertySet set = UnoRuntime.queryInterface(
- XPropertySet.class, getInsertedShape());
-
- try {
- assertTrue("Problems when setting property 'Anchor'",
- changeProperty(set, "Anchor",
- getSpreadsheet().getCellByPosition(5, 5)));
- } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
- // assure("Problems when setting property 'Anchor'", false);
- fail("Problems when setting property 'Anchor'");
- }
-
- assertTrue("Problems when setting property 'HoriOrientPosition'",
- changeProperty(set, "HoriOrientPosition", new Integer(1000)));
-
- assertTrue("Problems when setting property 'VertOrientPosition'",
- changeProperty(set, "VertOrientPosition", new Integer(1000)));
-
- assertTrue("Couldn't close document", closeSpreadsheetDocument());
- }
-
- @Test public void checkInfluenceOfSpreadsheetChange() {
- assertTrue("Couldn't open document", openSpreadsheetDocument());
-
- XShape oShape = getInsertedShape();
- XPropertySet sheetProps = UnoRuntime.queryInterface(
- XPropertySet.class, getSpreadsheet());
- XPropertySet shapeProps = UnoRuntime.queryInterface(
- XPropertySet.class, oShape);
-
- String[] previous = getShapeProps(shapeProps, oShape);
- assertTrue("Problems when setting property 'TableLayout'",
- changeProperty(sheetProps, "TableLayout",
- new Short(com.sun.star.text.WritingMode2.RL_TB)));
-
- String[] RL_TB = getShapeProps(shapeProps, oShape);
- assertTrue("Problems when setting property 'TableLayout'",
- changeProperty(sheetProps, "TableLayout",
- new Short(com.sun.star.text.WritingMode2.LR_TB)));
-
- String[] LR_TB = getShapeProps(shapeProps, oShape);
- assertTrue("Anchor has changed",
- (previous[0].equals(RL_TB[0]) && previous[0].equals(LR_TB[0])));
- assertEquals("HoriOrientPosition has changed",
- 2100, (Integer.valueOf(previous[1]).intValue() + Integer.valueOf(
- RL_TB[1])
- .intValue() +
- Integer.valueOf(LR_TB[1]).intValue()));
- assertEquals("VertOrientPosition has changed",
- 3*Integer.valueOf(previous[2]).intValue(),
- (Integer.valueOf(previous[2]).intValue() + Integer.valueOf(
- RL_TB[2])
- .intValue() +
- Integer.valueOf(LR_TB[2]).intValue()));
- assertTrue("x-position hasn't changed",
- (previous[3].equals(LR_TB[3]) &&
- ((Integer.valueOf(previous[3]).intValue() * (-1)) -
- oShape.getSize().Width != Integer.valueOf(LR_TB[2])
- .intValue())));
- assertTrue("Couldn't close document", closeSpreadsheetDocument());
- }
-
- protected String[] getShapeProps(XPropertySet set, XShape oShape) {
- String[] reValue = new String[4];
-
- try {
- reValue[0] = toString(getRealValue(set.getPropertyValue("Anchor")));
- reValue[1] = toString(set.getPropertyValue("HoriOrientPosition"));
- reValue[2] = toString(set.getPropertyValue("VertOrientPosition"));
- reValue[3] = toString(new Integer(oShape.getPosition().X));
- } catch (com.sun.star.beans.UnknownPropertyException e) {
- } catch (com.sun.star.lang.WrappedTargetException e) {
- }
-
- System.out.println("\t Anchor :" + reValue[0]);
- System.out.println("\t HoriOrientPosition :" + reValue[1]);
- System.out.println("\t VertOrientPosition :" + reValue[2]);
- System.out.println("\t Shape Position (x,y) : (" + oShape.getPosition().X +
- "," + oShape.getPosition().Y + ")");
-
- return reValue;
- }
-
- /*
- * this method opens a calc document and sets the corresponding class variable xSheetDoc
- */
- protected boolean openSpreadsheetDocument() {
- // SOfficeFactory SOF = SOfficeFactory.getFactory(
- // (XMultiServiceFactory) param.getMSF());
-
- final XMultiServiceFactory xMsf = UnoRuntime.queryInterface(XMultiServiceFactory.class, connection.getComponentContext().getServiceManager());
- SOfficeFactory SOF = SOfficeFactory.getFactory(xMsf);
-
- boolean worked = true;
-
- try {
- System.out.println("creating a sheetdocument");
- xSheetDoc = SOF.createCalcDoc(null);
- } catch (com.sun.star.uno.Exception e) {
- // Some exception occures.FAILED
- worked = false;
- e.printStackTrace(/*(PrintWriter) log*/ System.out);
- }
-
- return worked;
- }
-
- /*
- * 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;
- }
-
- /*
- * This method gets the first Sheet of the SpreadsheetDocument
- *
- */
- protected XSpreadsheet getSpreadsheet() {
- XSpreadsheet oSheet = null;
-
- System.out.println("getting sheets");
-
- XSpreadsheets xSpreadsheets = xSheetDoc.getSheets();
-
- System.out.println("getting a sheet");
-
- XIndexAccess oIndexAccess = UnoRuntime.queryInterface(
- XIndexAccess.class, xSpreadsheets);
-
- try {
- oSheet = UnoRuntime.queryInterface(
- XSpreadsheet.class, oIndexAccess.getByIndex(0));
- } catch (com.sun.star.lang.WrappedTargetException e) {
- e.printStackTrace(System.out);
- } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
- e.printStackTrace(System.out);
- }
-
- return oSheet;
- }
-
- /*
- * This method changes a given property to a given value
- * Parameters:
- * @param set : The XPropertySet that contains the properties
- * @param pName : The name of the Property that has to be changed
- * @param pValue : The value, the property should be changed too.
- */
- protected boolean changeProperty(XPropertySet set, String pName,
- Object pValue) {
- boolean worked = true;
-
- try {
- Object oldValue = set.getPropertyValue(pName);
-
- // for an exception thrown during setting new value
- // to pass it to checkResult method
- Exception exception = null;
-
- try {
- set.setPropertyValue(pName, pValue);
- } catch (IllegalArgumentException e) {
- exception = e;
- } catch (PropertyVetoException e) {
- exception = e;
- } catch (WrappedTargetException e) {
- exception = e;
- } catch (UnknownPropertyException e) {
- exception = e;
- } catch (RuntimeException e) {
- exception = e;
- }
-
- // getting result value
- Object resValue = set.getPropertyValue(pName);
-
-
- // checking results
- worked = checkResult(set, pName, oldValue, pValue, resValue,
- exception);
- } catch (Exception e) {
- System.out.println("Exception occurred while testing property '" +
- pName + "'");
- e.printStackTrace();
- worked = false;
- }
-
- return worked;
- }
-
- /*
- * This methods checks if a property has changed as expected
- * Parameters:
- * @param set : the given XPropertySet
- * @param propName : the name of the property that has been changed
- * @param oldValue : the value of the property before it has been changed
- * @param newValue : the value the property has been set to
- * @param resValue : the value getPropertyValue returned for the property
- * @param exception : the exeption thrown during the change of the property
- */
- protected boolean checkResult(XPropertySet set, String propName,
- Object oldValue, Object newValue,
- Object resValue, Exception exception)
- throws Exception {
- XPropertySetInfo info = set.getPropertySetInfo();
- Property prop = info.getPropertyByName(propName);
-
- oldValue = getRealValue(oldValue);
- newValue = getRealValue(newValue);
- resValue = getRealValue(resValue);
-
- short attr = prop.Attributes;
- boolean readOnly = (prop.Attributes & PropertyAttribute.READONLY) != 0;
- boolean maybeVoid = (prop.Attributes & PropertyAttribute.MAYBEVOID) != 0;
-
- //check get-set methods
- if (maybeVoid) {
- System.out.println("Property " + propName + " is void");
- }
-
- if (readOnly) {
- System.out.println("Property " + propName + " is readOnly");
- }
-
- if (util.utils.isVoid(oldValue) && !maybeVoid) {
- System.out.println(propName + " is void, but it's not MAYBEVOID");
-
- return false;
- } else if (oldValue == null) {
- System.out.println(propName +
- " has null value, and therefore can't be changed");
-
- return true;
- } else if (readOnly) {
- // check if exception was thrown
- if (exception != null) {
- if (exception instanceof PropertyVetoException) {
- // the change of read only prohibited - OK
- System.out.println("Property is ReadOnly and wasn't changed");
- System.out.println("Property '" + propName + "' OK");
-
- return true;
- } else if (exception instanceof IllegalArgumentException) {
- // the change of read only prohibited - OK
- System.out.println("Property is ReadOnly and wasn't changed");
- System.out.println("Property '" + propName + "' OK");
-
- return true;
- } else if (exception instanceof UnknownPropertyException) {
- // the change of read only prohibited - OK
- System.out.println("Property is ReadOnly and wasn't changed");
- System.out.println("Property '" + propName + "' OK");
-
- return true;
- } else if (exception instanceof RuntimeException) {
- // the change of read only prohibited - OK
- System.out.println("Property is ReadOnly and wasn't changed");
- System.out.println("Property '" + propName + "' OK");
-
- return true;
- } else {
- throw exception;
- }
- } else {
- // if no exception - check that value
- // has not changed
- if (!ValueComparer.equalValue(resValue, oldValue)) {
- System.out.println("Read only property '" + propName +
- "' has changed");
-
- try {
- if (!util.utils.isVoid(oldValue) &&
- oldValue instanceof Any) {
- oldValue = AnyConverter.toObject(
- new Type(((Any) oldValue).getClass()),
- oldValue);
- }
-
- System.out.println("old = " + toString(oldValue));
- System.out.println("new = " + toString(newValue));
- System.out.println("result = " + toString(resValue));
- } catch (com.sun.star.lang.IllegalArgumentException iae) {
- }
-
- return false;
- } else {
- System.out.println("Read only property '" + propName +
- "' hasn't changed");
- System.out.println("Property '" + propName + "' OK");
-
- return true;
- }
- }
- } else {
- if (exception == null) {
- // if no exception thrown
- // check that the new value is set
- if ((!ValueComparer.equalValue(resValue, newValue)) ||
- (ValueComparer.equalValue(resValue, oldValue))) {
- System.out.println("Value for '" + propName +
- "' hasn't changed as expected");
-
- try {
- if (!util.utils.isVoid(oldValue) &&
- oldValue instanceof Any) {
- oldValue = AnyConverter.toObject(
- new Type(((Any) oldValue).getClass()),
- oldValue);
- }
-
- System.out.println("old = " + toString(oldValue));
- System.out.println("new = " + toString(newValue));
- System.out.println("result = " + toString(resValue));
- } catch (com.sun.star.lang.IllegalArgumentException iae) {
- }
-
- if (resValue != null) {
- if ((!ValueComparer.equalValue(resValue, oldValue)) ||
- (!resValue.equals(oldValue))) {
- System.out.println("But it has changed.");
-
- return true;
- } else {
- return false;
- }
- } else {
- return false;
- }
-
- //tRes.tested(propName, false);
- } else {
- System.out.println("Property '" + propName + "' OK");
-
- try {
- if (!util.utils.isVoid(oldValue) &&
- oldValue instanceof Any) {
- oldValue = AnyConverter.toObject(
- new Type(((Any) oldValue).getClass()),
- oldValue);
- }
-
- System.out.println("old = " + toString(oldValue));
- System.out.println("new = " + toString(newValue));
- System.out.println("result = " + toString(resValue));
- } catch (com.sun.star.lang.IllegalArgumentException iae) {
- }
-
- return true;
- }
- } else {
- throw exception;
- }
- }
- }
-
- /*
- * Returns a String representation of a given object, returns "null" in case of a NullObject
- * @param obj : the given object
- */
- protected String toString(Object obj) {
- return (obj == null) ? "null" : obj.toString();
- }
-
- /*
- * Returns a human readable String representation for CellRangeAddressable
- */
- protected Object getRealValue(Object obj) {
- Object value = null;
-
- if (UnoRuntime.queryInterface(XCellRangeAddressable.class, obj) != null) {
- XCellRangeAddressable aCell = UnoRuntime.queryInterface(
- XCellRangeAddressable.class,
- obj);
- value = "Cell in Column " + aCell.getRangeAddress().StartColumn +
- " and Row " + aCell.getRangeAddress().StartRow;
- } else {
- return obj;
- }
-
- return value;
- }
-
- /*
- * This method inserts a RectangleShape into the calc document xSheetDoc and returns the resultung XShape-object
- */
- protected XShape getInsertedShape() {
- XShape insertedShape = null;
-
- try {
- System.out.println("getting Drawpages");
-
- XDrawPagesSupplier oDPS = UnoRuntime.queryInterface(
- XDrawPagesSupplier.class,
- xSheetDoc);
- XDrawPages oDP = oDPS.getDrawPages();
- XDrawPage firstDrawPage = UnoRuntime.queryInterface(
- XDrawPage.class,
- oDP.getByIndex(0));
-
- final XMultiServiceFactory xMsf = UnoRuntime.queryInterface(XMultiServiceFactory.class, connection.getComponentContext().getServiceManager());
- SOfficeFactory SOF = SOfficeFactory.getFactory(xMsf);
-
- // SOfficeFactory SOF = SOfficeFactory.getFactory(
- // (XMultiServiceFactory) param.getMSF());
- XComponent xComp = UnoRuntime.queryInterface(
- XComponent.class, xSheetDoc);
- insertedShape = SOF.createShape(xComp, 5000, 3500, 700, 500,
- "Rectangle");
- DrawTools.getShapes(firstDrawPage).add(insertedShape);
- } catch (com.sun.star.lang.WrappedTargetException e) {
- System.out.println("Couldn't create instance");
- e.printStackTrace();
-
- return null;
- } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
- System.out.println("Couldn't create instance");
- e.printStackTrace();
-
- return null;
- }
-
- return insertedShape;
- }
-
-
-
-
- @BeforeClass public static void setUpConnection() throws Exception {
- connection.setUp();
- }
-
- @AfterClass public static void tearDownConnection()
- throws InterruptedException, com.sun.star.uno.Exception
- {
- connection.tearDown();
- }
-
- private static final OfficeConnection connection = new OfficeConnection();
-
-}
diff --git a/sc/qa/complex/sc/makefile.mk b/sc/qa/complex/sc/makefile.mk
deleted file mode 100644
index e064f9d3b..000000000
--- a/sc/qa/complex/sc/makefile.mk
+++ /dev/null
@@ -1,51 +0,0 @@
-#*************************************************************************
-#
-# 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.
-#
-#*************************************************************************
-
-.IF "$(OOO_SUBSEQUENT_TESTS)" == ""
-nothing .PHONY:
-.ELSE
-
-PRJ = ../../..
-PRJNAME = sc
-TARGET = qa_complex_sc
-
-.IF "$(OOO_JUNIT_JAR)" != ""
-PACKAGE = complex/sc
-JAVATESTFILES = \
- CalcRTL.java
-JAVAFILES = $(JAVATESTFILES)
-JARFILES = OOoRunner.jar ridl.jar test.jar unoil.jar jurt.jar
-EXTRAJARFILES = $(OOO_JUNIT_JAR)
-.END
-
-.INCLUDE: settings.mk
-.INCLUDE: target.mk
-.INCLUDE: installationtest.mk
-
-ALLTAR : javatest
-
-.END