1*b1cdbd2cSJim Jagielski /************************************************************** 2*b1cdbd2cSJim Jagielski * 3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski * distributed with this work for additional information 6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski * 11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski * 13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski * under the License. 19*b1cdbd2cSJim Jagielski * 20*b1cdbd2cSJim Jagielski *************************************************************/ 21*b1cdbd2cSJim Jagielski 22*b1cdbd2cSJim Jagielski 23*b1cdbd2cSJim Jagielski package ifc.sheet; 24*b1cdbd2cSJim Jagielski 25*b1cdbd2cSJim Jagielski import lib.MultiMethodTest; 26*b1cdbd2cSJim Jagielski import lib.Status; 27*b1cdbd2cSJim Jagielski import lib.StatusException; 28*b1cdbd2cSJim Jagielski 29*b1cdbd2cSJim Jagielski import com.sun.star.sheet.SubTotalColumn; 30*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheet; 31*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSubTotalCalculatable; 32*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSubTotalDescriptor; 33*b1cdbd2cSJim Jagielski import com.sun.star.uno.UnoRuntime; 34*b1cdbd2cSJim Jagielski 35*b1cdbd2cSJim Jagielski 36*b1cdbd2cSJim Jagielski public class _XSubTotalCalculatable extends MultiMethodTest { 37*b1cdbd2cSJim Jagielski public XSubTotalCalculatable oObj; 38*b1cdbd2cSJim Jagielski protected XSubTotalDescriptor desc; 39*b1cdbd2cSJim Jagielski protected XSpreadsheet oSheet; 40*b1cdbd2cSJim Jagielski before()41*b1cdbd2cSJim Jagielski protected void before() { 42*b1cdbd2cSJim Jagielski oSheet = (XSpreadsheet) tEnv.getObjRelation("SHEET"); 43*b1cdbd2cSJim Jagielski 44*b1cdbd2cSJim Jagielski if (oSheet == null) { 45*b1cdbd2cSJim Jagielski log.println("Object relation oSheet is missing"); 46*b1cdbd2cSJim Jagielski log.println("Trying to query the needed Interface"); 47*b1cdbd2cSJim Jagielski oSheet = (XSpreadsheet) UnoRuntime.queryInterface( 48*b1cdbd2cSJim Jagielski XSpreadsheet.class, tEnv.getTestObject()); 49*b1cdbd2cSJim Jagielski 50*b1cdbd2cSJim Jagielski if (oSheet == null) { 51*b1cdbd2cSJim Jagielski throw new StatusException(Status.failed( 52*b1cdbd2cSJim Jagielski "Object relation oSheet is missing")); 53*b1cdbd2cSJim Jagielski } 54*b1cdbd2cSJim Jagielski } 55*b1cdbd2cSJim Jagielski } 56*b1cdbd2cSJim Jagielski _applySubTotals()57*b1cdbd2cSJim Jagielski public void _applySubTotals() { 58*b1cdbd2cSJim Jagielski requiredMethod("createSubTotalDescriptor()"); 59*b1cdbd2cSJim Jagielski 60*b1cdbd2cSJim Jagielski boolean res = true; 61*b1cdbd2cSJim Jagielski 62*b1cdbd2cSJim Jagielski try { 63*b1cdbd2cSJim Jagielski oSheet.getCellByPosition(0, 0).setFormula("first"); 64*b1cdbd2cSJim Jagielski oSheet.getCellByPosition(1, 0).setFormula("second"); 65*b1cdbd2cSJim Jagielski oSheet.getCellByPosition(0, 3).setFormula(""); 66*b1cdbd2cSJim Jagielski oSheet.getCellByPosition(0, 1).setValue(5); 67*b1cdbd2cSJim Jagielski oSheet.getCellByPosition(0, 2).setValue(5); 68*b1cdbd2cSJim Jagielski oSheet.getCellByPosition(1, 1).setValue(17); 69*b1cdbd2cSJim Jagielski oSheet.getCellByPosition(1, 2).setValue(25); 70*b1cdbd2cSJim Jagielski oObj.applySubTotals(desc, true); 71*b1cdbd2cSJim Jagielski 72*b1cdbd2cSJim Jagielski String formula = oSheet.getCellByPosition(0, 3).getFormula(); 73*b1cdbd2cSJim Jagielski String expected = "=SUBTOTAL(9;$A$2:$A$3)"; 74*b1cdbd2cSJim Jagielski res = formula.equals(expected); 75*b1cdbd2cSJim Jagielski 76*b1cdbd2cSJim Jagielski if (!res) { 77*b1cdbd2cSJim Jagielski log.println("getting: " + formula); 78*b1cdbd2cSJim Jagielski log.println("expected: " + expected); 79*b1cdbd2cSJim Jagielski } 80*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 81*b1cdbd2cSJim Jagielski log.println("Couldn't fill cells" + e.getLocalizedMessage()); 82*b1cdbd2cSJim Jagielski res = false; 83*b1cdbd2cSJim Jagielski } 84*b1cdbd2cSJim Jagielski 85*b1cdbd2cSJim Jagielski tRes.tested("applySubTotals()", res); 86*b1cdbd2cSJim Jagielski } 87*b1cdbd2cSJim Jagielski _createSubTotalDescriptor()88*b1cdbd2cSJim Jagielski public void _createSubTotalDescriptor() { 89*b1cdbd2cSJim Jagielski desc = oObj.createSubTotalDescriptor(true); 90*b1cdbd2cSJim Jagielski 91*b1cdbd2cSJim Jagielski SubTotalColumn[] columns = new SubTotalColumn[1]; 92*b1cdbd2cSJim Jagielski columns[0] = new SubTotalColumn(); 93*b1cdbd2cSJim Jagielski columns[0].Column = 0; 94*b1cdbd2cSJim Jagielski columns[0].Function = com.sun.star.sheet.GeneralFunction.SUM; 95*b1cdbd2cSJim Jagielski desc.addNew(columns, 0); 96*b1cdbd2cSJim Jagielski tRes.tested("createSubTotalDescriptor()", true); 97*b1cdbd2cSJim Jagielski } 98*b1cdbd2cSJim Jagielski _removeSubTotals()99*b1cdbd2cSJim Jagielski public void _removeSubTotals() { 100*b1cdbd2cSJim Jagielski requiredMethod("applySubTotals()"); 101*b1cdbd2cSJim Jagielski 102*b1cdbd2cSJim Jagielski boolean res = true; 103*b1cdbd2cSJim Jagielski 104*b1cdbd2cSJim Jagielski try { 105*b1cdbd2cSJim Jagielski oObj.removeSubTotals(); 106*b1cdbd2cSJim Jagielski 107*b1cdbd2cSJim Jagielski String formula = oSheet.getCellByPosition(0, 3).getFormula(); 108*b1cdbd2cSJim Jagielski String expected = ""; 109*b1cdbd2cSJim Jagielski res = formula.equals(expected); 110*b1cdbd2cSJim Jagielski 111*b1cdbd2cSJim Jagielski if (!res) { 112*b1cdbd2cSJim Jagielski log.println("getting: " + formula); 113*b1cdbd2cSJim Jagielski log.println("expected: " + expected); 114*b1cdbd2cSJim Jagielski } 115*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 116*b1cdbd2cSJim Jagielski log.println("Couldn't get cell" + e.getLocalizedMessage()); 117*b1cdbd2cSJim Jagielski } 118*b1cdbd2cSJim Jagielski 119*b1cdbd2cSJim Jagielski tRes.tested("removeSubTotals()", res); 120*b1cdbd2cSJim Jagielski } 121*b1cdbd2cSJim Jagielski }