1*ef39d40dSAndrew Rist /************************************************************** 2cdf0e10cSrcweir * 3*ef39d40dSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4*ef39d40dSAndrew Rist * or more contributor license agreements. See the NOTICE file 5*ef39d40dSAndrew Rist * distributed with this work for additional information 6*ef39d40dSAndrew Rist * regarding copyright ownership. The ASF licenses this file 7*ef39d40dSAndrew Rist * to you under the Apache License, Version 2.0 (the 8*ef39d40dSAndrew Rist * "License"); you may not use this file except in compliance 9*ef39d40dSAndrew Rist * with the License. You may obtain a copy of the License at 10cdf0e10cSrcweir * 11*ef39d40dSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12cdf0e10cSrcweir * 13*ef39d40dSAndrew Rist * Unless required by applicable law or agreed to in writing, 14*ef39d40dSAndrew Rist * software distributed under the License is distributed on an 15*ef39d40dSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*ef39d40dSAndrew Rist * KIND, either express or implied. See the License for the 17*ef39d40dSAndrew Rist * specific language governing permissions and limitations 18*ef39d40dSAndrew Rist * under the License. 19cdf0e10cSrcweir * 20*ef39d40dSAndrew Rist *************************************************************/ 21*ef39d40dSAndrew Rist 22*ef39d40dSAndrew Rist 23cdf0e10cSrcweir 24cdf0e10cSrcweir package ifc.sheet; 25cdf0e10cSrcweir 26cdf0e10cSrcweir import com.sun.star.sheet.XCellRangeFormula; 27cdf0e10cSrcweir 28cdf0e10cSrcweir public class _XCellRangeFormula extends lib.MultiMethodTest { 29cdf0e10cSrcweir 30cdf0e10cSrcweir public XCellRangeFormula oObj = null; 31cdf0e10cSrcweir 32cdf0e10cSrcweir public String[][] orgValue = null; 33cdf0e10cSrcweir _getFormulaArray()34cdf0e10cSrcweir public void _getFormulaArray() { 35cdf0e10cSrcweir Object noArray = tEnv.getObjRelation("noArray"); 36cdf0e10cSrcweir if (noArray != null) { 37cdf0e10cSrcweir log.println("Component " + noArray.toString() + 38cdf0e10cSrcweir " doesn't really support this Interface"); 39cdf0e10cSrcweir log.println("It doesn't make sense to get an FormulaArray from" 40cdf0e10cSrcweir + " the whole sheet"); 41cdf0e10cSrcweir tRes.tested("getFormulaArray()", true); 42cdf0e10cSrcweir return; 43cdf0e10cSrcweir } 44cdf0e10cSrcweir orgValue = oObj.getFormulaArray(); 45cdf0e10cSrcweir String[][] newValue = oObj.getFormulaArray(); 46cdf0e10cSrcweir newValue[0][0] = "inserted"; 47cdf0e10cSrcweir oObj.setFormulaArray(newValue); 48cdf0e10cSrcweir boolean res = oObj.getFormulaArray()[0][0].equals(newValue[0][0]); 49cdf0e10cSrcweir tRes.tested("getFormulaArray()",res); 50cdf0e10cSrcweir } 51cdf0e10cSrcweir _setFormulaArray()52cdf0e10cSrcweir public void _setFormulaArray() { 53cdf0e10cSrcweir requiredMethod("getFormulaArray()"); 54cdf0e10cSrcweir Object noArray = tEnv.getObjRelation("noArray"); 55cdf0e10cSrcweir if (noArray != null) { 56cdf0e10cSrcweir log.println("Component " + noArray.toString() + 57cdf0e10cSrcweir " doesn't really support this Interface"); 58cdf0e10cSrcweir log.println("It doesn't make sense to set an FormulaArray over" 59cdf0e10cSrcweir + " the whole sheet"); 60cdf0e10cSrcweir tRes.tested("setFormulaArray()", true); 61cdf0e10cSrcweir return; 62cdf0e10cSrcweir } 63cdf0e10cSrcweir oObj.setFormulaArray(orgValue); 64cdf0e10cSrcweir boolean res = oObj.getFormulaArray()[0][0].equals(orgValue[0][0]); 65cdf0e10cSrcweir tRes.tested("setFormulaArray()",res); 66cdf0e10cSrcweir } 67cdf0e10cSrcweir } 68