/**************************************************************
*
* 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 ifc.table;
import lib.MultiMethodTest;
import com.sun.star.table.CellContentType;
import com.sun.star.table.XCell;
/**
* Testing com.sun.star.table.XCell
* interface methods :
*
getFormula()
setFormula()
getValue()
setValue()
getType()
getError()
* Test is NOT multithread compilant.
* @see com.sun.star.table.XCell */ public class _XCell extends MultiMethodTest { public XCell oObj = null; /** * First time errors checked when a proper formula is entered. * Second time an incorrect formula entered and errors are checked.
* Has OK status if in the first case error code 0 returned, * and in the second case none-zerro code returned.
* The following method tests are to be completed successfully before : *
setFormula()
: the method must set proper
* formula into cell, so there must be no errors * Has OK status if the formula set are the same as get.
*/ public void _getFormula() { boolean result = true; String formula = ""; log.println("getFormula()"); oObj.setFormula("=2+2"); formula = (String) oObj.getFormula(); result &= formula.endsWith("2+2"); tRes.tested("getFormula()", result); } // end getFormula() /** * Gets the type and check it.
* Has OK status if the type is one of valid values.
*/ public void _getType() { boolean result = true; result = true ; log.println("getType() ..."); if(oObj.getType() == CellContentType.EMPTY) result &= true ; else if (oObj.getType() == CellContentType.VALUE) result &= true ; else if (oObj.getType() == CellContentType.TEXT) result &= true ; else if (oObj.getType() == CellContentType.FORMULA) result &= true ; else result = false; tRes.tested ("getType()", result) ; } // end getType() /** * Test calls the method.
* Has OK status if the method successfully returns * and no exceptions were thrown.
*/ public void _getValue() { boolean result = true; double value = 0; log.println("getValue() ..."); value = (double) oObj.getValue(); tRes.tested("getValue()",result); } // end getValue() /** * Sets a formula and then gets it.
* Has OK status if the formula set are the same as get.
*/ public void _setFormula() { boolean result = true; String formula = ""; log.println("setFormula() ..."); oObj.setFormula("=2/6") ; formula = (String) oObj.getFormula(); result &= formula.endsWith("2/6"); tRes.tested ("setFormula()", result) ; } // end setFormula /** * Sets a value and then gets it.
* Has OK status if the value set is equal to value get.
*/ public void _setValue() { boolean result = true; double cellValue = 0; log.println("setValue() ..."); oObj.setValue(222.333) ; cellValue = (double) oObj.getValue() ; result &= (cellValue == 222.333); tRes.tested("setValue()", result); } // end setValue() }