1 files changed, 0 insertions, 286 deletions
diff --git a/sc/qa/complex/cellRanges/CheckXCellRangesQuery.java b/sc/qa/complex/cellRanges/CheckXCellRangesQuery.java
deleted file mode 100755
index dfc9e4a39..000000000
--- a/sc/qa/complex/cellRanges/CheckXCellRangesQuery.java
+++ /dev/null
@@ -1,286 +0,0 @@
-/*************************************************************************
- *
- * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
- * Copyright 2000, 2010 Oracle and/or its affiliates.
- *
- * OpenOffice.org - a multi-platform office productivity suite
- *
- * This file is part of OpenOffice.org.
- *
- * OpenOffice.org is free software: you can redistribute it and/or modify
- * it under the terms of the GNU Lesser General Public License version 3
- * only, as published by the Free Software Foundation.
- *
- * OpenOffice.org is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- * GNU Lesser General Public License version 3 for more details
- * (a copy is included in the LICENSE file that accompanied this code).
- *
- * You should have received a copy of the GNU Lesser General Public License
- * version 3 along with OpenOffice.org.  If not, see
- * <http://www.openoffice.org/license.html>
- * for a copy of the LGPLv3 License.
- *
- ************************************************************************/
-
-package complex.cellRanges;
-
-import com.sun.star.container.XIndexAccess;
-// import complexlib.ComplexTestCase;
-import com.sun.star.lang.XMultiServiceFactory;
-// import com.sun.star.sheet.CellFlags;
-import com.sun.star.sheet.XCellRangesQuery;
-import com.sun.star.sheet.XSheetCellRanges;
-import com.sun.star.sheet.XSpreadsheet;
-import com.sun.star.sheet.XSpreadsheetDocument;
-import com.sun.star.sheet.XSpreadsheets;
-import com.sun.star.table.CellAddress;
-// import com.sun.star.table.XColumnRowRange;
-// import com.sun.star.table.XTableColumns;
-// import com.sun.star.table.XTableRows;
-import com.sun.star.uno.AnyConverter;
-import com.sun.star.uno.Type;
-import com.sun.star.uno.UnoRuntime;
-import com.sun.star.uno.XInterface;
-// import java.io.PrintWriter;
-import com.sun.star.util.XCloseable;
-import util.SOfficeFactory;
-
-import org.junit.After;
-import org.junit.AfterClass;
-import org.junit.Before;
-import org.junit.BeforeClass;
-import org.junit.Test;
-import org.openoffice.test.OfficeConnection;
-import static org.junit.Assert.*;
-
-/**
- * Check the XCellRangesQuery interface on the SheetCell service. test was 
- * created for bug i20044.
- */
-public class CheckXCellRangesQuery /* extends ComplexTestCase */ {
-    XSpreadsheetDocument m_xSheetDoc = null;
-    XCellRangesQuery m_xCell = null;
-    XSpreadsheet m_xSpreadSheet = null;
-
-    /**
-     * Get all test methods.
-     * @return The test methods.
-     */
-//     public String[] getTestMethodNames() {
-//         return new String[] {"checkEmptyCell", "checkFilledCell"};
-//     }
-
-    /**
-    * Creates Spreadsheet document and the test object, 
-    * before the actual test starts.
-    */
-    @Before public void before() {
-        // create a calc document
-        // SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory)param.getMSF() );
-        final XMultiServiceFactory xMsf = UnoRuntime.queryInterface(XMultiServiceFactory.class, connection.getComponentContext().getServiceManager());
-        SOfficeFactory SOF = SOfficeFactory.getFactory(xMsf);
-
-        try {
-            System.out.println( "creating a Spreadsheet document" );
-            m_xSheetDoc = SOF.createCalcDoc(null);
-        } catch ( com.sun.star.uno.Exception e ) {
-            // Some exception occures.FAILED
-            e.printStackTrace(  );
-            fail( "Couldn?t create document");
-        }
-        XInterface oObj = null;
-
-        try {
-            System.out.println("Getting spreadsheet") ;
-            XSpreadsheets oSheets = m_xSheetDoc.getSheets() ;
-            XIndexAccess oIndexSheets = 
-            UnoRuntime.queryInterface(XIndexAccess.class, oSheets);
-            m_xSpreadSheet = (XSpreadsheet) AnyConverter.toObject(
-                    new Type(XSpreadsheet.class),oIndexSheets.getByIndex(0));
-
-            // get the cell
-            System.out.println("Getting a cell from sheet") ;
-            oObj = m_xSpreadSheet.getCellByPosition(2, 3);
-            m_xCell = UnoRuntime.queryInterface(XCellRangesQuery.class, oObj);
-
-        } catch (com.sun.star.lang.WrappedTargetException e) {
-            e.printStackTrace();
-            fail("Error getting cell object from spreadsheet document");
-        } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
-            e.printStackTrace();
-            fail("Error getting cell object from spreadsheet document");
-        } catch (com.sun.star.lang.IllegalArgumentException e) {
-            e.printStackTrace();
-            fail("Error getting cell object from spreadsheet document");
-        }
-
-        // set one value for comparison.
-        try {
-            m_xSpreadSheet.getCellByPosition(1, 1).setValue(15);
-            m_xSpreadSheet.getCellByPosition(1, 3).setValue(5);
-            m_xSpreadSheet.getCellByPosition(2, 1).setFormula("=B2+B4");
-/*            m_xSpreadSheet.getCellByPosition(2, 1).setFormula("=B2+B3");
-            m_xSpreadSheet.getCellByPosition(3, 2).setFormula("");
-            m_xSpreadSheet.getCellByPosition(3, 3).setFormula("");            */
-        } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
-            e.printStackTrace();
-            fail("Could not fill cell (1, 1) with a value.");
-        }
-
-    }
-
-       /*
-     * this method closes a calc document and resets the corresponding class variable xSheetDoc
-     */
-    protected boolean closeSpreadsheetDocument() {
-        boolean worked = true;
-
-        System.out.println("    disposing xSheetDoc ");
-
-        try {
-            XCloseable oCloser =  UnoRuntime.queryInterface(
-                                         XCloseable.class, m_xSheetDoc);
-            oCloser.close(true);
-        } catch (com.sun.star.util.CloseVetoException e) {
-            worked = false;
-            System.out.println("Couldn't close document");
-        } catch (com.sun.star.lang.DisposedException e) {
-            worked = false;
-            System.out.println("Document already disposed");
-        } catch (java.lang.NullPointerException e) {
-            worked = false;
-            System.out.println("Couldn't get XCloseable");
-        }
-
-        m_xSheetDoc = null;
-
-        return worked;
-    }
-
-    @After public void after()
-        {
-            closeSpreadsheetDocument();
-        }
-    
-    /**
-     * Perform some tests on an empty cell:
-     * <ol>
-     * <li>compare an empty cell with a cell with a value in the same column</li>
-     * <li>compare an empty cell with a cell with a value in the same row</li>
-     * <li>query for empty cells</li>
-     * <ol>
-     */
-    @Test public void checkEmptyCell() {
-        System.out.println("Checking an empty cell...");
-        // compare an empty cell with a cell with a value
-        assertTrue("\tQuery column differences did not return the correct value.", _queryColumnDifferences("Sheet1.C4"));
-        // compare an empty cell with a cell with a value
-        assertTrue("\tQuery column differences did not return the correct value.", _queryRowDifferences("Sheet1.C4"));
-        // try to get this cell
-//         assertTrue("\tQuery empty cells did not return the correct value.", _queryEmptyCells("Sheet1.C4"));
-        System.out.println("...done");
-    }
-
-    /**
-     * Perform some tests on a filled cell:
-     * <ol>
-     * <li>compare an cell with value 5 with a cell with value 15 in the same column</li>
-     * <li>compare an cell with value 5 with a cell with value 15 in the same row</li>
-     * <li>query for an empty cell.</li>
-     * <ol>
-     */
-    @Test public void checkFilledCell() {
-        System.out.println("Checking a filled cell...");
-
-        // fill the cell with a value
-        try {
-            m_xSpreadSheet.getCellByPosition(2, 3).setValue(15);
-        } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
-            e.printStackTrace();
-            fail("Could not fill cell (2, 3) with a value.");
-        }
-
-        // compare an cell with value 5 with a cell with value 15
-        assertTrue("\tQuery column differences did not return the correct value.", _queryColumnDifferences("Sheet1.C4"));
-        // compare an cell with value 5 with a cell with value 15
-        assertTrue("\tQuery column differences did not return the correct value.", _queryRowDifferences("Sheet1.C4"));
-        // try to get nothing
-        assertTrue("\tQuery empty cells did not return the correct value.", _queryEmptyCells(""));
-        System.out.println("...done");
-    }
-
-
-    /**
-     *  Query column differences between my cell(2,3) and (1,1).
-     *  @param expected The expected outcome value.
-     *  @return True, if the result equals the expected result.
-     */
-    public boolean _queryColumnDifferences(String expected) {
-        System.out.println("\tQuery column differences");
-        XSheetCellRanges ranges = m_xCell.queryColumnDifferences(
-                                          new CellAddress((short) 0, 1, 1));
-        String getting = ranges.getRangeAddressesAsString();
-
-        if (!getting.equals(expected)) {
-            System.out.println("\tGetting: " + getting);
-            System.out.println("\tShould have been: " + expected);
-            return false;
-        }
-        return true;
-    }
-
-    /**
-     * Query for an empty cell.
-     *  @param expected The expected outcome value.
-     *  @return True, if the result equals the expected result.
-     */
-    public boolean _queryEmptyCells(String expected) {
-        System.out.println("\tQuery empty cells");
-        XSheetCellRanges ranges = m_xCell.queryEmptyCells();
-        String getting = ranges.getRangeAddressesAsString();
-
-        if (!getting.equals(expected)) {
-            System.out.println("\tGetting: " + getting);
-            System.out.println("\tShould have been: " + expected);
-            return false;
-        }
-        return true;
-    }
-
-    /**
-     *  Query row differences between my cell(2,3) and (1,1).
-     *  @param expected The expected outcome value.
-     *  @return True, if the result equals the expected result.
-     */
-    public boolean _queryRowDifferences(String expected) {
-        System.out.println("\tQuery row differences");
-        XSheetCellRanges ranges = m_xCell.queryRowDifferences(
-                                          new CellAddress((short) 0, 1, 1));
-        String getting = ranges.getRangeAddressesAsString();
-
-        if (!getting.equals(expected)) {
-            System.out.println("\tGetting: " + getting);
-            System.out.println("\tShould have been: " + expected);
-            return false;
-        }
-
-        return true;
-    }
-
-
-    @BeforeClass public static void setUpConnection() throws Exception {
-        connection.setUp();
-    }
-
-    @AfterClass public static void tearDownConnection()
-        throws InterruptedException, com.sun.star.uno.Exception
-    {
-        connection.tearDown();
-    }
-
-    private static final OfficeConnection connection = new OfficeConnection();
-
-}