1 /**************************************************************
2  *
3  * Licensed to the Apache Software Foundation (ASF) under one
4  * or more contributor license agreements.  See the NOTICE file
5  * distributed with this work for additional information
6  * regarding copyright ownership.  The ASF licenses this file
7  * to you under the Apache License, Version 2.0 (the
8  * "License"); you may not use this file except in compliance
9  * with the License.  You may obtain a copy of the License at
10  *
11  *   http://www.apache.org/licenses/LICENSE-2.0
12  *
13  * Unless required by applicable law or agreed to in writing,
14  * software distributed under the License is distributed on an
15  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16  * KIND, either express or implied.  See the License for the
17  * specific language governing permissions and limitations
18  * under the License.
19  *
20  *************************************************************/
21 
22 package fvt.gui.sc.validity;
23 
24 import static org.junit.Assert.*;
25 import static testlib.gui.AppTool.*;
26 import static testlib.gui.UIMap.*;
27 
28 import org.junit.After;
29 import org.junit.Before;
30 import org.junit.Rule;
31 import org.junit.Test;
32 import org.openoffice.test.common.Logger;
33 
34 import testlib.gui.AppTool;
35 import testlib.gui.SCTool;
36 
37 public class ValidityDateSupport1024Columns {
38 
39 	@Rule
40 	public Logger log = Logger.getLogger(this);
41 
42 	@Before
setUp()43 	public void setUp() throws Exception {
44 		app.start(true);
45 		AppTool.newSpreadsheet();
46 	}
47 
48 	@After
tearDown()49 	public void tearDown() throws Exception {
50 		app.stop();
51 	}
52 
53 	/**
54 	 * test Allow Greater than or equal to Date type in Validity, support 1024
55 	 * columns.
56 	 */
57 	@Test
testValidityDateSupport1024Columns()58 	public void testValidityDateSupport1024Columns() {
59 		SCTool.selectRange("ALM1000:ALO1005");
60 		app.dispatch(".uno:Validation");
61 
62 		scValidityCriteriaTabpage.select();
63 		scValidityCriteriaAllowList.select(3); // "Date"
64 		scValidityDecimalCompareOperator.select(2); // "greater than"
65 		scValiditySourceInput.setText("01/01/08");
66 		scValidityErrorAlertTabPage.select();
67 		scValidityShowErrorMessage.check();
68 		scValidityErrorMessageTitle.setText("Stop to enter");
69 		scValidityErrorMessage.setText("Invalid value");
70 		scValidityErrorAlertTabPage.ok();
71 
72 		SCTool.selectRange("ALM1001");
73 		scInputBarInput.activate();
74 		typeKeys("02/01/08<enter>");
75 		assertEquals("Cell text in ALM1001 is not 02/01/08","02/01/08", SCTool.getCellText("ALM1001"));
76 
77 		SCTool.selectRange("ALM1002");
78 		scInputBarInput.activate();
79 		typeKeys("01/02/08<enter>");
80 		assertEquals("Cell text in ALM1002 is not 01/02/08","01/02/08", SCTool.getCellText("ALM1002"));
81 
82 		SCTool.selectRange("ALM1003");
83 		scInputBarInput.activate();
84 		typeKeys("01/01/08<enter>");
85 		assertEquals("Have no alert message","Invalid value", activeMsgBox.getMessage());
86 		activeMsgBox.ok();
87 		assertEquals("Validity have not filter invalid value","", SCTool.getCellText("ALM1003"));
88 
89 		SCTool.selectRange("AML1003");
90 		scInputBarInput.activate();
91 		typeKeys("12/31/07<enter>");
92 		assertEquals("Have no alert message","Invalid value", activeMsgBox.getMessage());
93 		activeMsgBox.ok();
94 		assertEquals("Validity have not filter invalid value","", SCTool.getCellText("AML1003"));
95 	}
96 }
97