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