1 files changed, 286 insertions, 0 deletions
diff --git a/sc/qa/complex/cellRanges/CheckXCellRangesQuery.java b/sc/qa/complex/cellRanges/CheckXCellRangesQuery.java
new file mode 100755
index 000000000000..a85cb0483c1c
--- /dev/null
+++ b/sc/qa/complex/cellRanges/CheckXCellRangesQuery.java
@@ -0,0 +1,286 @@
+/*************************************************************************
+ *
+ * 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();
+
+}