summaryrefslogtreecommitdiff
path: root/sc/qa/complex/calcPreview
diff options
context:
space:
mode:
authorRĂ¼diger Timm <rt@openoffice.org>2007-07-24 12:33:26 +0000
committerRĂ¼diger Timm <rt@openoffice.org>2007-07-24 12:33:26 +0000
commitaca189cec260b951354796c38773123eef4585c1 (patch)
tree27ab1c10436c1cacff82c55e176c2227b176b6cc /sc/qa/complex/calcPreview
parentb8f605bc79935164ca88493900bb2cb9d1bbc095 (diff)
INTEGRATION: CWS complextest1 (1.1.2); FILE ADDED
2007/06/22 14:54:42 sg 1.1.2.1: #i78662# distributed tests for calc
Diffstat (limited to 'sc/qa/complex/calcPreview')
-rwxr-xr-xsc/qa/complex/calcPreview/ViewForwarder.java1091
1 files changed, 1091 insertions, 0 deletions
diff --git a/sc/qa/complex/calcPreview/ViewForwarder.java b/sc/qa/complex/calcPreview/ViewForwarder.java
new file mode 100755
index 000000000000..96e1de6041f7
--- /dev/null
+++ b/sc/qa/complex/calcPreview/ViewForwarder.java
@@ -0,0 +1,1091 @@
+/*************************************************************************
+ *
+ * $RCSfile: ViewForwarder.java,v $
+ *
+ * $Revision: 1.2 $
+ *
+ * last change: $Date: 2007-07-24 13:33:26 $
+ *
+ * The Contents of this file are made available subject to the terms of
+ * either of the following licenses
+ *
+ * - GNU Lesser General Public License Version 2.1
+ * - Sun Industry Standards Source License Version 1.1
+ *
+ * Sun Microsystems Inc., October, 2000
+ *
+ * GNU Lesser General Public License Version 2.1
+ * =============================================
+ * Copyright 2000 by Sun Microsystems, Inc.
+ * 901 San Antonio Road, Palo Alto, CA 94303, USA
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License version 2.1, as published by the Free Software Foundation.
+ *
+ * This library is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this library; if not, write to the Free Software
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ * MA 02111-1307 USA
+ *
+ *
+ * Sun Industry Standards Source License Version 1.1
+ * =================================================
+ * The contents of this file are subject to the Sun Industry Standards
+ * Source License Version 1.1 (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.openoffice.org/license.html.
+ *
+ * Software provided under this License is provided on an "AS IS" basis,
+ * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING,
+ * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+ * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+ * See the License for the specific provisions governing your rights and
+ * obligations concerning the Software.
+ *
+ * The Initial Developer of the Original Code is: Sun Microsystems, Inc.
+ *
+ * Copyright: 2000 by Sun Microsystems, Inc.
+ *
+ * All Rights Reserved.
+ *
+ * Contributor(s): _______________________________________
+ *
+ *
+ ************************************************************************/
+
+package complex.calcPreview;
+
+import complexlib.ComplexTestCase;
+
+import com.sun.star.awt.XWindow;
+import com.sun.star.container.XIndexAccess;
+import com.sun.star.frame.XController;
+import com.sun.star.frame.XDispatch;
+import com.sun.star.frame.XDispatchProvider;
+import com.sun.star.frame.XModel;
+import com.sun.star.lang.XComponent;
+import com.sun.star.lang.XMultiServiceFactory;
+import com.sun.star.sheet.XSpreadsheet;
+import com.sun.star.sheet.XSpreadsheetDocument;
+import com.sun.star.sheet.XSpreadsheets;
+import com.sun.star.table.XCell;
+import com.sun.star.uno.Any;
+import com.sun.star.uno.AnyConverter;
+import com.sun.star.uno.UnoRuntime;
+import com.sun.star.uno.XInterface;
+import com.sun.star.util.URL;
+import com.sun.star.util.XURLTransformer;
+import com.sun.star.accessibility.AccessibleRole;
+import com.sun.star.accessibility.XAccessible;
+import com.sun.star.accessibility.XAccessibleText;
+import com.sun.star.accessibility.XAccessibleValue;
+import com.sun.star.accessibility.XAccessibleComponent;
+import com.sun.star.accessibility.XAccessibleContext;
+
+import util.AccessibilityTools;
+import util.SOfficeFactory;
+import util.utils;
+
+import com.sun.star.beans.XPropertySet;
+import com.sun.star.beans.XPropertySetInfo;
+import com.sun.star.container.XNameAccess;
+import com.sun.star.lang.XComponent;
+import com.sun.star.sheet.XHeaderFooterContent;
+import com.sun.star.sheet.XSpreadsheetDocument;
+import com.sun.star.style.XStyle;
+import com.sun.star.style.XStyleFamiliesSupplier;
+import com.sun.star.text.XText;
+import com.sun.star.drawing.XDrawPageSupplier;
+import com.sun.star.drawing.XDrawPage;
+import com.sun.star.drawing.XShape;
+import com.sun.star.drawing.XShapes;
+
+
+import com.sun.star.beans.Property;
+import com.sun.star.lang.XServiceInfo;
+
+/**
+ * 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 extends ComplexTestCase {
+
+ /** The MultiServiceFactory **/
+ private XMultiServiceFactory mXMSF = null;
+
+ /** Get all test methods.
+ * @return The test methods.
+ */
+ public String[] getTestMethodNames() {
+ return new String[]{"checkPositiveViewForwarder",
+ "checkNegativeViewForwarder",
+ "checkPreviewHeaderCells",
+ "checkPreviewShape"
+ };
+ }
+
+ /**
+ * Get a MultiServiceFactory from the Office before the test.
+ */
+ public void before() {
+ mXMSF = (XMultiServiceFactory)param.getMSF();
+ }
+
+
+ /** Create a spreadsheet document, insert some text, header and footer.
+ * Let the user resize the document and check the contents.
+ */
+ public void checkPositiveViewForwarder() {
+ SOfficeFactory SOF = SOfficeFactory.getFactory( mXMSF );
+ XSpreadsheetDocument xSpreadsheetDoc = null;
+
+ try {
+ log.println("Creating a spreadsheet document");
+ xSpreadsheetDoc = SOF.createCalcDoc(null);
+ } catch (com.sun.star.uno.Exception e) {
+ failed(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 = (XIndexAccess)
+ 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) {
+ log.println("Exception ceating relation :");
+ failed(e.getMessage());
+ } catch(com.sun.star.lang.WrappedTargetException e) {
+ log.println("Exception ceating relation :");
+ failed(e.getMessage());
+ } catch(com.sun.star.lang.IndexOutOfBoundsException e) {
+ log.println("Exception ceating relation :");
+ failed(e.getMessage());
+ }
+
+ XModel aModel = (XModel)
+ UnoRuntime.queryInterface(XModel.class, xSpreadsheetDoc);
+
+ XController xController = aModel.getCurrentController();
+
+ // get page styles
+ XStyleFamiliesSupplier StyleFam = (XStyleFamiliesSupplier)
+ 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) {
+ failed(e.getMessage());
+ } catch(com.sun.star.lang.WrappedTargetException e){
+ failed(e.getMessage());
+ return;
+ } catch(com.sun.star.container.NoSuchElementException e){
+ failed(e.getMessage());
+ return;
+ }
+
+ //get the property-set
+ final XPropertySet PropSet = (XPropertySet)
+ 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) {
+ failed(e.getMessage());
+ } catch(com.sun.star.lang.WrappedTargetException e){
+ failed(e.getMessage());
+ return;
+ } catch(com.sun.star.beans.UnknownPropertyException e){
+ failed(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) {
+ failed(e.getMessage());
+ } catch(com.sun.star.lang.WrappedTargetException e){
+ failed(e.getMessage());
+ return;
+ } catch(com.sun.star.beans.UnknownPropertyException e){
+ failed(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 = (XDispatchProvider)
+ UnoRuntime.queryInterface(XDispatchProvider.class, xController);
+ XURLTransformer xParser = (com.sun.star.util.XURLTransformer)
+ 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) {
+ failed("Couldn't change mode");
+ return;
+ }
+
+ try {
+ Thread.sleep(500);
+ } catch (InterruptedException ex) {}
+
+ log.println("Press any key after resizing ");
+ try{
+ byte[]b = new byte[16];
+ System.in.read(b);
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+
+ // get the accessible content
+ AccessibilityTools at = new AccessibilityTools();
+
+ XWindow xWindow = at.getCurrentWindow(mXMSF, aModel);
+ XAccessible xRoot = at.getAccessibleObject(xWindow);
+ XAccessible parent = null;
+
+ try {
+ parent = at.getAccessibleObjectForRole
+ (xRoot, AccessibleRole.HEADER, "").getAccessibleChild(0);
+ oObj = parent.getAccessibleContext().getAccessibleChild(0);
+ } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
+ failed(iabe.getMessage());
+ return;
+ }
+
+ log.println("ImplementationName " + utils.getImplName(oObj));
+
+ XAccessibleComponent accPC = (XAccessibleComponent)
+ UnoRuntime.queryInterface(XAccessibleComponent.class, parent);
+
+ log.println("Parent-BoundsX= "+accPC.getBounds().X);
+ log.println("Parent-BoundsY= "+accPC.getBounds().Y);
+ log.println("Parent-BoundsWidth= "+accPC.getBounds().Width);
+ log.println("Parent-BoundsHeight= "+accPC.getBounds().Height);
+
+ XAccessibleComponent accPPC = (XAccessibleComponent)
+ UnoRuntime.queryInterface(XAccessibleComponent.class,
+ parent.getAccessibleContext().getAccessibleParent());
+
+ log.println("P-Parent-BoundsX= "+accPPC.getBounds().X);
+ log.println("P-Parent-BoundsY= "+accPPC.getBounds().Y);
+ log.println("P-Parent-BoundsWidth= "+accPPC.getBounds().Width);
+ log.println("P-Parent-BoundsHeight= "+accPPC.getBounds().Height);
+
+ try {
+ Thread.sleep(500);
+ } catch (InterruptedException ex) {}
+
+ log.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 {
+ log.println("ChildCount: "+
+ parent.getAccessibleContext().getAccessibleChildCount());
+ log.println("Getting child 0 again");
+ oObj = parent.getAccessibleContext().getAccessibleChild(0);
+ } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
+ failed(iabe.getMessage());
+ return;
+ }
+
+ XAccessibleText accT = (XAccessibleText)
+ UnoRuntime.queryInterface(XAccessibleText.class, oObj);
+ log.println("Getting the text: "+accT.getText());
+
+ XAccessibleComponent accC = (XAccessibleComponent)
+ UnoRuntime.queryInterface(XAccessibleComponent.class, oObj);
+ log.println("BoundsX= "+accC.getBounds().X);
+ log.println("BoundsY= "+accC.getBounds().Y);
+ log.println("BoundsWidth= "+accC.getBounds().Width);
+ log.println("BoundsHeight= "+accC.getBounds().Height);
+
+ accPC = (XAccessibleComponent)
+ UnoRuntime.queryInterface(XAccessibleComponent.class, parent);
+
+ log.println("Parent-BoundsX= "+accPC.getBounds().X);
+ log.println("Parent-BoundsY= "+accPC.getBounds().Y);
+ log.println("Parent-BoundsWidth= "+accPC.getBounds().Width);
+ log.println("Parent-BoundsHeight= "+accPC.getBounds().Height);
+
+ accPPC = (XAccessibleComponent)
+ UnoRuntime.queryInterface(XAccessibleComponent.class,
+ parent.getAccessibleContext().getAccessibleParent());
+
+ log.println("P-Parent-BoundsX= "+accPPC.getBounds().X);
+ log.println("P-Parent-BoundsY= "+accPPC.getBounds().Y);
+ log.println("P-Parent-BoundsWidth= "+accPPC.getBounds().Width);
+ log.println("P-Parent-BoundsHeight= "+accPPC.getBounds().Height);
+
+
+
+ log.println("Press any key when the footer is visible.");
+ try{
+ byte[]b = new byte[16];
+ System.in.read(b);
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+
+ try {
+ parent = at.getAccessibleObjectForRole
+ (xRoot, AccessibleRole.FOOTER, "").getAccessibleChild(0);
+ } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
+ failed(iabe.getMessage());
+ return;
+ }
+
+ accPC = (XAccessibleComponent)
+ UnoRuntime.queryInterface(XAccessibleComponent.class, parent);
+
+ try {
+ log.println("ChildCount: "+
+ parent.getAccessibleContext().getAccessibleChildCount());
+ log.println("Getting child 0 again");
+ oObj = parent.getAccessibleContext().getAccessibleChild(0);
+ } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
+ failed(iabe.getMessage());
+ return;
+ }
+
+ accT = (XAccessibleText)
+ UnoRuntime.queryInterface(XAccessibleText.class, oObj);
+ log.println("Getting the text: "+accT.getText());
+
+ accC = (XAccessibleComponent)
+ UnoRuntime.queryInterface(XAccessibleComponent.class, oObj);
+ log.println("BoundsX= "+accC.getBounds().X);
+ log.println("BoundsY= "+accC.getBounds().Y);
+ log.println("BoundsWidth= "+accC.getBounds().Width);
+ log.println("BoundsHeight= "+accC.getBounds().Height);
+
+ accPC = (XAccessibleComponent)
+ UnoRuntime.queryInterface(XAccessibleComponent.class, parent);
+
+ log.println("Parent-BoundsX= "+accPC.getBounds().X);
+ log.println("Parent-BoundsY= "+accPC.getBounds().Y);
+ log.println("Parent-BoundsWidth= "+accPC.getBounds().Width);
+ log.println("Parent-BoundsHeight= "+accPC.getBounds().Height);
+
+ accPPC = (XAccessibleComponent)
+ UnoRuntime.queryInterface(XAccessibleComponent.class,
+ parent.getAccessibleContext().getAccessibleParent());
+
+ log.println("P-Parent-BoundsX= "+accPPC.getBounds().X);
+ log.println("P-Parent-BoundsY= "+accPPC.getBounds().Y);
+ log.println("P-Parent-BoundsWidth= "+accPPC.getBounds().Width);
+ log.println("P-Parent-BoundsHeight= "+accPPC.getBounds().Height);
+
+
+ log.println("Press any key when the page content is on top");
+ try{
+ byte[]b = new byte[16];
+ System.in.read(b);
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+
+ try {
+ parent = at.getAccessibleObjectForRole
+ (xRoot, AccessibleRole.DOCUMENT, "").getAccessibleChild(0);
+ } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
+ failed(iabe.getMessage());
+ return;
+ }
+ System.out.println("PARENT: " + parent.getAccessibleContext().getAccessibleName());
+ accPC = (XAccessibleComponent)
+ UnoRuntime.queryInterface(XAccessibleComponent.class, parent);
+
+ int cCount = 0;
+ try {
+ cCount =
+ parent.getAccessibleContext().getAccessibleChildCount();
+ log.println("ChildCount: "+cCount);
+ log.println("Getting child 0 again");
+ oObj = parent.getAccessibleContext().getAccessibleChild(0);
+ } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
+ failed(iabe.getMessage());
+ return;
+ }
+
+ for (int i=0; i<cCount; i++) {
+ try {
+ XAccessible xA = parent.getAccessibleContext().getAccessibleChild(i);
+ System.out.println("NAME object " + i + ": " + xA.getAccessibleContext().getAccessibleName());
+ } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
+ failed(iabe.getMessage());
+ return;
+ }
+ }
+
+ System.out.println("SERVICES:");
+ util.dbg.getSuppServices(oObj);
+
+ XAccessibleValue accV = (XAccessibleValue)
+ 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());
+ log.println("Getting the value: "+accV.getCurrentValue());
+
+
+
+
+ accC = (XAccessibleComponent)
+ UnoRuntime.queryInterface(XAccessibleComponent.class, oObj);
+ log.println("BoundsX= "+accC.getBounds().X);
+ log.println("BoundsY= "+accC.getBounds().Y);
+ log.println("BoundsWidth= "+accC.getBounds().Width);
+ log.println("BoundsHeight= "+accC.getBounds().Height);
+
+ accPC = (XAccessibleComponent)
+ UnoRuntime.queryInterface(XAccessibleComponent.class, parent);
+
+ log.println("Parent-BoundsX= "+accPC.getBounds().X);
+ log.println("Parent-BoundsY= "+accPC.getBounds().Y);
+ log.println("Parent-BoundsWidth= "+accPC.getBounds().Width);
+ log.println("Parent-BoundsHeight= "+accPC.getBounds().Height);
+
+ accPPC = (XAccessibleComponent)
+ UnoRuntime.queryInterface(XAccessibleComponent.class,
+ parent.getAccessibleContext().getAccessibleParent());
+
+ log.println("P-Parent-BoundsX= "+accPPC.getBounds().X);
+ log.println("P-Parent-BoundsY= "+accPPC.getBounds().Y);
+ log.println("P-Parent-BoundsWidth= "+accPPC.getBounds().Width);
+ log.println("P-Parent-BoundsHeight= "+accPPC.getBounds().Height);
+
+ XComponent xComp = (XComponent)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.
+ */
+ public void checkNegativeViewForwarder() {
+ SOfficeFactory SOF = SOfficeFactory.getFactory( mXMSF );
+ XSpreadsheetDocument xSpreadsheetDoc = null;
+
+ try {
+ log.println("Creating a spreadsheet document");
+ xSpreadsheetDoc = SOF.createCalcDoc(null);
+ } catch (com.sun.star.uno.Exception e) {
+ failed(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 = (XIndexAccess)
+ 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) {
+ log.println("Exception ceating relation :");
+ failed(e.getMessage());
+ } catch(com.sun.star.lang.WrappedTargetException e) {
+ log.println("Exception ceating relation :");
+ failed(e.getMessage());
+ } catch(com.sun.star.lang.IndexOutOfBoundsException e) {
+ log.println("Exception ceating relation :");
+ failed(e.getMessage());
+ }
+
+ XModel aModel = (XModel)
+ UnoRuntime.queryInterface(XModel.class, xSpreadsheetDoc);
+
+ XController xController = aModel.getCurrentController();
+
+ // get page styles
+ XStyleFamiliesSupplier StyleFam = (XStyleFamiliesSupplier)
+ 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) {
+ failed(e.getMessage());
+ } catch(com.sun.star.lang.WrappedTargetException e){
+ failed(e.getMessage());
+ return;
+ } catch(com.sun.star.container.NoSuchElementException e){
+ failed(e.getMessage());
+ return;
+ }
+
+ //get the property-set
+ final XPropertySet PropSet = (XPropertySet)
+ UnoRuntime.queryInterface(XPropertySet.class, StdStyle);
+
+ XHeaderFooterContent RPHFC = null;
+
+ // get the header
+ log.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) {
+ failed(e.getMessage());
+ } catch(com.sun.star.lang.WrappedTargetException e){
+ failed(e.getMessage());
+ return;
+ } catch(com.sun.star.beans.UnknownPropertyException e){
+ failed(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) {
+ failed(e.getMessage());
+ } catch(com.sun.star.lang.WrappedTargetException e){
+ failed(e.getMessage());
+ return;
+ } catch(com.sun.star.beans.UnknownPropertyException e){
+ failed(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 = (XDispatchProvider)
+ UnoRuntime.queryInterface(XDispatchProvider.class, xController);
+ XURLTransformer xParser = (com.sun.star.util.XURLTransformer)
+ 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) {
+ failed("Couldn't change mode");
+ return;
+ }
+
+ try {
+ Thread.sleep(500);
+ } catch (InterruptedException ex) {}
+
+ log.println("Press any key after resizing ");
+ try{
+ byte[]b = new byte[16];
+ System.in.read(b);
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+
+ // get the accessible content
+ AccessibilityTools at = new AccessibilityTools();
+
+ XWindow xWindow = at.getCurrentWindow(mXMSF, aModel);
+ XAccessible xRoot = at.getAccessibleObject(xWindow);
+ XAccessible parent = null;
+
+ try {
+ parent = at.getAccessibleObjectForRole
+ (xRoot, AccessibleRole.HEADER, "").getAccessibleChild(0);
+ oObj = parent.getAccessibleContext().getAccessibleChild(0);
+ } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
+ failed(iabe.getMessage());
+ return;
+ }
+
+ log.println("ImplementationName " + utils.getImplName(oObj));
+
+ XAccessibleComponent accPC = (XAccessibleComponent)
+ UnoRuntime.queryInterface(XAccessibleComponent.class, parent);
+
+ log.println("Parent-BoundsX= "+accPC.getBounds().X);
+ log.println("Parent-BoundsY= "+accPC.getBounds().Y);
+ log.println("Parent-BoundsWidth= "+accPC.getBounds().Width);
+ log.println("Parent-BoundsHeight= "+accPC.getBounds().Height);
+
+ XAccessibleComponent accPPC = (XAccessibleComponent)
+ UnoRuntime.queryInterface(XAccessibleComponent.class,
+ parent.getAccessibleContext().getAccessibleParent());
+
+ log.println("P-Parent-BoundsX= "+accPPC.getBounds().X);
+ log.println("P-Parent-BoundsY= "+accPPC.getBounds().Y);
+ log.println("P-Parent-BoundsWidth= "+accPPC.getBounds().Width);
+ log.println("P-Parent-BoundsHeight= "+accPPC.getBounds().Height);
+
+ try {
+ Thread.sleep(500);
+ } catch (InterruptedException ex) {}
+
+ log.println("Press any key when the header is not visible.");
+ try{
+ byte[]b = new byte[16];
+ System.in.read(b);
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+
+ int childCount = 0;
+ childCount =
+ parent.getAccessibleContext().getAccessibleChildCount();
+ log.println("ChildCount: "+childCount);
+
+ if (childCount != 0)
+ failed("Could access header although it was not visible on page.");
+
+
+ try {
+ parent = at.getAccessibleObjectForRole
+ (xRoot, AccessibleRole.FOOTER, "").getAccessibleChild(0);
+ } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
+ failed(iabe.getMessage());
+ return;
+ }
+
+ accPC = (XAccessibleComponent)
+ UnoRuntime.queryInterface(XAccessibleComponent.class, parent);
+
+ log.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();
+ log.println("ChildCount: "+childCount);
+
+ if (childCount != 0)
+ failed("Could access footer although it was not visible on page.");
+
+ XComponent xComp = (XComponent)UnoRuntime.queryInterface(
+ XComponent.class, xSpreadsheetDoc);
+ xComp.dispose();
+
+ }
+
+
+
+
+ /**
+ * Check the preview of header cells
+ */
+ public void checkPreviewHeaderCells() {
+
+ XInterface oObj = null;
+ SOfficeFactory SOF = SOfficeFactory.getFactory( mXMSF);
+ XSpreadsheetDocument xSpreadsheetDoc = null;
+
+ try {
+ log.println("Creating a spreadsheet document");
+ xSpreadsheetDoc = SOF.createCalcDoc(null);
+ } catch (com.sun.star.uno.Exception e) {
+ failed(e.getMessage());
+ return;
+ }
+
+ XModel xModel = (XModel)
+ UnoRuntime.queryInterface(XModel.class, xSpreadsheetDoc);
+
+ XController xController = xModel.getCurrentController();
+
+ //setting value of cell A1
+ XCell xCell = null;
+ try {
+ log.println("Getting spreadsheet") ;
+ XSpreadsheets oSheets = xSpreadsheetDoc.getSheets() ;
+ XIndexAccess oIndexSheets = (XIndexAccess)
+ UnoRuntime.queryInterface(XIndexAccess.class, oSheets);
+ Object o = oIndexSheets.getByIndex(0);
+ XSpreadsheet oSheet = (XSpreadsheet)AnyConverter.toObject(
+ new com.sun.star.uno.Type(XSpreadsheet.class), o);
+
+ log.println("Getting a cell from sheet") ;
+ xCell = oSheet.getCellByPosition(0, 0);
+ } catch(com.sun.star.lang.IllegalArgumentException e) {
+ failed(e.getMessage());
+ } catch (com.sun.star.lang.WrappedTargetException e) {
+ failed(e.getMessage());
+ return;
+ } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
+ failed(e.getMessage());
+ return;
+ }
+
+ xCell.setFormula("Value");
+
+ //setting property 'PrintHeaders' of the style 'Default'
+ XStyleFamiliesSupplier xSFS = (XStyleFamiliesSupplier)
+ UnoRuntime.queryInterface(XStyleFamiliesSupplier.class,
+ xSpreadsheetDoc);
+ XNameAccess xNA = xSFS.getStyleFamilies();
+ XPropertySet xPropSet = null;
+ try {
+ Object oPageStyles = xNA.getByName("PageStyles");
+ xNA = (XNameAccess)
+ UnoRuntime.queryInterface(XNameAccess.class, oPageStyles);
+ Object oDefStyle = xNA.getByName("Default");
+ xPropSet = (XPropertySet)
+ UnoRuntime.queryInterface(XPropertySet.class, oDefStyle);
+ } catch(com.sun.star.lang.WrappedTargetException e) {
+ failed(e.getMessage());
+ return;
+ } catch(com.sun.star.container.NoSuchElementException e) {
+ failed(e.getMessage());
+ return;
+ }
+
+ try {
+ xPropSet.setPropertyValue("PrintHeaders", new Boolean(true));
+ } catch(com.sun.star.lang.WrappedTargetException e) {
+ failed(e.getMessage());
+ return;
+ } catch(com.sun.star.lang.IllegalArgumentException e) {
+ failed(e.getMessage());
+ return;
+ } catch(com.sun.star.beans.PropertyVetoException e) {
+ failed(e.getMessage());
+ return;
+ } catch(com.sun.star.beans.UnknownPropertyException e) {
+ failed(e.getMessage());
+ return;
+ }
+
+ //switching to 'Print Preview' mode
+ try {
+ XDispatchProvider xDispProv = (XDispatchProvider)
+ UnoRuntime.queryInterface(XDispatchProvider.class, xController);
+ XURLTransformer xParser = (com.sun.star.util.XURLTransformer)
+ 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) {
+ failed(e.getMessage());
+ return;
+ }
+
+ try {
+ Thread.currentThread().sleep(500) ;
+ } catch (InterruptedException e) {
+ System.out.println("While waiting :" + e) ;
+ }
+
+ AccessibilityTools at = new AccessibilityTools();
+
+ XWindow xWindow = at.getCurrentWindow(mXMSF, xModel);
+ XAccessible xRoot = at.getAccessibleObject(xWindow);
+
+// log.println("ImplementationName " + utils.getImplName(oObj));
+
+ log.println("Press any key when the header cell is on top.");
+ try{
+ byte[]b = new byte[16];
+ System.in.read(b);
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+
+
+ XAccessible parent = null;
+
+ try {
+ System.out.println("Count: " +at.getAccessibleObjectForRole
+ (xRoot, AccessibleRole.TABLE, "").getAccessibleChildCount());
+// parent = at.getAccessibleObjectForRole
+// (xRoot, AccessibleRole.TABLE, "").getAccessibleChild(0);
+// oObj = parent.getAccessibleContext().getAccessibleChild(1);
+ System.out.println("Getting child 2");
+ oObj = at.getAccessibleObjectForRole
+ (xRoot, AccessibleRole.TABLE, "").getAccessibleChild(2);
+ } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
+ failed(iabe.getMessage());
+ return;
+ }
+
+ System.out.println("*** DEBUG INFO ***");
+ util.dbg.getSuppServices(oObj);
+ System.out.println("****** IFC ******");
+ util.dbg.printInterfaces(oObj);
+ System.out.println("*****************");
+
+
+/* XAccessibleContext accCtx = (XAccessibleContext)
+ UnoRuntime.queryInterface(XAccessibleContext.class, oObj);
+ try {
+ System.out.println("Children now: " + accCtx.getAccessibleChild(0).getAccessibleContext().getAccessibleChildCount());
+ } catch (com.sun.star.lang.IndexOutOfBoundsException iabe) {
+ failed(iabe.getMessage());
+ return;
+ }
+*/
+
+ XAccessibleValue accV = (XAccessibleValue)
+ UnoRuntime.queryInterface(XAccessibleValue.class, oObj);
+ Object o = accV.getCurrentValue();
+ log.println("Getting the value: "+o + " is void " + util.utils.isVoid(o));
+
+
+ XAccessibleComponent accC = (XAccessibleComponent)
+ UnoRuntime.queryInterface(XAccessibleComponent.class, oObj);
+
+ log.println("BoundsX= "+accC.getBounds().X);
+ log.println("BoundsY= "+accC.getBounds().Y);
+ log.println("BoundsWidth= "+accC.getBounds().Width);
+ log.println("BoundsHeight= "+accC.getBounds().Height);
+
+ XComponent xComp = (XComponent)UnoRuntime.queryInterface(
+ XComponent.class, xSpreadsheetDoc);
+ xComp.dispose();
+
+ }
+
+
+
+
+
+ /**
+ * Check the preview of Shapes: load a document with shapes and see, if they
+ * are accessible.
+ */
+ public void checkPreviewShape() {
+ SOfficeFactory SOF = SOfficeFactory.getFactory( mXMSF );
+ XSpreadsheetDocument xSpreadsheetDoc = null;
+ XComponent xComp = null;
+ XInterface oObj = null;
+
+ try {
+ String docName = "calcshapes.sxc";
+ log.println("Loading a spreadsheetdocument.");
+ String url = utils.getFullURL(
+ (String)param.get("TestDocumentPath") + "/" + docName);
+ log.println("loading document '" + url + "'");
+ xComp = SOF.loadDocument(url);
+
+ } catch (com.sun.star.uno.Exception e) {
+ failed(e.getMessage());
+ return;
+ }
+
+ try {
+ Thread.currentThread().sleep(500) ;
+ } catch (InterruptedException e) {
+ System.out.println("While waiting :" + e) ;
+ }
+
+ if (xComp == null) {
+ failed("loading document failed.");
+ return;
+ }
+
+ xSpreadsheetDoc = (XSpreadsheetDocument)UnoRuntime.queryInterface(
+ XSpreadsheetDocument.class, xComp);
+ XModel aModel = (XModel)
+ UnoRuntime.queryInterface(XModel.class, xSpreadsheetDoc);
+
+ XController xController = aModel.getCurrentController();
+
+ // switching to 'Page Preview' mode
+ try {
+ XDispatchProvider xDispProv = (XDispatchProvider)
+ UnoRuntime.queryInterface(XDispatchProvider.class, xController);
+ XURLTransformer xParser = (com.sun.star.util.XURLTransformer)
+ 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) {
+ failed("Couldn't change mode");
+ return;
+ }
+
+ try {
+ Thread.currentThread().sleep(500) ;
+ } catch (InterruptedException e) {
+ System.out.println("While waiting :" + e) ;
+ }
+
+
+
+ log.println("Press any key when a shape is on top.");
+ try{
+ byte[]b = new byte[16];
+ System.in.read(b);
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+
+ // get the accessible content
+ AccessibilityTools at = new AccessibilityTools();
+
+ XWindow xWindow = at.getCurrentWindow(mXMSF, aModel);
+ XAccessible xRoot = at.getAccessibleObject(xWindow);
+ XAccessible parent = null;
+
+ try {
+ XAccessibleContext con = at.getAccessibleObjectForRole
+ (xRoot, AccessibleRole.SHAPE, "");
+ log.println("Name of AccessibleContext: " + con.getAccessibleName());
+ oObj = con;
+ } catch (Exception e) {
+ failed(e.getMessage());
+ return;
+ }
+
+ log.println("ImplementationName: " + utils.getImplName(oObj));
+ util.dbg.printInterfaces(oObj);
+
+ xComp.dispose();
+ }
+
+}
+
+