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 org.openoffice.test.common.Testspace.*;
26 import static testlib.gui.AppTool.*;
27 import static testlib.gui.UIMap.*;
28 
29 import org.junit.After;
30 import org.junit.Before;
31 import org.junit.Rule;
32 import org.junit.Test;
33 import org.openoffice.test.common.Logger;
34 
35 import testlib.gui.SCTool;
36 
37 public class ValiditySampleFile {
38 
39 	@Before
40 	public void setUp() throws Exception {
41 		app.start(true);
42 	}
43 
44 	@After
45 	public void tearDown() throws Exception {
46 		app.stop();
47 
48 	}
49 
50 	/**
51 	 * Test open MS 2003 spreadsheet with ignore blank validity.
52 	 *
53 	 * @throws Exception
54 	 */
55 	@Test
56 	public void testFFCIgnoreBlank() throws Exception {
57 		// Open sample file
58 		String file = prepareData("sc/FFC252FFCSC_XML_Datarange0235.xls");
59 		open(file);
60 		calc.waitForExistence(10, 2);
61 
62 		SCTool.selectRange("D5");
63 		scInputBarInput.activate();
64 		for (int i = 1; i <= 10; i++)
65 			typeKeys("<backspace>");
66 		typeKeys("<enter>");
67 
68 		assertEquals("", SCTool.getCellText("D5"));
69 	}
70 
71 	/**
72 	 * Test open MS 2003 spreadsheet with ignore blank validity.
73 	 *
74 	 * @throws Exception
75 	 */
76 	@Test
77 	public void testFFCNotIgnoreBlank() throws Exception {
78 		// open sample file
79 		String file = prepareData("sc/FFC252FFCSC_XML_Datarange0205.xls");
80 		open(file);
81 		calc.waitForExistence(10, 2);
82 
83 		SCTool.selectRange("F5");
84 		scInputBarInput.activate();
85 		typeKeys("<backspace><enter>");
86 
87 		activeMsgBox.ok();
88 		assertEquals("8", SCTool.getCellText("F5"));
89 	}
90 
91 	/**
92 	 * test Cell is not locked after switch from validity cell to source cells
93 	 */
94 	@Test
95 	public void testNotLockCellFromValidityCell() {
96 		// open sample file on data path
97 		String file = prepareData("sc/sampledata.ods");
98 		open(file);
99 		calc.waitForExistence(10, 2);
100 
101 		SCTool.selectRange("F19");
102 		typeKeys("d<enter>");
103 		SCTool.selectRange("F17");
104 		typeKeys("Test<enter>");
105 
106 		assertEquals("Test", SCTool.getCellText("F17"));
107 	}
108 }
109