1*cdf0e10cSrcweir /************************************************************************* 2*cdf0e10cSrcweir * 3*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 4*cdf0e10cSrcweir * 5*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * This file is part of OpenOffice.org. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 12*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 13*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 16*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 17*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 18*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 19*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 20*cdf0e10cSrcweir * 21*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 22*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 23*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 24*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 25*cdf0e10cSrcweir * 26*cdf0e10cSrcweir ************************************************************************/ 27*cdf0e10cSrcweir package ifc.sheet; 28*cdf0e10cSrcweir 29*cdf0e10cSrcweir import com.sun.star.sheet.XPrintAreas; 30*cdf0e10cSrcweir import com.sun.star.table.CellRangeAddress; 31*cdf0e10cSrcweir import lib.MultiMethodTest; 32*cdf0e10cSrcweir import lib.Status; 33*cdf0e10cSrcweir import lib.StatusException; 34*cdf0e10cSrcweir import util.ValueComparer; 35*cdf0e10cSrcweir 36*cdf0e10cSrcweir /** 37*cdf0e10cSrcweir * 38*cdf0e10cSrcweir */ 39*cdf0e10cSrcweir public class _XPrintAreas extends MultiMethodTest { 40*cdf0e10cSrcweir public XPrintAreas oObj = null; 41*cdf0e10cSrcweir CellRangeAddress address = null; 42*cdf0e10cSrcweir CellRangeAddress subaddress = null; 43*cdf0e10cSrcweir CellRangeAddress titleColumns; 44*cdf0e10cSrcweir CellRangeAddress titleRows; 45*cdf0e10cSrcweir 46*cdf0e10cSrcweir public void before() { 47*cdf0e10cSrcweir address = (CellRangeAddress)tEnv.getObjRelation("CellRangeAddress"); 48*cdf0e10cSrcweir subaddress = (CellRangeAddress)tEnv.getObjRelation("CellRangeSubAddress"); 49*cdf0e10cSrcweir if (address == null) 50*cdf0e10cSrcweir throw new StatusException(Status.failed("Object relation CellRangeAddress not found")); 51*cdf0e10cSrcweir if (subaddress == null) 52*cdf0e10cSrcweir throw new StatusException(Status.failed("Object relation CellRangeSubAddress not found")); 53*cdf0e10cSrcweir } 54*cdf0e10cSrcweir 55*cdf0e10cSrcweir public void _getPrintAreas() { 56*cdf0e10cSrcweir requiredMethod("getPrintTitleColumns()"); 57*cdf0e10cSrcweir requiredMethod("getPrintTitleRows()"); 58*cdf0e10cSrcweir executeMethod("getTitleColumns()"); 59*cdf0e10cSrcweir executeMethod("getTitleRows()"); 60*cdf0e10cSrcweir CellRangeAddress[] printAreas = oObj.getPrintAreas(); 61*cdf0e10cSrcweir CellRangeAddress[] setValue = new CellRangeAddress[]{address}; 62*cdf0e10cSrcweir boolean ret = ValueComparer.equalValue(printAreas, setValue); 63*cdf0e10cSrcweir // delete the print area 64*cdf0e10cSrcweir oObj.setPrintAreas(null); 65*cdf0e10cSrcweir printAreas = oObj.getPrintAreas(); 66*cdf0e10cSrcweir ret &= printAreas.length == 0; 67*cdf0e10cSrcweir 68*cdf0e10cSrcweir tRes.tested("getPrintAreas()", ret); 69*cdf0e10cSrcweir } 70*cdf0e10cSrcweir 71*cdf0e10cSrcweir public void _getPrintTitleColumns() { 72*cdf0e10cSrcweir requiredMethod("setPrintTitleColumns()"); 73*cdf0e10cSrcweir tRes.tested("getPrintTitleColumns()", !oObj.getPrintTitleColumns()); 74*cdf0e10cSrcweir } 75*cdf0e10cSrcweir 76*cdf0e10cSrcweir public void _getPrintTitleRows() { 77*cdf0e10cSrcweir requiredMethod("setPrintTitleRows()"); 78*cdf0e10cSrcweir tRes.tested("getPrintTitleRows()", !oObj.getPrintTitleRows()); 79*cdf0e10cSrcweir } 80*cdf0e10cSrcweir 81*cdf0e10cSrcweir public void _getTitleColumns() { 82*cdf0e10cSrcweir requiredMethod("setTitleColumns()"); 83*cdf0e10cSrcweir CellRangeAddress setValue = oObj.getTitleColumns(); 84*cdf0e10cSrcweir tRes.tested("getTitleColumns()", ValueComparer.equalValue(setValue,titleColumns)); 85*cdf0e10cSrcweir } 86*cdf0e10cSrcweir 87*cdf0e10cSrcweir public void _getTitleRows() { 88*cdf0e10cSrcweir requiredMethod("setTitleRows()"); 89*cdf0e10cSrcweir CellRangeAddress setValue = oObj.getTitleRows(); 90*cdf0e10cSrcweir tRes.tested("getTitleRows()", ValueComparer.equalValue(setValue,titleRows)); 91*cdf0e10cSrcweir } 92*cdf0e10cSrcweir 93*cdf0e10cSrcweir public void _setPrintAreas() { 94*cdf0e10cSrcweir boolean ret = false; 95*cdf0e10cSrcweir CellRangeAddress[]setValue = new CellRangeAddress[]{subaddress}; 96*cdf0e10cSrcweir oObj.setPrintAreas(setValue); 97*cdf0e10cSrcweir CellRangeAddress[]newVal = oObj.getPrintAreas(); 98*cdf0e10cSrcweir ret = ValueComparer.equalValue(newVal, setValue); 99*cdf0e10cSrcweir setValue = new CellRangeAddress[]{address}; 100*cdf0e10cSrcweir oObj.setPrintAreas(setValue); 101*cdf0e10cSrcweir newVal = oObj.getPrintAreas(); 102*cdf0e10cSrcweir ret &= ValueComparer.equalValue(newVal, setValue); 103*cdf0e10cSrcweir tRes.tested("setPrintAreas()", ret); 104*cdf0e10cSrcweir } 105*cdf0e10cSrcweir 106*cdf0e10cSrcweir public void _setPrintTitleColumns() { 107*cdf0e10cSrcweir requiredMethod("setTitleColumns()"); 108*cdf0e10cSrcweir boolean ret = false; 109*cdf0e10cSrcweir boolean value = oObj.getPrintTitleColumns(); 110*cdf0e10cSrcweir oObj.setPrintTitleColumns(!value); 111*cdf0e10cSrcweir ret = value != oObj.getPrintTitleColumns(); 112*cdf0e10cSrcweir oObj.setPrintTitleColumns(false); 113*cdf0e10cSrcweir tRes.tested("setPrintTitleColumns()", ret); 114*cdf0e10cSrcweir } 115*cdf0e10cSrcweir 116*cdf0e10cSrcweir public void _setPrintTitleRows() { 117*cdf0e10cSrcweir requiredMethod("setTitleRows()"); 118*cdf0e10cSrcweir boolean ret = false; 119*cdf0e10cSrcweir boolean value = oObj.getPrintTitleRows(); 120*cdf0e10cSrcweir oObj.setPrintTitleRows(!value); 121*cdf0e10cSrcweir ret = value != oObj.getPrintTitleRows(); 122*cdf0e10cSrcweir oObj.setPrintTitleRows(false); 123*cdf0e10cSrcweir tRes.tested("setPrintTitleRows()", ret); 124*cdf0e10cSrcweir } 125*cdf0e10cSrcweir 126*cdf0e10cSrcweir public void _setTitleColumns() { 127*cdf0e10cSrcweir requiredMethod("setPrintAreas()"); 128*cdf0e10cSrcweir boolean ret = false; 129*cdf0e10cSrcweir CellRangeAddress newVal = oObj.getTitleColumns(); 130*cdf0e10cSrcweir ret = ValueComparer.equalValue(newVal, new CellRangeAddress((short)0, 0, 0, 0, 0)); 131*cdf0e10cSrcweir // use first row of range as title column 132*cdf0e10cSrcweir titleColumns = new CellRangeAddress(); 133*cdf0e10cSrcweir titleColumns.Sheet = address.Sheet; 134*cdf0e10cSrcweir titleColumns.StartColumn = address.StartColumn; 135*cdf0e10cSrcweir titleColumns.StartRow = address.StartRow; 136*cdf0e10cSrcweir titleColumns.EndColumn = address.EndColumn; 137*cdf0e10cSrcweir titleColumns.EndRow = address.StartRow; 138*cdf0e10cSrcweir oObj.setTitleColumns(titleColumns); 139*cdf0e10cSrcweir tRes.tested("setTitleColumns()", ret); 140*cdf0e10cSrcweir } 141*cdf0e10cSrcweir 142*cdf0e10cSrcweir public void _setTitleRows() { 143*cdf0e10cSrcweir requiredMethod("setPrintAreas()"); 144*cdf0e10cSrcweir boolean ret = false; 145*cdf0e10cSrcweir CellRangeAddress newVal = oObj.getTitleRows(); 146*cdf0e10cSrcweir ret = ValueComparer.equalValue(newVal, new CellRangeAddress((short)0, 0, 0, 0, 0)); 147*cdf0e10cSrcweir // use first column of range as title row 148*cdf0e10cSrcweir titleRows = new CellRangeAddress(); 149*cdf0e10cSrcweir titleRows.Sheet = address.Sheet; 150*cdf0e10cSrcweir titleRows.StartColumn = address.StartColumn; 151*cdf0e10cSrcweir titleRows.StartRow = address.StartRow; 152*cdf0e10cSrcweir titleRows.EndColumn = address.StartColumn; 153*cdf0e10cSrcweir titleRows.EndRow = address.EndRow; 154*cdf0e10cSrcweir oObj.setTitleColumns(titleRows); 155*cdf0e10cSrcweir tRes.tested("setTitleRows()", ret); 156*cdf0e10cSrcweir } 157*cdf0e10cSrcweir 158*cdf0e10cSrcweir } 159