test/testuno/source/fvt/uno/sc/chart/ChartGrid.java - openoffice - Git at Google

 /**************************************************************
  *
  * 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 fvt.uno.sc.chart;

 import static org.junit.Assert.assertArrayEquals;

 import java.util.Arrays;
 import java.util.Collection;

 import org.junit.After;
 import org.junit.AfterClass;
 import org.junit.Before;
 import org.junit.BeforeClass;
 import org.junit.Test;
 import org.junit.runner.RunWith;
 import org.junit.runners.Parameterized;
 import org.junit.runners.Parameterized.Parameters;
 import org.openoffice.test.uno.UnoApp;

 import testlib.uno.SCUtil;

 import com.sun.star.awt.Rectangle;
 import com.sun.star.chart.XChartDocument;
 import com.sun.star.chart.XDiagram;
 import com.sun.star.lang.XComponent;
 import com.sun.star.sheet.XSpreadsheet;
 import com.sun.star.sheet.XSpreadsheetDocument;
 import com.sun.star.table.CellRangeAddress;

 /**
  *  Check Grids in chart can be applied and saved
  *
  */
 @RunWith(value = Parameterized.class)
 public class ChartGrid {

 	private Boolean[] majorGrids;
 	private Boolean[] minorGrids;
 	private String inputType;
 	private double[][] numberData;
 	private String fileType;

 	private static final UnoApp unoApp = new UnoApp();

 	XComponent scComponent = null;
 	XSpreadsheetDocument scDocument = null;

 	@Parameters
 	public static Collection<Object[]> data() throws Exception {
 		double[][] numberData1 = {
 				{10, 20, 30, 40},
 				{20, 40.3, 50, 80},
 				{40, 20, 30, 10},
 				{10, -10, 0, -30}
 		};
 		Boolean[][] gridsList = {
 				{false, false, false}, //[0] no grid
 				{true, false, false}, // [1] X
 				{false, true, false}, // [2] Y
 				{true, true, false}, // [3] X & Y
 				{true, true, true}, // [4] X & Y & Z
 				{false, false, true}, // [5] Z
 				{false, true, true}, // [6] Y & Z
 				{true, false, true} // [7] X & Z
 		};

 		return Arrays.asList(new Object[][] {
 			{gridsList[0], null, "com.sun.star.chart.BarDiagram", numberData1, "ods"},
 			{gridsList[2], gridsList[3], "com.sun.star.chart.BarDiagram", numberData1, "ods"},
 			{gridsList[2], gridsList[4], "com.sun.star.chart.BarDiagram", numberData1, "ods"},
 			{gridsList[6], gridsList[7], "com.sun.star.chart.BarDiagram", numberData1, "ods"},
 			{gridsList[1], gridsList[5], "com.sun.star.chart.BarDiagram", numberData1, "ods"},
 			{gridsList[4], gridsList[4], "com.sun.star.chart.BarDiagram", numberData1, "ods"},

 			{gridsList[0], null, "com.sun.star.chart.BarDiagram", numberData1, "xls"},
 			{gridsList[2], gridsList[3], "com.sun.star.chart.BarDiagram", numberData1, "xls"}
 //			{null, gridsList[4], "com.sun.star.chart.BarDiagram", numberData1, "xls"},
 //			{gridsList[6], gridsList[7], "com.sun.star.chart.BarDiagram", numberData1, "xls"},
 //			{gridsList[1], gridsList[5], "com.sun.star.chart.BarDiagram", numberData1, "xls"},
 //			{gridsList[4], gridsList[4], "com.sun.star.chart.BarDiagram", numberData1, "xls"}

 		});
 	}

 	public ChartGrid(Boolean[] majorGrids, Boolean[] minorGrids, String inputType, double[][] numberData, String fileType) {
 		this.majorGrids = majorGrids;
 		this.minorGrids = minorGrids;
 		this.inputType = inputType;
 		this.numberData = numberData;
 		this.fileType = fileType;
 	}

 	@Before
 	public void setUp() throws Exception {
 		scComponent = unoApp.newDocument("scalc");
 		scDocument = SCUtil.getSCDocument(scComponent);
 	}

 	@After
 	public void tearDown() throws Exception {
 		unoApp.closeDocument(scComponent);

 	}

 	@BeforeClass
 	public static void setUpConnection() throws Exception {
 		unoApp.start();
 	}

 	@AfterClass
 	public static void tearDownConnection() throws InterruptedException, Exception {
 		unoApp.close();
 		SCUtil.clearTempDir();
 	}

 	/**
 	 * Enable different types of grids in chart.
 	 * 1. Create a spreadsheet file.
 	 * 2. Input number in a cell range and create a 2D chart.
 	 * 3. Enable grids of X/Y axis in chart.
 	 * 4. Save file as ODF/MSBinary format.
 	 * 5. Close and reopen file.  -> Check the grid setting.
 	 * @throws Exception
 	 */
 	@Test
 	public void testCreateXYGrid() throws Exception {
 		String fileName = "testCreateXYGrid";
 		String chartName = "testChart";
 		String cellRangeName = "A1:D4";
 		Boolean[][] expected = {
 				{false, true, false},
 				{false, false, false}
 		};
 		Boolean[][] results = {
 				{false, false, false},
 				{false, false, false}
 		};

 		if (inputType.equals("com.sun.star.chart.StockDiagram")) {
 			cellRangeName = "A1:C4";
 		}
 		if (fileType.equalsIgnoreCase("xls")) {
 			chartName = "Object 1";
 		}

 		XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument);

 		SCUtil.setValueToCellRange(sheet, 0, 0, numberData);

 		CellRangeAddress[] cellAddress = new CellRangeAddress[1];
 		cellAddress[0] = SCUtil.getChartDataRangeByName(sheet, cellRangeName);
 		Rectangle rectangle = new Rectangle(1000, 1000, 15000, 9500);
 		XChartDocument xChartDocument = null;
 		xChartDocument = SCUtil.createChart(sheet, rectangle, cellAddress, chartName);
 		SCUtil.setChartType(xChartDocument, inputType);
 		XDiagram xDiagram = xChartDocument.getDiagram();

 		if (majorGrids != null) {
 			SCUtil.setProperties(xDiagram, "HasXAxisGrid", majorGrids[0]);
 			SCUtil.setProperties(xDiagram, "HasYAxisGrid", majorGrids[1]);
 			expected[0][0] = majorGrids[0];
 			expected[0][1] = majorGrids[1];
 		}
 		if (minorGrids != null) {
 			SCUtil.setProperties(xDiagram, "HasXAxisHelpGrid", minorGrids[0]);
 			SCUtil.setProperties(xDiagram, "HasYAxisHelpGrid", minorGrids[1]);
 			expected[1][0] = minorGrids[0];
 			expected[1][1] = minorGrids[1];
 		}

 		SCUtil.saveFileAs(scComponent, fileName, fileType);
 		scDocument = SCUtil.reloadFile(unoApp, scDocument, fileName + "." + fileType);
 		sheet = SCUtil.getCurrentSheet(scDocument);

 		xChartDocument = SCUtil.getChartByName(sheet, chartName);
 		xDiagram = xChartDocument.getDiagram();
 		results[0][0] = (Boolean) SCUtil.getProperties(xDiagram, "HasXAxisGrid");
 		results[0][1] = (Boolean) SCUtil.getProperties(xDiagram, "HasYAxisGrid");
 		results[1][0] = (Boolean) SCUtil.getProperties(xDiagram, "HasXAxisHelpGrid");
 		results[1][1] = (Boolean) SCUtil.getProperties(xDiagram, "HasYAxisHelpGrid");

 		SCUtil.closeFile(scDocument);

 		assertArrayEquals("Incorrect chart grids got in ." + fileType + " file.", expected, results);

 	}

 	/**
 	 * Enable different types of grids in chart.
 	 * 1. Create a spreadsheet file.
 	 * 2. Input number in a cell range and create a 3D chart.
 	 * 3. Enable grids of X/Y/Z axes in chart.
 	 * 4. Save file as ODF/MSBinary format.
 	 * 5. Close and reopen file.  -> Check the grid setting.
 	 * @throws Exception
 	 */
 	@Test
 	public void testCreateXYZGrid() throws Exception {
 		String fileName = "testCreateXYZGrid";
 		String chartName = "testChart";
 		String cellRangeName = "A1:D4";
 		Boolean[][] expected = {
 				{false, true, false},
 				{false, false, false}
 		};
 		Boolean[][] results = {
 				{false, false, false},
 				{false, false, false}
 		};

 		if (inputType.equals("com.sun.star.chart.StockDiagram")) {
 			cellRangeName = "A1:C4";
 		}
 		if (fileType.equalsIgnoreCase("xls")) {
 			chartName = "Object 1";
 		}

 		XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument);

 		SCUtil.setValueToCellRange(sheet, 0, 0, numberData);

 		CellRangeAddress[] cellAddress = new CellRangeAddress[1];
 		cellAddress[0] = SCUtil.getChartDataRangeByName(sheet, cellRangeName);
 		Rectangle rectangle = new Rectangle(1000, 1000, 15000, 9500);
 		XChartDocument xChartDocument = null;
 		xChartDocument = SCUtil.createChart(sheet, rectangle, cellAddress, chartName);
 		SCUtil.setChartType(xChartDocument, inputType);
 		SCUtil.setProperties(xChartDocument.getDiagram(), "Dim3D", true);
 		XDiagram xDiagram = xChartDocument.getDiagram();

 		if (majorGrids != null) {
 			SCUtil.setProperties(xDiagram, "HasXAxisGrid", majorGrids[0]);
 			SCUtil.setProperties(xDiagram, "HasYAxisGrid", majorGrids[1]);
 			SCUtil.setProperties(xDiagram, "HasZAxisGrid", majorGrids[2]);
 			expected[0][0] = majorGrids[0];
 			expected[0][1] = majorGrids[1];
 			expected[0][2] = majorGrids[2];
 		}
 		if (minorGrids != null) {
 			SCUtil.setProperties(xDiagram, "HasXAxisHelpGrid", minorGrids[0]);
 			SCUtil.setProperties(xDiagram, "HasYAxisHelpGrid", minorGrids[1]);
 			SCUtil.setProperties(xDiagram, "HasZAxisHelpGrid", minorGrids[2]);
 			expected[1][0] = minorGrids[0];
 			expected[1][1] = minorGrids[1];
 			expected[1][2] = minorGrids[2];
 		}

 		SCUtil.saveFileAs(scComponent, fileName, fileType);
 		scDocument = SCUtil.reloadFile(unoApp, scDocument, fileName + "." + fileType);
 		sheet = SCUtil.getCurrentSheet(scDocument);

 		xChartDocument = SCUtil.getChartByName(sheet, chartName);
 		xDiagram = xChartDocument.getDiagram();
 		results[0][0] = (Boolean) SCUtil.getProperties(xDiagram, "HasXAxisGrid");
 		results[0][1] = (Boolean) SCUtil.getProperties(xDiagram, "HasYAxisGrid");
 		results[0][2] = (Boolean) SCUtil.getProperties(xDiagram, "HasZAxisGrid");
 		results[1][0] = (Boolean) SCUtil.getProperties(xDiagram, "HasXAxisHelpGrid");
 		results[1][1] = (Boolean) SCUtil.getProperties(xDiagram, "HasYAxisHelpGrid");
 		results[1][2] = (Boolean) SCUtil.getProperties(xDiagram, "HasZAxisHelpGrid");

 		SCUtil.closeFile(scDocument);

 		assertArrayEquals("Incorrect chart grids got in ." + fileType + " file.", expected, results);

 	}

 }
	/**************************************************************
	*
	* 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 fvt.uno.sc.chart;

	import static org.junit.Assert.assertArrayEquals;

	import java.util.Arrays;
	import java.util.Collection;

	import org.junit.After;
	import org.junit.AfterClass;
	import org.junit.Before;
	import org.junit.BeforeClass;
	import org.junit.Test;
	import org.junit.runner.RunWith;
	import org.junit.runners.Parameterized;
	import org.junit.runners.Parameterized.Parameters;
	import org.openoffice.test.uno.UnoApp;

	import testlib.uno.SCUtil;

	import com.sun.star.awt.Rectangle;
	import com.sun.star.chart.XChartDocument;
	import com.sun.star.chart.XDiagram;
	import com.sun.star.lang.XComponent;
	import com.sun.star.sheet.XSpreadsheet;
	import com.sun.star.sheet.XSpreadsheetDocument;
	import com.sun.star.table.CellRangeAddress;

	/**
	* Check Grids in chart can be applied and saved
	*
	*/
	@RunWith(value = Parameterized.class)
	public class ChartGrid {

	private Boolean[] majorGrids;
	private Boolean[] minorGrids;
	private String inputType;
	private double[][] numberData;
	private String fileType;

	private static final UnoApp unoApp = new UnoApp();

	XComponent scComponent = null;
	XSpreadsheetDocument scDocument = null;

	@Parameters
	public static Collection<Object[]> data() throws Exception {
	double[][] numberData1 = {
	{10, 20, 30, 40},
	{20, 40.3, 50, 80},
	{40, 20, 30, 10},
	{10, -10, 0, -30}
	};
	Boolean[][] gridsList = {
	{false, false, false}, //[0] no grid
	{true, false, false}, // [1] X
	{false, true, false}, // [2] Y
	{true, true, false}, // [3] X & Y
	{true, true, true}, // [4] X & Y & Z
	{false, false, true}, // [5] Z
	{false, true, true}, // [6] Y & Z
	{true, false, true} // [7] X & Z
	};

	return Arrays.asList(new Object[][] {
	{gridsList[0], null, "com.sun.star.chart.BarDiagram", numberData1, "ods"},
	{gridsList[2], gridsList[3], "com.sun.star.chart.BarDiagram", numberData1, "ods"},
	{gridsList[2], gridsList[4], "com.sun.star.chart.BarDiagram", numberData1, "ods"},
	{gridsList[6], gridsList[7], "com.sun.star.chart.BarDiagram", numberData1, "ods"},
	{gridsList[1], gridsList[5], "com.sun.star.chart.BarDiagram", numberData1, "ods"},
	{gridsList[4], gridsList[4], "com.sun.star.chart.BarDiagram", numberData1, "ods"},

	{gridsList[0], null, "com.sun.star.chart.BarDiagram", numberData1, "xls"},
	{gridsList[2], gridsList[3], "com.sun.star.chart.BarDiagram", numberData1, "xls"}
	// {null, gridsList[4], "com.sun.star.chart.BarDiagram", numberData1, "xls"},
	// {gridsList[6], gridsList[7], "com.sun.star.chart.BarDiagram", numberData1, "xls"},
	// {gridsList[1], gridsList[5], "com.sun.star.chart.BarDiagram", numberData1, "xls"},
	// {gridsList[4], gridsList[4], "com.sun.star.chart.BarDiagram", numberData1, "xls"}

	});
	}

	public ChartGrid(Boolean[] majorGrids, Boolean[] minorGrids, String inputType, double[][] numberData, String fileType) {
	this.majorGrids = majorGrids;
	this.minorGrids = minorGrids;
	this.inputType = inputType;
	this.numberData = numberData;
	this.fileType = fileType;
	}

	@Before
	public void setUp() throws Exception {
	scComponent = unoApp.newDocument("scalc");
	scDocument = SCUtil.getSCDocument(scComponent);
	}

	@After
	public void tearDown() throws Exception {
	unoApp.closeDocument(scComponent);

	}

	@BeforeClass
	public static void setUpConnection() throws Exception {
	unoApp.start();
	}

	@AfterClass
	public static void tearDownConnection() throws InterruptedException, Exception {
	unoApp.close();
	SCUtil.clearTempDir();
	}

	/**
	* Enable different types of grids in chart.
	* 1. Create a spreadsheet file.
	* 2. Input number in a cell range and create a 2D chart.
	* 3. Enable grids of X/Y axis in chart.
	* 4. Save file as ODF/MSBinary format.
	* 5. Close and reopen file. -> Check the grid setting.
	* @throws Exception
	*/
	@Test
	public void testCreateXYGrid() throws Exception {
	String fileName = "testCreateXYGrid";
	String chartName = "testChart";
	String cellRangeName = "A1:D4";
	Boolean[][] expected = {
	{false, true, false},
	{false, false, false}
	};
	Boolean[][] results = {
	{false, false, false},
	{false, false, false}
	};

	if (inputType.equals("com.sun.star.chart.StockDiagram")) {
	cellRangeName = "A1:C4";
	}
	if (fileType.equalsIgnoreCase("xls")) {
	chartName = "Object 1";
	}

	XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument);

	SCUtil.setValueToCellRange(sheet, 0, 0, numberData);

	CellRangeAddress[] cellAddress = new CellRangeAddress[1];
	cellAddress[0] = SCUtil.getChartDataRangeByName(sheet, cellRangeName);
	Rectangle rectangle = new Rectangle(1000, 1000, 15000, 9500);
	XChartDocument xChartDocument = null;
	xChartDocument = SCUtil.createChart(sheet, rectangle, cellAddress, chartName);
	SCUtil.setChartType(xChartDocument, inputType);
	XDiagram xDiagram = xChartDocument.getDiagram();

	if (majorGrids != null) {
	SCUtil.setProperties(xDiagram, "HasXAxisGrid", majorGrids[0]);
	SCUtil.setProperties(xDiagram, "HasYAxisGrid", majorGrids[1]);
	expected[0][0] = majorGrids[0];
	expected[0][1] = majorGrids[1];
	}
	if (minorGrids != null) {
	SCUtil.setProperties(xDiagram, "HasXAxisHelpGrid", minorGrids[0]);
	SCUtil.setProperties(xDiagram, "HasYAxisHelpGrid", minorGrids[1]);
	expected[1][0] = minorGrids[0];
	expected[1][1] = minorGrids[1];
	}

	SCUtil.saveFileAs(scComponent, fileName, fileType);
	scDocument = SCUtil.reloadFile(unoApp, scDocument, fileName + "." + fileType);
	sheet = SCUtil.getCurrentSheet(scDocument);

	xChartDocument = SCUtil.getChartByName(sheet, chartName);
	xDiagram = xChartDocument.getDiagram();
	results[0][0] = (Boolean) SCUtil.getProperties(xDiagram, "HasXAxisGrid");
	results[0][1] = (Boolean) SCUtil.getProperties(xDiagram, "HasYAxisGrid");
	results[1][0] = (Boolean) SCUtil.getProperties(xDiagram, "HasXAxisHelpGrid");
	results[1][1] = (Boolean) SCUtil.getProperties(xDiagram, "HasYAxisHelpGrid");

	SCUtil.closeFile(scDocument);

	assertArrayEquals("Incorrect chart grids got in ." + fileType + " file.", expected, results);

	}

	/**
	* Enable different types of grids in chart.
	* 1. Create a spreadsheet file.
	* 2. Input number in a cell range and create a 3D chart.
	* 3. Enable grids of X/Y/Z axes in chart.
	* 4. Save file as ODF/MSBinary format.
	* 5. Close and reopen file. -> Check the grid setting.
	* @throws Exception
	*/
	@Test
	public void testCreateXYZGrid() throws Exception {
	String fileName = "testCreateXYZGrid";
	String chartName = "testChart";
	String cellRangeName = "A1:D4";
	Boolean[][] expected = {
	{false, true, false},
	{false, false, false}
	};
	Boolean[][] results = {
	{false, false, false},
	{false, false, false}
	};

	if (inputType.equals("com.sun.star.chart.StockDiagram")) {
	cellRangeName = "A1:C4";
	}
	if (fileType.equalsIgnoreCase("xls")) {
	chartName = "Object 1";
	}

	XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument);

	SCUtil.setValueToCellRange(sheet, 0, 0, numberData);

	CellRangeAddress[] cellAddress = new CellRangeAddress[1];
	cellAddress[0] = SCUtil.getChartDataRangeByName(sheet, cellRangeName);
	Rectangle rectangle = new Rectangle(1000, 1000, 15000, 9500);
	XChartDocument xChartDocument = null;
	xChartDocument = SCUtil.createChart(sheet, rectangle, cellAddress, chartName);
	SCUtil.setChartType(xChartDocument, inputType);
	SCUtil.setProperties(xChartDocument.getDiagram(), "Dim3D", true);
	XDiagram xDiagram = xChartDocument.getDiagram();

	if (majorGrids != null) {
	SCUtil.setProperties(xDiagram, "HasXAxisGrid", majorGrids[0]);
	SCUtil.setProperties(xDiagram, "HasYAxisGrid", majorGrids[1]);
	SCUtil.setProperties(xDiagram, "HasZAxisGrid", majorGrids[2]);
	expected[0][0] = majorGrids[0];
	expected[0][1] = majorGrids[1];
	expected[0][2] = majorGrids[2];
	}
	if (minorGrids != null) {
	SCUtil.setProperties(xDiagram, "HasXAxisHelpGrid", minorGrids[0]);
	SCUtil.setProperties(xDiagram, "HasYAxisHelpGrid", minorGrids[1]);
	SCUtil.setProperties(xDiagram, "HasZAxisHelpGrid", minorGrids[2]);
	expected[1][0] = minorGrids[0];
	expected[1][1] = minorGrids[1];
	expected[1][2] = minorGrids[2];
	}

	SCUtil.saveFileAs(scComponent, fileName, fileType);
	scDocument = SCUtil.reloadFile(unoApp, scDocument, fileName + "." + fileType);
	sheet = SCUtil.getCurrentSheet(scDocument);

	xChartDocument = SCUtil.getChartByName(sheet, chartName);
	xDiagram = xChartDocument.getDiagram();
	results[0][0] = (Boolean) SCUtil.getProperties(xDiagram, "HasXAxisGrid");
	results[0][1] = (Boolean) SCUtil.getProperties(xDiagram, "HasYAxisGrid");
	results[0][2] = (Boolean) SCUtil.getProperties(xDiagram, "HasZAxisGrid");
	results[1][0] = (Boolean) SCUtil.getProperties(xDiagram, "HasXAxisHelpGrid");
	results[1][1] = (Boolean) SCUtil.getProperties(xDiagram, "HasYAxisHelpGrid");
	results[1][2] = (Boolean) SCUtil.getProperties(xDiagram, "HasZAxisHelpGrid");

	SCUtil.closeFile(scDocument);

	assertArrayEquals("Incorrect chart grids got in ." + fileType + " file.", expected, results);

	}

	}