## Display Device Driver Reference for OS/2

[prev][next][parent][TOC]

### Testing Video Device Drivers Using LOTUS 123

This section describes a nonexhaustive test of the 16-bit Lotus 123 for OS/ 2.

Conventions

Throughout this procedure, keys to be pressed are denoted by brackets ([ ] ), such as [F9], [Ctrl+PgDn].

A string of characters is denoted by quotations (" "), such as "\FIRST". If instructed to type "string", type the string without the quotes.

Directory references are relative to the root directory, and are not drive -specific. The drive on which the application is installed is implied.

Lotus 123 for OS/2 uses a graphical user interface with window and menu displays. This test case uses the convention MainMenuItem | SubMenuItem. Select the MainMenuItem first, the SubMenuItem second.

Installing LOTUS 123

Note: If you do not have LOTUS 123 installed, refer to your LOTUS 123 Installation Manual for instructions.

Starting Lotus 123

1.Double-click on the 123 folder on the desktop.

2.Double-click on the 123 icon to start the program.

3.Click on the Maximize button once the application appears on the screen.

Getting Help

1.Select Help. A help window appears with WORKSHEET on the menu bar.

2.Click on How do I...; the text screen displays the information.

3.Click on Previous to go back.

4.Click on Graph Tool. The mouse pointer changes to a ? on the text screen .

5.Click on Cancel to exit the help window.

Working with a Spreadsheet

Create a Spreadsheet

1.Make A1 the active cell.

Note: To make a cell active, click once on that cell.

2.Type "Salary" and press [Down] to enter text for A1.

3.Type "Inventory" and press [Down] to enter text for A2.

4.Type "Overhead" and press [Down] to enter text for A3.

5.Press [Down], type "Total Expenses" and press [Down] to enter text for A5.

6.Press [Down], type "Revenues" and press [Down] to enter text for A7.

7.Press [Down], type "Operating Income" and press [Enter] to enter text for A9.

8.Make B1 the active cell.

9.Type "192000" and press [Down] to enter a value for B1.

10.Type "95000" and press [Down] to enter a value for B2.

11.Type "87000" and press [Enter] to enter a value for B3.

12.Make B7 the active cell.

13.Type "995000" and press [Enter] to enter a value for B7.

Verify that video corruption does not occur in all operations.

Formatting the Spreadsheet

1.Select cells B1-B9 by dragging from B1 to B9.

2.Select Copy...

3.Click on the To: box.

4.Type "A: C1" and select OK.

5.Select the first column by clicking on the letter A at top of the column .

6.Select Worksheet | Column...

7.Click on the box with the current column width. The default should be 9.

8.Change the width to 18 and then select OK. The text should fit properly in the column.

9.Select columns B and C by clicking on the letter B and dragging across to the letter C.

10.Repeat steps 5 and 6 and change the column width to 12.

11.Select Range | Format...

12.Select Currency and then select OK. The cells are formatted as currency.

Building a Formula

1.Make B5 the active cell.

2.Type "+b1+b2+b3" and press [Enter]. B5 should contain the sum of b1 through b3.

3.Make B9 the active cell.

4.Type "+b7-b5" and press [Enter]. B9 should contain the updated income. B9 should still be active.

5.Select Copy...

6.Click on the To: box.

7.Change the entry to "A: C9" and click on Options.

8.Make sure Formulas is selected and select OK.

9.Select OK to complete the copy. Note that B9 and C9 are different.

10.Follow steps 5 and 6 to copy B5 to C5. C9 has changed.

Editing Information

1.Select row 1 by clicking on the number 1 on the first row.

2.Select Worksheet | Insert...

3.Select Row and select OK.

4.Make B1 the active cell.

5.Type " '1992 Forecast" and press [Right].

6.Type " '1992 Actual" and press [Enter].

7.Make C2 the active cell.

8.Type "195000" and press [Down].

9.Type "96000" and press [Enter]. The Total Expenses and Operating Income changed each time.

Working with Graphs

Creating a Graph

1.Select cells A1 to C10 by dragging the mouse from A1 through C10.

2.Select Graph | Options | Titles...

3.Click on the First box and type "Test Graph".

4.Press [Tab], type "Lotus 123", and then select OK.

5.Select Graph | View. The SHEET.GPH is shown. Note that the blue line is not visible because it is overlapped by the red line.

Changing a Graph Type

1.Resize both the worksheet and the graph window so that both of them are side by side.

2.Make sure the highlighted area (A1 to C10) is shown in the smaller window.

3.Make the graph window active.

4.Select Type | Bar to see a bar graph.

5.Select Type | Area to see a area graph.

6.Select Type | Pie to see a pie graph.

7.Select Type | 3-D Bar to see a 3-D bar graph. The legends are tangled together.

8.Select Type | Bar to show a bar graph again.

9.Make the worksheet window active.

10.Make C8 the active cell.

11.Type "600000" and press [Enter]. The red bar in the bar graph is shorter .

12.Make B8 the active cell.

13.Type "300000" and press [Enter]. The blue bar of Operating Income is negative.

14.Make the graph window active.

15.Select Layout | Printer View. The window will show a full page preview of the graph.

16.Select Type | Horizontal. The graph is flipped sideways.

17.Select Layout | Window View to get a closer look.

18.Close the SHEET1.GPH without saving any changes.

Macro

Creating a Macro

1.Maximize the worksheet window.

2.Make E1 the active cell.

3.Select Range | Name | Create...

4.Type "\A" and select OK. [Ctrl + A] is the hot key for this macro. E1 should still be active.

5.Type " '/rgb2~20000{D}1500{D}2000{R}3500{U}5000{U}55000~" and press [ Down].

6.Type " '/rga12~Macro is finished!!!~" and press [Down].

7.Type " '{QUIT}" and press [Enter] to indicate the end of this macro.

Running the Macro

1.Make A1 the active cell.

2.Press [Ctrl+A] to start the macro. Cells B2 through C4 are changed and the totals are updated.

Finishing

Exiting and Cleaning Up

1.Click on the system icon and select Close.

2.Select NO to not save SHEET1.WG2.

Verify that video corruption does not occur in all operations.