Quelle CalcRTL.java Sprache: JAVA

/*
* 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
 * 
 * (REMARK: the testcases expects the TableLayout to be LR_TB)
 * 
 * 1. A calc document is opened and the properties in css.sheet.Spreadsheet are checked
 * 
 * 2. A calc document is opened and a shape inserted, afterwards the properties in css.sheet.Shape are checked
 * 
 * 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 
 * afterwards all calc specific properties of the Shape are checked. 
 * 
 * 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();

}

Messung V0.5

¤ Dauer der Verarbeitung: 0.28 Sekunden (vorverarbeitet) ¤

Wurzel

Suchen

Beweissystem der NASA

Beweissystem Isabelle

NIST Cobol Testsuite

Cephes Mathematical Library

Wiener Entwicklungsmethode

Haftungshinweis

Die Informationen auf dieser Webseite wurden nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit, noch Qualität der bereit gestellten Informationen zugesichert.

Bemerkung:

Die farbliche Syntaxdarstellung und die Messung sind noch experimentell.