qadevOOo/tests/java/ifc/sheet/_XSubTotalCalculatable.java

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