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 /** 23 * 24 */ 25 package bvt.gui; 26 27 import static org.junit.Assert.*; 28 import static org.openoffice.test.common.Testspace.*; 29 import static org.openoffice.test.vcl.Tester.*; 30 import static testlib.gui.AppTool.*; 31 import static testlib.gui.UIMap.*; 32 33 import java.awt.Rectangle; 34 import java.io.File; 35 36 import org.junit.AfterClass; 37 import org.junit.Before; 38 import org.junit.BeforeClass; 39 import org.junit.Rule; 40 import org.junit.Test; 41 import org.openoffice.test.common.FileUtil; 42 import org.openoffice.test.common.GraphicsUtil; 43 import org.openoffice.test.common.Logger; 44 45 import testlib.gui.SCTool; 46 47 /** 48 * 49 */ 50 public class BasicFunctionTest { 51 52 @Rule 53 public Logger log = Logger.getLogger(this); 54 55 @BeforeClass 56 public static void beforeClass() { 57 app.clean(); 58 } 59 60 @AfterClass 61 public static void afterClass() { 62 app.stop(); 63 } 64 65 @Before 66 public void before() { 67 app.stop(); 68 app.start(); 69 } 70 71 72 @Test 73 public void smokeTest() { 74 File smoketestOutput = new File(aoo.getUserInstallation(), "user/temp"); 75 prepareData("TestExtension.oxt"); 76 // Open sample file smoketestdoc.sxw 77 open(prepareData("smoketestdoc.sxw")); 78 writer.waitForEnabled(10, 2); 79 // Run test cases 80 app.dispatch("vnd.sun.star.script:Standard.Global.StartTestWithDefaultOptions?language=Basic&location=document", 120); 81 String smoketestlog = FileUtil.readFileAsString(new File(smoketestOutput, "smoketest.log")); 82 String testclosurelog = FileUtil.readFileAsString(new File(smoketestOutput, "testclosure.log")); 83 log.info(smoketestlog + "\n" + testclosurelog); 84 assertTrue("No Error", !smoketestlog.contains("error") && !testclosurelog.contains("error")); 85 86 } 87 88 @Test 89 public void testExportAsPDF() throws Exception { 90 String file = prepareData("bvt/pdf.odt"); 91 String exportTo1 = getPath("temp/1.pdf"); 92 String exportTo2 = getPath("temp/2.pdf"); 93 deleteFile(exportTo1); 94 deleteFile(exportTo2); 95 open(file); 96 writer.waitForExistence(10, 1); 97 app.dispatch(".uno:ExportToPDF"); 98 pdfGeneralPage.ok(); 99 submitSaveDlg(exportTo1); 100 sleep(1); 101 String magic = FileUtil.readFileAsString(exportTo1).substring(0, 4); 102 assertEquals("PDF is exported?", "%PDF", magic); 103 104 button(".uno:ExportDirectToPDF").click();//Click via toolbar 105 submitSaveDlg(exportTo2); 106 sleep(1); 107 magic = FileUtil.readFileAsString(exportTo2).substring(0, 4); 108 assertEquals("PDF is exported directly?", "%PDF", magic); 109 } 110 111 /** 112 * Test the File -- Print Dialog show 113 * 114 */ 115 @Test 116 public void testPrinter() { 117 // Create a new text document 118 newTextDocument(); 119 app.dispatch(".uno:PrinterSetup"); 120 if (activeMsgBox.exists(2)) 121 activeMsgBox.ok(); 122 123 // PrintService[] ps = PrintServiceLookup.lookupPrintServices(null, null); 124 // String[] names = new String[ps.length]; 125 // for (int i = 0; i < ps.length; i++) { 126 // names[i] = ps[i].getName(); 127 // } 128 // 129 // assertArrayEquals("Printers Names", names, printerSetUpDlgPrinterNames.getItemsText()); 130 assertTrue("Printer Setup dialog appears", printerSetUpDlg.exists(3)); 131 printerSetUpDlg.cancel(); 132 } 133 134 /** 135 * Test the File -- Java Dialog show 136 * 137 */ 138 // @Test 139 // public void testJavaDialog() { 140 // 141 // // Create a new text document and launch a Wizards dialog which need JVM 142 // // work correctly. 143 // app.dispatch("private:factory/swriter"); 144 // File tempfile = new File(oo.getUserInstallation(), "user/template/myAgendaTemplate.ott"); 145 // FileUtil.deleteFile(tempfile); 146 // sleep(3); 147 // app.dispatch("service:com.sun.star.wizards.agenda.CallWizard?start"); 148 // sleep(5); 149 // assertTrue(Wizards_AgendaDialog.exists(10)); 150 // Wizards_AgendaDialog_FinishButton.click(); 151 // sleep(10); 152 // writer.focus(); 153 // sleep(1); 154 // app.dispatch(".uno:SelectAll"); 155 // typeKeys("<$copy>"); 156 // // System.out.println("now txt:"+app.getClipboard()); 157 // // assertTrue(app.getClipboard().startsWith("<Name>")); 158 // assertNotNull(app.getClipboard()); 159 // } 160 161 /** 162 * Test the Tools / Macros / Organize Dialogs" show 163 * 164 */ 165 @Test 166 public void testRunMacro() { 167 open(prepareData("bvt/macro.ods")); 168 calc.waitForExistence(10, 2); 169 app.dispatch(".uno:RunMacro"); 170 runMacroDlgCategories.expand("macro.ods"); 171 runMacroDlgCategories.expand("Standard"); 172 runMacroDlgCategories.select("Module1"); 173 runMacroDlgCommands.select(0); 174 runMacroDlg.ok(); 175 assertEquals("A3 should be =1+3", "4", SCTool.getCellText("A3")); 176 discard(); 177 } 178 179 /** 180 * Test the About Dialog show 181 * 182 */ 183 @Test 184 public void testHelp() { 185 app.dispatch(".uno:About"); 186 assertTrue(aboutDialog.exists(5)); 187 aboutDialog.ok(); 188 sleep(1); 189 typeKeys("<F1>"); 190 assertTrue(helpWindow.exists(5)); 191 helpWindow.close(); 192 } 193 194 /** 195 * Test inserting a picture in text document 196 * 197 * @throws Exception 198 */ 199 200 @Test 201 public void testInsertPictureInDocument() throws Exception { 202 String bmp_green = prepareData("image/green_256x256.bmp"); 203 String bmp_red = prepareData("image/red_256x256.bmp"); 204 205 // Create a new text document 206 newTextDocument(); 207 // Insert a picture fully filled with green 208 app.dispatch(".uno:InsertGraphic"); 209 submitOpenDlg(bmp_green); 210 writer.click(5,200); 211 sleep(1); 212 213 // Verify if the picture is inserted successfully 214 Rectangle rectangle = GraphicsUtil.findRectangle(writer.getScreenRectangle(), 0xFF00FF00); 215 assertTrue("Green Picture is inserted?" + rectangle, rectangle != null && rectangle.getWidth() > 10); 216 // insert another picture 217 app.dispatch(".uno:InsertGraphic"); 218 submitOpenDlg(bmp_red); 219 writer.click(5, 200); 220 sleep(1); 221 // Verify if the picture is inserted successfully 222 rectangle = GraphicsUtil.findRectangle(writer.getScreenRectangle(), 0xFFFF0000); 223 assertTrue("Green Picture is inserted? " + rectangle, rectangle != null && rectangle.getWidth() > 10); 224 discard(); 225 } 226 227 @Test 228 public void testInsertPictureInSpreadsheet() throws Exception { 229 String bmp_green = prepareData("image/green_64x64.png"); 230 String bmp_red = prepareData("image/red_64x64.png"); 231 newSpreadsheet(); 232 // Insert a picture fully filled with green 233 app.dispatch(".uno:InsertGraphic"); 234 submitOpenDlg(bmp_green); 235 calc.click(5, 150); 236 sleep(1); 237 238 // Verify if the picture is inserted successfully 239 Rectangle rectangle = GraphicsUtil.findRectangle(calc.getScreenRectangle(), 0xFF00FF00); 240 assertTrue("Green Picture is inserted?" + rectangle, rectangle != null && rectangle.getWidth() > 10); 241 242 SCTool.selectRange("C1"); 243 // insert another picture 244 app.dispatch(".uno:InsertGraphic"); 245 submitOpenDlg(bmp_red); 246 calc.click(5, 150); 247 sleep(1); 248 // Verify if the picture is inserted successfully 249 rectangle = GraphicsUtil.findRectangle(calc.getScreenRectangle(), 0xFFFF0000); 250 assertTrue("Red Picture is inserted? " + rectangle, rectangle != null && rectangle.getWidth() > 10); 251 discard(); 252 } 253 254 @Test 255 public void testInsertPictureInPresentation() throws Exception { 256 String bmp_green = prepareData("image/green_256x256.bmp"); 257 String bmp_red = prepareData("image/red_256x256.bmp"); 258 newPresentation(); 259 // Insert a picture fully filled with green 260 app.dispatch(".uno:InsertGraphic"); 261 submitOpenDlg(bmp_green); 262 impress.click(5, 5); 263 sleep(1); 264 265 // Verify if the picture is inserted successfully 266 Rectangle rectangle = GraphicsUtil.findRectangle(impress.getScreenRectangle(), 0xFF00FF00); 267 assertTrue("Green Picture is inserted?" + rectangle, rectangle != null && rectangle.getWidth() > 10); 268 // insert another picture 269 app.dispatch(".uno:InsertGraphic"); 270 submitOpenDlg(bmp_red); 271 impress.click(1, 1); 272 sleep(1); 273 // Verify if the picture is inserted successfully 274 rectangle = GraphicsUtil.findRectangle(impress.getScreenRectangle(), 0xFFFF0000); 275 assertTrue("Red Picture is inserted? " + rectangle, rectangle != null && rectangle.getWidth() > 10); 276 discard(); 277 } 278 279 @Test 280 public void testSlideShow() throws Exception { 281 open(prepareData("bvt/slideshow.odp")); 282 impress.waitForExistence(10, 2); 283 sleep(1); 284 impress.typeKeys("<F5>"); 285 sleep(3); 286 Rectangle rectangle = GraphicsUtil.findRectangle(slideShow.getScreenRectangle(), 0xFFFF0000); 287 assertNotNull("1st slide appears", rectangle); 288 slideShow.click(0.5, 0.5); 289 sleep(2); 290 rectangle = GraphicsUtil.findRectangle(slideShow.getScreenRectangle(), 0xFF00FF00); 291 assertNotNull("2nd slide appears", rectangle); 292 typeKeys("<enter>"); 293 sleep(2); 294 rectangle = GraphicsUtil.findRectangle(slideShow.getScreenRectangle(), 0xFF0000FF); 295 assertNotNull("3rd slide appears", rectangle); 296 slideShow.click(0.5, 0.5); 297 sleep(2); 298 rectangle = GraphicsUtil.findRectangle(slideShow.getScreenRectangle(), 0xFF0000FF); 299 assertNull("The end", rectangle); 300 slideShow.click(0.5, 0.5); 301 sleep(3); 302 assertFalse("Quit", slideShow.exists()); 303 } 304 305 @Test 306 public void testFind() { 307 open(prepareData("bvt/find.odt")); 308 writer.waitForExistence(10, 2); 309 app.dispatch(".uno:SearchDialog"); 310 findDlgFor.setText("OpenOffice"); 311 findDlgFind.click(); 312 sleep(1); 313 writer.typeKeys("<$copy>"); 314 assertEquals("OpenOffice", app.getClipboard()); 315 findDlgFindAll.click(); 316 sleep(1); 317 writer.typeKeys("<$copy>"); 318 assertEquals("OpenOfficeOpenOfficeOpenOffice", app.getClipboard()); 319 findDlgReplaceWith.setText("Awesome OpenOffice"); 320 findDlgReplaceAll.click(); 321 sleep(1); 322 msgbox("Search key replaced 3 times.").ok(); 323 findDlg.close(); 324 sleep(1); 325 assertEquals( 326 "Apache Awesome OpenOffice is comprised of six personal productivity applications: a word processor (and its web-authoring component), spreadsheet, presentation graphics, drawing, equation editor, and database. Awesome OpenOffice is released on Windows, Solaris, Linux and Macintosh operation systems, with more communities joining, including a mature FreeBSD port. Awesome OpenOffice is localized, supporting over 110 languages worldwide. ", 327 copyAll()); 328 discard(); 329 } 330 331 @Test 332 public void testFindFormulasAndValues() { 333 open(prepareData("bvt/searchFormulasValues.ods")); 334 calc.waitForExistence(10, 2); 335 336 // Searching for 2003 by formula finds A2 337 SCTool.selectRange("A1"); 338 app.dispatch(".uno:SearchDialog"); 339 findDlgFor.setText("2003"); 340 findDlgMore.click(); 341 findDlgCalcSearchIn.select("Formulas"); 342 findDlgFind.click(); 343 sleep(1); 344 assertEquals("wrong cell found for formulas search", "A2", scInputBarPosition.getText()); 345 findDlg.close(); 346 347 // Searching for October by value finds A2 348 SCTool.selectRange("A1"); 349 app.dispatch(".uno:SearchDialog"); 350 findDlgFor.setText("October"); 351 findDlgMore.click(); 352 findDlgCalcSearchIn.select("Values"); 353 findDlgFind.click(); 354 sleep(1); 355 assertEquals("wrong cell found for values search", "A2", scInputBarPosition.getText()); 356 findDlg.close(); 357 358 discard(); 359 } 360 361 @Test 362 public void testFillInSpreadsheet() { 363 String[][] expected1 = new String[][] { { "1" }, { "1" }, { "1" }, { "1" }, { "1" }, { "1" }, }; 364 String[][] expected2 = new String[][] { { "2" }, { "2" }, { "2" }, { "2" }, { "2" }, { "2" }, }; 365 String[][] expected3 = new String[][] { { "Hi friends", "Hi friends", "Hi friends", "Hi friends" } }; 366 String[][] expected4 = new String[][] { { "99999.999", "99999.999", "99999.999", "99999.999" } }; 367 String[][] expected5 = new String[][] { 368 { "99999.999", "-10" }, { "100000.999", "-9" }, { "100001.999", "-8" }, { "100002.999", "-7" }, { "100003.999", "-6" } 369 }; 370 newSpreadsheet(); 371 SCTool.selectRange("C5"); 372 typeKeys("1<enter>"); 373 SCTool.selectRange("C5:C10"); 374 app.dispatch(".uno:FillDown"); 375 assertArrayEquals("Fill Down:", expected1, SCTool.getCellTexts("C5:C10")); 376 377 SCTool.selectRange("D10"); 378 typeKeys("2<enter>"); 379 SCTool.selectRange("D5:D10"); 380 app.dispatch(".uno:FillUp"); 381 assertArrayEquals("Fill Up:", expected2, SCTool.getCellTexts("D5:D10")); 382 383 SCTool.selectRange("A1"); 384 typeKeys("Hi friends<enter>"); 385 SCTool.selectRange("A1:D1"); 386 app.dispatch(".uno:FillRight"); 387 assertArrayEquals("Fill Right:", expected3, SCTool.getCellTexts("A1:D1")); 388 389 SCTool.selectRange("D2"); 390 typeKeys("99999.999<enter>"); 391 SCTool.selectRange("A2:D2"); 392 app.dispatch(".uno:FillLeft"); 393 assertArrayEquals("Fill left:", expected4, SCTool.getCellTexts("A2:D2")); 394 395 SCTool.selectRange("E1"); 396 typeKeys("99999.999<tab>-10<enter>"); 397 398 SCTool.selectRange("E1:F5"); 399 app.dispatch(".uno:FillSeries"); 400 fillSeriesDlg.ok(); 401 sleep(1); 402 assertArrayEquals("Fill series..", expected5, SCTool.getCellTexts("E1:F5")); 403 discard(); 404 } 405 406 @Test 407 public void testSort() { 408 String[][] expected1 = new String[][] { { "-9999999" }, { "-1.1" }, { "-1.1" }, { "0" }, { "0" }, { "0.1" }, { "10" }, { "12" }, { "9999999" }, { "9999999" }, 409 410 }; 411 String[][] expected2 = new String[][] { { "TRUE", "Oracle" }, { "TRUE", "OpenOffice" }, { "FALSE", "OpenOffice" }, { "TRUE", "IBM" }, { "FALSE", "IBM" }, 412 { "TRUE", "Google" }, { "FALSE", "facebook " }, { "TRUE", "Apache" }, { "TRUE", "!yahoo" }, { "TRUE", "" }, 413 414 }; 415 416 String[][] expected3 = new String[][] { { "Sunday" }, { "Monday" }, { "Tuesday" }, { "Wednesday" }, { "Thursday" }, { "Friday" }, { "Saturday" }, 417 418 }; 419 420 String[][] expected4 = new String[][] { { "-$10.00" }, { "$0.00" }, { "$0.00" }, { "$1.00" }, { "$3.00" }, { "$9.00" }, { "$123.00" }, { "$200.00" }, { "$400.00" }, 421 { "$10,000.00" }, 422 423 }; 424 open(prepareData("bvt/sort.ods")); 425 calc.waitForExistence(10, 2); 426 SCTool.selectRange("A1:A10"); 427 app.dispatch(".uno:DataSort"); 428 sortWarningDlgCurrent.click(); 429 assertEquals(1, sortPageBy1.getSelIndex()); 430 sortPage.ok(); 431 sleep(1); 432 assertArrayEquals("Sorted Data", expected1, SCTool.getCellTexts("A1:A10")); 433 SCTool.selectRange("B1:C10"); 434 app.dispatch(".uno:DataSort"); 435 436 sortPageBy1.select(2); 437 sortPageDescending1.check(); 438 assertFalse(sortPageBy3.isEnabled()); 439 assertFalse(sortPageAscending3.isEnabled()); 440 assertFalse(sortPageDescending3.isEnabled()); 441 sortPageBy2.select(1); 442 assertTrue(sortPageBy3.isEnabled()); 443 assertTrue(sortPageAscending3.isEnabled()); 444 assertTrue(sortPageDescending3.isEnabled()); 445 sortPageDescending2.check(); 446 sortPageBy2.select(0); 447 assertFalse(sortPageBy3.isEnabled()); 448 assertFalse(sortPageAscending3.isEnabled()); 449 assertFalse(sortPageDescending3.isEnabled()); 450 sortPageBy2.select(1); 451 sortPage.ok(); 452 sleep(1); 453 454 assertArrayEquals("Sorted Data", expected2, SCTool.getCellTexts("B1:C10")); 455 SCTool.selectRange("D1:D7"); 456 app.dispatch(".uno:DataSort"); 457 sortWarningDlgCurrent.click(); 458 sortOptionsPage.select(); 459 sortOptionsPageRangeContainsColumnLabels.uncheck(); 460 sortOptionsPageCustomSortOrder.check(); 461 sortOptionsPageCustomSortOrderList.select("Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday"); 462 sortOptionsPage.ok(); 463 sleep(1); 464 assertArrayEquals("Sorted Data", expected3, SCTool.getCellTexts("D1:D7")); 465 466 SCTool.selectRange("E1:E10"); 467 app.dispatch(".uno:DataSort"); 468 sortWarningDlgCurrent.click(); 469 sortPage.ok(); 470 sleep(1); 471 assertArrayEquals("Sorted Data", expected4, SCTool.getCellTexts("E1:E10")); 472 discard(); 473 } 474 475 /** 476 * Test insert a chart in a draw document 1. New a draw document 2. Insert a 477 * chart 3. Check if the chart is inserted successfully 478 * 479 * @throws Exception 480 */ 481 @Test 482 public void testInsertChartInDraw() throws Exception { 483 // Create a new drawing document 484 newDrawing(); 485 // Insert a chart 486 app.dispatch(".uno:InsertObjectChart"); 487 sleep(3); 488 489 // Verify if the chart is inserted successfully 490 assertTrue("Chart Editor appears", chart.exists(3)); 491 // Focus on edit pane 492 draw.click(5, 5); 493 sleep(1); 494 assertFalse("Chart Editor appears", chart.exists()); 495 discard(); 496 } 497 498 /** 499 * Test insert a chart in a text document 1. New a text document 2. Insert a 500 * chart 3. Check if the chart is inserted successfully 501 * 502 * @throws Exception 503 */ 504 @Test 505 public void testInsertChartInDocument() throws Exception { 506 // Create a new text document 507 newTextDocument(); 508 // Insert a chart 509 app.dispatch(".uno:InsertObjectChart"); 510 sleep(3); 511 512 // Verify if the chart is inserted successfully 513 assertTrue("Chart Editor appears", chart.exists(3)); 514 // Focus on edit pane 515 writer.click(5, 5); 516 sleep(1); 517 assertFalse("Chart Editor appears", chart.exists()); 518 discard(); 519 } 520 521 /** 522 * Test insert a chart in a spreadsheet document 1. New a spreadsheet 523 * document 2. Insert a chart 3. Check if the chart is inserted successfully 524 * 525 * @throws Exception 526 */ 527 @Test 528 public void testInsertChartInSpreadsheet() throws Exception { 529 // Create a new spreadsheet document 530 newSpreadsheet(); 531 // Insert a chart 532 app.dispatch(".uno:InsertObjectChart"); 533 sleep(3); 534 chartWizard.ok(); 535 536 // Verify if the chart is inserted successfully 537 assertTrue("Chart Editor appears", chart.exists(3)); 538 // Focus on edit pane 539 calc.click(5, 5); 540 sleep(1); 541 assertFalse("Chart Editor appears", chart.exists()); 542 discard(); 543 } 544 545 /** 546 * Test insert a chart in a presentation document 1. New a presentation 547 * document 2. Insert a chart 3. Check if the chart is inserted successfully 548 * 549 * @throws Exception 550 */ 551 @Test 552 public void testInsertChartInPresentation() throws Exception { 553 // Create a new presentation document 554 newPresentation(); 555 // Insert a chart 556 app.dispatch(".uno:InsertObjectChart"); 557 sleep(3); 558 // Verify if the chart is inserted successfully 559 assertTrue("Chart Editor appears", chart.exists(3)); 560 // Focus on edit pane 561 impress.click(5, 5); 562 sleep(1); 563 assertFalse("Chart Editor appears", chart.exists()); 564 discard(); 565 } 566 567 /** 568 * Test insert a table in a draw document 1. New a draw document 2. Insert a 569 * default table 3. Check if the table is inserted successfully 570 * 571 * @throws Exception 572 */ 573 @Test 574 public void testInsertTableInDraw() throws Exception { 575 // Create a new drawing document 576 newDrawing(); 577 // Insert a table 578 app.dispatch(".uno:InsertTable"); 579 insertTable.ok(); 580 sleep(1); 581 draw.typeKeys("3"); 582 assertTrue("Table Toolbar appears", tableToolbar.exists(3)); 583 // assertEquals("The cell content", "3", copyAll()); 584 discard(); 585 } 586 587 /** 588 * Test insert a table in a text document 1. New a text document 2. Insert a 589 * default table 3. Check if the table is inserted successfully 590 * 591 * @throws Exception 592 */ 593 @Test 594 public void testInsertTableInDocument() throws Exception { 595 // Create a new text document 596 newTextDocument(); 597 // Insert a table 598 app.dispatch(".uno:InsertTable"); 599 writerInsertTable.ok(); 600 sleep(1); 601 writer.typeKeys("3"); 602 // Verify if the table toolbar is active 603 assertTrue("Table Toolbar appears", tableToolbar.exists(3)); 604 // assertEquals("The cell content", "3", copyAll()); 605 discard(); 606 } 607 608 /** 609 * Test insert a table in a presentation document 1. New a presentation 610 * document 2. Insert a default table 3. Check if the table is inserted 611 * successfully 612 * 613 * @throws Exception 614 */ 615 @Test 616 public void testInsertTableInPresentation() throws Exception { 617 // Create a new presentation document 618 newPresentation(); 619 620 // Insert a table 621 app.dispatch(".uno:InsertTable"); 622 insertTable.ok(); 623 sleep(1); 624 impress.typeKeys("3"); 625 assertTrue("Table Toolbar appears", tableToolbar.exists(3)); 626 // assertEquals("The cell content", "3", copyAll()); 627 discard(); 628 } 629 630 /** 631 * Test insert a function in a spreadsheet document via Sum button 1. New a 632 * spreadsheet document 2. Insert a function via Sum button 3. Check if the 633 * result is correct 634 * 635 * @throws Exception 636 */ 637 @Test 638 public void testSumInFormulaBar() throws Exception { 639 // Create a new spreadsheet document 640 newSpreadsheet(); 641 // Insert source numbers 642 String sourceNumber1 = "5"; 643 String sourceNumber2 = "3"; 644 String expectedResult = "8"; 645 SCTool.selectRange("A1"); 646 typeKeys(sourceNumber1); 647 SCTool.selectRange("B1"); 648 typeKeys(sourceNumber2); 649 // Insert a function via Sum button 650 SCTool.selectRange("C1"); 651 scInputBarSum.click(); 652 typeKeys("<enter>"); 653 // Verify if the calculated result is equal to the expected result 654 assertEquals("The calculated result", expectedResult, SCTool.getCellText("C1")); 655 discard(); 656 } 657 658 /** 659 * Test insert a function in a spreadsheet document via inputbar 1. New a 660 * spreadsheet document 2. Insert a function via inputbar: COS 3. Check if 661 * the result is correct 662 * 663 * @throws Exception 664 */ 665 @Test 666 public void testInsertFunctionViaFormulaBar() throws Exception { 667 // Create a new spreadsheet document 668 newSpreadsheet(); 669 // Insert source numbers and expected result 670 String sourceData = "0"; 671 String expectedResult = "1"; 672 SCTool.selectRange("A1"); 673 typeKeys(sourceData); 674 675 // Insert a function via inputbar: COS 676 SCTool.selectRange("D1"); 677 scInputBarInput.inputKeys("=COS(A1)"); 678 typeKeys("<enter>"); 679 680 // Verify if the calculated result is equal to the expected result 681 assertEquals("The calculated result", expectedResult, SCTool.getCellText("D1")); 682 discard(); 683 } 684 685 /** 686 * Test insert a function in a spreadsheet document via Function Wizard 687 * Dialog 1. New a spreadsheet document 2. Insert a function via Function 688 * Wizard Dialog: ABS 3. Check if the result is correct 689 * 690 * @throws Exception 691 */ 692 @Test 693 public void testFunctionWizardInFormulaBar() throws Exception { 694 // Create a new spreadsheet document 695 newSpreadsheet(); 696 // Insert source number 697 String sourceNumber = "-5"; 698 String expectedResult = "5"; 699 SCTool.selectRange("A1"); 700 typeKeys(sourceNumber); 701 typeKeys("<enter>"); 702 // Insert a function via Function Wizard Dialog: ABS 703 SCTool.selectRange("B1"); 704 app.dispatch(".uno:FunctionDialog"); 705 // SC_FunctionWizardDlg_FunctionList.doubleClick(5, 5); 706 scFunctionWizardDlgFunctionList.select("ABS"); 707 scFunctionWizardDlgNext.click(); // Use "Next" button 708 scFunctionWizardDlgEdit1.typeKeys("A1"); 709 scFunctionWizardDlg.ok(); 710 // Verify if the calculated result is equal to the expected result 711 assertEquals("The calculated result", expectedResult, SCTool.getCellText("B1")); 712 discard(); 713 } 714 } 715
