/**************************************************************
*
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF licenses this file
* to you under the Apache License, Version 2.0 (the
* "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing,
* software distributed under the License is distributed on an
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
* KIND, either express or implied. See the License for the
* specific language governing permissions and limitations
* under the License.
*
*************************************************************/
package ifc.sheet;
import com.sun.star.awt.Point;
import com.sun.star.beans.PropertyValue;
import com.sun.star.container.XIndexAccess;
import com.sun.star.container.XNamed;
import com.sun.star.drawing.XDrawPage;
import com.sun.star.drawing.XDrawPagesSupplier;
import com.sun.star.drawing.XShape;
import com.sun.star.frame.XDispatchHelper;
import com.sun.star.frame.XDispatchProvider;
import com.sun.star.frame.XModel;
import com.sun.star.lang.XMultiServiceFactory;
import com.sun.star.sheet.XDocumentAuditing;
import com.sun.star.sheet.XSheetAuditing;
import com.sun.star.sheet.XSpreadsheet;
import com.sun.star.sheet.XSpreadsheetDocument;
import com.sun.star.sheet.XSpreadsheets;
import com.sun.star.table.CellAddress;
import com.sun.star.uno.UnoRuntime;
import lib.MultiMethodTest;
import lib.Status;
import lib.StatusException;
/**
*
*/
public class _XDocumentAuditing extends MultiMethodTest {
public XDocumentAuditing oObj = null;
XDrawPage xDrawPage = null;
XSpreadsheet[] xSheet = null;
int elementCount = 0;
String sheetName = null;
Point pos = null;
public void before() {
Exception ex = null;
// get two sheets
xSheet = new XSpreadsheet[2];
try {
XSpreadsheetDocument xSpreadsheetDocument = (XSpreadsheetDocument)
UnoRuntime.queryInterface(XSpreadsheetDocument.class, oObj);
XSpreadsheets oSheets = xSpreadsheetDocument.getSheets();
XIndexAccess oIndexSheets = (XIndexAccess) UnoRuntime.queryInterface(
XIndexAccess.class, oSheets);
XSpreadsheet oSheet = (XSpreadsheet) UnoRuntime.queryInterface(
XSpreadsheet.class, oIndexSheets.getByIndex(0));
xSheet[0] = oSheet;
oSheet = (XSpreadsheet) UnoRuntime.queryInterface(
XSpreadsheet.class, oIndexSheets.getByIndex(1));
xSheet[1] = oSheet;
}
catch(com.sun.star.lang.IndexOutOfBoundsException e) {
ex = e;
}
catch(com.sun.star.lang.WrappedTargetException e) {
ex = e;
}
catch(java.lang.NullPointerException e) {
ex = e;
}
if (ex != null) {
throw new StatusException("Could not get two sheets.", ex);
}
// get the draw page for checking the shapes
xDrawPage = (XDrawPage)tEnv.getObjRelation("XDocumentAuditing.DrawPage");
if (xDrawPage == null) { // get from object
try {
XDrawPagesSupplier oDPS = (XDrawPagesSupplier)
UnoRuntime.queryInterface(XDrawPagesSupplier.class, oObj);
Object o = oDPS.getDrawPages().getByIndex(1);
xDrawPage = (XDrawPage)UnoRuntime.queryInterface(XDrawPage.class, o);
}
catch(com.sun.star.lang.IndexOutOfBoundsException e) {
} // ignore exceptions, we'll run into next if statement anyway
catch(com.sun.star.lang.WrappedTargetException e) {
}
}
if (xDrawPage == null) {
throw new StatusException(Status.failed("'XSheetAuditing.DrawPage' object relation not found."));
}
if (xDrawPage.hasElements()) {
elementCount = xDrawPage.getCount();
}
// switch off the automatic refresh
PropertyValue[] props = new PropertyValue[1];
props[0] = new PropertyValue();
props[0].Name = "AutoRefreshArrows";
props[0].Value = Boolean.FALSE;
XModel xModel = (XModel)UnoRuntime.queryInterface(XModel.class, oObj);
dispatch(xModel.getCurrentController().getFrame(), (XMultiServiceFactory)tParam.getMSF(), ".uno:AutoRefreshArrows", props);
// prepare the sheets
try {
xSheet[0].getCellByPosition(6, 6).setValue(9);
XNamed xNamed = (XNamed)UnoRuntime.queryInterface(XNamed.class, xSheet[0]);
sheetName = xNamed.getName();
xSheet[1].getCellByPosition(6, 6).setValue(16);
xSheet[1].getCellByPosition(6, 7).setFormula("= SQRT(G7)");
XSheetAuditing xSheetAuditing = (XSheetAuditing)UnoRuntime.queryInterface(XSheetAuditing.class, xSheet[1]);
CellAddress add = new CellAddress((short)1, 6, 7);
xSheetAuditing.showPrecedents(add);
boolean ok = hasRightAmountOfShapes(1);
if (!ok)
throw new StatusException(Status.failed("Wrong amount of shapes on page."));
}
catch(com.sun.star.lang.IndexOutOfBoundsException e) {
throw new StatusException("Could not set formulas on sheets.", e);
}
}
public void after() {
// switch the automatic refresh back on
PropertyValue[] props = new PropertyValue[1];
props[0] = new PropertyValue();
props[0].Name = "AutoRefreshArrows";
props[0].Value = Boolean.TRUE;
XModel xModel = (XModel)UnoRuntime.queryInterface(XModel.class, oObj);
dispatch(xModel.getCurrentController().getFrame(), (XMultiServiceFactory)tParam.getMSF(), ".uno:AutoRefreshArrows", props);
}
public void _refreshArrows() {
boolean result = true;
Point p0 = pos;
try {
result &= xSheet[1].getCellByPosition(6, 7).getValue() == 4;
xSheet[1].getCellByPosition(6, 7).setFormula("= SQRT(" + sheetName + ".G7)");
result &= xSheet[1].getCellByPosition(6, 7).getValue() == 3;
}
catch(com.sun.star.lang.IndexOutOfBoundsException e) {
throw new StatusException("Could not set formulas on sheets.", e);
}
result &= hasRightAmountOfShapes(1);
Point p1 = pos;
// points have to be the same: if not we have an auto update
boolean res = (p0.X == p1.X && p0.Y == p1.Y);
result &= res;
if (!res)
log.println("Arrow has been refreshed, but this should have been switched off.");
oObj.refreshArrows();
result &= hasRightAmountOfShapes(1);
Point p2 = pos;
// points have to differ
res = (p1.X != p2.X || p1.Y != p2.Y);
result &= res;
if (!res)
log.println("Arrow has not been refreshed.");
tRes.tested("refreshArrows()", result);
}
/**
* Check if the amount of shapes is the right one after displaying that stuff
* 2do improve this: check taht the shapes are the correct ones -> convwatch
* @desiredValue That's the amount of shapes that have to be here.
* @return True, if the actual count of shapes is the same
*/
private boolean hasRightAmountOfShapes(int desiredValue) {
int newCount = xDrawPage.getCount();
if (newCount != elementCount + desiredValue) {
return false;
}
else {
if (desiredValue >= 0) {
for (int i=elementCount; i<newCount; i++) {
try {
Object o = xDrawPage.getByIndex(i);
XShape xShape = (XShape)UnoRuntime.queryInterface(XShape.class, o);
pos = xShape.getPosition();
System.out.println("Shape Type: " + xShape.getShapeType());
}
catch(com.sun.star.uno.Exception e) {
e.printStackTrace();
}
}
}
}
return true;
}
private void dispatch(Object oProvider, XMultiServiceFactory xMSF, String url, PropertyValue[] prop) {
XDispatchProvider xDispatchProvider = (XDispatchProvider)UnoRuntime.queryInterface(XDispatchProvider.class, oProvider);
Object dispatcher = null;
try {
dispatcher = xMSF.createInstance("com.sun.star.frame.DispatchHelper");
}
catch(com.sun.star.uno.Exception e) {
}
XDispatchHelper xDispatchHelper = (XDispatchHelper)UnoRuntime.queryInterface(XDispatchHelper.class, dispatcher);
xDispatchHelper.executeDispatch(xDispatchProvider, url, "", 0, prop);
}
}