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