blob: 51bc373efc2c33cde1cdd459051056f6282bf2cb (
plain)
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
|
'encoding UTF-8 Do not remove or change this line!
'**************************************************************************
'* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
'*
'* Copyright 2008 by Sun Microsystems, Inc.
'*
'* OpenOffice.org - a multi-platform office productivity suite
'*
'* $RCSfile: t_spreadsheet_tools1.inc,v $
'*
'* $Revision: 1.1 $
'*
'* last change: $Author: jsi $ $Date: 2008-06-13 10:27:08 $
'*
'* This file is part of OpenOffice.org.
'*
'* OpenOffice.org is free software: you can redistribute it and/or modify
'* it under the terms of the GNU Lesser General Public License version 3
'* only, as published by the Free Software Foundation.
'*
'* OpenOffice.org is distributed in the hope that it will be useful,
'* but WITHOUT ANY WARRANTY; without even the implied warranty of
'* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
'* GNU Lesser General Public License version 3 for more details
'* (a copy is included in the LICENSE file that accompanied this code).
'*
'* You should have received a copy of the GNU Lesser General Public License
'* version 3 along with OpenOffice.org. If not, see
'* <http://www.openoffice.org/license.html>
'* for a copy of the LGPLv3 License.
'*
'/***********************************************************************
'*
'* owner : oliver.craemer@sun.com
'*
'* short description : Global tools for spreadsheet
'*
'************************************************************************
'*
' #1 fGotoCell ' Set active cell in a spreadhseet to a defined cell adress
'
'*
'\***********************************************************************
function fGotoCell (sCelladdress as String) as integer
'/// The function sets the active cell in a spreadsheet to a defined cell address.
'/// Input: sCelladdress as String
'/// Output: <ul><li>0 = active cell has changed successfully</li>
'///+ <li>1 = active cell hasn't changed</li>
Dim sActualPlace as string
const CFN = "qa:qatesttool:global:tools:inc:t_spreadsheet_tools1.inc:fGotoCell: "
'function will return 1 if something goes wrong
fGotoCell = 1
Kontext "RechenleisteCalc"
'/// If the spreadsheet <i>formula toolbar</i> isn't available make them
'/// + available with View / Toolbars / Formula Bar
if NOT RechenleisteCalc.Exists(1) then
ViewToolbarsFormulaBar
end if
try
Kontext "RechenleisteCalc"
sActualPlace = AktiverZellbereich.GetSelText
if UCase(sActualPlace) = UCase(sCelladdress) then
fGotocell = 0
exit function
else
sActualPlace = ""
'/// Type the cell address into the <i>name box</i>
AktiverZellbereich.SetText sCelladdress
'///+ and press RETURN
AktiverZellbereich.TypeKeys "<RETURN>"
sleep(1)
'/// If the <i>name box<i>' address has been changed to the expected
'///+ cell address the function was successfull.
sActualPlace = AktiverZellbereich.GetSelText
if UCase(sActualPlace) = UCase(sCelladdress) then
fGotocell = 0
else
warnlog CFN & "The cell address has not been changed!"
end if
end if
catch
warnlog CFN & "Something unexpected happened! The cell address has not been changed!"
fGotocell = 1
endcatch
end function
|