| /************************************************************** |
| * |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| * |
| *************************************************************/ |
| |
| |
| |
| package complex.dataPilot; |
| |
| import com.sun.star.sheet.XDataPilotTable; |
| import com.sun.star.table.CellAddress; |
| import com.sun.star.table.CellRangeAddress; |
| import com.sun.star.table.XCell; |
| // import lib.Status; |
| //import lib.StatusException; |
| import lib.TestParameters; |
| // import share.LogWriter; |
| |
| /** |
| * Testing <code>com.sun.star.sheet.XDataPilotTable</code> |
| * interface methods : |
| * <ul> |
| * <li><code> getOutputRange()</code></li> |
| * <li><code> refresh()</code></li> |
| * </ul> <p> |
| * This test needs the following object relations : |
| * <ul> |
| * <li> <code>'OUTPUTRANGE'</code> (of type <code>CellAddress</code>): |
| * to check value returned by method <code>getOutputRange()</code> </li> |
| * <li> <code>'CELLFORCHANGE'</code> (of type <code>XCell</code>): |
| * to check the method refresh(value of this cell will be changed)</li> |
| * <li> <code>'CELLFORCHECK'</code> (of type <code>XCell</code>): |
| * to check the method refresh (value of this cell must be changed after refresh |
| * call) </li><ul> <p> |
| * @see com.sun.star.sheet.XDataPilotTable |
| * @see com.sun.star.table.CellAddress |
| */ |
| public class _XDataPilotTable { |
| |
| public XDataPilotTable oObj = null; |
| XCell xCellForChange = null; |
| XCell xCellForCheck = null; |
| CellAddress OutputRange = null; |
| int changeValue = 0; |
| |
| /** |
| * The test parameters |
| */ |
| private TestParameters param = null; |
| |
| /** |
| * The log writer |
| */ |
| // private LogWriter log = null; |
| |
| /** |
| * Constructor: gets the object to test, a logger and the test parameters |
| * @param xObj The test object |
| |
| * @param param The test parameters |
| */ |
| public _XDataPilotTable(XDataPilotTable xObj/*, |
| LogWriter log*/, TestParameters param) { |
| oObj = xObj; |
| // this.log = log; |
| this.param = param; |
| } |
| |
| public boolean before() { |
| xCellForChange = (XCell)param.get("CELLFORCHANGE"); |
| xCellForCheck = (XCell)param.get("CELLFORCHECK"); |
| OutputRange = (CellAddress)param.get("OUTPUTRANGE"); |
| changeValue = ((Integer)param.get("CHANGEVALUE")).intValue(); |
| |
| if (xCellForChange == null || OutputRange == null || |
| xCellForCheck == null) { |
| System.out.println("Relation not found"); |
| return false; |
| } |
| return true; |
| } |
| /** |
| * Test calls the method and checks returned value using value obtained by |
| * object relation <code>'OUTPUTRANGE'</code>. <p> |
| * Has <b> OK </b> status if values are equal. <p> |
| * @return |
| */ |
| public boolean _getOutputRange(){ |
| boolean bResult = true; |
| CellRangeAddress objRange = oObj.getOutputRange(); |
| bResult &= OutputRange.Sheet == objRange.Sheet; |
| bResult &= OutputRange.Row == objRange.StartRow; |
| bResult &= OutputRange.Column == objRange.StartColumn; |
| return bResult; |
| } |
| |
| /** |
| * Test sets new value of the cell obtained by object relation |
| * 'CELLFORCHANGE', and checks value of the cell obtained by object |
| * relation 'CELLFORCHECK'.<p> |
| * Has <b>OK</b> status if value of the cell obtained by object relation |
| * 'CELLFORCHECK' is changed. <p> |
| * @return |
| */ |
| public boolean _refresh(){ |
| xCellForChange.setValue(changeValue); |
| double oldData = xCellForCheck.getValue(); |
| oObj.refresh(); |
| double newData = xCellForCheck.getValue(); |
| System.out.println("Old data:" + oldData + "; new data:" + newData); |
| |
| return oldData != newData; |
| } |
| } |
| |