1 'encoding UTF-8 Do not remove or change this line!
2 '**************************************************************************
3 ' DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
5 ' Copyright 2000, 2010 Oracle and/or its affiliates.
7 ' OpenOffice.org - a multi-platform office productivity suite
9 ' This file is part of OpenOffice.org.
11 ' OpenOffice.org is free software: you can redistribute it and/or modify
12 ' it under the terms of the GNU Lesser General Public License version 3
13 ' only, as published by the Free Software Foundation.
15 ' OpenOffice.org is distributed in the hope that it will be useful,
16 ' but WITHOUT ANY WARRANTY; without even the implied warranty of
17 ' MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 ' GNU Lesser General Public License version 3 for more details
19 ' (a copy is included in the LICENSE file that accompanied this code).
21 ' You should have received a copy of the GNU Lesser General Public License
22 ' version 3 along with OpenOffice.org. If not, see
23 ' <http://www.openoffice.org/license.html>
24 ' for a copy of the LGPLv3 License.
26 '/***********************************************************************
28 '* owner : oliver.craemer@oracle.com
30 '* short description : Resource Test - Tools Menu Part I
32 '\***********************************************************************
36 Printlog Chr(13) + "--------- Tools Menu Part I (c_upd_toolsmenu.inc) ---------"
39 call tToolsHangulHanjaConversion
40 call tToolsLanguageChineseTranslation
41 call tToolsLanguageThesaurus
42 call tToolsLanguageHyphenation
44 call tToolsAutoCorrect
47 call tToolsProtectSheet
48 call tToolsProtectDocument
49 call tToolsCellContents
51 call tToolsMediaPlayer
55 '-----------------------------------------------------------
57 testcase tToolsSpellcheck
58 '///<u><b>Tools - Spellcheck</b></u>
60 Dim iDictionaries as integer
62 printlog " Load document from 'gTesttoolPath + spreadsheet\required\input\english.ods"
63 hFileOpenLocally( gTesttoolPath & "spreadsheet\required\input\english.ods" )
64 '/// Enter 'fgsdftk' in a cell
65 printlog " Enter 'fgsdftk' in a cell"
66 Kontext "DocumentCalc"
67 DocumentCalc.TypeKeys "fgsdftk<Return><Up>"
68 '/// Open 'Spellcheck' – dialog via 'Tools – Spellcheck'
69 printlog " Open 'Spellcheck' – dialog via 'Tools – Spellcheck'"
73 'for some languages there is no spellchecker available.
74 warnlog "Spellchecking not possible"
78 ' If 'blabla' is already in the dictionary (because of a former failed testrun)
79 ' there will be a messagebox that the spellchecking has finished. The test will abort.
82 warnlog "It seems that a former testrun has failed, test will abort"
83 printlog "Messagebox: " & Active.GetText
89 DialogTest ( Spellcheck )
90 '/// Verify that the 'Add' – button shows dictionaries
91 printlog " Verify that the 'Add' – button shows dictionaries"
92 qaErrorlog "Due to problems on Sols the AddToDictionary-Button is not tested"
94 ' AddToDictionary.Click
96 ' If hMenuItemGetCount < 1 then
97 ' warnlog "There are no dictionaries available"
100 ' warnlog "The menu on the ADD button could not be opened"
102 '/// Verify that the 'Dictionary language' – combobox has items
103 printlog " Verify that the 'Dictionary language' – combobox has items"
104 If DictionaryLanguage.GetItemCount < 1 then
105 warnlog "There are no languages available"
107 '/// Open 'Options'- dialog by clicking 'Options' – button
108 printlog " Open 'Options'- dialog by clicking 'Options' – button"
109 SpellcheckOptions.Click
110 Kontext "TabLinguistik"
111 DialogTest ( TabLinguistik )
112 'Memorize the amount of available dictionaries
113 iDictionaries = Benutzerwoerterbuch.GetItemCount
114 Kontext "TabLinguistik"
115 '/// Open 'New Dictionary' – dialog by clicking 'New' – button
116 printlog " Open 'New Dictionary' – dialog by clicking 'New' – button"
118 Kontext "BenutzerwoerterbuchAnlegen"
119 Call DialogTest ( BenutzerwoerterbuchAnlegen )
120 '/// Verify that the 'Language' combobox has items
121 printlog " Verify that the 'Language' combobox has items"
122 If Sprache.GetItemCount < 1 then
123 warnlog "There are no languages available"
125 '/// Enter name 'Testdictionary'
126 printlog " Enter name 'Testdictionary'"
127 Woerterbuchname.TypeKeys "Testdictionary"
128 '/// Uncheck 'Exception'
129 printlog " Uncheck 'Exception'"
131 '/// Close dialog with 'OK'
132 printlog " Close dialog with 'OK'"
133 BenutzerwoerterbuchAnlegen.OK
134 Kontext "TabLinguistik"
135 '/// Select 'Testdictionary'
136 Benutzerwoerterbuch.Select (iDictionaries + 1)
137 '/// Click on 'Edit' – button to open 'Edit Custom Dictionary' – dialog
138 printlog " Click on 'Edit' – button to open 'Edit Custom Dictionary' – dialog"
140 Kontext "BenutzerwoerterbuchBearbeiten"
141 Call DialogTest ( BenutzerwoerterbuchBearbeiten )
142 '/// Verify that the 'Book' combobox has items
143 printlog " Verify that the 'Book' combobox has items"
144 If Buch.GetItemCount < 1 then
145 warnlog "There are no dictionaries available"
147 '/// Verify that the 'Language' combobox has items
148 printlog " Verify that the 'Language' combobox has items"
149 If Sprache.GetItemCount < 1 then
150 warnlog "There are no languages available"
152 '/// Close dialog with 'Close'
153 printlog " Close dialog with 'Close'"
154 BenutzerwoerterbuchBearbeiten.Close
155 Kontext "TabLinguistik"
156 '/// Click on 'Delete' button
157 printlog " Click on 'Delete' button"
159 '/// Close messageboc with 'Yes'
160 printlog " Close messageboc with 'Yes'"
162 If Active.Exists then
165 Kontext "TabLinguistik"
166 '/// Select ninth option (Minimal number of ...)
167 printlog " Select ninth option (Minimal number of ...)"
169 '/// Click on 'Edit' – button
170 printlog " Click on 'Edit' – button"
171 OptionenBearbeiten.Click
172 Kontext "HyphenationOptions"
173 Call DialogTest ( HyphenationOptions )
174 '/// Decrease 'Minimal word length'
175 printlog " Decrease 'Minimal word length'"
176 ZeichenVorUmbruch.More
177 '/// Close dialog with 'Cancel'
178 printlog " Close dialog with 'Cancel'"
179 HyphenationOptions.Cancel
180 Kontext "TabLinguistik"
181 '/// Close dialog with 'Cancel'
182 printlog " Close dialog with 'Cancel'"
185 '/// Close 'Spellcheck' – dialog with 'Close'
186 printlog " Close 'Spellcheck' – dialog with 'Close'"
188 '/// Close starting document
189 printlog " Close starting document"
191 hFileDelete( gLastWorkFile )
195 '-----------------------------------------------------------
197 testcase tToolsHangulHanjaConversion
198 '///<u><b>Tools - Hangul/Hanja Conversion</b></u>
200 Dim bAsianLanguage as boolean
201 Dim bCTLlanguage as boolean
203 '/// Open new Spreadsheet document
204 printlog " Open new Spreadsheet document"
206 '/// Enable language support for CJK and CTL (Tools-Options-Language Support)
207 printlog " Enable language support for CJK and CTL (Tools-Options-Language Support)"
208 bAsianLanguage = ActiveDeactivateAsianSupport(TRUE)
209 bCTLLanguage = ActiveDeactivateCTLSupport(TRUE)
210 '/// Load document from 'gTesttoolPath + "spreadsheet\required\input\korean.ods"'
211 printlog " Load document from 'gTesttoolPath + spreadsheet\required\input\korean.ods"
212 hFileOpenLocally( gTesttoolPath & "spreadsheet\required\input\korean.ods" )
214 printlog " Select cell B1"
215 Call fCalcSelectRange ("B1")
216 '/// Open 'Hangul/Hanja Conversion' dialog via 'Tools – Language – Hangul/Hanja Conversion'
217 printlog " Open 'Hangul/Hanja Conversion' dialog via 'Tools – Language – Hangul/Hanja Conversion'"
218 ToolsLanguageHangulHanjaConversion
219 Kontext "HangulHanjaConversion"
220 if HangulHanjaConversion.Exists (5) then
221 Call DialogTest ( HangulHanjaConversion )
226 '/// Click on 'Options' button to open 'Hangul/Hanja Options' dialog
227 printlog " Click on 'Options' button to open 'Hangul/Hanja Options' dialog"
229 Kontext "HangulHanjaOptions"
230 if HangulHanjaOptions.Exists (5) then
231 Call DialogTest ( HangulHanjaOptions )
233 warnlog " Hangul/Hanja Options' dialog could not be open"
234 HangulHanjaConversion.Cancel
238 '/// Click on 'New' button
239 printlog " Click on 'New' button"
241 Kontext "HangulHanjaNewDictionary"
242 if HangulHanjaNewDictionary.Exists (5) then
243 Call DialogTest ( HangulHanjaNewDictionary )
245 warnlog " HangulHanjaNewDictionary dialog could not be opened"
246 Kontext "HangulHanjaOptions"
247 HangulHanjaOptions.Cancel
248 Kontext "HangulHanjaConversion"
249 HangulHanjaConversion.Cancel
253 '/// Enter string 'Dictionary_added_by_Testtool'
254 printlog " Enter string 'Dictionary_added_by_Testtool'"
255 DictionaryName.Settext "Dictionary_added_by_Testtool"
256 '/// Close dialog with 'OK'
257 printlog " Close dialog with 'OK'"
258 HangulHanjaNewDictionary.OK
260 Kontext "HangulHanjaOptions"
261 '/// Click on 'Edit' button
262 printlog " Click on 'Edit' button"
263 if HangulHanjaOptions.Exists (5) then
267 warnlog " Edit button could not be accessed"
268 HangulHanjaConversion.Cancel
272 Kontext "HangulHanjaEditDictionary"
273 if HangulHanjaEditDictionary.Exists (5) then
274 Call DialogTest ( HangulHanjaEditDictionary )
276 warnlog " HangulHanjaEditDictionary dialog could not be opened"
277 Kontext "HangulHanjaOptions"
278 HangulHanjaOptions.Cancel
279 Kontext "HangulHanjaConversion"
280 HangulHanjaConversion.Cancel
284 '/// Close 'Edit Custom Dictionary' dialog with 'Close'
285 printlog " Close 'Edit Custom Dictionary' dialog with 'Close'"
286 HangulHanjaEditDictionary.Close
287 Kontext "HangulHanjaOptions"
288 '/// Click on 'Delete' button
289 printlog " Click on 'Delete' button"
290 DeleteDictionary.Click
291 '/// UnCheck 'Ignore post-positional words'
292 printlog " UnCheck 'Ignore post-positional words'"
293 IgnorePostPositionalWord.UnCheck
294 '/// Check 'Show entries'
295 printlog " Check 'Show entries'"
297 '/// Check 'Replace Unique Entries'
298 printlog " Check 'Replace Unique Entries'"
299 ReplaceUniqueEntries.Check
300 '/// Close 'Hangul/Hanja Options' dialog with 'Cancel'
301 printlog " Close 'Hangul/Hanja Options' dialog with 'Cancel'"
302 HangulHanjaOptions.Cancel
303 Kontext "HangulHanjaConversion"
304 '/// Close 'Hangul/Hanja Conversion' dialog with 'Close'
305 printlog " Close 'Hangul/Hanja Conversion' dialog with 'Close'"
306 HangulHanjaConversion.Close
307 '/// Set support for CJK and CTL back to default (Tools – Options – Language Support)
308 printlog " Set support for CJK and CTL back to default (Tools – Options – Language Support)"
309 if bAsianLanguage = FALSE then
310 Call ActiveDeactivateAsianSupport(FALSE)
312 if bCTLLanguage = FALSE then
313 Call ActiveDeactivateCTLSupport(FALSE)
316 printlog " Close document"
318 hFileDelete( gLastWorkFile )
322 '-----------------------------------------------------------
324 testcase tToolsLanguageChineseTranslation
325 '///<u><b>Tools – Language – Chinese Translation</b></u>
327 Dim bAsianLanguage as boolean
328 Dim bCTLlanguage as boolean
330 '/// Open new Spreadsheet document
331 printlog " Open new Spreadsheet document"
333 '/// Enable language support for CJK and CTL (Tools-Options-Language Support)
334 printlog " Enable language support for CJK and CTL (Tools-Options-Language Support)"
335 bAsianLanguage = ActiveDeactivateAsianSupport(TRUE)
336 bCTLLanguage = ActiveDeactivateCTLSupport(TRUE)
337 '/// Open 'Chinese Translation' dialog by 'Tools – Language – Chinese Translation'
338 printlog " Open 'Chinese Translation' dialog by 'Tools – Language – Chinese Translation'"
339 ToolsLanguageChineseTranslation
340 Kontext "ChineseTranslation"
341 Call DialogTest ( ChineseTranslation )
342 '/// Click on 'Edit Terms' button to open 'Edit Dictionary' dialog
343 printlog " Click on 'Edit Terms' button to open 'Edit Dictionary' dialog"
345 Kontext "ChineseDictionary"
346 Call DialogTest ( ChineseDictionary )
347 '/// Close dialog with 'Cancel'
348 printlog " Close dialog with 'Cancel'"
349 ChineseDictionary.Cancel
350 Kontext "ChineseTranslation"
351 '/// Close 'Chinese Translation' dialog with 'Cancel'
352 printlog " Close 'Chinese Translation' dialog with 'Cancel'"
353 ChineseTranslation.Cancel
354 '/// Set support for CJK and CTL back to default (Tools – Options – Language Support)
355 printlog " Set support for CJK and CTL back to default (Tools – Options – Language Support)"
356 if bAsianLanguage = FALSE then
357 Call ActiveDeactivateAsianSupport(FALSE)
359 if bCTLLanguage = FALSE then
360 Call ActiveDeactivateCTLSupport(FALSE)
363 printlog " Close document"
368 '-----------------------------------------------------------
370 testcase tToolsLanguageThesaurus
371 '///<u><b>Tools – Language – Chinese Translation</b></u>
373 printlog " Load document from 'gTesttoolPath + spreadsheet\required\input\english.ods"
374 hFileOpenLocally( gTesttoolPath & "spreadsheet\required\input\english.ods" )
375 Kontext "DocumentCalc"
376 printlog " Enter 'test' in a cell"
377 Call fCalcSelectRange ("B2")
378 DocumentCalc.TypeKeys "test<Return><Up>"
379 printlog " Open 'Thesaurus' dialog by 'Tools – Language – Thesaurus"
381 ToolsLanguageThesaurus
383 warnlog "Thesaurus did not work"
388 DialogTest ( Thesaurus )
389 printlog " Check if the cellcontent test is correctly read"
390 if CurrentWord.GetSelText <> "test" then
391 warnlog "The cellcontent is not test but is " & CurrentWord.GetSelText
393 printlog " Check that there are alternatives available"
394 if Alternatives.GetItemCount < 1 then
395 warnlog "There are no alternatives available"
397 Alternatives.Select (1)
399 if ReplaceWith.GetText = "" then
400 warnlog "The repacle with field is empty"
403 printlog " Close 'Thesaurus' with 'Cancel'"
405 printlog " Close document"
407 hFileDelete( gLastWorkFile )
411 '-----------------------------------------------------------
413 testcase tToolsLanguageHyphenation
414 '///<u><b>Tools – Language – Hyphenation</b></u>
416 '/// Open new Spreadsheet document
417 printlog " Open new Spreadsheet document"
419 '/// Enter 'blabla' in a cell
420 printlog " Enter 'blabla' in a cell"
421 Call fCalcSelectRange ("B2")
422 DocumentCalc.TypeKeys "blabla<Return><Up>"
423 '/// Use 'Tools – Language – Hyphenation' to open 'Format Cells' dialog
424 printlog " Use 'Tools – Language – Hyphenation' to open 'Format Cells' dialog"
425 ToolsLanguageHyphenateCalc
426 Kontext "TabAusrichtung"
427 '/// Close dialog with 'Cancel'
428 printlog " Close dialog with 'Cancel'"
429 TabAusrichtung.Cancel
431 printlog " Close document"
436 '-----------------------------------------------------------
438 testcase tToolsDetective
439 '///<u><b>Tools – Detective</b></u>
441 '/// Open new Spreadsheet document
442 printlog " Open new Spreadsheet document"
444 '/// Enter '1' in cell A1
445 printlog " Enter '1' in cell A1"
446 Call fCalcSelectRange ("A1")
447 DocumentCalc.TypeKeys "1<Return>"
448 '/// Enter '=A1' in cell C4
449 printlog " Enter '=A1' in cell C4"
450 Call fCalcSelectRange ("C4")
451 DocumentCalc.TypeKeys "=A1<Return>"
453 printlog " Select cell C4"
454 Call fCalcSelectRange ("C4")
455 '/// Enable 'Trace Precedents' by 'Tools – Detective – Trace Precedents'
456 printlog " Enable 'Trace Precedents' by 'Tools – Detective – Trace Precedents'"
457 ToolsDetectiveTracePrecedents
458 '/// Disable 'Trace Precedents' by 'Tools – Detective – Remove Precedents'
459 printlog " Disable 'Trace Precedents' by 'Tools – Detective – Remove Precedents'"
460 ToolsDetectiveRemovePrecedents
462 printlog " Select cell A1"
463 Call fCalcSelectRange ("A1")
464 '/// Enable 'Trace Dependents' by 'Tools – Detective – Trace Dependents'
465 printlog " Enable 'Trace Dependents' by 'Tools – Detective – Trace Dependents'"
466 ToolsDetectiveTraceDependents
467 '/// Disable 'Trace Dependents' by 'Tools – Detective – Remove Dependents'
468 printlog " Disable 'Trace Dependents' by 'Tools – Detective – Remove Dependents'"
469 ToolsDetectiveRemoveDependents
470 '/// Remove 'All Traces' by 'Tools – Detective – Remove All Traces'
471 printlog " Remove 'All Traces' by 'Tools – Detective – Remove All Traces'"
472 ToolsDetectiveRemoveAllTraces
473 '/// Enter '=C4/0' in cell C7
474 printlog " Enter '=C4/0' in cell C7"
475 Call fCalcSelectRange ("C7")
476 DocumentCalc.TypeKeys "=C4/0<Return>"
478 printlog " Select cell C7"
479 Call fCalcSelectRange ("C7")
480 '/// Enable 'Trace Error' by 'Tools – Detective – Trace Error'
481 printlog " Enable 'Trace Error' by 'Tools – Detective – Trace Error'"
482 ToolsDetectiveTraceError
483 '/// Enable 'Mark Invalid Data' by 'Tools – Detective – Mark Invalid Data'
484 printlog " Enable 'Mark Invalid Data' by 'Tools – Detective – Mark Invalid Data'"
485 ToolsDetectiveMarkInvalidData
486 '/// Refresh traces by 'Tools – Detective – Refresh Traces'
487 printlog " Refresh traces by 'Tools – Detective – Refresh Traces'"
488 ToolsDetectiveRefreshTraces
489 '/// Switch mode of autorefreshing by 'Tools – Detective – AutoRefresh'
490 printlog " Switch mode of autorefreshing by 'Tools – Detective – AutoRefresh'"
491 ToolsDetectiveAutoUpdate
492 '/// Switch mode back to default for autorefreshing by 'Tools – Detective – AutoRefresh'
493 printlog " Switch mode back to default for autorefreshing by 'Tools – Detective – AutoRefresh'"
494 ToolsDetectiveAutoUpdate
495 '/// Switch 'Fill Mode' by 'Tools – Detective – Fill Mode'
496 printlog " Switch 'Fill Mode' by 'Tools – Detective – Fill Mode'"
497 ToolsDetectiveFillMode
498 '/// Switch 'Fill Mode' back to default by 'Tools – Detective – Fill Mode'
499 printlog " Switch 'Fill Mode' back to default by 'Tools – Detective – Fill Mode'"
500 ToolsDetectiveFillMode
502 printlog " Close document"
507 '-----------------------------------------------------------
509 testcase tToolsAutoCorrect
510 '///<u><b>Tools – AutoCorrect</b></u>
512 '/// Open new Spreadsheet document
513 printlog " Open new Spreadsheet document"
515 '/// Open 'AutoCorrect' dialog by 'Tools – AutoCorrect'
516 printlog " Open 'AutoCorrect' dialog by 'Tools – AutoCorrect'"
518 '/// Switch to tabpage 'Replace'
519 printlog " Switch to tabpage 'Replace'"
521 active.SetPage TabErsetzung
522 Kontext "TabErsetzung"
523 Call DialogTest ( TabErsetzung )
524 '/// Verify that the language combobox has items
525 printlog " Verify that the language combobox has items"
526 if WelcheSprache.GetItemCount < 1 then
527 warnlog "The Language listbox is empty"
529 '/// Enter string 'Testerentrie' in 'Replace' field
530 printlog " Enter string 'Testerentrie' in 'Replace' field"
531 Kuerzel.SetText "Testerentrie"
532 '/// Enter string 'Testentrie' in 'With' field
533 printlog " Enter string 'Testentrie' in 'With' field"
534 ErsetzenDurch.SetText "Testentrie"
535 '/// Click on 'New' button
536 printlog " Click on 'New' button"
538 '/// Click on 'Delete' button
539 printlog " Click on 'Delete' button"
541 '/// Switch to tabpage 'Exceptions'
542 printlog " Switch to tabpage 'Exceptions'"
544 active.SetPage TabAusnahmen
545 Kontext "TabAusnahmen"
546 Call DialogTest ( TabAusnahmen )
547 '/// Enter string 'olala' as 'Abbreviation'
548 printlog " Enter string 'olala' as 'Abbreviation'"
549 Abkuerzungen.SetText "olala"
550 '/// Press 'New' button
551 printlog " Press 'New' button"
552 AbkuerzungenNeu.click
553 '/// Press 'Delete' button
554 printlog " Press 'Delete' button"
555 AbkuerzungenLoeschen.click
556 '/// Enter string 'TTLauncher' in 'Words with ...'
557 printlog " Enter string 'TTLauncher' in 'Words with ...'"
558 Woerter.SetText "TTLauncher"
559 '/// Press 'New' button
560 printlog " Press 'New' button"
562 '/// Press 'Delete' button
563 printlog " Press 'Delete' button"
564 WoerterLoeschen.click
565 '/// Switch to tabpage 'Options'
566 printlog " Switch to tabpage 'Options'"
568 active.SetPage TabOptionen
569 Kontext "TabOptionen"
570 Call DialogTest ( TabOptionen )
571 '/// Switch to tabpage 'Custom Quotes'
572 printlog " Switch to tabpage 'Custom Quotes'"
574 active.SetPage TabLocalizedOptions
575 Kontext "TabLocalizedOptions"
576 Call DialogTest ( TabLocalizedOptions )
577 '/// Press on button for 'Start quote' for 'Single quotes'
578 printlog " Press on button for 'Start quote' for 'Single quotes'"
579 SingleQuotesStart.Click
580 Kontext "Sonderzeichen"
581 '/// Close 'Start quote' dialog with 'Cancel'
582 printlog " Close 'Start quote' dialog with 'Cancel'"
584 Kontext "TabLocalizedOptions"
585 '/// Press on button for 'End quote' for 'Single quotes'
586 printlog " Press on button for 'End quote' for 'Single quotes'"
587 SingleQuotesEnd.Click
588 Kontext "Sonderzeichen"
589 '/// Close 'End quote' dialog with 'Cancel'
590 printlog " Close 'End quote' dialog with 'Cancel'"
592 Kontext "TabLocalizedOptions"
593 '/// Click on 'Default' button for 'Single quotes'
594 printlog " Click on 'Default' button for 'Single quotes'"
595 SingleQuotesDefault.Click
596 '/// Press on button for 'Start quote' for 'Double quotes'
597 printlog " Press on button for 'Start quote' for 'Double quotes'"
598 DoubleQuotesStart.Click
599 Kontext "Sonderzeichen"
600 '/// Close 'Start quote' dialog with 'Cancel'
601 printlog " Close 'Start quote' dialog with 'Cancel'"
603 Kontext "TabLocalizedOptions"
604 '/// Press on button for 'End quote' for 'Double quotes'
605 printlog " Press on button for 'End quote' for 'Double quotes'"
606 DoubleQuotesEnd.Click
607 Kontext "Sonderzeichen"
608 '/// Close 'End quote' dialog with 'Cancel'
609 printlog " Close 'End quote' dialog with 'Cancel'"
611 Kontext "TabLocalizedOptions"
612 '/// Click on 'Default' button for 'Double quotes'
613 printlog " Click on 'Default' button for 'Double quotes'"
614 DoubleQuotesDefault.Click
615 '/// Close 'AutoCorrect' dialog with 'Cancel'
616 printlog " Close 'AutoCorrect' dialog with 'Cancel'"
617 TabLocalizedOptions.cancel
619 printlog " Close document"
624 '-----------------------------------------------------------
626 testcase tToolsGoalSeek
627 '///<u><b>Tools - Goal Seek</b></u>
629 '/// Open new Spreadsheet document
630 printlog " Open new Spreadsheet document"
632 '/// Open 'Goal Seek' dialog by 'Tools – Goal Seek'
633 printlog " Open 'Goal Seek' dialog by 'Tools – Goal Seek'"
635 Kontext "Zielwertsuche"
636 DialogTest ( Zielwertsuche )
637 '/// Click on 'Shrink' button for 'Formula Cell'
638 printlog " Click on 'Shrink' button for 'Formula Cell'"
640 '/// Close rangechooser with 'Shrink' button
641 printlog " Close rangechooser with 'Shrink' button"
643 '/// Click on 'Shrink' button for 'Variable Cell'
644 printlog " Click on 'Shrink' button for 'Variable Cell'"
646 '/// Close rangechooser with 'Shrink' button
647 printlog " Close rangechooser with 'Shrink' button"
649 '/// Close 'Goal Seek' dialog with 'Cancel'
650 printlog " Close 'Goal Seek' dialog with 'Cancel'"
653 printlog " Close document"
658 '-----------------------------------------------------------
660 testcase tToolsScenario
661 '///<u><b>Tools - Scenario</b></u>
663 '/// Open new Spreadsheet document
664 printlog " Open new Spreadsheet document"
666 '/// Enter '1' in A1, '2' in A2, '3' in A3
667 printlog " Enter '1' in A1, '2' in A2, '3' in A3"
668 Call fCalcSelectRange ("A1")
669 DocumentCalc.TypeKeys "1<Return>2<Return>3<Return>"
670 '/// Select cells A1:A3
671 printlog " Select cells A1:A3"
672 Call fCalcSelectRange ("A1:A3")
673 '/// Open 'Create Scenario' dialog by 'Tools – Scenario'
674 printlog " Open 'Create Scenario' dialog by 'Tools – Scenario'"
676 Kontext "SzenarioAnlegen"
677 DialogTest ( SzenarioAnlegen )
678 '/// Enter 'Scenario_by_Testtool' as 'Name of Scenario'
679 printlog " Enter 'Scenario_by_Testtool' as 'Name of Scenario'"
680 SzenarioName.SetText "Scenario_by_Testtool"
681 '/// Enter 'Comment_by_Testtool' as 'Comment'
682 printlog " Enter 'Comment_by_Testtool' as 'Comment'"
683 Kommentar.SetText "Comment_by_Testtool"
684 '/// Verify that the color combobox has items
685 printlog " Verify that the color combobox has items"
686 If Rahmenfarbe.GetItemCount < 1 then
687 warnlog "The colorbox is empty"
689 '/// Check 'Display border'
690 printlog " Check 'Display border'"
692 '/// Check 'Copy back'
693 printlog " Check 'Copy back'"
694 Zurueckkopieren.Check
695 '/// UnCheck 'Copy entire sheet'
696 printlog " UnCheck 'Copy entire sheet'"
698 '/// Check 'PreventChanges'
699 printlog " Check 'PreventChanges'"
701 '/// Close 'Create Scenario' dialog with 'Cancel'
702 printlog " Close 'Create Scenario' dialog with 'Cancel'"
703 SzenarioAnlegen.Cancel
705 printlog " Close document"
710 '-----------------------------------------------------------
712 testcase tToolsProtectSheet
713 '///<u><b>Tools - Protect – Sheet</b></u>
715 '/// Open new Spreadsheet document
716 printlog " Open new Spreadsheet document"
718 '/// Open 'Protect Sheet' dialog by 'Tools – Protect – Sheet'
719 printlog " Open 'Protect Sheet' dialog by 'Tools – Protect – Sheet'"
720 ToolsProtectDocumentSheet
721 Kontext "TabelleSchuetzen"
722 DialogTest ( TabelleSchuetzen,1 )
723 '/// Enter 'Secret' as 'Password'
724 printlog " Enter 'Secret' as 'Password'"
725 Passwort.SetText "Secret"
726 '/// Enter 'Secred' as 'Confirm'
727 printlog " Enter 'Secred' as 'Confirm'"
728 Bestaetigung.SetText "Secred"
729 '/// Press 'OK' button
730 printlog " Press 'OK' button"
732 '/// Close errormessage with 'OK'
733 printlog " Close errormessage with 'OK'"
735 if Active.Exists then
736 DialogTest ( Active )
739 warnlog "There is no error message by confirming a wrong password!"
741 '/// Enter 'Secret' as 'Confirm'
742 printlog " Enter 'Secret' as 'Confirm'"
743 Kontext "TabelleSchuetzen"
744 Bestaetigung.SetText "Secret"
745 '/// Press 'OK' button
746 printlog " Press 'OK' button"
748 '/// Open 'Unprotect Sheet' dialog by 'Tools - Protect – Sheet'
749 printlog " Open 'Unprotect Sheet' dialog by 'Tools - Protect – Sheet'"
750 ToolsProtectDocumentSheet
751 Kontext "TabelleSchuetzen"
752 DialogTest ( TabelleSchuetzen,2 )
753 '/// Enter string 'Secret'
754 printlog " Enter string 'Secret'"
755 Passwort.setText "Secret"
756 '/// Press 'OK' button
757 printlog " Press 'OK' button"
760 printlog " Close document"
765 '-----------------------------------------------------------
767 testcase tToolsProtectDocument
768 '///<u><b>Tools - Protect – Document</b></u>
770 '/// Open new Spreadsheet document
771 printlog " Open new Spreadsheet document"
773 '/// Open 'Protect Document' dialog by 'Tools – Protect – Document'
774 printlog " Open 'Protect Document' dialog by 'Tools – Protect – Document'"
775 ToolsProtectDocumentDocument
776 Kontext "DokumentSchuetzen"
777 DialogTest ( DokumentSchuetzen,1 )
778 '/// Enter 'Secret' as 'Password'
779 printlog " Enter 'Secret' as 'Password'"
780 Passwort.setText "Secret"
781 '/// Enter 'Secred' as 'Confirm'
782 printlog " Enter 'Secred' as 'Confirm'"
783 Bestaetigung.SetText "Secred"
784 '/// Press 'OK' button
785 printlog " Press 'OK' button"
787 '/// Close errormessage with 'OK'
788 printlog " Close errormessage with 'OK'"
790 if Active.Exists then
791 DialogTest ( Active )
794 warnlog "There is no error message by confirming a wrong password!"
796 Kontext "DokumentSchuetzen"
797 '/// Enter 'Secret' as 'Confirm'
798 printlog " Enter 'Secret' as 'Confirm'"
799 Bestaetigung.SetText "Secret"
800 '/// Press 'OK' button
801 printlog " Press 'OK' button"
803 '/// Open 'Unprotect Document' dialog by 'Tools - Protect – Document'
804 printlog " Open 'Unprotect Document' dialog by 'Tools - Protect – Document'"
805 ToolsProtectDocumentDocument
806 Kontext "DokumentSchuetzen"
807 DialogTest ( DokumentSchuetzen,2 )
808 '/// Enter string 'Secret'
809 printlog " Enter string 'Secret'"
810 Passwort.setText "Secret"
811 '/// Press 'OK' button
812 printlog " Press 'OK' button"
815 printlog " Close document"
820 '-----------------------------------------------------------
822 testcase tToolsCellContents
823 '///<u><b>Tools - Cell Contents</b></u>
825 '/// Open new Spreadsheet document
826 printlog " Open new Spreadsheet document"
828 '/// Recalculate cells by 'Tools – Cell Contents – Recalculate'
829 printlog " Recalculate cells by 'Tools – Cell Contents – Recalculate'"
830 ToolsCellContentsRecalculate
831 '/// Switch 'AutoCalculate' mode by 'Tools – Cell Contents – AutoCalculate'
832 printlog " Switch 'AutoCalculate' mode by 'Tools – Cell Contents – AutoCalculate'"
833 ToolsCellContentsAutoCalculate
834 '/// Switch 'AutoCalculate' mode back by 'Tools – Cell Contents – AutoCalculate'
835 printlog " Switch 'AutoCalculate' mode back by 'Tools – Cell Contents – AutoCalculate'"
836 ToolsCellContentsAutoCalculate
837 '/// Switch 'AutoInput' mode by 'Tools – Cell Contents – AutoInput'
838 printlog " Switch 'AutoInput' mode by 'Tools – Cell Contents – AutoInput'"
839 ToolsCellContentsAutoInput
840 '/// Switch 'AutoInput' mode back by 'Tools – Cell Contents – AutoInput'
841 printlog " Switch 'AutoInput' mode back by 'Tools – Cell Contents – AutoInput'"
842 ToolsCellContentsAutoInput
844 printlog " Close document"
849 '-----------------------------------------------------------
851 testcase tToolsGallery
852 '///<u><b>Tools - Gallery</b></u>
854 '/// Open new Spreadsheet document
855 printlog " Open new Spreadsheet document"
857 '/// Enable 'Gallery' by 'Tools – Gallery'
858 printlog " Enable 'Gallery' by 'Tools – Gallery'"
860 if Not Gallery.Exists then ToolsGallery
862 '/// Verify that there are 'Themes' available (more than one)
863 printlog " Verify that there are 'Themes' available (more than one)"
864 If Gallerys.getItemCount < 1 then
865 warnlog "There are no items in the Gallerylist"
867 '/// Click on 'New Theme' button
868 printlog " Click on 'New Theme' button"
870 '/// Switch to tabpage 'General'
871 printlog " Switch to tabpage 'General'"
873 Active.SetPage TabAllgemeinGallery
874 Kontext "TabAllgemeinGallery"
875 Call DialogTest ( TabAllgemeinGallery )
876 '/// Switch to tabpage 'Files'
877 printlog " Switch to tabpage 'Files'"
879 Active.SetPage TabDateien
881 Call DialogTest ( TabDateien )
882 '/// Verify that the 'File type' combobox has items
883 printlog " Verify that the 'File type' combobox has items"
884 If Dateityp.GetItemCount < 1 then
885 warnlog "There are no filetypes available"
887 '/// Click on 'Find Files' button
888 printlog " Click on 'Find Files' button"
891 '/// Close 'Select Path' dialog with 'Cancel'
892 printlog " Close 'Select Path' dialog with 'Cancel'"
895 '/// Click on 'Add' button to open 'Gallery' dialog
896 printlog " Click on 'Add' button to open 'Gallery' dialog"
898 Kontext "GrafikEinfuegenDlg"
899 '/// Close 'Gallery' dialog with 'Cancel'
900 printlog " Close 'Gallery' dialog with 'Cancel'"
901 GrafikEinfuegenDlg.Cancel
903 '/// Close 'Properties' dialog with 'Cancel'
904 printlog " Close 'Properties' dialog with 'Cancel'"
906 '/// Disable 'Gallery' by 'Tools – Gallery'
907 printlog " Disable 'Gallery' by 'Tools – Gallery'"
910 if Gallery.Exists then
911 Warnlog "The Gallery has not been closed!"
914 printlog " Close document"
919 '-----------------------------------------------------------
921 testcase tToolsMediaPlayer
922 '///<u><b>Tools - Media Player</b></u>
924 '/// Open new Spreadsheet document
925 printlog " Open new Spreadsheet document"
927 '/// Open 'Media Player' by 'Tools – Media Player'
928 printlog " Open 'Media Player' by 'Tools – Media Player'"
931 Call DialogTest ( Mplayer )
932 '/// Click on 'Open' button
933 printlog " Click on 'Open' button"
936 '/// Verify that there are more than one filter available
937 printlog " Verify that there are more than one filter available"
938 If DateiTyp.GetItemCount < 1 then
939 warnlog "There are no filters available"
941 '/// Close dialog with 'Cancel'
942 printlog " Close dialog with 'Cancel'"
944 '/// Close 'Media Player' by 'Tools – Media Player'
945 printlog " Close 'Media Player' by 'Tools – Media Player'"
948 printlog " Close document"
953 '-----------------------------------------------------------