| /************************************************************** |
| * |
| * 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.sheet; |
| |
| import lib.MultiMethodTest; |
| |
| import com.sun.star.beans.PropertyValue; |
| import com.sun.star.sheet.ConditionOperator; |
| import com.sun.star.sheet.XSheetConditionalEntries; |
| import com.sun.star.table.CellAddress; |
| |
| /** |
| * Testing <code>com.sun.star.sheet.XSheetConditionalEntries</code> |
| * interface methods : |
| * <ul> |
| * <li><code> addNew()</code></li> |
| * <li><code> removeByIndex()</code></li> |
| * <li><code> clear()</code></li> |
| * </ul> <p> |
| * @see com.sun.star.sheet.XSheetConditionalEntries |
| */ |
| public class _XSheetConditionalEntries extends MultiMethodTest { |
| public XSheetConditionalEntries oObj = null; |
| int nNum = 0; |
| |
| /** |
| * Test adds a conditional entry to the format. <p> |
| * Has <b> OK </b> status if the method successfully returns. <p> |
| */ |
| public void _addNew() { |
| nNum = oObj.getCount(); |
| oObj.addNew( Conditions(4) ); |
| boolean res = (nNum + 1) == oObj.getCount(); |
| |
| tRes.tested("addNew()", res); |
| } |
| |
| /** |
| * Test calls the method and checks number of conditional entries in |
| * collection. <p> |
| * Has <b> OK </b> status if number of conditional entries in co0llection |
| * after method call is equal zero. <p> |
| * The following method tests are to be completed successfully before : |
| * <ul> |
| * <li> <code> addNew() </code> : to have one conditional entry in |
| * collection at least </li> |
| * </ul> |
| */ |
| public void _clear() { |
| requiredMethod("removeByIndex()"); |
| oObj.clear(); |
| int anz = oObj.getCount(); |
| tRes.tested("clear()", anz == 0); |
| } |
| |
| /** |
| * Test adds a conditional entry, removes entry with index 0 |
| * and compares number of entries after adding to number of entries after |
| * removing. <p> |
| * Has <b> OK </b> status if number of entries after adding is greater |
| * than number of entries after removing. <p> |
| * The following method tests are to be completed successfully before : |
| * <ul> |
| * <li> <code> clear() </code> : to be sure that collection hasn't |
| * elements </li> |
| * </ul> |
| */ |
| public void _removeByIndex() { |
| requiredMethod("addNew()"); |
| oObj.removeByIndex(0); |
| int pastNum = oObj.getCount(); |
| tRes.tested("removeByIndex()", pastNum == nNum); |
| } |
| |
| /** |
| * Method creates array of property value for conditional entry using |
| * passed parameter <code>nr</code>. |
| * @param nr number of row for conditional entry |
| */ |
| protected PropertyValue[] Conditions(int nr) { |
| PropertyValue[] con = new PropertyValue[5]; |
| CellAddress ca = new CellAddress(); |
| ca.Column = 1; |
| ca.Row = 5; |
| ca.Sheet = 0; |
| con[0] = new PropertyValue(); |
| con[0].Name = "StyleName"; |
| con[0].Value = "Result2"; |
| con[1] = new PropertyValue(); |
| con[1].Name = "Formula1"; |
| con[1].Value = "$Sheet1.$B$"+nr; |
| con[2] = new PropertyValue(); |
| con[2].Name = "Formula2"; |
| con[2].Value = ""; |
| con[3] = new PropertyValue(); |
| con[3].Name = "Operator"; |
| con[3].Value = ConditionOperator.EQUAL; |
| con[4] = new PropertyValue(); |
| con[4].Name = "SourcePosition"; |
| con[4].Value = ca; |
| return con; |
| } |
| |
| /** |
| * Forces object environment recreation. |
| */ |
| protected void after() { |
| this.disposeEnvironment(); |
| } |
| } // finish class _XSheetConditionalEntries |
| |
| |