summaryrefslogtreecommitdiffstats
path: root/sc/qa/complex
diff options
context:
space:
mode:
Diffstat (limited to 'sc/qa/complex')
-rw-r--r--sc/qa/complex/calcPreview/TestDocument.java30
-rw-r--r--sc/qa/complex/calcPreview/ViewForwarder.java1003
-rw-r--r--sc/qa/complex/calcPreview/makefile.mk114
-rw-r--r--sc/qa/complex/calcPreview/test_documents/calcshapes.sxcbin0 -> 13030 bytes
-rw-r--r--sc/qa/complex/dataPilot/_XDataPilotDescriptor.java420
-rw-r--r--sc/qa/complex/dataPilot/_XDataPilotTable.java97
-rw-r--r--sc/qa/complex/dataPilot/_XNamed.java133
-rw-r--r--sc/qa/complex/dataPilot/_XPropertySet.java601
-rw-r--r--sc/qa/complex/sc/CalcRTL.java493
9 files changed, 2891 insertions, 0 deletions
diff --git a/sc/qa/complex/calcPreview/TestDocument.java b/sc/qa/complex/calcPreview/TestDocument.java
new file mode 100644
index 0000000000..1ab9bdd3fe
--- /dev/null
+++ b/sc/qa/complex/calcPreview/TestDocument.java
@@ -0,0 +1,30 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+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
new file mode 100644
index 0000000000..d1490013a9
--- /dev/null
+++ b/sc/qa/complex/calcPreview/ViewForwarder.java
@@ -0,0 +1,1003 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package complex.calcPreview;
+
+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.XMultiServiceFactory;
+import com.sun.star.sheet.XSpreadsheet;
+import com.sun.star.sheet.XSpreadsheets;
+import com.sun.star.table.XCell;
+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.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 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 a MultiServiceFactory from the Office before the test.
+ */
+ @Before public void before()
+ {
+ mXMSF = UnoRuntime.queryInterface(XMultiServiceFactory.class, connection.getComponentContext().getServiceManager());
+ }
+
+
+ /** 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 creating relation :");
+ fail(e.getMessage());
+ } catch(com.sun.star.lang.WrappedTargetException e) {
+ System.out.println("Exception creating relation :");
+ fail(e.getMessage());
+ } catch(com.sun.star.lang.IndexOutOfBoundsException e) {
+ System.out.println("Exception creating 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;
+ }
+
+ util.utils.waitForEventIdle(mXMSF);
+
+ System.out.println("Press any key after resizing ");
+ try{
+ byte[]b = new byte[16];
+ System.in.read(b);
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+
+ XWindow xWindow = AccessibilityTools.getCurrentWindow(aModel);
+ XAccessible xRoot = AccessibilityTools.getAccessibleObject(xWindow);
+ XAccessible parent = null;
+
+ try {
+ parent = AccessibilityTools.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);
+
+ util.utils.waitForEventIdle(mXMSF);
+
+ 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 = AccessibilityTools.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 = AccessibilityTools.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);
+
+ long 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 (long 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 creating relation :");
+ fail(e.getMessage());
+ } catch(com.sun.star.lang.WrappedTargetException e) {
+ System.out.println("Exception creating relation :");
+ fail(e.getMessage());
+ } catch(com.sun.star.lang.IndexOutOfBoundsException e) {
+ System.out.println("Exception creating 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;
+ }
+
+ util.utils.waitForEventIdle(mXMSF);
+
+ System.out.println("Press any key after resizing ");
+ try{
+ byte[]b = new byte[16];
+ System.in.read(b);
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+
+ XWindow xWindow = AccessibilityTools.getCurrentWindow(aModel);
+ XAccessible xRoot = AccessibilityTools.getAccessibleObject(xWindow);
+ XAccessible parent = null;
+
+ try {
+ parent = AccessibilityTools.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);
+
+ util.utils.waitForEventIdle(mXMSF);
+
+ 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();
+ }
+
+ long 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 = AccessibilityTools.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", 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;
+ }
+
+ util.utils.waitForEventIdle(mXMSF);
+
+ XWindow xWindow = AccessibilityTools.getCurrentWindow(xModel);
+ XAccessible xRoot = AccessibilityTools.getAccessibleObject(xWindow);
+
+ 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();
+ }
+
+
+ try {
+ System.out.println("Count: " +AccessibilityTools.getAccessibleObjectForRole
+ (xRoot, AccessibleRole.TABLE, "").getAccessibleChildCount());
+ System.out.println("Getting child 2");
+ oObj = AccessibilityTools.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("*****************");
+
+
+ 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 = 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;
+ }
+
+ util.utils.waitForEventIdle(mXMSF);
+
+ 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;
+ }
+
+ util.utils.waitForEventIdle(mXMSF);
+
+ 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();
+ }
+
+ XWindow xWindow = AccessibilityTools.getCurrentWindow(aModel);
+ XAccessible xRoot = AccessibilityTools.getAccessibleObject(xWindow);
+
+ try {
+ XAccessibleContext con = AccessibilityTools.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
new file mode 100644
index 0000000000..85eeefb47e
--- /dev/null
+++ b/sc/qa/complex/calcPreview/makefile.mk
@@ -0,0 +1,114 @@
+#
+# This file is part of the LibreOffice project.
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# License, v. 2.0. If a copy of the MPL was not distributed with this
+# file, You can obtain one at http://mozilla.org/MPL/2.0/.
+#
+# This file incorporates work covered by the following license notice:
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements. See the NOTICE file distributed
+# with this work for additional information regarding copyright
+# ownership. The ASF licenses this file to you under the Apache
+# License, Version 2.0 (the "License"); you may not use this file
+# except in compliance with the License. You may obtain a copy of
+# the License at http://www.apache.org/licenses/LICENSE-2.0 .
+#
+
+.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
new file mode 100644
index 0000000000..7f98b1a501
--- /dev/null
+++ b/sc/qa/complex/calcPreview/test_documents/calcshapes.sxc
Binary files differ
diff --git a/sc/qa/complex/dataPilot/_XDataPilotDescriptor.java b/sc/qa/complex/dataPilot/_XDataPilotDescriptor.java
new file mode 100644
index 0000000000..b75267439e
--- /dev/null
+++ b/sc/qa/complex/dataPilot/_XDataPilotDescriptor.java
@@ -0,0 +1,420 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+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.TestParameters;
+
+/**
+* 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 {
+
+ private final XDataPilotDescriptor oObj;
+ private final CellRangeAddress CRA = new CellRangeAddress((short)1, 0, 0, 5, 5);
+
+ private static final String sTag = "XDataPilotDescriptor_Tag";
+ private String fieldsNames[];
+ private int tEnvFieldsAmount = 0;
+
+ /**
+ * The test parameters
+ */
+ private final TestParameters param;
+
+ /**
+ * 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.param = param;
+ }
+
+ /**
+ * Retrieves object relations.
+
+ */
+ 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>
+ */
+ 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>
+ */
+ public boolean _setSourceRange(){
+
+ 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>
+ */
+ public boolean _getTag(){
+ 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>
+ */
+ 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>
+ */
+ 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");}
+
+ int 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>
+ */
+ public boolean _getColumnFields(){
+ 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>
+ */
+ public boolean _getDataFields(){
+ 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>
+ */
+ public boolean _getHiddenFields(){
+ 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>
+ */
+ public boolean _getRowFields(){
+ 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>
+ */
+ public boolean _getPageFields(){
+ 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>
+ */
+ 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 returned.") ;
+ return false ;
+ }
+
+ if (fieldsNames[rem] == null) {
+ System.out.println("No fields were set to this orientation - can'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
new file mode 100644
index 0000000000..1c29a0f77c
--- /dev/null
+++ b/sc/qa/complex/dataPilot/_XDataPilotTable.java
@@ -0,0 +1,97 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+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.TestParameters;
+
+/**
+* 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 {
+
+ private final XDataPilotTable oObj;
+ private XCell xCellForChange = null;
+ private XCell xCellForCheck = null;
+ private CellAddress OutputRange = null;
+
+ /**
+ * The test parameters
+ */
+ private final TestParameters param;
+
+ /**
+ * 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.param = param;
+ }
+
+ public boolean before() {
+ xCellForChange = (XCell)param.get("CELLFORCHANGE");
+ xCellForCheck = (XCell)param.get("CELLFORCHECK");
+ OutputRange = (CellAddress)param.get("OUTPUTRANGE");
+
+ 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>
+ */
+ 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;
+ }
+
+}
+
diff --git a/sc/qa/complex/dataPilot/_XNamed.java b/sc/qa/complex/dataPilot/_XNamed.java
new file mode 100644
index 0000000000..2161abdd00
--- /dev/null
+++ b/sc/qa/complex/dataPilot/_XNamed.java
@@ -0,0 +1,133 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package complex.dataPilot;
+
+import com.sun.star.container.XNamed;
+import lib.TestParameters;
+
+/**
+* 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 compliant. <p>
+* @see com.sun.star.container.XNamed
+*/
+public class _XNamed {
+
+ /**
+ * The object that is testsed.
+ */
+ private final XNamed oObj;
+
+ /**
+ * Constructor: gets the object to test, a logger and the test parameters
+ * @param xObj The test object
+ * @param param The test parameters
+ */
+ public _XNamed(XNamed xObj/*, LogWriter log*/, TestParameters param) {
+ oObj = xObj;
+ }
+
+ /**
+ * 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;
+
+ 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(){
+ 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
new file mode 100644
index 0000000000..c7174c975d
--- /dev/null
+++ b/sc/qa/complex/dataPilot/_XPropertySet.java
@@ -0,0 +1,601 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+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 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 final XPropertySet oObj;
+
+ /**
+ * The test parameters
+ */
+ private final TestParameters param;
+
+ /**
+ * Flag that indicates change listener was called.
+ */
+ private boolean propertyChanged = false;
+
+
+ /**
+ * The own property change listener
+ */
+ private final XPropertyChangeListener PClistener = new MyChangeListener();
+
+ /**
+ * Listener that must be called on bound property changing.
+ */
+ private 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.
+ */
+ private boolean vetoableChanged = false;
+
+ /**
+ * The own vetoable change listener
+ */
+ private final XVetoableChangeListener VClistener = new MyVetoListener();
+
+ /**
+ * Listener that must be called on constrained property changing.
+ */
+ private 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
+ */
+ private final PropsToTest PTT = new PropsToTest();
+
+ /**
+ * Structure that collects three properties of each type to test :
+ * Constrained, Bound and Normal.
+ */
+ private class PropsToTest {
+ private String constrained = null;
+ private String bound = null;
+ String normal = null;
+ }
+
+ /**
+ * Constructor: gets the object to test, a logger and the test parameters
+ * @param xObj The test object
+ * @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 occurred while trying to change "+
+ "property '"+ PTT.bound+"'");
+ e.printStackTrace();
+ } catch (com.sun.star.lang.IllegalArgumentException e) {
+ System.out.println("Exception occurred while trying to change "+
+ "property '"+ PTT.bound+"'");
+ e.printStackTrace();
+ } catch (com.sun.star.beans.UnknownPropertyException e) {
+ System.out.println("Exception occurred while trying to change "+
+ "property '"+ PTT.bound+"'");
+ e.printStackTrace();
+ } catch (com.sun.star.lang.WrappedTargetException e) {
+ System.out.println("Exception occurred 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() {
+
+ 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 occurred while trying to change "+
+ "property '"+ PTT.constrained+"'");
+ e.printStackTrace();
+ } catch (com.sun.star.lang.IllegalArgumentException e) {
+ System.out.println("Exception occurred while trying to change "+
+ "property '"+ PTT.constrained+"'");
+ e.printStackTrace();
+ } catch (com.sun.star.beans.UnknownPropertyException e) {
+ System.out.println("Exception occurred while trying to change "+
+ "property '"+ PTT.constrained+"'");
+ e.printStackTrace();
+ } catch (com.sun.star.lang.WrappedTargetException e) {
+ System.out.println("Exception occurred 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() {
+
+ 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 occurred while trying to change "+
+ "property '"+ PTT.normal+"'");
+ e.printStackTrace();
+ } catch (com.sun.star.lang.IllegalArgumentException e) {
+ System.out.println("Exception occurred while trying to change "+
+ "property '"+ PTT.normal+"'");
+ e.printStackTrace();
+ } catch (com.sun.star.beans.UnknownPropertyException e) {
+ System.out.println("Exception occurred while trying to change "+
+ "property '"+ PTT.normal+"'");
+ e.printStackTrace();
+ } catch (com.sun.star.lang.WrappedTargetException e) {
+ System.out.println("Exception occurred 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() {
+
+ 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 {
+ oObj.getPropertyValue(toCheck);
+ } catch (com.sun.star.beans.UnknownPropertyException e) {
+ System.out.println("Exception occurred while trying to get property '"+
+ PTT.normal+"'");
+ e.printStackTrace();
+ result = false;
+ } catch (com.sun.star.lang.WrappedTargetException e) {
+ System.out.println("Exception occurred 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() {
+
+ 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 occurred while trying to change "+
+ "property '"+ PTT.bound+"'");
+ e.printStackTrace();
+ } catch (com.sun.star.lang.IllegalArgumentException e) {
+ System.out.println("Exception occurred while trying to change "+
+ "property '"+ PTT.bound+"'");
+ e.printStackTrace();
+ } catch (com.sun.star.beans.UnknownPropertyException e) {
+ System.out.println("Exception occurred while trying to change "+
+ "property '"+ PTT.bound+"'");
+ e.printStackTrace();
+ } catch (com.sun.star.lang.WrappedTargetException e) {
+ System.out.println("Exception occurred 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() {
+
+ 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 occurred while trying to change "+
+ "property '"+ PTT.constrained+"'");
+ e.printStackTrace();
+ } catch (com.sun.star.lang.IllegalArgumentException e) {
+ System.out.println("Exception occurred while trying to change "+
+ "property '"+ PTT.constrained+"'");
+ e.printStackTrace();
+ } catch (com.sun.star.beans.UnknownPropertyException e) {
+ System.out.println("Exception occurred while trying to change "+
+ "property '"+ PTT.constrained+"'");
+ e.printStackTrace();
+ } catch (com.sun.star.lang.WrappedTargetException e) {
+ System.out.println("Exception occurred 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).
+ */
+ private 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 ( 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.
+ */
+ private 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;
+
+ }
+
+ private 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/sc/CalcRTL.java b/sc/qa/complex/sc/CalcRTL.java
new file mode 100644
index 0000000000..7bb1ec405b
--- /dev/null
+++ b/sc/qa/complex/sc/CalcRTL.java
@@ -0,0 +1,493 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+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.uno.UnoRuntime;
+import com.sun.star.util.XCloseable;
+
+import util.DrawTools;
+import util.SOfficeFactory;
+import util.ValueComparer;
+
+import org.junit.AfterClass;
+import org.junit.BeforeClass;
+import org.junit.Test;
+import org.openoffice.test.OfficeConnection;
+import static org.junit.Assert.*;
+
+
+public class CalcRTL
+{
+ 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
+ */
+
+ /*
+ * 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", Integer.valueOf(1000)));
+
+ assertTrue("Problems when setting property 'VertOrientPosition'",
+ changeProperty(set, "VertOrientPosition", Integer.valueOf(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",
+ Short.valueOf(com.sun.star.text.WritingMode2.RL_TB)));
+
+ String[] RL_TB = getShapeProps(shapeProps, oShape);
+ assertTrue("Problems when setting property 'TableLayout'",
+ changeProperty(sheetProps, "TableLayout",
+ Short.valueOf(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.parseInt(previous[1]) + Integer.parseInt(RL_TB[1]) +
+ Integer.parseInt(LR_TB[1]));
+ assertEquals("VertOrientPosition has changed",
+ 3*Integer.parseInt(previous[2]),
+ (Integer.parseInt(previous[2]) + Integer.parseInt(RL_TB[2]) +
+ Integer.parseInt(LR_TB[2])));
+ assertTrue("x-position hasn't changed",
+ (previous[3].equals(LR_TB[3]) &&
+ ((Integer.parseInt(previous[3]) * (-1)) -
+ oShape.getSize().Width != Integer.parseInt(LR_TB[2]))));
+ 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(Integer.valueOf(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() {
+ 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 occurs.FAILED
+ worked = false;
+ e.printStackTrace(/*(PrintWriter) log*/ System.err);
+ }
+
+ 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 (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.err);
+ } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
+ e.printStackTrace(System.err);
+ }
+
+ 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 exception 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);
+
+ 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");
+
+ System.out.println("old = " + toString(oldValue));
+ System.out.println("new = " + toString(newValue));
+ System.out.println("result = " + toString(resValue));
+
+ 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)) {
+ System.out.println("Value for '" + propName +
+ "' hasn't changed as expected");
+
+ System.out.println("old = " + toString(oldValue));
+ System.out.println("new = " + toString(newValue));
+ System.out.println("result = " + toString(resValue));
+
+ if (!ValueComparer.equalValue(resValue, oldValue)) {
+ System.out.println("But it has changed.");
+ return true;
+ } else {
+ return false;
+ }
+ } else {
+ System.out.println("Property '" + propName + "' OK");
+
+ System.out.println("old = " + toString(oldValue));
+ System.out.println("new = " + toString(newValue));
+ System.out.println("result = " + toString(resValue));
+
+ 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 resulting 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);
+
+ 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();
+
+}
generated by cgit v1.2.3 (git 2.39.1) at 2024-12-24 13:07:15 +0000