From a9a5a55e0284638deb87c69699ab37a456908900 Mon Sep 17 00:00:00 2001 From: Jens Carl Date: Sat, 5 Aug 2017 05:42:39 +0000 Subject: tdf#45904 Remove/disable obsolete _XGoalSeek Java test The _XGoalSeek test is already written in C++ since commit ce6f47a4588e2c6e115fcc4980f575d3002ca603. Change-Id: I898bcbf5e41751610fdc3f40cf7d6f6094df68c4 Reviewed-on: https://gerrit.libreoffice.org/40785 Tested-by: Jenkins Reviewed-by: Markus Mohrhard --- qadevOOo/Jar_OOoRunner.mk | 1 - .../sc/com.sun.star.comp.office.ScModelObj.csv | 1 - qadevOOo/tests/java/ifc/sheet/_XGoalSeek.java | 105 --------------------- 3 files changed, 107 deletions(-) delete mode 100644 qadevOOo/tests/java/ifc/sheet/_XGoalSeek.java (limited to 'qadevOOo') diff --git a/qadevOOo/Jar_OOoRunner.mk b/qadevOOo/Jar_OOoRunner.mk index f68fca900db2..3804778bf22e 100644 --- a/qadevOOo/Jar_OOoRunner.mk +++ b/qadevOOo/Jar_OOoRunner.mk @@ -615,7 +615,6 @@ $(eval $(call gb_Jar_add_sourcefiles,OOoRunner,\ qadevOOo/tests/java/ifc/sheet/_XEnhancedMouseClickBroadcaster \ qadevOOo/tests/java/ifc/sheet/_XFormulaQuery \ qadevOOo/tests/java/ifc/sheet/_XFunctionDescriptions \ - qadevOOo/tests/java/ifc/sheet/_XGoalSeek \ qadevOOo/tests/java/ifc/sheet/_XHeaderFooterContent \ qadevOOo/tests/java/ifc/sheet/_XLabelRange \ qadevOOo/tests/java/ifc/sheet/_XLabelRanges \ diff --git a/qadevOOo/objdsc/sc/com.sun.star.comp.office.ScModelObj.csv b/qadevOOo/objdsc/sc/com.sun.star.comp.office.ScModelObj.csv index fbd045be3319..97c52331d984 100644 --- a/qadevOOo/objdsc/sc/com.sun.star.comp.office.ScModelObj.csv +++ b/qadevOOo/objdsc/sc/com.sun.star.comp.office.ScModelObj.csv @@ -48,7 +48,6 @@ "ScModelObj";"com::sun::star::beans::XPropertySet#optional";"addVetoableChangeListener()" "ScModelObj";"com::sun::star::beans::XPropertySet#optional";"removeVetoableChangeListener()" "ScModelObj";"com::sun::star::sheet::XDocumentAuditing";"refreshArrows()" -"ScModelObj";"com::sun::star::sheet::XGoalSeek";"seekGoal()" "ScModelObj";"com::sun::star::sheet::SpreadsheetDocument";"NamedRanges" "ScModelObj";"com::sun::star::sheet::SpreadsheetDocument";"DatabaseRanges" "ScModelObj";"com::sun::star::sheet::SpreadsheetDocument";"ColumnLabelRanges" diff --git a/qadevOOo/tests/java/ifc/sheet/_XGoalSeek.java b/qadevOOo/tests/java/ifc/sheet/_XGoalSeek.java deleted file mode 100644 index 88b768361dd9..000000000000 --- a/qadevOOo/tests/java/ifc/sheet/_XGoalSeek.java +++ /dev/null @@ -1,105 +0,0 @@ -/* - * 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 ifc.sheet; - -import com.sun.star.container.XIndexAccess; -import com.sun.star.sheet.GoalResult; -import com.sun.star.sheet.XGoalSeek; -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.StatusException; - -/** - * - */ -public class _XGoalSeek extends MultiMethodTest { - public XGoalSeek oObj = null; - XSpreadsheet xSheet = null; - CellAddress aFormula = null; - CellAddress aValue = null; - - @Override - public void before() { - Exception ex = null; - // get two sheets - try { - XSpreadsheetDocument xSpreadsheetDocument = UnoRuntime.queryInterface(XSpreadsheetDocument.class, oObj); - XSpreadsheets oSheets = xSpreadsheetDocument.getSheets(); - XIndexAccess oIndexSheets = UnoRuntime.queryInterface( - XIndexAccess.class, oSheets); - xSheet = UnoRuntime.queryInterface( - XSpreadsheet.class, oIndexSheets.getByIndex(1)); - } - catch(com.sun.star.lang.IndexOutOfBoundsException e) { - ex = e; - } - catch(com.sun.star.lang.WrappedTargetException e) { - ex = e; - } - catch(NullPointerException e) { - ex = e; - } - if (ex != null) { - throw new StatusException("Could not get a sheet.", ex); - } - - // set value and formula - try { - xSheet.getCellByPosition(3, 4).setValue(9); - xSheet.getCellByPosition(3, 5).setFormula("= SQRT(D5)"); - aValue = new CellAddress((short)1, 3, 4); - aFormula = new CellAddress((short)1, 3, 5); - } - catch(Exception e) { - throw new StatusException("Could not get set formulas on the sheet.", e); - } - } - - public void _seekGoal() { - boolean result = true; - double divergence = 0.01; - GoalResult goal = oObj.seekGoal(aFormula, aValue, "4"); - log.println("Goal Result: " + goal.Result + " Divergence: " + goal.Divergence); - result &= goal.Divergence < divergence; - result &= goal.Result > 16 - divergence || goal.Result < 16 + divergence; - - goal = oObj.seekGoal(aFormula, aValue, "-4"); - log.println("Goal Result: " + goal.Result + " Divergence: " + goal.Divergence); - result &= goal.Divergence > 1/divergence; - result &= goal.Result < divergence || goal.Result > -divergence; - - // just curious: let goal seek find a limiting value - try { - xSheet.getCellByPosition(3, 4).setValue(0.8); - xSheet.getCellByPosition(3, 5).setFormula("= (D5 ^ 2 - 1) / (D5 - 1)"); - } - catch(Exception e) { - System.out.println("caught exception: " + e); - } - goal = oObj.seekGoal(aFormula, aValue, "2"); - log.println("Goal Result: " + goal.Result + " Divergence: " + goal.Divergence); - result &= goal.Divergence < divergence; - result &= goal.Result > 16 - divergence || goal.Result < 16 + divergence; - - tRes.tested("seekGoal()", result); - } -} -- cgit