diff options
Diffstat (limited to 'testautomation/spreadsheet/required/includes/c_upd_insertmenu.inc')
-rwxr-xr-x | testautomation/spreadsheet/required/includes/c_upd_insertmenu.inc | 1313 |
1 files changed, 1313 insertions, 0 deletions
diff --git a/testautomation/spreadsheet/required/includes/c_upd_insertmenu.inc b/testautomation/spreadsheet/required/includes/c_upd_insertmenu.inc new file mode 100755 index 000000000000..b8c749c27cd9 --- /dev/null +++ b/testautomation/spreadsheet/required/includes/c_upd_insertmenu.inc @@ -0,0 +1,1313 @@ +'encoding UTF-8 Do not remove or change this line! +'************************************************************************** +' DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. +' +' Copyright 2000, 2010 Oracle and/or its affiliates. +' +' OpenOffice.org - a multi-platform office productivity suite +' +' 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@oracle.com +'* +'* short description : Resource Test - Insert Menu +'* +'************************************************************************ +'* +' #1 tInsertManualBreak +' #1 tInsertCells +' #1 tInsertRowsColumns +' #1 tInsertSheet +' #1 tInsertSheetFromFile +' #1 tInsertLink +' #1 tInsertSpecialCharacters +' #1 tInsertFormattingMark +' #1 tInsertHyperlink +' #1 tInsertFunction +' #1 tInsertFunctionList +' #1 tInsertNamesDefine +' #1 tInsertNamesInsert +' #1 tInsertNamesCreate +' #1 tInsertNamesLabels +' #1 tInsertNote +' #1 tInsertPictureFromFile +' #1 tInsertMovieSound +' #1 tInsertObjectOLE +' #1 tInsertObjectPlugin +' #1 tInsertObjectSound +' #1 tInsertObjectVideo +' #1 tInsertObjectFormular +' #1 tInsertChart +' #1 tInsertFloatingFrame + +'* +'\*********************************************************************** + +sub c_upd_insertmenu + + Printlog Chr(13) + "--------- Insert Menu (c_upd_insertmenu.inc) ---------" + + call tInsertManualBreak + call tInsertCells + call tInsertRowsColumns + call tInsertSheet + call tInsertSheetFromFile + call tInsertLink + call tInsertSpecialCharacters + call tInsertFormattingMark + call tInsertHyperlink + call tInsertFunction + call tInsertFunctionList + call tInsertNamesDefine + call tInsertNamesInsert + call tInsertNamesCreate + call tInsertNamesLabels + call tInsertNote + call tInsertPictureFromFile + call tInsertMovieSound + call tInsertObjectOLE + call tInsertObjectPlugin + call tInsertObjectSound + call tInsertObjectVideo + call tInsertObjectFormular + call tInsertChart + call tInsertFloatingFrame + +end sub + +'----------------------------------------------------------- + +testcase tInsertManualBreak +'///<u><b>Insert - Manual Break</b></u> + + '/// Opening new spreadsheet document for getting defined starting environment + printlog " Opening new spreadsheet document for getting defined starting environment" + call hNewDocument + '/// Goto cell D5 + printlog " Goto cell D5" + call fCalcSelectRange ("D5") + '/// Insert a manual row break by 'Insert – Manual Break – Row Break' + printlog " Insert a manual row break by 'Insert – Manual Break – Row Break'" + InsertManuelBreakRowBreak + '/// Insert a manual column break by 'Insert – Manual Break – Column Break' + printlog " Insert a manual column break by 'Insert – Manual Break – Column Break'" + InsertManuelBreakColumnBreak + '/// Close starting document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertCells +'///<u><b>Insert - Cells</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Open 'Insert Cells'- dialog by 'Insert – Cells' + printlog " Open 'Insert Cells'- dialog by 'Insert – Cells'" + InsertCells + Kontext "ZellenEinfuegen" + Call DialogTest ( ZellenEinfuegen ) + '/// Check option 'Shift cells down' + printlog " Check option 'Shift cells down'" + ZellenNachUnten.Check + '/// Check option 'Shift cells right' + printlog " Check option 'Shift cells right'" + ZellenNachRechts.Check + '/// Check option 'Entire row' + printlog " Check option 'Entire row'" + GanzeZeile.Check + '/// Check option 'Entire column' + printlog " Check option 'Entire column'" + GanzeSpalte.Check + '/// Close dialog with 'Cancel' + printlog " Close dialog with 'Cancel'" + ZellenEinfuegen.Cancel + '/// Close starting document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertRowsColumns +'///<u><b>Insert - Rows/Columns</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Insert a new row by 'Insert - Rows' + printlog " Insert a new row by 'Insert - Rows'" + InsertRowsCalc + '/// Insert a new column by 'Insert - Columns' + printlog " Insert a new column by 'Insert - Columns'" + InsertColumnsCalc + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertSheet +'///<u><b>Insert - Sheet</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Open 'Insert Sheet' – dialog by 'Insert – Sheet' + printlog " Open 'Insert Sheet' – dialog by 'Insert – Sheet'" + InsertSheetCalc + Kontext "TabelleEinfuegenCalc" + Call DialogTest ( TabelleEinfuegenCalc ) + '/// Check option 'After current sheet' + printlog " Check option 'After current sheet'" + Nach.Check + '/// Set 'Name' to 'Test' + printlog " Set 'Name' to 'Test'" + TabellenName.SetText "Test" + '/// Set number of sheets to 2 + printlog " Set number of sheets to 2" + Anzahl.More + '/// Check option 'From File' + printlog " Check option 'From File'" + AusDateiErstellen.Check + '/// Check option 'Link' + printlog " Check option 'Link'" + Verknuepfen.Check + '/// Click on 'Browse' – button + Durchsuchen.Click + Kontext "OeffnenDLG" + '/// Close 'Insert' – dialog with 'Cancel' + printlog " Close 'Insert' – dialog with 'Cancel'" + OeffnenDLG.Cancel + Kontext "TabelleEinfuegenCalc" + '/// Close 'Insert Sheet' – dialog with 'Cancel' + printlog " Close 'Insert Sheet' – dialog with 'Cancel'" + TabelleEinfuegenCalc.Cancel + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertSheetFromFile +'///<u><b>Insert - Sheet From File</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Open 'Insert Sheet' – dialog by 'Insert – Sheet From File' + printlog " Open 'Insert Sheet' – dialog by 'Insert – Sheet From File'" + InsertSheetFromFile + Kontext "OeffnenDLG" + '/// Set filename 'spreadsheet/required/input/twosheets.ods' + printlog " Set filename 'spreadsheet/required/input/twosheets.ods'" + Dateiname.setText ( convertpath ( gTesttoolPath & "spreadsheet/required/input/twosheets.ods" ) ) + '/// Close 'Insert' – dialog with 'Insert' + printlog " Close 'Insert' – dialog with 'Insert'" + Oeffnen.Click + Kontext "TabelleEinfuegenCalc" + '/// Verify that the selected file has two sheets + printlog " Verify that the selected file has two sheets" + if Auswahl.GetItemCount <> 2 then + warnlog "The file has more/less than two sheets" + end if + '/// Close 'Insert Sheet' – dialog with 'Insert' + printlog " Close 'Insert Sheet' – dialog with 'Insert'" + TabelleEinfuegenCalc.Cancel + '/// Close document' + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertLink +'///<u><b>Insert - Link</b></u> + + '/// Open new Sreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Open 'External Data' – dialog by 'Insert – Link To External Data' + printlog " Open 'External Data' – dialog by 'Insert – Link To External Data'" + InsertLinkToExternalData + Kontext "ExternalData" + call Dialogtest (ExternalData) + '/// Press browse button for URL + printlog " Press browse button for URL" + FileChoose.Click + Kontext "OeffnenDlg" + '/// Close 'Insert' – dialog with 'Cancel' + printlog " Close 'Insert' – dialog with 'Cancel'" + OeffnenDlg.close + Kontext "ExternalData" + '/// Check option 'Updata every' + printlog " Check option 'Updata every'" + Update.Check + '/// Increase updatetimer by 1 + printlog " Increase updatetimer by 1" + UpdateTime.More + '/// Close 'External Data' – dialog with 'Cancel' + printlog " Close 'External Data' – dialog with 'Cancel'" + ExternalData.close + '/// Close starting document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertSpecialCharacters +'///<u><b>Insert - Special Characters</b></u> + + '///Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Open 'Special Characters' – dialog by 'Insert – Special Characters' + printlog " Open 'Special Characters' – dialog by 'Insert – Special Characters'" + InsertSpecialCharacterCalc + Kontext "Sonderzeichen" + DialogTest ( Sonderzeichen ) + '/// Change 'Font' to next one + printlog " Change 'Font' to next one" + if Schrift.GetItemCount = Schrift.GetSelIndex then + Schrift.Select(Schrift.GetSelIndex -1) + else Schrift.Select(Schrift.GetSelIndex +1) + end if + '/// Change 'Subset' to next one + printlog " Change 'Subset' to next one" + If Subset.IsVisible then + if Subset.GetItemCount = Subset.GetSelIndex then + Subset.Select(Subset.GetSelIndex -1) + else Subset.Select(Subset.GetSelIndex +1) + end if + end if + '/// Choose a character by clicking + printlog " Choose a character by clicking" + Zeichenanzeige.MouseDown 50,50 + Zeichenanzeige.MouseUp 50,50 + '/// Delete character by 'Delete' + printlog " Delete character by 'Delete'" + Loeschen.Click + '/// Close 'Special Characters' – dialog with 'Cancel' + printlog " Close 'Special Characters' – dialog with 'Cancel'" + Sonderzeichen.Cancel + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertFormattingMark +'///<u><b>Insert - Formatting Mark</b></u> + + Dim bAsianLanguage as boolean + Dim bCTLlanguage as boolean + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Enable support for CJK and CTL by 'Tools-Options-Language Settings' + printlog " Enable support for CJK and CTL by 'Tools-Options-Language Settings'" + bAsianLanguage = ActiveDeactivateAsianSupport(TRUE) + bCTLLanguage = ActiveDeactivateCTLSupport(TRUE) + '/// Select cell A1 + printlog " Select cell A1" + call fCalcSelectRange ("A1") + '/// Enter 'Test' in cell 'A1' to activate editmode + printlog " Enter 'Test' in cell 'A1' to activate editmode" + DocumentCalc.TypeKeys "Test" + '/// Enter in cell 'Insert – Formatting Mark – Non-Breaking Space' + printlog " Enter in cell 'A' and 'Insert – Formatting Mark – Non-Breaking Space'" + InsertNonBreakingSpace + '/// Enter in cell 'Insert – Formatting Mark – Non-Breaking Hyphen' + printlog " Enter in cell 'Insert – Formatting Mark – Non-Breaking Hyphen'" + InsertHardHyphen + '/// Enter in cell 'Insert – Formatting Mark – Optional Hyphen' + printlog " Enter in cell 'Insert – Formatting Mark – Optional Hyphen'" + InsertSoftHyphen + '/// Enter in cell 'Insert – Formatting Mark – No-Width Optional Break' + printlog " Enter in cell 'Insert – Formatting Mark – No-Width Optional Break'" + InsertZWSP + '/// Enter in cell 'Insert – Formatting Mark – No-Width no break' + printlog " Enter in cell 'Insert – Formatting Mark – No-Width no break'" + InsertZWNBSP + '/// Enter in cell 'Insert – Formatting Mark – Left-to-right-mark' + printlog "/ Enter in cell 'Insert – Formatting Mark – Left-to-right-mark'" + InsertLRM + '/// Enter in cell 'Insert – Formatting Mark – right-to-left-mark' + printlog " Enter in cell 'Insert – Formatting Mark – right-to-left-mark'" + InsertRLM + '/// Leave cell with 'Enter' + printlog " Leave cell with 'Enter'" + DocumentCalc.TypeKeys "<Return>" + '/// Set support for CTL and CJK back to defaults + printlog " Set support for CTL and CJK back to defaults" + if bAsianLanguage = FALSE then + Call ActiveDeactivateAsianSupport(FALSE) + end if + if bCTLLanguage = FALSE then + Call ActiveDeactivateCTLSupport(FALSE) + end if + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertHyperlink +'///<u><b>Insert - Hyperlink</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Open 'Hyperlink' – dialog via 'Insert – Hyperlink' + printlog " Open 'Hyperlink' – dialog via 'Insert – Hyperlink'" + InsertHyperlink + + kontext "HyperlinkDialog" + if ( HyperlinkDialog.exists( 2 ) ) then + + Kontext "Hyperlink" + '/// Switch to category 'Internet' (first one) + printlog " Switch to category 'Internet'" + Auswahl.TypeKeys "<HOME>" + '/// Choose 'Web' + printlog " Choose 'Web'" + Kontext "TabHyperlinkInternet" + internet.check + Call DialogTest ( TabHyperlinkInternet,1 ) + '/// Click on 'Target in Document' – button (the target dialog appears) + printlog " Click on 'Target in Document' – button (the target dialog appears)" + Target.Click + Kontext "ZielImDokument" + Call DialogTest ( ZielImDokument ) + '/// Close 'Target' – dialog with 'Close' + printlog " Close 'Target' – dialog with 'Close'" + ZielImDokument.Close + Kontext "TabHyperlinkInternet" + '/// Choose 'FTP' + printlog " Choose 'FTP'" + FTP.check + Call DialogTest ( TabHyperlinkInternet,2 ) + '/// Check that the 'Target' – button is disabled + printlog " Check that the 'Target' – button is disabled" + if Target.IsEnabled then + warnlog "The target button is enabled, but should be disabled" + end if + '/// Check option 'Anonymous User' + printlog " Check option 'Anonymous User'" + AnonymerBenutzer.Check + '/// Check that 'Login Name' is disabled + printlog " Check that 'Login Name' is disabled" + if Loginname.IsEnabled then + warnlog "The Loginname is enabled, but should be disabled" + end if + '/// Chose 'Telnet' + printlog " Chose 'Telnet'" + Telnet.check + Call DialogTest ( TabHyperlinkInternet,3 ) + '/// Check that the 'Target' – button is disabled + printlog " Check that the 'Target' – button is disabled" + if Target.IsEnabled then + warnlog "The target button is enabled, but should be disabled" + end if + '/// Switch to category 'Mail & News' + Kontext "Hyperlink" + Auswahl.TypeKeys "<DOWN>" + Kontext "TabHyperlinkMailUndNews" + Call DialogTest ( TabHyperlinkMailUndNews ) + '/// Click twice on 'Data Source' – button to turn on / off the databasebeamer + printlog " Click twice on 'Data Source' – button to turn on / off the databasebeamer" + Adressbuch.click + Adressbuch.click + '/// Check option 'Mail' + printlog " Check option 'Mail'" + EMail.check + '/// Check that the editfield for 'Receiver' is enabled + printlog " Check that the editfield for 'Receiver' is enabled" + if not Receiver.IsEnabled then + warnlog "Receiver is disabled but should be enabled" + end if + '/// Check that the editfield for 'Subject' is enabled + printlog " Check that the editfield for 'Subject' is enabled" + if not Betreff.IsEnabled then + warnlog "Subject is disabled but should be enabled" + end if + '/// Check option 'News' + printlog " Check option 'News'" + News.check + '/// Check that the editfield for 'Subject' is disabled + printlog " Check that the editfield for 'Subject' is disabled" + if Betreff.IsEnabled then + warnlog "Subject is enabled but should be disabled" + end if + '/// Switch to category Document + printlog " Switch to category Document" + Kontext "Hyperlink" + Auswahl.TypeKeys "<DOWN>" + Kontext "TabHyperlinkDokument" + Call DialogTest ( TabHyperlinkDokument ) + '/// Enter 'Test' in 'Path' + printlog " Enter 'Test' in 'Path'" + Path.TypeKeys "Test" + '/// Click on 'Open' – button + printlog " Click on 'Open' – button" + DateiOeffnen.click + Kontext "OeffnenDlg" + '/// Close 'Open' – dialog with 'Cancel' + printlog " Close 'Open' – dialog with 'Cancel'" + OeffnenDlg.Cancel + Kontext "TabHyperlinkDokument" + '/// Click on 'Target in Document' – button (the target dialog appears) + printlog " Click on 'Target in Document' – button (the target dialog appears)" + Target.click + Kontext "ZielImDokument" + '/// Close 'Target' – dialog with 'Close' + printlog " Close 'Target' – dialog with 'Close'" + ZielImDokument.close + Kontext "Hyperlink" + '/// Switch to category 'New Document' + printlog " Switch to category 'New Document'" + Auswahl.TypeKeys "<DOWN>" + Kontext "TabHyperlinkNeuesDokument" + Call DialogTest ( TabHyperlinkNeuesDokument ) + '/// Check 'Edit Now' + printlog " Click 'Edit Now'" + SofortBearbeiten.check + '/// Check 'Edit Later' + printlog " Click 'Edit Later'" + SpaeterBearbeiten.check + '/// Click on 'Select Path' – button + printlog " Click on 'Select Path' – button" + Pfad.click + Kontext "OeffnenDlg" + '/// Close 'Select Path' – dialog with 'Cancel' + printlog " Close 'Select Path' – dialog with 'Cancel'" + OeffnenDlg.Cancel + Kontext "TabHyperlinkNeuesDokument" + '/// Check that the 'Frame' listbox has items + printlog " Check that the 'Frame' listbox has items" + if Frame.GetItemCount < 1 then + warnlog "The Frame combobox is empty" + end if + '/// Check that the 'Form' listbox has 2 entries + printlog " Check that the 'Form' listbox has 2 entries" + if Form.GetItemCount <> 2 then + warnlog "The Form combobox has not 2 items" + end if + '/// Close 'Hyperlink' – dialog with 'Close' + printlog " Close 'Hyperlink' – dialog with 'Close'" + kontext "HyperlinkDialog" + HyperlinkDialog.Close() + else + warnlog( "Failed to open <HyperlinkDialog>" ) + endif + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertFunction +'///<u><b>Insert - Function</b></u> + + Dim ifunctionCount as integer + Dim ifunctionIndex as integer + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Open the 'Function Wizard' via 'Insert – Function' + printlog " Open the 'Function Wizard' via 'Insert – Function'" + InsertFunction + Kontext "FunctionWizard" + '/// Check that there are 13 entries in the category listbox + printlog " Check that there are 13 entries in the category listbox" + if CategoryLB.GetItemCount <> 13 then + warnlog "There are " & CategoryLB.GetItemCount & " categories instead of 13" + end if + '/// Choose the second entry (all) in the category listbox + printlog " Choose the second entry (all) in the category listbox" + CategoryLB.Select(2) + '/// Choose all entries in the function list and click 'Next' button + printlog " Choose all entries in the function list" + ifunctionCount = FunctionLB.getItemCount + for ifunctionIndex = 1 To ifunctionCount + CategoryLB.Select(2) + FunctionLB.Select(ifunctionIndex) +' sleep(1) + printlog FunctionLB.GetSelText + call DialogTest ( FunctionWizard,ifunctionIndex ) + '/// Click on 'Next' – button + Forward.Click + call DialogTest ( FunctionWizard,(ifunctionCount + ifunctionIndex) ) + Formel.typekeys "<MOD1 A><DELETE>", true + next ifunctionIndex + '/// Check option 'Array' + printlog " Check option 'Array'" + Matrix.check + '/// Choose the third entry (database) in the category listbox + printlog " Choose the third entry (database) in the category listbox" + CategoryLB.Select(3) + '/// Choose first function + printlog " Choose first function" + FunctionLB.Select (1) + '/// Click on 'Next' button + printlog " Click on 'Next' button" + Forward.Click + '/// Click on 'Shrink' – button; the range chooser appears + printlog " Click on 'Shrink' – button; the range chooser appears" + Shrink1.click + '/// Enter 'A1' in rangechooser + printlog " Enter 'A1' in rangechooser" + Editfield1.SetText ("A1") + '/// Click on 'Maximize' – button + printlog " Click on 'Maximize' – button" + maximize.click + '/// Click on 'fx' – button + printlog " Click on 'fx' – button" + Functionsbutton1.click + '/// Switch to tabpage 'Structure' + printlog " Switch to tabpage 'Structure'" + Kontext "FunctionWizardTabControl" + FunctionWizardTabControl.setpage TabFunctionWizardStructure + Kontext "FunctionWizard" + call DialogTest ( FunctionWizard,((ifunctionCount *2)+1) ) + '/// Close dialog with 'Cancel' + printlog " Close dialog with 'Cancel'" + FunctionWizard.Cancel + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertFunctionList +'///<u><b>Insert - Function List</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Check if 'function list' is already opened + printlog " Check if 'function list' is already opened" + Kontext "FunctionsCalc" + if FunctionsCalc.Exists(2) then + printlog "Functions List was already open" + else + '/// Open 'function list' by 'Insert – Function List' + printlog " Open 'function list' by 'Insert – Function List'" + InsertFunctionList + end if + '/// Check that there are 13 categories in the listbox + printlog " Check that there are 13 categories in the listbox" + if Category.GetItemCount <> 13 then + warnlog "The count of categories is " & Category.GetItemCount & " instead of 13" + end if + '/// Click on second function + printlog " Click on second function" + FunctionList.Select(2) + call DialogTest ( FunctionsCalc ) + '/// Click on 'Insert' – button to insert the function into the cell + printlog " Click on 'Insert' – button to insert the function into the cell" + FunctionInsert.click + '/// Press 'ESC' to leave insert mode + printlog " Press 'ESC' to leave insert mode" + kontext "DocumentCalc" + DocumentCalc.TypeKeys "<ESCAPE>" + '/// Close function list by 'Insert – Function list' + printlog " Close function list by 'Insert – Function list'" + InsertFunctionList + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertNamesDefine +'///<u><b>Insert - Names – Define</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Open 'Define Names' -dialog by 'Insert – Names – Define' + printlog " Open 'Define Names' -dialog by 'Insert – Names – Define'" + InsertNamesDefine + Kontext "NamenFestlegen" + '/// Click on 'More' – button + printlog " Click on 'More' – button" + Zusaetze.Click + DialogTest ( NamenFestlegen ) + '/// Check that the 'Add' – button is disabled + printlog " Check that the 'Add' – button is disabled" + if Hinzufuegen.IsEnabled then + warnlog "'Add' is enabled but should be disabled" + end if + '/// Check that the 'Delete' – button is disabled + printlog " Check that the 'Delete' – button is disabled" + if Loeschen.IsEnabled then + warnlog "'Delete' is enabled but should be disabled" + end if + '/// Check that the 'Shrink' – button is disabled + printlog " Check that the 'Shrink' – button is disabled" + if ZugeordnetZuButton.IsEnabled then + warnlog "'Shrink' is enabled but should be disabled" + end if + '/// Check that the 'Print Range' option is disabled + printlog " Check that the 'Print Range' option is disabled" + if Druckbereich.IsEnabled then + warnlog "'Printrange' is enabled but should be disabled" + end if + '/// Check that the 'Filter' option is disabled + printlog " Check that the 'Filter' option is disabled" + if Filter.IsEnabled then + warnlog "'Filter' is enabled but should be disabled" + end if + '/// Check that the 'Repeat Column' option is disabled + printlog " Check that the 'Repeat Column' option is disabled" + if Wiederholungsspalte.IsEnabled then + warnlog "'Repeat Column' is enabled but should be disabled" + end if + '/// Check that the 'Repeat Row' option is disabled + printlog " Check that the 'Repeat Row' option is disabled" + if Wiederholungszeile.IsEnabled then + warnlog "'Repeat Row' is enabled but should be disabled" + end if + '/// Enter the name 'Test' + printlog " Enter the name 'Test'" + BereichsName.SetText "Test" + '/// Press the 'Shrink' – button + printlog " Press the 'Shrink' – button" + ZugeordnetZuButton.click + '/// Click on 'Maximize' – button + printlog " Click on 'Maximize' – button" + ZugeordnetZuButton.click + '/// Check the 'Print Range' option + printlog " Check the 'Print Range' option" + Druckbereich.check + '/// Check the 'Filter' option + printlog " Check the 'Filter' option" + Filter.check + '/// Check the 'Repeat Column' option + printlog " Check the 'Repeat Column' option" + Wiederholungsspalte.check + '/// Check the 'Repeat Row' option + printlog " Check the 'Repeat Row' option" + Wiederholungszeile.check + '/// Press the 'Add' – button + printlog " Press the 'Add' – button" + Hinzufuegen.click + '/// Choose the 'Test' name + printlog " Choose the 'Test' name" + BereichsName.Select "Test" + '/// Press the 'Delete' – button + printlog " Press the 'Delete' – button" + Loeschen.click + '/// On appearing messagebox click 'Yes' + printlog " On appearing messagebox click 'Yes'" + kontext "Active" + if Active.exists( 2 ) then + Active.Yes + end if + '/// Close dialog with 'Cancel' + printlog " Close dialog with 'Cancel'" + Kontext "NamenFestlegen" + NamenFestlegen.Cancel + '/// Close the document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertNamesInsert +'///<u><b>Insert - Names – Define</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Select cell A1 + printlog " Select cell A1" + call fCalcSelectRange ("A1") + '/// Open 'Define Names' -dialog by 'Insert – Names – Define' + printlog " Open 'Define Names' -dialog by 'Insert – Names – Define'" + InsertNamesDefine + Kontext "NamenFestlegen" + '/// Enter the name 'Test' + printlog " Enter the name 'Test'" + BereichsName.SetText "Test" + '/// Press the 'Add' – button + printlog " Press the 'Add' – button" + Hinzufuegen.click + '/// Close dialog with 'OK' + printlog " Close dialog with 'OK'" + NamenFestlegen.OK + '/// Select cell D4 + printlog " Select cell D4" + call fCalcSelectRange ("D4") + '/// Open 'Insert Names' – dialog by 'Insert – Names – Insert' + printlog " Open 'Insert Names' – dialog by 'Insert – Names – Insert'" + InsertNamesInsert + Kontext "NamenEinfuegen" + Call DialogTest ( NamenEinfuegen ) + '/// Select name 'Test' + printlog " Select name 'Test'" + NamenAuswahl.Select "Test" + '/// Press 'OK' – button (the dialog will be closed) + printlog " Press 'OK' – button (the dialog will be closed)" + NamenEinfuegen.OK + '/// Press 'Enter' to leave the editmode of the cell + printlog " Press 'Enter' to leave the editmode of the cell" + kontext "DocumentCalc" + DocumentCalc.TypeKeys "<ESCAPE>" + '/// Open 'Define Names' -dialog by 'Insert – Names – Insert' + printlog " Open 'Define Names' -dialog by 'Insert – Names – Insert'" + InsertNamesInsert + Kontext "NamenEinfuegen" + '/// Press 'Insert All' – button (the dialog will be closed) + printlog " Press 'Insert All' – button (the dialog will be closed)" + Liste.click + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertNamesCreate +'///<u><b>Insert - Names – Create</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Open 'Create Names' – dialog by 'Insert – Names – Create' + printlog " Open 'Create Names' – dialog by 'Insert – Names – Create'" + InsertNameCreate + Kontext "NamenErzeugen" + DialogTest ( NamenErzeugen ) + '/// Check option 'Top row' + printlog " Check option 'Top row'" + Kopfzeile.check + '/// Check option 'Left column' + printlog " Check option 'Left column'" + LinkerSpalte.check + '/// Check option 'Bottom row' + printlog " Check option 'Bottom row'" + Fusszeile.check + '/// Check option 'Right column' + printlog " Check option 'Right column'" + RechterSpalte.check + '/// Press 'OK' button + printlog " Press 'OK' button" + NamenErzeugen.OK + '/// Close warningbox with 'OK' + printlog " Close warningbox with 'OK'" + Kontext + if active.exists (1) then + active.ok + end if + '/// Enter 'Create Names Test' in cell A1 + printlog " Enter 'Create Names Test' in cell A1" + call fCalcSelectRange ("A1") + DocumentCalc.TypeKeys "Create Names Test<RETURN>" + '/// Select cells A1:A4 + printlog " Select cells A1:A4" + call fCalcSelectRange ("A1:A4") + '/// Open 'Create Names' – dialog by 'Insert – Names – Create' + printlog " Open 'Create Names' – dialog by 'Insert – Names – Create'" + InsertNameCreate + Kontext "NamenErzeugen" + '/// Check that option 'Top row' is selected + printlog " Check that option 'Top row' is selected" + if not Kopfzeile.IsChecked then + warnlog "The header was not autodetected" + end if + '/// Press 'OK' button + printlog " Press 'OK' button" + NamenErzeugen.OK + '/// Select cells A1:A3 + printlog " Select cells A1:A3" + call fCalcSelectRange ("A1:A3") + '/// Open 'Create Names' – dialog by 'Insert – Names – Create' + printlog " Open 'Create Names' – dialog by 'Insert – Names – Create'" + InsertNameCreate + Kontext "NamenErzeugen" + '/// Press 'OK' button + printlog " Press 'OK' button" + NamenErzeugen.OK + '/// Close replacing messagebox with 'Cancel' + printlog " Close replacing messagebox with 'Cancel'" + Kontext + if active.exists (1) then + active.cancel + end if + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertNamesLabels +'///<u><b>Insert - Names – Labels</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Open 'Define Label Range' – dialog by 'Insert – Names – Labels' + printlog " Open 'Define Label Range' – dialog by 'Insert – Names – Labels'" + InsertNamesLabels + Kontext "BeschriftungsbereichFestlegen" + DialogTest ( BeschriftungsbereichFestlegen ) + '/// Press 'Shrink' button for range + printlog " Press 'Shrink' button for range" + ButtonZellbereich.Click + '/// Press 'Maximize' button on rangechooser + printlog " Press 'Maximize' button on rangechooser" + ButtonZellbereich.Click + '/// Press 'Shrink' button for data range + printlog " Press 'Shrink' button for data range" + ButtonDatenbereich.Click + '/// Press 'Maximize' button on rangechooser + printlog " Press 'Maximize' button on rangechooser" + ButtonDatenbereich.Click + '/// Switch between 'Contains ...' options + printlog " Switch between 'Contains ...' options" + Zeilenkoepfe.Check + Spaltenkoepfe.Check + '/// Press 'Add' – button + printlog " Press 'Add' – button" + Hinzufuegen.Click + '/// Select range + printlog " Select range" + Bereich.Select (2) + '/// Press 'Delete' – button + printlog " Press 'Delete' – button" + Loeschen.Click + '/// Confirm mesagebox with 'Yes' + printlog " Confirm mesagebox with 'Yes'" + Kontext + if active.exists then + active.Yes + end if + Kontext "BeschriftungsbereichFestlegen" + '/// Close 'Define Label Range' – dialog with 'Cancel' + printlog " Close 'Define Label Range' – dialog with 'Cancel'" + BeschriftungsbereichFestlegen.Cancel + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertNote +'///<u><b>Insert - Note</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Insert a note via 'Insert – Note' + printlog " Insert a note via 'Insert – Note'" + InsertNoteCalc + Kontext + '/// Enter 'This is a <Return> Testtext' into the note + printlog " Enter 'This is a <Return> Testtext' into the note" + DocumentCalc.TypeKeys "This is a <Return> Testtext" + '/// Leave note with <Escape> + printlog " Leave note with <Escape>" + DocumentCalc.TypeKeys "<Escape>" + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertPictureFromFile +'///<u><b>Insert - Picture – From File</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Open 'Insert Picture' – dialog by 'Insert – Picture – From File' + printlog " Open 'Insert Picture' – dialog by 'Insert – Picture – From File'" + InsertGraphicsFromFile + Kontext "GrafikEinfuegenDlg" + Call DialogTest (GrafikEinfuegenDlg) + '/// Enter filename 'global\input\graf_inp\' + printlog " Enter filename 'global\input\graf_inp\borabora.jpg'" + Dateiname.Settext convertpath(gTesttoolpath + "global\input\graf_inp\borabora.jpg") + '/// Verify that there are more than one filter available + printlog " Verify that there are more than one filter available" + if Dateityp.GetItemCount < 2 then + warnlog "The filterlist is empty" + end if + '/// Check 'Link' – option + printlog " Check 'Link' – option" + Link.Check + '/// Check 'Preview' - option + printlog " Check 'Preview' - option" + Preview.Check + '/// Close dialog with 'Open' + printlog " Close dialog with 'Open'" + Oeffnen.Click + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertMovieSound +'///<u><b>Insert - Movie and Sound</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Open 'Insert Movie and Sound' – dialog by 'Insert – Movie and Sound' + printlog " Open 'Insert Movie and Sound' – dialog by 'Insert – Movie and Sound'" + InsertMovieAndSound + Kontext "OeffnenDLG" + '/// Verify that there are more than one filter available + printlog " Verify that there are more than one filter available" + if Dateityp.GetItemCount < 2 then + warnlog "The filterlist is empty" + end if + '/// Close dialog with 'Cancel' + printlog " Close dialog with 'Cancel'" + OeffnenDLG.Cancel + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertObjectOLE +'///<u><b>Insert - Object – OLE Object</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Open 'Insert OLE Object' – dialog by 'Insert – Object – OLE Object' + printlog " Open 'Insert OLE Object' – dialog by 'Insert – Object – OLE Object'" + InsertObjectOLEObject + Kontext "OLEObjektEinfuegen" + '/// Choose 'Create new' + printlog " Choose 'Create new'" + NeuErstellen.Check + Call DialogTest (OLEObjektEinfuegen, 1) + '/// Check that there are more than 1 entries (amount is dependant from operating system) + printlog " Check that there are more than 1 entries (amount is dependant from operating system)" + if Objekttyp.getitemcount < 2 then + warnlog "There are no OLE-Objects in the listbox" + end if + '/// Choose 'Create from file' + printlog " Choose 'Create from file'" + AusDateierstellen.Check + Call DialogTest (OLEObjektEinfuegen, 2) + '/// Click on 'Search' – button + printlog " Click on 'Search' – button" + Durchsuchen.Click + Kontext "OeffnenDLG" + '/// Close 'Open' – dialog with 'Cancel' + printlog " Close 'Open' – dialog with 'Cancel'" + OeffnenDLG.Cancel + Kontext "OLEObjektEinfuegen" + '/// Check option 'Link to file' + printlog " Check option 'Link to file'" + Verknuepfen.check + '/// Close dialog with 'Cancel' + printlog " Close dialog with 'Cancel'" + OLEObjektEinfuegen.Cancel + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertObjectPlugin +'///<u><b>Insert - Object – Plug-in</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Open 'Insert Plug-in' – dialog by 'Insert – Object – Plug-in' + printlog " Open 'Insert Plug-in' – dialog by 'Insert – Object – Plug-in'" + InsertObjectPlugIn + Kontext "PlugInEinfuegen" + Call DialogTest (PlugInEinfuegen) + '/// Click on 'Browse' – button + printlog " Click on 'Browse' – button" + DurchSuchen.Click + Kontext "OeffnenDLG" + '/// Click on 'Default Directory' – button + printlog " Click on 'Default Directory' – button" + Standard.click + '/// Click on 'Create New Directory' – button + printlog " Click on 'Create New Directory' – button" + NeuerOrdner.Click + Kontext "NeuerOrdner" + '/// Close namedialog with 'Cancel' + printlog " Close namedialog with 'Cancel'" + NeuerOrdner.cancel + Kontext "OeffnenDLG" + '/// Close 'Open' – dialog with 'Cancel' + printlog " Close 'Open' – dialog with 'Cancel'" + OeffnenDlg.Cancel + '/// Close 'Insert Plug-in' – dialog with 'Cancel' + printlog " Close 'Insert Plug-in' – dialog with 'Cancel'" + Kontext "PluginEinfuegen" + PlugInEinfuegen.Cancel + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertObjectSound +'///<u><b>Insert - Object – Sound</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + try + '/// If enabled (depends on additional instalations on the OS) open the 'Insert Sound' – dialog by 'Insert – Object – Sound' + printlog " If enabled (depends on additional instalations on the OS) open the 'Insert Sound' – dialog by 'Insert – Object – Sound'" + InsertObjectSound + Kontext "OeffnenDlg" + '/// Click on 'Default Directory' – button + printlog " Click on 'Default Directory' – button" + Standard.click + '/// Click on 'Create New Directory' – button + printlog " Click on 'Create New Directory' – button" + NeuerOrdner.Click + Kontext "NeuerOrdner" + '/// Close namedialog with 'Cancel' + printlog " Close namedialog with 'Cancel'" + NeuerOrdner.cancel + Kontext "OeffnenDLG" + '/// Close 'Open' – dialog with 'Cancel' + printlog " Close 'Open' – dialog with 'Cancel'" + OeffnenDlg.Cancel + catch + printlog "Insert - Object - Sound is not possible on this machine" + endcatch + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertObjectVideo +'///<u><b>Insert - Object – Video</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument +try + '/// If enabled (depends on additional instalations on the OS) open the 'Insert Video' – dialog by 'Insert – Object – Sound' + printlog " If enabled (depends on additional instalations on the OS) open the 'Insert Video' – dialog by 'Insert – Object – Sound'" + InsertObjectVideo + Kontext "OeffnenDlg" + '/// Click on 'Default Directory' – button + printlog " Click on 'Default Directory' – button" + Standard.click + '/// Click on 'Create New Directory' – button + printlog " Click on 'Create New Directory' – button" + NeuerOrdner.Click + Kontext "NeuerOrdner" + '/// Close namedialog with 'Cancel' + printlog " Close namedialog with 'Cancel'" + NeuerOrdner.cancel + Kontext "OeffnenDLG" + '/// Close 'Open' – dialog with 'Cancel' + printlog " Close 'Open' – dialog with 'Cancel'" + OeffnenDlg.Cancel + catch + printlog "Insert - Object - Video is not possible on this machine" + endcatch + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertObjectFormular +'///<u><b>Insert - Object – Formular</b></u> + + '/// Open new Spraedsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Insert Formular by 'Insert – Object – Formular' + printlog " Insert Formular by 'Insert – Object – Formular'" + InsertObjectFormulaCalc + Kontext "SelectionMath" + if SelectionMath.Exists(2) then + call DialogTest (SelectionMath) + else + try + Kontext "DocumentCalc" + ViewSelectionCalc + Kontext "SelectionMath" + call DialogTest (SelectionMath) + catch + qaerrorlog "#i93427# Math Selection Dialog is not available" + endcatch + end if + '/// Close Formular with 'Esc' + printlog " Close Formular with 'Esc'" + Kontext "DocumentCalc" + DocumentCalc.TypeKeys "<Escape>" + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertChart +'///<u><b>Insert - Chart</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Open 'Chart Wizard' by 'Insert – Chart' + printlog " Open 'Chart Wizard' by 'Insert – Chart'" + InsertChart + Kontext "ChartWizard" + if ChartWizard.Exists(1) then + Call Dialogtest(ChartWizard) + '/// Close 'Chart Wizard' with 'Cancel' + ChartWizard.Cancel + else + warnlog "Chart wizard is not available" + end if + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + +'----------------------------------------------------------- + +testcase tInsertFloatingFrame +'///<u><b>Insert - Floating Frame</b></u> + + '/// Open new Spreadsheet document + printlog " Open new Spreadsheet document" + call hNewDocument + '/// Open 'Floating Frame Properties' – dialog by 'Insert – Floating Frame' + printlog " Open 'Floating Frame Properties' – dialog by 'Insert – Floating Frame'" + InsertFloatingFrame + Kontext "TabEigenschaften" + Dialogtest (TabEigenschaften) + '/// Click on 'Browse' – button for 'Contents' + printlog " Click on 'Browse' – button for 'Contents'" + Oeffnen.Click + Kontext "OeffnenDlg" + '/// Click on 'Default Directory' – button + printlog " Click on 'Default Directory' – button" + Standard.click + '/// Click on 'Create New Directory' – button + printlog " Click on 'Create New Directory' – button" + NeuerOrdner.Click + Kontext "NeuerOrdner" + '/// Close namedialog with 'Cancel' + printlog " Close namedialog with 'Cancel'" + NeuerOrdner.cancel + Kontext "OeffnenDLG" + '/// Close 'Select File for Floating Frame' – dialog with 'Cancel' + printlog " Close 'Select File for Floating Frame' – dialog with 'Cancel'" + OeffnenDlg.Cancel + Kontext "TabEigenschaften" + '/// Check 'Scrollbar' on + printlog " Check 'Scrollbar' on" + An.Check + '/// Check 'Scrollbar' off + printlog " Check 'Scrollbar' off" + Aus.Check + '/// Check 'Scrollbar' automatic + printlog " Check 'Scrollbar' automatic" + Automatisch.Check + '/// Check 'Border Off' + printlog " Check 'Border Off'" + UmrandungAus.Check + '/// Check 'Border On' + printlog " Check 'Border On'" + UmrandungAn.Check + '/// Uncheck 'Default' + printlog " Uncheck 'Default'" + BreiteStandard.UnCheck + '/// Increase 'Width' by 1 + printlog " Increase 'Width' by 1" + Breite.More + '/// Increase 'Height' by 1 + printlog " Increase 'Height' by 1" + Hoehe.More + '/// Check 'Default' + printlog " Check 'Default'" + HoeheStandard.Check + '/// Close 'Floating Frame Properties' – dialog with 'Cancel' + printlog " Close 'Floating Frame Properties' – dialog with 'Cancel'" + TabEigenschaften.Cancel + '/// Close document + printlog " Close starting document" + call hCloseDocument + +endcase + + |