1 /************************************************************** 2 * 3 * Licensed to the Apache Software Foundation (ASF) under one 4 * or more contributor license agreements. See the NOTICE file 5 * distributed with this work for additional information 6 * regarding copyright ownership. The ASF licenses this file 7 * to you under the Apache License, Version 2.0 (the 8 * "License"); you may not use this file except in compliance 9 * with the License. You may obtain a copy of the License at 10 * 11 * http://www.apache.org/licenses/LICENSE-2.0 12 * 13 * Unless required by applicable law or agreed to in writing, 14 * software distributed under the License is distributed on an 15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16 * KIND, either express or implied. See the License for the 17 * specific language governing permissions and limitations 18 * under the License. 19 * 20 *************************************************************/ 21 22 package fvt.uno.sc.formula; 23 24 import static org.junit.Assert.*; 25 26 import org.junit.AfterClass; 27 import org.junit.Before; 28 import org.junit.Rule; 29 import org.junit.Test; 30 31 import org.junit.runner.RunWith; 32 import org.junit.runners.Parameterized; 33 import org.junit.runners.Parameterized.Parameters; 34 35 import java.util.Arrays; 36 import java.util.Collection; 37 38 import org.openoffice.test.common.Testspace; 39 import org.openoffice.test.common.Logger; 40 41 import org.openoffice.test.uno.UnoApp; 42 43 import testlib.uno.SCUtil; 44 import static testlib.uno.TestUtil.*; 45 46 import com.sun.star.beans.PropertyValue; 47 import com.sun.star.document.MacroExecMode; 48 import com.sun.star.lang.XComponent; 49 import com.sun.star.sheet.XSpreadsheet; 50 import com.sun.star.sheet.XSpreadsheetDocument; 51 import com.sun.star.sheet.XSpreadsheets; 52 import com.sun.star.table.XCell; 53 import com.sun.star.uno.Any; 54 import com.sun.star.text.XText; 55 import com.sun.star.uno.UnoRuntime; 56 import com.sun.star.util.XModifiable; 57 58 import java.util.logging.Level; 59 60 @RunWith(Parameterized.class) 61 public class TestFormulaDocs { 62 63 private String filename; 64 private String type; 65 66 @Parameters 67 public static Collection<Object[]> data() { 68 return Arrays.asList(new Object[][]{ 69 // test documents 70 {"uno/sc/fvt/FormulaTest1.ods", "FormulaTest1.ods"}, 71 {"uno/sc/fvt/StarBasicYearMonthDateHourMinuteSecondTests.ods", "Basic Year Month Date Hour Minute Second Test"}, 72 {"uno/sc/fvt/StarBasicCLng.ods", "Basic Convert to Long Function Test"}, 73 {"uno/sc/fvt/StarBasicTab.ods", "Basic Tab Function Test"}, 74 {"uno/sc/fvt/DGET on formulas.ods", "DGET on formulas Test"}, 75 {"uno/sc/fvt/Basic Line as variable and Line Input.ods", "Basic Line as variable and Line Input Test"}, 76 {"uno/sc/fvt/comment-in-single-line-if-then-else.ods", "Basic comment after single line if statement Test"}, 77 {"uno/sc/fvt/Bug81233ColumnZReference.xml", "Bug 81233 column Z reference wrongly converts to column A"}, 78 {"uno/sc/fvt/Bug100989MergeAcross0AddsExtraEmptyCell.xml", "Bug 100989 ss:MergeCross=\"0\" adds an extra empty cell to the right"} 79 }); 80 } 81 82 @Rule 83 public Logger log = Logger.getLogger(this); 84 85 static UnoApp unoApp = new UnoApp(); 86 XComponent scComponent = null; 87 88 /** 89 * Clean class after testing 90 * 91 * @throws Exception 92 */ 93 @AfterClass 94 public static void afterClass() { 95 unoApp.close(); 96 } 97 98 @Before 99 public void setUp() throws Exception { 100 unoApp.close(); // moved here from tearDown because stopping app there causes a late screenshot 101 unoApp.start(); 102 } 103 104 public TestFormulaDocs(String filename, String type) { 105 this.filename = filename; 106 this.type = type; 107 } 108 109 // FIXME: only needs a timeout for running tests against AOO41X due to fixes for i112383 and i117960 present in trunk 110 // haven't been backported to AOO41X yet and causes these tests to hang on an error dialog. 111 @Test(timeout = 15000) 112 public void testOneDoc() throws Exception { 113 // open the spreadsheet document 114 String sample = Testspace.prepareData(filename); 115 // enable macros 116 PropertyValue prop = new PropertyValue(); 117 prop.Name = "MacroExecutionMode"; 118 prop.Value = MacroExecMode.ALWAYS_EXECUTE_NO_WARN; 119 XSpreadsheetDocument scDoc = (XSpreadsheetDocument) UnoRuntime.queryInterface( 120 XSpreadsheetDocument.class, unoApp.loadDocument(sample, prop)); 121 XSpreadsheet xSheet = SCUtil.getCurrentSheet( scDoc); 122 123 // find the "TestID" and "TestOK" markers 124 int nTestIdCol = -1; 125 int nTestOkCol = -1; 126 int nTestRowStart = -1; 127 for( int y = 0; y < 8; ++y) { 128 for( int x = 0; x < 26; ++x) { 129 XCell xCell = xSheet.getCellByPosition( x, y); 130 XText xText = (XText)UnoRuntime.queryInterface( XText.class, xCell); 131 String name = xText.getString(); 132 if( name.equals( "TestID")) { 133 assertTrue( "Multiple rows with TestID marker!", nTestIdCol == -1); 134 assertTrue( nTestRowStart == -1); 135 nTestIdCol = x; 136 nTestRowStart = y + 1; 137 } else if( name.equals( "TestOK")) { 138 assertTrue( "Multiple rows with TestOK marker!", nTestOkCol == -1); 139 assertTrue( "TestID and TestOK marker not in same row!", nTestRowStart == y + 1); 140 nTestOkCol = x; 141 } 142 } 143 } 144 assertTrue( "Column \"TestID\" not found!", nTestIdCol >= 0); 145 assertTrue( "Column \"TestOK\" not found!", nTestOkCol >= 0); 146 147 int nTestRowEnd = nTestRowStart + 100; // TODO: get the last row from the sheet 148 int nTestCount = 0; 149 int nFailCount = 0; 150 for( int y = nTestRowStart; y < nTestRowEnd; ++y) { 151 // get the test id 152 XCell xCell = xSheet.getCellByPosition( nTestIdCol, y); 153 XText xText = (XText)UnoRuntime.queryInterface( XText.class, xCell); 154 String testId = xText.getString(); 155 // ignore rows without test ids 156 if( testId.length() == 0) 157 continue; 158 ++nTestCount; 159 160 // get and check the test result 161 xCell = xSheet.getCellByPosition( nTestOkCol, y); 162 String testOk = ((XText)UnoRuntime.queryInterface( XText.class, xCell)).getString(); 163 assertTrue( "Test result must be TRUE or FALSE", testOk.equals("TRUE") || testOk.equals("FALSE")); 164 boolean bOK = testOk.equals("TRUE"); 165 // mark evaluated test results 166 SCUtil.setProperties( xCell, "CellBackColor", (Integer)(bOK ? 0x00FF00 : 0xFF0000)); 167 // handle failed test cases 168 if( !bOK) { 169 ++nFailCount; 170 log.log( Level.SEVERE, "\ttest \""+testId+" failed"); 171 } 172 } 173 174 assertTrue( (""+nFailCount+" of "+nTestCount+" tests failed for " + type), nFailCount==0); 175 176 XModifiable modified = (XModifiable)UnoRuntime.queryInterface( XModifiable.class, scDoc); 177 modified.setModified( false); 178 SCUtil.closeFile( scDoc); 179 } 180 181 } 182