| /************************************************************** |
| * |
| * 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 mod._sc; |
| import java.io.PrintWriter; |
| |
| import lib.StatusException; |
| import lib.TestCase; |
| import lib.TestEnvironment; |
| import lib.TestParameters; |
| import util.SOfficeFactory; |
| import util.ValueComparer; |
| |
| import com.sun.star.beans.XPropertySet; |
| import com.sun.star.lang.XComponent; |
| import com.sun.star.lang.XMultiServiceFactory; |
| import com.sun.star.sheet.XSheetCellRange; |
| 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.table.XCellRange; |
| 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 ifc.sheet._XCellRangesQuery; |
| |
| |
| /** |
| * Test for object which is represented by service |
| * <code>com.sun.star.sheet.SheetCellCursor</code>. <p> |
| * Object implements the following interfaces : |
| * <ul> |
| * <li> <code>com::sun::star::style::ParagraphProperties</code></li> |
| * <li> <code>com::sun::star::sheet::XUsedAreaCursor</code></li> |
| * <li> <code>com::sun::star::table::CellProperties</code></li> |
| * <li> <code>com::sun::star::table::XCellRange</code></li> |
| * <li> <code>com::sun::star::sheet::XCellRangeAddressable</code></li> |
| * <li> <code>com::sun::star::table::XCellCursor</code></li> |
| * <li> <code>com::sun::star::sheet::XSheetCellCursor</code></li> |
| * <li> <code>com::sun::star::style::CharacterProperties</code></li> |
| * <li> <code>com::sun::star::sheet::XSheetOperation</code></li> |
| * <li> <code>com::sun::star::sheet::XArrayFormulaRange</code></li> |
| * <li> <code>com::sun::star::sheet::XSheetCellRange</code></li> |
| * <li> <code>com::sun::star::sheet::SheetCellRange</code></li> |
| * <li> <code>com::sun::star::chart::XChartData</code></li> |
| * <li> <code>com::sun::star::beans::XPropertySet</code></li> |
| * <li> <code>com::sun::star::util::XMergeable</code></li> |
| * <li> <code>com::sun::star::table::XColumnRowRange</code></li> |
| * </ul> |
| * @see com.sun.star.sheet.SheetCellCursor |
| * @see com.sun.star.style.ParagraphProperties |
| * @see com.sun.star.sheet.XUsedAreaCursor |
| * @see com.sun.star.table.CellProperties |
| * @see com.sun.star.table.XCellRange |
| * @see com.sun.star.sheet.XCellRangeAddressable |
| * @see com.sun.star.table.XCellCursor |
| * @see com.sun.star.sheet.XSheetCellCursor |
| * @see com.sun.star.style.CharacterProperties |
| * @see com.sun.star.sheet.XSheetOperation |
| * @see com.sun.star.sheet.XArrayFormulaRange |
| * @see com.sun.star.sheet.XSheetCellRange |
| * @see com.sun.star.sheet.SheetCellRange |
| * @see com.sun.star.chart.XChartData |
| * @see com.sun.star.beans.XPropertySet |
| * @see com.sun.star.util.XMergeable |
| * @see com.sun.star.table.XColumnRowRange |
| * @see ifc.style._ParagraphProperties |
| * @see ifc.sheet._XUsedAreaCursor |
| * @see ifc.table._CellProperties |
| * @see ifc.table._XCellRange |
| * @see ifc.sheet._XCellRangeAddressable |
| * @see ifc.table._XCellCursor |
| * @see ifc.sheet._XSheetCellCursor |
| * @see ifc.style._CharacterProperties |
| * @see ifc.sheet._XSheetOperation |
| * @see ifc.sheet._XArrayFormulaRange |
| * @see ifc.sheet._XSheetCellRange |
| * @see ifc.sheet._SheetCellRange |
| * @see ifc.chart._XChartData |
| * @see ifc.beans._XPropertySet |
| * @see ifc.util._XMergeable |
| * @see ifc.table._XColumnRowRange |
| */ |
| public class ScCellCursorObj extends TestCase { |
| static XSpreadsheetDocument xSheetDoc = null; |
| |
| /** |
| * Creates Spreadsheet document. |
| */ |
| protected void initialize(TestParameters tParam, PrintWriter log) { |
| SOfficeFactory SOF = SOfficeFactory.getFactory( |
| (XMultiServiceFactory) tParam.getMSF()); |
| |
| try { |
| log.println("creating a Spreadsheet document"); |
| xSheetDoc = SOF.createCalcDoc(null); |
| } catch (com.sun.star.uno.Exception e) { |
| // Some exception occures.FAILED |
| e.printStackTrace(log); |
| throw new StatusException("Couldn't create document", e); |
| } |
| } |
| |
| /** |
| * Disposes Spreadsheet document. |
| */ |
| protected void cleanup(TestParameters tParam, PrintWriter log) { |
| log.println(" disposing xSheetDoc "); |
| |
| XComponent oComp = (XComponent) UnoRuntime.queryInterface( |
| XComponent.class, xSheetDoc); |
| |
| util.DesktopTools.closeDoc(oComp); |
| } |
| |
| /** |
| * Creating a Testenvironment for the interfaces to be tested. |
| * Retrieves a collection of spreadsheets from a document, |
| * and takes one of them, retrieves some cell range and creates cursor range |
| * that is instance of the service |
| * <code>com.sun.star.sheet.SheetCellCursor</code>, |
| * fills some cells in the cell range. |
| * Object relations created : |
| * <ul> |
| * <li> <code>'SHEET'</code> for |
| * {@link ifc.table._XCellCursor}, |
| * {@link ifc.sheet._XArrayFormulaRange} (the spreadsheet that was |
| * retieved from collection)</li> |
| * </ul> |
| */ |
| protected synchronized TestEnvironment createTestEnvironment(TestParameters Param, |
| PrintWriter log) { |
| XInterface oObj = null; |
| TestEnvironment tEnv = null; |
| XSpreadsheet oSheet = null; |
| XCellRange testRange = null; |
| |
| |
| // creation of testobject here |
| // first we write what we are intend to do to log file |
| log.println("Creating a test environment"); |
| |
| XSpreadsheets oSpreadsheets = ((XSpreadsheetDocument) UnoRuntime.queryInterface( |
| XSpreadsheetDocument.class, |
| xSheetDoc)).getSheets(); |
| |
| try { |
| oSheet = (XSpreadsheet) AnyConverter.toObject( |
| new Type(XSpreadsheet.class), |
| oSpreadsheets.getByName( |
| oSpreadsheets.getElementNames()[0])); |
| |
| testRange = oSheet.getCellRangeByName("$A$1:$D$4"); |
| |
| XSheetCellRange testSheetRange = (XSheetCellRange) UnoRuntime.queryInterface( |
| XSheetCellRange.class, |
| testRange); |
| oObj = oSheet.createCursorByRange(testSheetRange); |
| oSheet.getCellByPosition(1, 1).setValue(1); |
| oSheet.getCellByPosition(4, 5).setValue(1); |
| oSheet.getCellByPosition(3, 2).setFormula("xTextDoc"); |
| oSheet.getCellByPosition(3, 3).setFormula("xTextDoc"); |
| } catch (com.sun.star.lang.WrappedTargetException e) { |
| log.println("Exception occured while creating test object:"); |
| e.printStackTrace(log); |
| throw new StatusException("Couldn't create test object", e); |
| } catch (com.sun.star.container.NoSuchElementException e) { |
| log.println("Exception occured while creating test object:"); |
| e.printStackTrace(log); |
| throw new StatusException("Couldn't create test object", e); |
| } catch (com.sun.star.lang.IndexOutOfBoundsException e) { |
| log.println("Exception occured while creating test object:"); |
| e.printStackTrace(log); |
| throw new StatusException("Couldn't create test object", e); |
| } catch (com.sun.star.lang.IllegalArgumentException e) { |
| log.println("Exception occured while creating test object:"); |
| e.printStackTrace(log); |
| throw new StatusException("Couldn't create test object", e); |
| } |
| |
| log.println("Test object successfully created."); |
| |
| tEnv = new TestEnvironment(oObj); |
| |
| tEnv.addObjRelation("CRDESC", |
| "Column and RowDescriptions can't be changed for this Object"); |
| |
| tEnv.addObjRelation("SHEET", oSheet); |
| // add expected results for the XCellRangesQuery interface test |
| String[]expectedResults = new String[7]; |
| expectedResults[_XCellRangesQuery.QUERYCOLUMNDIFFERENCES] = "Sheet1.B1"; |
| expectedResults[_XCellRangesQuery.QUERYCONTENTCELLS] = "Sheet1.B2"; |
| expectedResults[_XCellRangesQuery.QUERYEMPTYCELLS] = "Sheet1.A1 ... Sheet1.B1 ... Sheet1.B3 ... Sheet1.C1 ... Sheet1.D1"; |
| expectedResults[_XCellRangesQuery.QUERYFORMULACELLS] = ""; |
| expectedResults[_XCellRangesQuery.QUERYINTERSECTION] = "Sheet1.D4"; |
| expectedResults[_XCellRangesQuery.QUERYROWDIFFERENCES] = "Sheet1.A2;Sheet1.C2"; |
| expectedResults[_XCellRangesQuery.QUERYVISIBLECELLS] = "Sheet1.A2"; |
| tEnv.addObjRelation("XCellRangesQuery.EXPECTEDRESULTS", expectedResults); |
| |
| tEnv.addObjRelation("NewData", |
| new Object[][] |
| { |
| { "", "", "", "" }, |
| { "", "2", "3", "4" }, |
| { "", "2", "3", "4" }, |
| { "", "2", "3", "4" } |
| }); |
| |
| XPropertySet PropSet = (XPropertySet) UnoRuntime.queryInterface( |
| XPropertySet.class, oObj); |
| tEnv.addObjRelation("PropSet", PropSet); |
| |
| //Adding relation for util.XSortable |
| final PrintWriter finalLog = log; |
| final XCellRange oTable = testRange; |
| tEnv.addObjRelation("SORTCHECKER", |
| new ifc.util._XSortable.XSortChecker() { |
| PrintWriter out = finalLog; |
| |
| public void setPrintWriter(PrintWriter log) { |
| out = log; |
| } |
| |
| public void prepareToSort() { |
| try { |
| oTable.getCellByPosition(0, 0).setValue(4); |
| oTable.getCellByPosition(0, 1).setFormula("b"); |
| oTable.getCellByPosition(0, 2).setValue(3); |
| oTable.getCellByPosition(0, 3).setValue(23); |
| } catch (com.sun.star.lang.IndexOutOfBoundsException e) { |
| out.println("Exception while checking sort"); |
| } |
| } |
| |
| public boolean checkSort(boolean isSortNumbering, |
| boolean isSortAscending) { |
| out.println("Sort checking..."); |
| |
| boolean res = false; |
| String[] value = new String[4]; |
| |
| for (int i = 0; i < 4; i++) { |
| try { |
| XCell cell = oTable.getCellByPosition(0, i); |
| value[i] = cell.getFormula(); |
| } catch (com.sun.star.lang.IndexOutOfBoundsException e) { |
| out.println("Exception while checking sort"); |
| } |
| } |
| |
| if (isSortNumbering) { |
| if (isSortAscending) { |
| out.println("Sorting ascending"); |
| |
| String[] rightVal = { "3", "4", "23", "b" }; |
| String[] vals = { value[0], value[1], value[2], value[3] }; |
| res = ValueComparer.equalValue(vals, rightVal); |
| out.println("Expected 3, 4, 23, b"); |
| out.println("getting: " + value[0] + ", " + |
| value[1] + ", " + value[2] + ", " + |
| value[3]); |
| } else { |
| String[] rightVal = { "b", "23", "4", "3" }; |
| String[] vals = { value[0], value[1], value[2], value[3] }; |
| res = ValueComparer.equalValue(vals, rightVal); |
| out.println("Expected b, 23, 4, 3"); |
| out.println("getting: " + value[0] + ", " + |
| value[1] + ", " + value[2] + ", " + |
| value[3]); |
| } |
| } else { |
| if (isSortAscending) { |
| String[] rightVal = { "3", "4", "23", "b" }; |
| res = ValueComparer.equalValue(value, rightVal); |
| out.println("Expected 3, 4, 23, b"); |
| out.println("getting: " + value[0] + ", " + |
| value[1] + ", " + value[2] + ", " + |
| value[3]); |
| } else { |
| String[] rightVal = { "b", "23", "4", "3" }; |
| res = ValueComparer.equalValue(value, rightVal); |
| out.println("Expected b, 23, 4, 3"); |
| out.println("getting: " + value[0] + ", " + |
| value[1] + ", " + value[2] + ", " + |
| value[3]); |
| } |
| } |
| |
| if (res) { |
| out.println("Sorted correctly"); |
| } else { |
| out.println("Sorted uncorrectly"); |
| } |
| |
| return res; |
| } |
| }); |
| |
| return tEnv; |
| } |
| } // finish class ScCellCursorObj |
