/************************************************************************
 *
 * Licensed Materials - Property of IBM.
 * (C) Copyright IBM Corporation 2003, 2012.  All Rights Reserved.
 * U.S. Government Users Restricted Rights:
 * Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
 *
 ************************************************************************/

package testcase.sc.validity;

import static testlib.AppUtil.*;
import static testlib.UIMap.*;

import java.io.File;

import org.junit.After;
import static org.junit.Assert.*;
import static org.openoffice.test.vcl.Tester.*;

import org.junit.Before;
import org.junit.Rule;
import org.junit.Test;
import org.openoffice.test.vcl.IDList;
import org.openoffice.test.vcl.widgets.VclMessageBox;


import testlib.CalcUtil;
import testlib.Log;


public class ValidityDateSupport1024Columns {
	private static IDList idList = new IDList(new File("./ids"));
	public static final VclMessageBox ActiveMsgBox = new VclMessageBox(idList.getId("UID_ACTIVE"), "Message on message box.");
	
	/**
	 * TestCapture helps us to do
	 * 1. Take a screenshot when failure occurs.
	 * 2. Collect extra data when OpenOffice crashes.
	 */	
	@Rule
	public Log LOG = new Log();
	
	/**
	 * initApp helps us to do 
	 * 1. Patch the OpenOffice to enable automation if necessary.
	 * 2. Start OpenOffice with automation enabled if necessary.
	 * 3. Reset OpenOffice to startcenter.
	 * 
	 * @throws java.lang.Exception
	 */
	@Before
	public void setUp() throws Exception {
		initApp();
	}
	
	/**
	 * test Allow Greater than or equal to Date type in Validity, support 1024 columns.
	 */
	@Test
	public void testValidityDateSupport1024Columns() {
		startcenter.menuItem("File->New->Spreadsheet").select();
		sleep(1);
		
		CalcUtil.selectRange("Sheet1.ALM1000");
		CalcUtil.selectRange("Sheet1.ALM1000:Sheet1.ALO1005");	
		
		calc.menuItem("Data->Validity...").select();	
		sleep(1);	
		
		SC_ValidityCriteriaTabpage.select();
		SC_ValidityCriteriaAllowList.select("Date");
		SC_ValidityDecimalCompareOperator.select("greater than");
		SC_ValiditySourceInput.setText("01/01/08");
		SC_ValidityErrorAlertTabPage.select();
		SC_ValidityShowErrorMessage.check();
		SC_ValidityErrorMessageTitle.setText("Stop to enter");
		SC_ValidityErrorMessage.setText("Invalid value");
		typeKeys("<tab>");
		typeKeys("<enter>");	
		sleep(1);
				
		CalcUtil.selectRange("Sheet1.ALM1001");
		SC_CellInput.activate();
		typeKeys("02/01/08");
		typeKeys("<enter>");
		assertEquals("02/01/08",CalcUtil.getCellText("Sheet1.ALM1001"));
		
		CalcUtil.selectRange("Sheet1.ALM1002");
		SC_CellInput.activate();
		typeKeys("01/02/08");
		typeKeys("<enter>");
		assertEquals("01/02/08",CalcUtil.getCellText("Sheet1.ALM1002"));
		
		CalcUtil.selectRange("Sheet1.ALM1003");
		SC_CellInput.activate();
		typeKeys("01/01/08");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.ALM1003"));

		CalcUtil.selectRange("Sheet1.AML1003");
		SC_CellInput.activate();
		typeKeys("12/31/07");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.AML1003"));
		
		}

}