1 files changed, 247 insertions, 0 deletions
diff --git a/qadevOOo/tests/java/ifc/sheet/_XDatabaseRange.java b/qadevOOo/tests/java/ifc/sheet/_XDatabaseRange.java
new file mode 100644
index 000000000000..6606aa06c782
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sheet/_XDatabaseRange.java
@@ -0,0 +1,247 @@
+/*************************************************************************
+ *
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+ *
+ * Copyright 2008 by Sun Microsystems, Inc.
+ *
+ * OpenOffice.org - a multi-platform office productivity suite
+ *
+ * $RCSfile: _XDatabaseRange.java,v $
+ * $Revision: 1.5 $
+ *
+ * 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 ifc.sheet;
+
+import lib.MultiMethodTest;
+import lib.Status;
+import lib.StatusException;
+
+import com.sun.star.beans.PropertyValue;
+import com.sun.star.sheet.SubTotalColumn;
+import com.sun.star.sheet.XDatabaseRange;
+import com.sun.star.sheet.XSheetFilterDescriptor;
+import com.sun.star.sheet.XSubTotalDescriptor;
+import com.sun.star.table.CellRangeAddress;
+import com.sun.star.table.XCell;
+import com.sun.star.table.XCellRange;
+
+/**
+* Testing <code>com.sun.star.sheet.XDatabaseRange</code>
+* interface methods :
+* <ul>
+*  <li><code> getDataArea()</code></li>
+*  <li><code> setDataArea()</code></li>
+*  <li><code> getSortDescriptor()</code></li>
+*  <li><code> getFilterDescriptor()</code></li>
+*  <li><code> getSubTotalDescriptor()</code></li>
+*  <li><code> getImportDescriptor()</code></li>
+*  <li><code> refresh()</code></li>
+* </ul> <p>
+* This test needs the following object relations :
+* <ul>
+*  <li> <code>'DATAAREA'</code> (of type <code>CellRangeAddress</code>):
+*   to have cell range address for test of method <code>getDataArea()</code></li>
+*   <li> <code>'XCELLRANGE'</code> (of type <code>XCellRange</code>):
+*   cell range of the spreadsheet with database range,
+*   to get values of cell</li>
+* <ul> <p>
+* @see com.sun.star.sheet.XDatabaseRange
+* @see com.sun.star.table.CellRangeAddress
+*/
+public class _XDatabaseRange extends MultiMethodTest {
+
+    public XDatabaseRange oObj = null;
+    CellRangeAddress oldCRA = null;
+    XCellRange xCellRange = null;
+
+    /**
+    * Retrieves object relations.
+    * @throws StatusException If one of relations not found.
+    */
+    protected void before() {
+        oldCRA = (CellRangeAddress)tEnv.getObjRelation("DATAAREA");
+        if (oldCRA == null) {
+            throw new StatusException(Status.failed
+                ("Relation 'DATAAREA' not found"));
+        }
+        xCellRange = (XCellRange)tEnv.getObjRelation("XCELLRANGE");
+        if (xCellRange == null) {
+            throw new StatusException(Status.failed
+                ("Relation 'XCELLRANGE' not found"));
+        }
+    }
+
+    /**
+    * Test calls the method and compares returned cell range address with
+    * cell range address obtained by object relation <code>'DATAAREA'</code>.<p>
+    * Has <b> OK </b> status if all fields of cell range addresses are equal. <p>
+    */
+    public void _getDataArea() {
+        boolean bResult = true;
+        CellRangeAddress objCRA = oObj.getDataArea();
+        bResult &= objCRA.EndColumn   == oldCRA.EndColumn;
+        bResult &= objCRA.EndRow       == oldCRA.EndRow;
+        bResult &= objCRA.Sheet       == oldCRA.Sheet;
+        bResult &= objCRA.StartColumn == oldCRA.StartColumn;
+        bResult &= objCRA.StartRow       == oldCRA.StartRow;
+        tRes.tested("getDataArea()", bResult);
+    }
+
+    /**
+    * Test calls the method and checks returned value. <p>
+    * Has <b> OK </b> status if returned value isn't null. <p>
+    */
+    public void _getFilterDescriptor() {
+        XSheetFilterDescriptor FD = oObj.getFilterDescriptor();
+        tRes.tested("getFilterDescriptor()", FD != null);
+    }
+
+    /**
+    * Test calls the method and checks returned value. <p>
+    * Has <b> OK </b> status if returned value isn't null. <p>
+    */
+    public void _getImportDescriptor() {
+        PropertyValue[] pva = oObj.getImportDescriptor();
+        tRes.tested("getImportDescriptor()", pva != null);
+    }
+
+    /**
+    * Test calls the method and checks returned value. <p>
+    * Has <b> OK </b> status if returned value isn't null. <p>
+    */
+    public void _getSortDescriptor() {
+        PropertyValue[] pva = oObj.getSortDescriptor();
+        tRes.tested("getSortDescriptor()", pva != null);
+    }
+
+    /**
+    * Test calls the method and checks returned value. <p>
+    * Has <b> OK </b> status if returned value isn't null. <p>
+    */
+    public void _getSubTotalDescriptor() {
+        STD = oObj.getSubTotalDescriptor();
+        tRes.tested("getSubTotalDescriptor()", STD != null);
+    }
+
+    XSubTotalDescriptor STD = null;
+
+    /**
+    * Test adds new SubTotalDescriptor and checks value of cell with
+    * subtotal sum after refresh() call. <p>
+    * Has <b> OK </b> if value of cell with subtotal sum was changed
+    * after refresh() call.<p>
+    */
+    public void _refresh() {
+        requiredMethod("getSubTotalDescriptor()");
+        requiredMethod("setDataArea()");
+
+        for(int i = STARTROW; i < ENDROW+1; i++) {
+            try {
+                XCell cell = xCellRange.getCellByPosition(COL, i);
+                cell.setValue(i);
+            } catch(com.sun.star.lang.IndexOutOfBoundsException e) {
+                log.println("Unexpected exception");
+                e.printStackTrace(log);
+                tRes.tested("refresh()", false);
+            }
+        }
+
+        SubTotalColumn[] STC = new SubTotalColumn[1];
+        STC[0] = new SubTotalColumn();
+        STC[0].Column = COL;
+        STC[0].Function = com.sun.star.sheet.GeneralFunction.SUM;
+
+        double oldVal = 0;
+        try {
+            XCell checkCell = xCellRange.getCellByPosition(COL, ENDROW);
+            oldVal = checkCell.getValue();
+        } catch(com.sun.star.lang.IndexOutOfBoundsException e) {
+            log.println("Unexpected exception");
+            e.printStackTrace(log);
+            tRes.tested("refresh()", false);
+        }
+        log.println("Value of the cell (" + COL + ", " + ENDROW +
+            ") : " + oldVal );
+
+        log.println("Set new SubTotal descriptor...");
+
+        STD.clear();
+        STD.addNew(STC, 1);
+
+        double valBeforeRefresh = 0;
+        try {
+            XCell checkCell = xCellRange.getCellByPosition(COL, ENDROW);
+            valBeforeRefresh = checkCell.getValue();
+        } catch(com.sun.star.lang.IndexOutOfBoundsException e) {
+            log.println("Unexpected exception");
+            e.printStackTrace(log);
+            tRes.tested("refresh()", false);
+        }
+        log.println("Value of the cell (" + COL + ", " + ENDROW +
+            ") : " + valBeforeRefresh );
+
+        log.println("Now call refresh()...");
+        oObj.refresh();
+
+        double valAfterRefresh = 0;
+        try {
+            XCell checkCell = xCellRange.getCellByPosition(COL, ENDROW);
+            valAfterRefresh = checkCell.getValue();
+        } catch(com.sun.star.lang.IndexOutOfBoundsException e) {
+            log.println("Unexpected exception");
+            e.printStackTrace(log);
+            tRes.tested("refresh()", false);
+        }
+        log.println("Value of the cell (" + COL + ", " + ENDROW +
+            ") : " + valAfterRefresh );
+
+        tRes.tested("refresh()", oldVal != valAfterRefresh &&
+            oldVal == valBeforeRefresh);
+    }
+
+    final short COL = 0;
+    final short STARTROW = 0;
+    final short ENDROW = 5;
+
+    /**
+    * Test creates new cell range address and calls the method. <p>
+    * Has <b> OK </b> status if the method successfully returns. <p>
+    */
+    public void _setDataArea() {
+        executeMethod("getDataArea()");
+        CellRangeAddress newCRA = new CellRangeAddress();
+        newCRA.Sheet = oldCRA.Sheet;
+        newCRA.StartColumn = COL;
+        newCRA.EndColumn = COL;
+        newCRA.StartRow = STARTROW;
+        newCRA.EndRow = ENDROW;
+
+        oObj.setDataArea(newCRA);
+
+        tRes.tested("setDataArea()", true);
+    }
+
+    protected void after() {
+        disposeEnvironment();
+    }
+}
+
+