[Libreoffice-commits] core.git: sc/qa
Stephan Bergmann
sbergman at redhat.com
Mon Feb 15 14:03:05 UTC 2016
sc/qa/complex/cellRanges/CheckXCellRangesQuery.java | 264 --------------------
1 file changed, 264 deletions(-)
New commits:
commit 73c0e1e94a285d6c062853a3e7ce874b807ba82e
Author: Stephan Bergmann <sbergman at redhat.com>
Date: Mon Feb 15 15:01:56 2016 +0100
Remove newly unused .java file
...after 8c125eca7f8a0dd2d59678cff2574bbccc70e536 "tdf#45904 move java based api
tests to c++"
Change-Id: Ia8469a6bcbb27658f4f26d41ff83389e37888bde
diff --git a/sc/qa/complex/cellRanges/CheckXCellRangesQuery.java b/sc/qa/complex/cellRanges/CheckXCellRangesQuery.java
deleted file mode 100644
index 288b4f5..0000000
--- a/sc/qa/complex/cellRanges/CheckXCellRangesQuery.java
+++ /dev/null
@@ -1,264 +0,0 @@
-/*
- * This file is part of the LibreOffice project.
- *
- * This Source Code Form is subject to the terms of the Mozilla Public
- * License, v. 2.0. If a copy of the MPL was not distributed with this
- * file, You can obtain one at http://mozilla.org/MPL/2.0/.
- *
- * This file incorporates work covered by the following license notice:
- *
- * 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 .
- */
-
-package complex.cellRanges;
-
-import com.sun.star.container.XIndexAccess;
-import com.sun.star.lang.XMultiServiceFactory;
-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.uno.AnyConverter;
-import com.sun.star.uno.Type;
-import com.sun.star.uno.UnoRuntime;
-import com.sun.star.uno.XInterface;
-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.*;
-
-import com.sun.star.container.XNamed;
-
-/**
- * Check the XCellRangesQuery interface on the SheetCell service. test was
- * created for bug i20044.
- */
-public class CheckXCellRangesQuery {
- XSpreadsheetDocument m_xSheetDoc = null;
- XCellRangesQuery m_xCell = null;
- XSpreadsheet m_xSpreadSheet = null;
- String sSheetName = "";
-
- /**
- * Creates Spreadsheet document and the test object, before the actual test
- * starts.
- */
- @Before
- public void before() throws Exception {
- // create a calc document
- final XMultiServiceFactory xMsf = UnoRuntime.queryInterface(
- XMultiServiceFactory.class, connection.getComponentContext()
- .getServiceManager());
- SOfficeFactory SOF = SOfficeFactory.getFactory(xMsf);
-
- System.out.println("creating a Spreadsheet document");
- m_xSheetDoc = SOF.createCalcDoc(null);
- XInterface oObj = null;
-
- 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 first sheet name
- XNamed xNamed = (XNamed) AnyConverter.toObject(new Type(XNamed.class),
- m_xSpreadSheet);
- sSheetName = xNamed.getName();
-
- // get the cell
- System.out.println("Getting a cell from sheet");
- oObj = m_xSpreadSheet.getCellByPosition(2, 3);
- m_xCell = UnoRuntime.queryInterface(XCellRangesQuery.class, oObj);
-
- // set one value for comparison.
- m_xSpreadSheet.getCellByPosition(1, 1).setValue(15);
- m_xSpreadSheet.getCellByPosition(1, 3).setValue(5);
- m_xSpreadSheet.getCellByPosition(2, 1).setFormula("=B2+B4");
-
- }
-
- /**
- * 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 (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(sSheetName + ".C4"));
- // compare an empty cell with a cell with a value
- assertTrue(
- "\tQuery column differences did not return the correct value.",
- _queryRowDifferences(sSheetName + ".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(sSheetName + ".C4"));
- // compare an cell with value 5 with a cell with value 15
- assertTrue(
- "\tQuery column differences did not return the correct value.",
- _queryRowDifferences(sSheetName + ".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();
-
-}
More information about the Libreoffice-commits
mailing list