1ef39d40dSAndrew Rist /************************************************************** 2cdf0e10cSrcweir * 3ef39d40dSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4ef39d40dSAndrew Rist * or more contributor license agreements. See the NOTICE file 5ef39d40dSAndrew Rist * distributed with this work for additional information 6ef39d40dSAndrew Rist * regarding copyright ownership. The ASF licenses this file 7ef39d40dSAndrew Rist * to you under the Apache License, Version 2.0 (the 8ef39d40dSAndrew Rist * "License"); you may not use this file except in compliance 9ef39d40dSAndrew Rist * with the License. You may obtain a copy of the License at 10ef39d40dSAndrew Rist * 11ef39d40dSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12ef39d40dSAndrew Rist * 13ef39d40dSAndrew Rist * Unless required by applicable law or agreed to in writing, 14ef39d40dSAndrew Rist * software distributed under the License is distributed on an 15ef39d40dSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16ef39d40dSAndrew Rist * KIND, either express or implied. See the License for the 17ef39d40dSAndrew Rist * specific language governing permissions and limitations 18ef39d40dSAndrew Rist * under the License. 19ef39d40dSAndrew Rist * 20ef39d40dSAndrew Rist *************************************************************/ 21ef39d40dSAndrew Rist 22ef39d40dSAndrew Rist 23cdf0e10cSrcweir 24cdf0e10cSrcweir package mod._sc; 25cdf0e10cSrcweir 26cdf0e10cSrcweir import java.io.PrintWriter; 27cdf0e10cSrcweir 28cdf0e10cSrcweir import lib.StatusException; 29cdf0e10cSrcweir import lib.TestCase; 30cdf0e10cSrcweir import lib.TestEnvironment; 31cdf0e10cSrcweir import lib.TestParameters; 32cdf0e10cSrcweir import util.SOfficeFactory; 33cdf0e10cSrcweir import util.utils; 34cdf0e10cSrcweir 35cdf0e10cSrcweir import com.sun.star.beans.PropertyValue; 36cdf0e10cSrcweir import com.sun.star.beans.XPropertySet; 37cdf0e10cSrcweir import com.sun.star.container.XIndexAccess; 38cdf0e10cSrcweir import com.sun.star.lang.XComponent; 39cdf0e10cSrcweir import com.sun.star.lang.XMultiServiceFactory; 40cdf0e10cSrcweir import com.sun.star.sheet.ConditionOperator; 41cdf0e10cSrcweir import com.sun.star.sheet.XSheetConditionalEntries; 42cdf0e10cSrcweir import com.sun.star.sheet.XSheetConditionalEntry; 43cdf0e10cSrcweir import com.sun.star.sheet.XSpreadsheet; 44cdf0e10cSrcweir import com.sun.star.sheet.XSpreadsheetDocument; 45cdf0e10cSrcweir import com.sun.star.sheet.XSpreadsheets; 46cdf0e10cSrcweir import com.sun.star.table.CellAddress; 47cdf0e10cSrcweir import com.sun.star.uno.AnyConverter; 48cdf0e10cSrcweir import com.sun.star.uno.Type; 49cdf0e10cSrcweir import com.sun.star.uno.UnoRuntime; 50cdf0e10cSrcweir import com.sun.star.uno.XInterface; 51cdf0e10cSrcweir 52cdf0e10cSrcweir /** 53cdf0e10cSrcweir * Test for object which is represented by service 54cdf0e10cSrcweir * <code>com.sun.star.sheet.TableConditionalEntry</code>. <p> 55cdf0e10cSrcweir * Object implements the following interfaces : 56cdf0e10cSrcweir * <ul> 57cdf0e10cSrcweir * <li> <code>com::sun::star::sheet::XSheetConditionalEntry</code></li> 58cdf0e10cSrcweir * <li> <code>com::sun::star::sheet::XSheetCondition</code></li> 59cdf0e10cSrcweir * </ul> 60cdf0e10cSrcweir * @see com.sun.star.sheet.TableConditionalEntry 61cdf0e10cSrcweir * @see com.sun.star.sheet.XSheetConditionalEntry 62cdf0e10cSrcweir * @see com.sun.star.sheet.XSheetCondition 63cdf0e10cSrcweir * @see ifc.sheet._XSheetConditionalEntry 64cdf0e10cSrcweir * @see ifc.sheet._XSheetCondition 65cdf0e10cSrcweir */ 66cdf0e10cSrcweir public class ScTableConditionalEntry extends TestCase { 67cdf0e10cSrcweir static XSpreadsheetDocument xSpreadsheetDoc = null; 68cdf0e10cSrcweir 69cdf0e10cSrcweir /** 70cdf0e10cSrcweir * Creates Spreadsheet document. 71cdf0e10cSrcweir */ initialize( TestParameters tParam, PrintWriter log )72cdf0e10cSrcweir protected void initialize( TestParameters tParam, PrintWriter log ) { 73cdf0e10cSrcweir // get a soffice factory object 74cdf0e10cSrcweir SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory)tParam.getMSF()); 75cdf0e10cSrcweir 76cdf0e10cSrcweir try { 77cdf0e10cSrcweir log.println( "creating a sheetdocument" ); 78*170fb961SPedro Giffuni xSpreadsheetDoc = SOF.createCalcDoc(null); 79cdf0e10cSrcweir } catch (com.sun.star.uno.Exception e) { 80cdf0e10cSrcweir // Some exception occures.FAILED 81cdf0e10cSrcweir e.printStackTrace( log ); 82cdf0e10cSrcweir throw new StatusException( "Couldn't create document", e ); 83cdf0e10cSrcweir } 84cdf0e10cSrcweir } 85cdf0e10cSrcweir 86cdf0e10cSrcweir /** 87cdf0e10cSrcweir * Disposes Spreadsheet document. 88cdf0e10cSrcweir */ cleanup( TestParameters tParam, PrintWriter log )89cdf0e10cSrcweir protected void cleanup( TestParameters tParam, PrintWriter log ) { 90cdf0e10cSrcweir log.println( " disposing xSheetDoc " ); 91cdf0e10cSrcweir XComponent oComp = (XComponent) 92cdf0e10cSrcweir UnoRuntime.queryInterface (XComponent.class, xSpreadsheetDoc) ; 93cdf0e10cSrcweir util.DesktopTools.closeDoc(oComp); 94cdf0e10cSrcweir } 95cdf0e10cSrcweir 96cdf0e10cSrcweir /** 97cdf0e10cSrcweir * Creating a Testenvironment for the interfaces to be tested. 98cdf0e10cSrcweir * Retrieves a collection of spreadsheets from the document and takes one of 99cdf0e10cSrcweir * them. Fills some cells of the spreadsheet. Retrieves value of the property 100cdf0e10cSrcweir * <code>'ConditionalFormat'</code> that is the collection of the conditions 101cdf0e10cSrcweir * of a conditional format. Adds new conditional entry to the collection 102cdf0e10cSrcweir * using the interface <code>XSheetConditionalEntries</code>. Sets new value 103cdf0e10cSrcweir * of the property <code>'ConditionalFormat'</code>. Obtains the conditional 104cdf0e10cSrcweir * entry with index 0 that is the instance of the service 105cdf0e10cSrcweir * <code>com.sun.star.sheet.TableConditionalEntry</code>. 106cdf0e10cSrcweir * @see com.sun.star.sheet.XSheetConditionalEntries 107cdf0e10cSrcweir * @see com.sun.star.sheet.TableConditionalEntry 108cdf0e10cSrcweir */ createTestEnvironment(TestParameters Param, PrintWriter log)109cdf0e10cSrcweir protected synchronized TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) { 110cdf0e10cSrcweir 111cdf0e10cSrcweir XInterface oObj = null; 112cdf0e10cSrcweir log.println("getting sheets"); 113cdf0e10cSrcweir XSpreadsheets xSpreadsheets = (XSpreadsheets)xSpreadsheetDoc.getSheets(); 114cdf0e10cSrcweir 115cdf0e10cSrcweir log.println("getting a sheet"); 116cdf0e10cSrcweir XSpreadsheet oSheet = null; 117cdf0e10cSrcweir XIndexAccess oIndexAccess = (XIndexAccess) 118cdf0e10cSrcweir UnoRuntime.queryInterface(XIndexAccess.class, xSpreadsheets); 119cdf0e10cSrcweir 120cdf0e10cSrcweir try { 121cdf0e10cSrcweir oSheet = (XSpreadsheet) AnyConverter.toObject( 122cdf0e10cSrcweir new Type(XSpreadsheet.class),oIndexAccess.getByIndex(0)); 123cdf0e10cSrcweir } catch (com.sun.star.lang.WrappedTargetException e) { 124cdf0e10cSrcweir e.printStackTrace(log); 125cdf0e10cSrcweir throw new StatusException( "Couldn't get a spreadsheet", e); 126cdf0e10cSrcweir } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 127cdf0e10cSrcweir e.printStackTrace(log); 128cdf0e10cSrcweir throw new StatusException( "Couldn't get a spreadsheet", e); 129cdf0e10cSrcweir } catch (com.sun.star.lang.IllegalArgumentException e) { 130cdf0e10cSrcweir e.printStackTrace(log); 131cdf0e10cSrcweir throw new StatusException( "Couldn't get a spreadsheet", e); 132cdf0e10cSrcweir } 133cdf0e10cSrcweir 134cdf0e10cSrcweir log.println("filling some cells"); 135cdf0e10cSrcweir try { 136cdf0e10cSrcweir oSheet.getCellByPosition(5, 5).setValue(15); 137cdf0e10cSrcweir oSheet.getCellByPosition(1, 4).setValue(10); 138cdf0e10cSrcweir oSheet.getCellByPosition(2, 0).setValue(-5.15); 139cdf0e10cSrcweir } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 140cdf0e10cSrcweir log.println("Exception occurred while filling cells"); 141cdf0e10cSrcweir e.printStackTrace(log); 142cdf0e10cSrcweir } 143cdf0e10cSrcweir 144cdf0e10cSrcweir Object CFormat = null; 145cdf0e10cSrcweir XPropertySet Props = null; 146cdf0e10cSrcweir 147cdf0e10cSrcweir try { 148cdf0e10cSrcweir Props = (XPropertySet) 149cdf0e10cSrcweir UnoRuntime.queryInterface(XPropertySet.class, oSheet); 150cdf0e10cSrcweir CFormat = Props.getPropertyValue("ConditionalFormat"); 151cdf0e10cSrcweir if (utils.isVoid(CFormat)) { 152cdf0e10cSrcweir log.println("Property 'ConditionalFormat' is void"); 153cdf0e10cSrcweir } 154cdf0e10cSrcweir } catch (com.sun.star.lang.WrappedTargetException e){ 155cdf0e10cSrcweir e.printStackTrace(log); 156cdf0e10cSrcweir throw new StatusException("Couldn't create instance", e); 157cdf0e10cSrcweir } catch (com.sun.star.beans.UnknownPropertyException e){ 158cdf0e10cSrcweir e.printStackTrace(log); 159cdf0e10cSrcweir throw new StatusException("Couldn't create instance", e); 160cdf0e10cSrcweir } 161cdf0e10cSrcweir 162cdf0e10cSrcweir try { 163cdf0e10cSrcweir XSheetConditionalEntries xSCE = (XSheetConditionalEntries) 164cdf0e10cSrcweir UnoRuntime.queryInterface(XSheetConditionalEntries.class, CFormat); 165cdf0e10cSrcweir xSCE.addNew(Conditions()); 166cdf0e10cSrcweir Props.setPropertyValue("ConditionalFormat", xSCE); 167cdf0e10cSrcweir oObj = (XSheetConditionalEntry) AnyConverter.toObject( 168cdf0e10cSrcweir new Type(XSheetConditionalEntry.class),xSCE.getByIndex(0)); 169cdf0e10cSrcweir } catch (com.sun.star.lang.WrappedTargetException e) { 170cdf0e10cSrcweir e.printStackTrace(log); 171cdf0e10cSrcweir throw new StatusException( 172cdf0e10cSrcweir "Exception occurred while getting Entry", e); 173cdf0e10cSrcweir } catch (com.sun.star.lang.IllegalArgumentException e) { 174cdf0e10cSrcweir e.printStackTrace(log); 175cdf0e10cSrcweir throw new StatusException( 176cdf0e10cSrcweir "Exception occurred while getting Entry", e); 177cdf0e10cSrcweir } catch (com.sun.star.beans.PropertyVetoException e) { 178cdf0e10cSrcweir e.printStackTrace(log); 179cdf0e10cSrcweir throw new StatusException( 180cdf0e10cSrcweir "Exception occurred while getting Entry", e); 181cdf0e10cSrcweir } catch (com.sun.star.beans.UnknownPropertyException e) { 182cdf0e10cSrcweir e.printStackTrace(log); 183cdf0e10cSrcweir throw new StatusException( 184cdf0e10cSrcweir "Exception occurred while getting Entry", e); 185cdf0e10cSrcweir } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 186cdf0e10cSrcweir e.printStackTrace(log); 187cdf0e10cSrcweir throw new StatusException( 188cdf0e10cSrcweir "Exception occurred while getting Entry", e); 189cdf0e10cSrcweir } 190cdf0e10cSrcweir 191cdf0e10cSrcweir log.println("creating a new environment for object"); 192cdf0e10cSrcweir TestEnvironment tEnv = new TestEnvironment(oObj); 193cdf0e10cSrcweir 194cdf0e10cSrcweir return tEnv; 195cdf0e10cSrcweir } // finish method getTestEnvironment 196cdf0e10cSrcweir 197cdf0e10cSrcweir /** 198cdf0e10cSrcweir * Returns the array of the property values that was filled by condition 199cdf0e10cSrcweir * values. 200cdf0e10cSrcweir */ Conditions()201cdf0e10cSrcweir protected PropertyValue[] Conditions() { 202cdf0e10cSrcweir PropertyValue[] con = new PropertyValue[5]; 203cdf0e10cSrcweir CellAddress ca = new CellAddress(); 204cdf0e10cSrcweir ca.Column = 1; 205cdf0e10cSrcweir ca.Row = 5; 206cdf0e10cSrcweir ca.Sheet = 0; 207cdf0e10cSrcweir con[0] = new PropertyValue(); 208cdf0e10cSrcweir con[0].Name = "StyleName"; 209cdf0e10cSrcweir con[0].Value = "Result2"; 210cdf0e10cSrcweir con[1] = new PropertyValue(); 211cdf0e10cSrcweir con[1].Name = "Formula1"; 212cdf0e10cSrcweir con[1].Value = "$Sheet1.$B$5"; 213cdf0e10cSrcweir con[2] = new PropertyValue(); 214cdf0e10cSrcweir con[2].Name = "Formula2"; 215cdf0e10cSrcweir con[2].Value = ""; 216cdf0e10cSrcweir con[3] = new PropertyValue(); 217cdf0e10cSrcweir con[3].Name = "Operator"; 218cdf0e10cSrcweir con[3].Value = ConditionOperator.EQUAL; 219cdf0e10cSrcweir con[4] = new PropertyValue(); 220cdf0e10cSrcweir con[4].Name = "SourcePosition"; 221cdf0e10cSrcweir con[4].Value = ca; 222cdf0e10cSrcweir return con; 223cdf0e10cSrcweir } 224cdf0e10cSrcweir 225cdf0e10cSrcweir } // finish class ScTableConditionalEntry 226cdf0e10cSrcweir 227