sc/formula/TestFormulaDocs.java

/**************************************************************
 *
 * 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 fvt.uno.sc.formula;

import static org.junit.Assert.*;

import org.junit.AfterClass;
import org.junit.Before;
import org.junit.Rule;
import org.junit.Test;

import org.junit.runner.RunWith;
import org.junit.runners.Parameterized;
import org.junit.runners.Parameterized.Parameters;

import java.util.Arrays;
import java.util.Collection;

import org.openoffice.test.common.Testspace;
import org.openoffice.test.common.Logger;

import org.openoffice.test.uno.UnoApp;

import testlib.uno.SCUtil;
import static testlib.uno.TestUtil.*;

import com.sun.star.beans.PropertyValue;
import com.sun.star.document.MacroExecMode;
import com.sun.star.lang.XComponent;
import com.sun.star.sheet.XSpreadsheet;
import com.sun.star.sheet.XSpreadsheetDocument;
import com.sun.star.sheet.XSpreadsheets;
import com.sun.star.table.XCell;
import com.sun.star.uno.Any;
import com.sun.star.text.XText;
import com.sun.star.uno.UnoRuntime;
import com.sun.star.util.XModifiable;

import java.util.logging.Level;

@RunWith(Parameterized.class)
public class TestFormulaDocs {

    private String filename;
    private String type;

    @Parameters
    public static Collection<Object[]> data() {
        return Arrays.asList(new Object[][]{
                // test documents
                {"uno/sc/fvt/FormulaTest1.ods", "FormulaTest1.ods"},
                {"uno/sc/fvt/StarBasicYearMonthDateHourMinuteSecondTests.ods", "Basic Year Month Date Hour Minute Second Test"},
                {"uno/sc/fvt/StarBasicCLng.ods", "Basic Convert to Long Function Test"},
                {"uno/sc/fvt/StarBasicTab.ods", "Basic Tab Function Test"},
                {"uno/sc/fvt/DGET on formulas.ods", "DGET on formulas Test"},
                {"uno/sc/fvt/Basic Line as variable and Line Input.ods", "Basic Line as variable and Line Input Test"},
                {"uno/sc/fvt/comment-in-single-line-if-then-else.ods", "Basic comment after single line if statement Test"},
                {"uno/sc/fvt/Bug81233ColumnZReference.xml", "Bug 81233 column Z reference wrongly converts to column A"},
                {"uno/sc/fvt/Bug100989MergeAcross0AddsExtraEmptyCell.xml", "Bug 100989 ss:MergeCross=\"0\" adds an extra empty cell to the right"},
                {"uno/sc/fvt/Bug128554FractionalSecondsIgnored.xml", "Bug 100989 fractional seconds are silently ignored during import"}
        });
    }

    @Rule
    public Logger log = Logger.getLogger(this);

    static UnoApp unoApp = new UnoApp();
    XComponent scComponent = null;

    /**
     * Clean class after testing
     *
     * @throws Exception
     */
    @AfterClass
    public static void afterClass() {
        unoApp.close();
    }

    @Before
    public void setUp() throws Exception {
        unoApp.close(); // moved here from tearDown because stopping app there causes a late screenshot
        unoApp.start();
    }

    public TestFormulaDocs(String filename, String type) {
        this.filename = filename;
        this.type = type;
    }

    // FIXME: only needs a timeout for running tests against AOO41X due to fixes for i112383 and i117960 present in trunk
    // haven't been backported to AOO41X yet and causes these tests to hang on an error dialog.
    @Test(timeout = 15000)
    public void testOneDoc() throws Exception {
        // open the spreadsheet document
        String sample = Testspace.prepareData(filename);
        // enable macros
        PropertyValue prop = new PropertyValue();
        prop.Name = "MacroExecutionMode";
        prop.Value = MacroExecMode.ALWAYS_EXECUTE_NO_WARN;
        XSpreadsheetDocument scDoc = (XSpreadsheetDocument) UnoRuntime.queryInterface(
            XSpreadsheetDocument.class, unoApp.loadDocument(sample, prop));
        XSpreadsheet xSheet = SCUtil.getCurrentSheet( scDoc);

        // find the "TestID" and "TestOK" markers
        int nTestIdCol = -1;
        int nTestOkCol = -1;
        int nTestRowStart = -1;
        for( int y = 0; y < 8; ++y) {
            for( int x = 0; x < 26; ++x) {
                XCell xCell = xSheet.getCellByPosition( x, y);
                XText xText = (XText)UnoRuntime.queryInterface( XText.class, xCell);
                String name = xText.getString();
                if( name.equals( "TestID")) {
                    assertTrue( "Multiple rows with TestID marker!", nTestIdCol == -1);
                    assertTrue( nTestRowStart == -1);
                    nTestIdCol = x;
                    nTestRowStart = y + 1;
                } else if( name.equals( "TestOK")) {
                    assertTrue( "Multiple rows with TestOK marker!", nTestOkCol == -1);
                    assertTrue( "TestID and TestOK marker not in same row!", nTestRowStart == y + 1);
                    nTestOkCol = x;
                }
            }
        }
        assertTrue( "Column \"TestID\" not found!", nTestIdCol >= 0);
        assertTrue( "Column \"TestOK\" not found!", nTestOkCol >= 0);

        int nTestRowEnd = nTestRowStart + 100; // TODO: get the last row from the sheet
        int nTestCount = 0;
        int nFailCount = 0;
        for( int y = nTestRowStart; y < nTestRowEnd; ++y) {
            // get the test id
            XCell xCell = xSheet.getCellByPosition( nTestIdCol, y);
            XText xText = (XText)UnoRuntime.queryInterface( XText.class, xCell);
            String testId = xText.getString();
            // ignore rows without test ids
            if( testId.length() == 0)
                continue;
            ++nTestCount;

            // get and check the test result
            xCell = xSheet.getCellByPosition( nTestOkCol, y);
            String testOk = ((XText)UnoRuntime.queryInterface( XText.class, xCell)).getString();
            assertTrue( "Test result must be TRUE or FALSE", testOk.equals("TRUE") || testOk.equals("FALSE"));
            boolean bOK = testOk.equals("TRUE");
            // mark evaluated test results
            SCUtil.setProperties( xCell, "CellBackColor", (Integer)(bOK ? 0x00FF00 : 0xFF0000));
            // handle failed test cases
            if( !bOK) {
                ++nFailCount;
                log.log( Level.SEVERE, "\ttest \""+testId+" failed");
            }
        }

        assertTrue( (nFailCount+" of "+nTestCount+" tests failed for " + type), nFailCount==0);

        XModifiable modified = (XModifiable)UnoRuntime.queryInterface( XModifiable.class, scDoc);
        modified.setModified( false);
        SCUtil.closeFile( scDoc);
    }

}