diff options
Diffstat (limited to 'qadevOOo/tests/java/ifc/sheet/_XFormulaQuery.java')
| -rw-r--r-- | qadevOOo/tests/java/ifc/sheet/_XFormulaQuery.java | 201 |
1 files changed, 201 insertions, 0 deletions
diff --git a/qadevOOo/tests/java/ifc/sheet/_XFormulaQuery.java b/qadevOOo/tests/java/ifc/sheet/_XFormulaQuery.java new file mode 100644 index 000000000000..3e04690ac47b --- /dev/null +++ b/qadevOOo/tests/java/ifc/sheet/_XFormulaQuery.java @@ -0,0 +1,201 @@ +/************************************************************************* + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************/ + +package ifc.sheet; + +import lib.MultiMethodTest; +import lib.Status; +import lib.StatusException; + +import com.sun.star.sheet.XFormulaQuery; +import com.sun.star.sheet.XSheetCellRanges; +import com.sun.star.sheet.XSpreadsheet; +import com.sun.star.table.CellRangeAddress; +import com.sun.star.table.XCell; +import com.sun.star.uno.UnoRuntime; + +/** + * + * @author sw93809 + */ +public class _XFormulaQuery extends MultiMethodTest { + + public XFormulaQuery oObj; + + protected XSpreadsheet oSheet = null; + private XCell mxCell; + private int miQueryThisDependentRange = 1; + private int miQueryThisPrecedentRange = 1; + private int[] miExpectedDependentValues; + private int[] miExpectedPrecedentValues; + + protected void before() { + oSheet = (XSpreadsheet)tEnv.getObjRelation("SHEET"); + + if (oSheet == null) { + log.println("Object relation oSheet is missing"); + log.println("Trying to query the needed Interface"); + oSheet = (XSpreadsheet) UnoRuntime.queryInterface( + XSpreadsheet.class, tEnv.getTestObject()); + + if (oSheet == null) { + throw new StatusException(Status.failed( + "Object relation oSheet is missing")); + } + } + Object o = tEnv.getObjRelation("MAKEENTRYINCELL"); + if (o != null) { + mxCell = (XCell)o; + } + else { + try { + mxCell = oSheet.getCellByPosition(15, 15); + } catch (com.sun.star.lang.IndexOutOfBoundsException e) { + throw new StatusException( + Status.failed("Couldn't get initial cell")); + } + } + + o = tEnv.getObjRelation("RANGEINDICES"); + if (o != null) { + int[]index = (int[])o; + miQueryThisDependentRange = index[0]; + miQueryThisPrecedentRange = index[1]; + } + + o = tEnv.getObjRelation("EXPECTEDDEPENDENTVALUES"); + if (o != null) { + miExpectedDependentValues = (int[])o; + } + else { + miExpectedDependentValues = new int[4]; + miExpectedDependentValues[0] = 15; + miExpectedDependentValues[1] = 15; + miExpectedDependentValues[2] = 15; + miExpectedDependentValues[3] = 15; + } + + o = tEnv.getObjRelation("EXPECTEDPRECEDENTVALUES"); + if (o != null) { + miExpectedPrecedentValues = (int[])o; + } + else { + miExpectedPrecedentValues = new int[4]; + miExpectedPrecedentValues[0] = 0; + miExpectedPrecedentValues[1] = 0; + miExpectedPrecedentValues[2] = 15; + miExpectedPrecedentValues[3] = 15; + } + } + + public void _queryDependents() { + boolean res = true; + + try { + mxCell.setFormula("=sum(A1:D1)"); + oSheet.getCellByPosition(0, 0).setValue(1); + oSheet.getCellByPosition(1, 0).setValue(1); + oSheet.getCellByPosition(2, 0).setValue(1); + oSheet.getCellByPosition(3, 0).setValue(1); + + log.println( + "calling oObj.queryDependents(false)"); + XSheetCellRanges getting = oObj.queryDependents(false); + CellRangeAddress[] range = getting.getRangeAddresses(); + + res = ((range[miQueryThisDependentRange].StartColumn==miExpectedDependentValues[0]) && + (range[miQueryThisDependentRange].EndColumn==miExpectedDependentValues[1]) && + (range[miQueryThisDependentRange].StartRow==miExpectedDependentValues[2]) && + (range[miQueryThisDependentRange].EndRow==miExpectedDependentValues[3])); + + if (!res) { + log.println("Getting (" + +(range[miQueryThisDependentRange]).StartColumn+"," + +(range[miQueryThisDependentRange]).EndColumn+"," + +(range[miQueryThisDependentRange]).StartRow+"," + +(range[miQueryThisDependentRange]).EndRow+")"); + log.println("Expected (" + miExpectedDependentValues[0] + "," + + miExpectedDependentValues[1] + "," + + miExpectedDependentValues[2] + "," + + miExpectedDependentValues[3] + ")"); + } + } catch (com.sun.star.lang.IndexOutOfBoundsException e) { + log.println("Couldn't set initial version to cell"); + res = false; + } + + tRes.tested("queryDependents()", res); + } + + public void _queryPrecedents() { + boolean res = true; + + try { + mxCell.setFormula("=sum(A1:D1)"); + oSheet.getCellByPosition(0, 0).setValue(1); + oSheet.getCellByPosition(1, 0).setValue(1); + oSheet.getCellByPosition(2, 0).setValue(1); + oSheet.getCellByPosition(3, 0).setValue(1); + oSheet.getCellByPosition(1, 2).setFormula("=A16*2"); + + log.println( + "calling oObj.queryPrecedents(false)"); + XSheetCellRanges getting = oObj.queryPrecedents(false); + CellRangeAddress[] range = getting.getRangeAddresses(); + + res = ((range[miQueryThisPrecedentRange].StartColumn==miExpectedPrecedentValues[0]) && + (range[miQueryThisPrecedentRange].EndColumn==miExpectedPrecedentValues[1]) && + (range[miQueryThisPrecedentRange].StartRow==miExpectedPrecedentValues[2]) && + (range[miQueryThisPrecedentRange].EndRow==miExpectedPrecedentValues[3])); + + if (!res) { + log.println("Getting (" + +(range[miQueryThisPrecedentRange]).StartColumn+"," + +(range[miQueryThisPrecedentRange]).EndColumn+"," + +(range[miQueryThisPrecedentRange]).StartRow+"," + +(range[miQueryThisPrecedentRange]).EndRow+")"); + log.println("Expected (" + miExpectedPrecedentValues[0] + "," + + miExpectedPrecedentValues[1] + "," + + miExpectedPrecedentValues[2] + "," + + miExpectedPrecedentValues[3] + ")"); + } + } catch (com.sun.star.lang.IndexOutOfBoundsException e) { + log.println("Couldn't set initial version to cell"); + res = false; + } + + tRes.tested("queryPrecedents()", res); + } + + /** + * Forces environment recreation. + */ + protected void after() { + disposeEnvironment(); + } + +} |