1ef39d40dSAndrew Rist /************************************************************** 2cdf0e10cSrcweir * 3ef39d40dSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4ef39d40dSAndrew Rist * or more contributor license agreements. See the NOTICE file 5ef39d40dSAndrew Rist * distributed with this work for additional information 6ef39d40dSAndrew Rist * regarding copyright ownership. The ASF licenses this file 7ef39d40dSAndrew Rist * to you under the Apache License, Version 2.0 (the 8ef39d40dSAndrew Rist * "License"); you may not use this file except in compliance 9ef39d40dSAndrew Rist * with the License. You may obtain a copy of the License at 10ef39d40dSAndrew Rist * 11ef39d40dSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12ef39d40dSAndrew Rist * 13ef39d40dSAndrew Rist * Unless required by applicable law or agreed to in writing, 14ef39d40dSAndrew Rist * software distributed under the License is distributed on an 15ef39d40dSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16ef39d40dSAndrew Rist * KIND, either express or implied. See the License for the 17ef39d40dSAndrew Rist * specific language governing permissions and limitations 18ef39d40dSAndrew Rist * under the License. 19ef39d40dSAndrew Rist * 20ef39d40dSAndrew Rist *************************************************************/ 21ef39d40dSAndrew Rist 22ef39d40dSAndrew Rist 23cdf0e10cSrcweir 24cdf0e10cSrcweir package ifc.sheet; 25cdf0e10cSrcweir 26cdf0e10cSrcweir import lib.MultiMethodTest; 27cdf0e10cSrcweir 28cdf0e10cSrcweir import com.sun.star.sheet.CellFlags; 29cdf0e10cSrcweir import com.sun.star.sheet.GeneralFunction; 30cdf0e10cSrcweir import com.sun.star.sheet.XSheetOperation; 31cdf0e10cSrcweir 32cdf0e10cSrcweir /** 33cdf0e10cSrcweir * Testing <code>com.sun.star.sheet.XSheetOperation</code> 34cdf0e10cSrcweir * interface methods : 35cdf0e10cSrcweir * <ul> 36cdf0e10cSrcweir * <li><code> computeFunction()</code></li> 37cdf0e10cSrcweir * <li><code> clearContents()</code></li> 38cdf0e10cSrcweir * </ul> <p> 39cdf0e10cSrcweir * @see com.sun.star.sheet.XSheetOperation 40cdf0e10cSrcweir */ 41cdf0e10cSrcweir public class _XSheetOperation extends MultiMethodTest { 42cdf0e10cSrcweir 43cdf0e10cSrcweir public XSheetOperation oObj = null; 44cdf0e10cSrcweir 45cdf0e10cSrcweir /** 46cdf0e10cSrcweir * Test clears formula and value contents, calls the method 47cdf0e10cSrcweir * <code>computeFunction</code> and checks returned value. <p> 48cdf0e10cSrcweir * Has <b> OK </b> status if returned value is equal to zero 49cdf0e10cSrcweir * and no exceptions were thrown. <p> 50cdf0e10cSrcweir */ _clearContents()51cdf0e10cSrcweir public void _clearContents() { 52cdf0e10cSrcweir boolean result = true; 53cdf0e10cSrcweir double resultVal = -1; 54cdf0e10cSrcweir 55cdf0e10cSrcweir log.println("Testing clearContents() ..."); 56cdf0e10cSrcweir 57cdf0e10cSrcweir int allFlags; 58cdf0e10cSrcweir allFlags = CellFlags.VALUE | CellFlags.FORMULA; 59cdf0e10cSrcweir 60cdf0e10cSrcweir oObj.clearContents (allFlags) ; 61cdf0e10cSrcweir 62cdf0e10cSrcweir try { 63cdf0e10cSrcweir resultVal = oObj.computeFunction(GeneralFunction.SUM); 64cdf0e10cSrcweir result &= (resultVal == 0.0) || (resultVal == 0); 65cdf0e10cSrcweir } catch (com.sun.star.uno.Exception e) { 66cdf0e10cSrcweir result &= false ; 67cdf0e10cSrcweir log.println( 68*bb6af6bcSPedro Giffuni "Exception occurred while checking results of method"); 69cdf0e10cSrcweir e.printStackTrace(log); 70cdf0e10cSrcweir } 71cdf0e10cSrcweir 72cdf0e10cSrcweir tRes.tested("clearContents()", result); 73cdf0e10cSrcweir 74cdf0e10cSrcweir } // finished clearContents 75cdf0e10cSrcweir 76cdf0e10cSrcweir /** 77cdf0e10cSrcweir * Test calls the method and checks returned value. <p> 78cdf0e10cSrcweir * Has <b> OK </b> status if returned value is equal or greate than zero 79cdf0e10cSrcweir * and no exceptions were thrown. <p> 80cdf0e10cSrcweir */ _computeFunction()81cdf0e10cSrcweir public void _computeFunction() { 82cdf0e10cSrcweir 83cdf0e10cSrcweir log.println("Testing computeFunction() ..."); 84cdf0e10cSrcweir double resultVal = -1; 85cdf0e10cSrcweir boolean result = true; 86cdf0e10cSrcweir 87cdf0e10cSrcweir try { 88cdf0e10cSrcweir resultVal = oObj.computeFunction (GeneralFunction.COUNT) ; 89cdf0e10cSrcweir result = resultVal >= 0; 90cdf0e10cSrcweir } catch (com.sun.star.uno.Exception e) { 91cdf0e10cSrcweir result = false; 92*bb6af6bcSPedro Giffuni log.println("Exception occurred in method computeFunction."); 93cdf0e10cSrcweir e.printStackTrace(log); 94cdf0e10cSrcweir } 95cdf0e10cSrcweir 96cdf0e10cSrcweir tRes.tested("computeFunction()", result); 97cdf0e10cSrcweir } // finished computeFunction 98cdf0e10cSrcweir 99cdf0e10cSrcweir } // finished class _XSheetOperation 100cdf0e10cSrcweir 101