/************************************************************** * * 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 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: *