test/testuno/source/fvt/uno/sc/cell/CellProtected.java

/**************************************************************
 *
 * 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.cell;

import static org.junit.Assert.assertEquals;

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 testlib.uno.TestUtil;
import testlib.uno.CellInfo;

import com.sun.star.lang.XComponent;
import com.sun.star.sheet.XSpreadsheet;
import com.sun.star.sheet.XSpreadsheetDocument;
import com.sun.star.table.XCell;
import com.sun.star.util.CellProtection;


/**
 *  Check the cell protection setting can be applied and saved
 *
 */
@RunWith(value = Parameterized.class)
public class CellProtected {

	private Boolean[] expected;
	private String inputType;
	private CellProtection inputProtectProps;
	private String fileType;

	private static final UnoApp unoApp = new UnoApp();

	XComponent scComponent = null;
	XSpreadsheetDocument scDocument = null;

	@Parameters
	public static Collection<Object[]> data() throws Exception {
		Boolean[][] list = {
				{true, false, false, false}, //lock cell
				{false, true, false, false}, //hide formula
				{false, false, true, false}, //hide cell
				{false, false, false, true}, //hide cell from print

				{true, true, true, false}
		};

		return Arrays.asList(new Object[][] {
			{list[0], "CellProtection", list[0], "ods"},
			{list[1], "CellProtection", list[1], "ods"},
			{list[4], "CellProtection", list[2], "ods"},
			{list[3], "CellProtection", list[3], "ods"}
		});
	}

	public CellProtected(Boolean[] expected, String inputType, Boolean[] inputData, String fileType) {

		CellProtection protection = new CellProtection();

		protection.IsLocked = inputData[0];
		protection.IsFormulaHidden = inputData[1];
		protection.IsHidden = inputData[2];
		protection.IsPrintHidden = inputData[3];

		this.expected = expected;
		this.inputType = inputType;
		this.inputProtectProps = protection;
		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();
	}

	/**
	 * Check the cell protection settings
	 * 1. Create a spreadsheet file.
	 * 2. Input number, text, formula into many cell.
	 * 3. Set cell protection properties. (Clock, HiddenFormula, Hidden Cell, Hidden Cell from Printing)
	 * 4. Save file as ODF/MSBinary format.
	 * 5. Close and reopen file.  -> Check the cell protection setting.
	 * @throws Exception
	 */
	@Test
	public void testCellProtected() throws Exception {
		String fileName = "testCellProtected";

		int cellNum = 5;
		XCell[] cells = new XCell[cellNum];
		CellProtection[] results = new CellProtection[cellNum];
		CellInfo cInfo = TestUtil.randCell(10, 10);

		XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument);

		for (int i = 0; i < cellNum; i++) {
			cells[i] = sheet.getCellByPosition(cInfo.getCol() + i, cInfo.getRow());
		}

		cells[0].setValue(2134359.343223);
		SCUtil. setTextToCell(cells[1], inputType);
		cells[2].setFormula("=Average(A1:A10)");
		cells[3].setValue(-0.0003424);

		for (int i = 0; i < cellNum; i++) {
			SCUtil.setCellProperties(cells[i], inputType, inputProtectProps);
		}

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

		for (int i = 0; i < cellNum; i++) {
			cells[i] = sheet.getCellByPosition(cInfo.getCol() + i, cInfo.getRow());
			results[i] = (CellProtection) SCUtil.getCellProperties(cells[i], inputType);
		}

		SCUtil.closeFile(scDocument);

		for (int i = 0; i < cellNum; i++) {
			assertEquals("Incorrect cell protection (IsLocked) value got in ." + fileType + " file.", expected[0], results[i].IsLocked);
			assertEquals("Incorrect cell protection(IsFormulaHidden) value got in ." + fileType + " file.", expected[1], results[i].IsFormulaHidden);
			assertEquals("Incorrect cell protection(IsHidden) value got in ." + fileType + " file.", expected[2], results[i].IsHidden);
			assertEquals("Incorrect cell protection(IsPrintHidden) value got in ." + fileType + " file.", expected[3], results[i].IsPrintHidden);
		}
	}

}