1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
|
/*
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
*/
package ifc.sheet;
import lib.MultiMethodTest;
import com.sun.star.sheet.XCellRangeAddressable;
import com.sun.star.sheet.XSheetCellCursor;
import com.sun.star.sheet.XUsedAreaCursor;
import com.sun.star.table.CellRangeAddress;
import com.sun.star.uno.UnoRuntime;
/**
* Testing <code>com.sun.star.sheet.XUsedAreaCursor</code>
* interface methods :
* <ul>
* <li><code> gotoStartOfUsedArea()</code></li>
* <li><code> gotoEndOfUsedArea()</code></li>
* </ul> <p>
* Component must also implement the following interfaces :
* <ul>
* <li> <code> com.sun.star.XCellRangeAddressable </code> : to check the current
* position of the cursor </li>
* <ul> <p>
* @see com.sun.star.sheet.XUsedAreaCursor
*/
public class _XUsedAreaCursor extends MultiMethodTest {
public XUsedAreaCursor oObj = null;
public XSheetCellCursor oC = null;
CellRangeAddress sAddr = null;
/**
* Test points the cursor to the start of used area, expands cursor to the
* end of the used area, gets and checks current range address, then
* points the cursor to the end of the used area, gets and checks current
* range address again. <p>
* Has <b> OK </b> status if the range address expands at all used area
* in first case and if the range address just points to the cell at the end
* of the used area in second case. <p>
*/
public void _gotoEndOfUsedArea() {
boolean result = true ;
XCellRangeAddressable oAddr = UnoRuntime.queryInterface (XCellRangeAddressable.class, oObj) ;
// first with true argument
oObj.gotoStartOfUsedArea(false);
oObj.gotoEndOfUsedArea(true);
sAddr = oAddr.getRangeAddress();
result &= (sAddr.StartColumn == 1);
result &= (sAddr.StartRow == 1);
result &= (sAddr.EndColumn == 4);
result &= (sAddr.EndRow == 5);
oObj.gotoEndOfUsedArea(false);
sAddr = oAddr.getRangeAddress();
result &= (sAddr.StartColumn == 4);
result &= (sAddr.StartRow == 5);
result &= (sAddr.EndColumn == 4);
result &= (sAddr.EndRow == 5);
tRes.tested("gotoEndOfUsedArea()", result) ;
}
/**
* Test points the cursor to the end of used area, expands cursor to the
* start of the used area, gets and checks current range address, then
* points the cursor to the start of the used area, gets and checks current
* range address again. <p>
* Has <b> OK </b> status if the range address expands at all used area
* in first case and if the range address just points to the cell at the
* start of the used area in second case. <p>
*/
public void _gotoStartOfUsedArea() {
XCellRangeAddressable oAddr = UnoRuntime.queryInterface (XCellRangeAddressable.class, oObj) ;
boolean result = true ;
// with true parameter first
oObj.gotoEndOfUsedArea(false);
oObj.gotoStartOfUsedArea(true);
sAddr = oAddr.getRangeAddress();
result &= (sAddr.StartColumn == 1);
result &= (sAddr.StartRow == 1);
result &= (sAddr.EndColumn == 4);
result &= (sAddr.EndRow == 5);
// now testing with false parameter
oObj.gotoStartOfUsedArea(false);
sAddr = oAddr.getRangeAddress();
result &= (sAddr.StartColumn == 1);
result &= (sAddr.StartRow == 1);
result &= (sAddr.EndColumn == 1);
result &= (sAddr.EndRow == 1);
tRes.tested("gotoStartOfUsedArea()", result) ;
} // finished gotoStartOfUsedArea
/**
* Forces object environment recreation.
*/
@Override
protected void after() {
this.disposeEnvironment();
}
} // finished class _XUsedAreaCursor
|