Using Screen Power Integrated and Lotus 1-2-3

We have provided a special Lotus 1-2-3 environment file with Screen
Power Integrated.  The environment file 123.SPI in your Screen
Power Integrated directory, has comprehensive settings for Lotus 
1-2-3.  These settings feature many special Screen Power capabilities,
such as hotkeys, windows, monitors, and macros.  The 123.SPI
environment has been created and tested with versions 2.01, 2.3 and
2.4.  All you need to do is load the environment prior to entering
Lotus.  See instructions for loading environments in your Screen
Power Integrated manual.  There is a quick reference list for the Hotkeys
defined in this environment included at the end of this document.

The Lotus environment includes several hotkeys.  Some of the
hotkeys activate windows or monitors.  Some activate macros that,
in turn, activate other macros.  We will not describe the contents
or format of these hotkeys, windows, monitors, and macros. 
Instead, we will focus only on describing what the Lotus 1-2-3
functions will do when the 123.SPI environment is operational.  At
times there will be brief descriptions of Lotus commands and how
they behave on the screen.  This document is not a tutorial in
Lotus and therefore we recommend you refer to a Lotus 1-2-3 manual
for details on using Lotus. 


Movement From Cell to Cell

When you use the arrow keys to move from cell to cell, you usually
need to know two things: (1) what cell you moved to, and (2) the
cell contents.  Using hotkeys, monitors, and macros, the Lotus
environment does just that.  

Every time you move to a new cell, Screen Power Integrated tells
you the cell number and its contents.  For example, if you move to
cell B5, which contains the number 150, Screen Power Integrated
will say, "B five colon one hundred fifty."

The braille display will show the cell contents at the left edge of
the braille display.  Displaying the highlighted contents at the
left edge provides a convenient way to focus just on the
highlighted area and reduces the time necessary to locate a cursor
under a highlighted item. 


Using the 1-2-3 Menu System

The Lotus 1-2-3 command to activate the main menu is the / (slash)
key.  When you press the / key, Lotus displays the main menu on row
2 of the screen.  Lotus then highlights the first menu selection in
row 2.  As you move left and right through the menu selections 
items are highlighted by the menu bar.  Row 3 contains the
additional menu selections for each highlighted item on row 2.   
Pressing the enter key selects the highlighted item and produces a
sub-menu of choices relating to the selected item.  The sub-menu
choices are also located on row 2 with added information about the
currently highlighted item on row 3.  

Screen Power Integrated automatically reads the highlighted menu
selection in row 2, then reads all the additional menu choices on
row 3.  If you press the ENTER key to select a menu item, Lotus
displays that item on row 2, and its sub-menu choices or its
instructions on row 3.  Screen Power also automatically reads this
information.  

You can also read all of row 2 by pressing ALT-1.  You can read
just the highlighted menu selection on row 2 by pressing ALT-2. 
Read the additional menu choices on row 3 by pressing ALT-3.  

When the Lotus menu is active, the highlighted menu item on line 2
is displayed at the left edge of the braille display.  When you
move through the menu choices using the left and right arrows, the
current highlighted item is displayed at the left edge.  

Reading the sub-menu or additional information on line 3, is done
one of two ways.  You can Press ALT-3 to move the braille display
to the beginning of row 3, or you can simply use the appropriate
navigation keys to move the braille display forward/down to the
beginning of line 3.  

Exiting the 1-2-3 menu system is done by pressing the ESC key until
all menu choices are gone from line 2 and 3.  At this point, Screen
Power Integrated will say the current cell and contents to indicate 
that the menu system is no longer activate and the braille display 
returns to the spreadsheet at the cell position from where the menu 
system was first invoked.


Reading Cell Formulas, Contents, and Locations

You can read the formula of the current cell at any time by
pressing ALT-5.  Speak the cell contents by pressing ALT-7.  Read
the cell location by pressing ALT-6.  

You can read the formula or location of the current cell at any
time by pressing either ALT-5 or ALT-6.  Formulas and cell
locations are displayed on line one starting at the left edge.  

Pressing ALT-5, tells Screen Power Integrated to speak the formula
for the current cell and to position the braille display starting
at line one column one.  Pressing ALT-6 tells Screen Power to speak
the current cell location and to position the braille display on
line one column one (Screen Power goes back to normal cell and contents
navigation as soon as you move to a new cell location).

In either case, the braille display is moved to the line containing
the spoken information, making it easy for the user to verify in
braille the verbalized messages.  Also, if the speech is shut-off,
one could still receive the appropriate information regarding the
formula and location of a specific cell.

In order to return to the cell contents in the worksheet, press
ALT-7.  The ALT-7 key always moves the braille display to the
highlighted cell, thereby displaying the cell contents. 
Continually pressing ALT-7 will cause Screen Power Integrated to
speak the contents and location without moving the braille display 
away from the cell.


Reading Mode, Status, and Error Indicators

Screen Power Integrated will automatically inform you whenever mode
indicators, status indicators, or error messages change or appear
by speaking them.  Mode indicators always appear in the upper right
corner of the screen, at the far right of line 1.  When you enter
the 1-2-3 menu by pressing the slash key, the mode indicator on
line 1 displays the word menu at the far right.  When you are at a
specific cell, the mode indicator reads ready.

Error messages appear either at the end of line 1 or at the
beginning of line 25.  Status indicators appear on the right-hand
half of row 25.  

To speak the mode or error indicator with the braille display, at 
the end of row 1, press ALT-9.  To read status indicators or error
messages using braille and speech on row 25, press ALT-8.  

ALT-8 moves the braille display to the beginning of line 25.  To
see the status indicators, you can press ALT-8 and then press a 
braille navigation key to move the braille display right to display 
to the right half of the line.

The mode indicator is rarely announced by Screen Power during normal 
operation.  The "WAIT" message is 1 exception to this since it is 
helpful to see this during a delay in 1-2-3 operations.  To see the 
mode indicator at any time, press ALT-9 and the braille display will
move to the right half of line one if you are using a 40 cell system.  
An eighty cell system will of course occupy the whole top line of the 
screen.

When an error occurs, the mode indicator changes to "ERROR" and a 
message box typically appears in the middle of the screen with Lotus 
Version 2.3 and 2.4 (other versions of Lotus will either put the error 
message itself on line 25 or a message referring to the Help services 
for further definition).  The Screen Power Integrated Lotus environment
moves the braille display to the error mode indicator on line 1.  At 
that point, you can still use ALT-8 to read anything on the bottom line 
or ALT-Control-F4 to read the error message pop-up in the center of the 
screen.

Reading Status and Help Screens in Release 2.3 and 2.4:

Lotus 1-2-3 releases 2.01, 2.3 and 2.4 have different formats for
Status and Help screens.  We have created separate commands for
each.  1-2-3 release 2.3 and 2.4 contains status boxes for several
functions, including global worksheet settings and printer
information.  These status boxes overlay the current worksheet. 
They do not entirely cover or replace the worksheet screen.

Release 2.3 and 2.4 Status screens have a cyan background.  Their 
titles are in a black background with the text on line 4 and 
information beginning at line 6.  At the bottom of each Status 
screen is a message with a blue background, telling you what key to 
press in order to exit or edit the Status screen.  In addition, the 
Status screen Edit mode has (at the bottom line of the settings box) 
a menu bar with selections in a black background and with the 
highlighted choice in blue a background.  

Press ALT-Control-F1 to speak the Status screen information.  This
command speaks all cyan background text in rows 5 to 24. 

ALT-Control-F1 also moves the braille display to the header of the 
dialog box on line 4.  Using the braille navigation keys you can 
read down the screen until you reach the bottom of the text.  

Note: while reading the settings or status display in this way you 
may detect some text which is in the worksheet behind the dialog box.

Press ALT-Control-F2 to speak the (black background) titles.  This 
command reads all black background text in row 4.

Press ALT-Control-F3 to speak the (blue background) highlighted menu 
bar selection within the Settings screens, and to read the "Press 
any Key..." or "Press F2..." messages at the bottom of various 
screens.  This command speaks all blue background text in rows 5 
to 24 and links the braille display to the soft cursor. When editing 
the settings in lotus version 2.3 and 2.4 you can use the braille 
navigation keys to examine various screen contents and the arrow or 
tab keys to move from one option to the other.  The braille display 
will track the highlight bar but speech will not.  If you wish to 
hear the highlighted item press Alt-Control-F3 again.

The Help screens in release 2.3 and 2.4 are overlays in the middle 
of the screen.  The Help information and topics are listed in a 
white background in rows 4 through 24.  The highlighted topic you 
select is in a blue-background menu bar somewhere in this area.  The 
ALT-Control-F3 key, in addition to its Status screen uses, provides 
assistance for reading the Help screens.  However, you usually don't 
have to use this hotkey since the help monitor activates this 
function for you when a menu appears on the Help screens.  

Note:  Pressing Alt-Control-Home will read all the information in the Help
Screen windows.  If you wish to examine it with the Braille Display, press
the Left Button / Left Rocker Up simultaneously on the Power Braille panel
keys.  This will take the display to the upper left corner of the active
braille window (which is set for the Help Screens).  From here you may use
the right and left buttons to read each line.  The braille display width will
change from 40 cells to 26 cells so that you will not have to re-orient
yourself on the second half of each line; when you leave the Help Screen it
will return to 40 cells.

Lotus 1-2-3 releases 2.01, 2.3, and 2.4 have different formats for
Status and Help screens.  We have created separate commands for each.  

Reading Status and Help screens for Lotus version 2.3 and 2.4:

Press ALT-Control-HOME to speak the entire Help screen, including the 
highlighted topics.  The braille display will track the highlighted 
items in the help dialog boxes.  If you press Alt-Control-F3 while 
in Help, the Braille display will move to the top of the help screen, 
while speech reads the bottom line.  So, you can use Alt-Control-Home 
to speak the Help screen and the Braille navigation keys to display 
the Help screen in braille.


Reading Status and Help Screens in Release 2.01:

For release 2.01 the Help screens have a different highlighted text 
for Help items which have additional text;  the braille display will
automatically track these highlighted items.  To speak the 
highlighted item press Alt-Control-F9.  To read the text for any 
Help screen, press Alt-Control-End (this reads a different part of 
the screen than Alt-Control-Home, which is for reading the help 
screens in version 2.3 and 2.4).

The Status screens for Lotus version 2.01 have a mix of green and 
white text.  Press ALT-Control-End to read these screens also.


Reading Cell Address, Contents, and Formula:

Regarding Speech:

You can put Screen Power into any of four different modes, depending 
on what you want to hear when you move from cell to cell.  You can 
have Screen Power read you:

      the cell address and formula
      the cell address only [ not applicable for braille ]
      the cell contents only
      the cells address and contents [ not possible for braille ]


Press ALT-Control-F5 to put Screen Power Integrated into a mode in
which it speaks the cell address and formula.  Screen Power will
say "formula mode."  Press ALT-Control-F6 to put Screen Power
Integrated into a mode in which it speaks the cell address only. 
Screen Power will not announce this mode. 
Press ALT-Control-F7 to put Screen Power Integrated into a mode in
which it speaks the cell contents only.  It will say "row and
columns off."


Press ALT-Control-F8 to put Screen Power into a mode in which it
speaks the cell address and contents.  It will say "row and columns on."


Regarding braille:

You can put Screen Power Integrated into one of
two different modes, depending on what you want to read when you
move from cell to cell.  You can have Screen Power Integrated show
you the cell address and formula or just the cell contents.

Press ALT-Control-F5 to put Screen Power Integrated into a mode in which 
it displays the cell address and formula.  Screen Power Integrated 
will move the braille display to the beginning of line 1.

ALT-Control-F7, Alt-Control-F6 or Alt-Control-F8 puts Screen Power Integrated
into its default mode.  That is, it initiates soft cursor tracking to display
active cell contents.
Quick Reference:   Summary of Screen Power Hotkeys for Lotus 123:

ALT-1     Reads all of Row 2.

ALT-2     Read just highlighted menu item on Row 2.

ALT-3     Read the additional menu choices on Row 3.

ALT-4     Read the highlighted item on Row 3.

ALT-5     Read the formula of the current cell.

ALT-6     Read the cell location only.

ALT-7     Read the current cell contents.  Restores "normal" operation.

ALT-8     Reads status or error messages on line 25.

ALT-9     Read the mode indicator at the end of line 1 (also indicates when
          there is an error).

ALT-CTRL-F1    Read all cyan background text on lines 5 through 24; Speaks
               status screen info and moves braille to header of dialog box
               on line 4; use unlinked panel keys after that.

ALT-CTRL-F2    Speak black background text on line 4 (headers of dialog
               boxes).

ALT-CTRL-F3    Lotus version 2.3 and 2.4:  Speak blue background highlighted
               text in lines 5 through 24;  Speaks highlighted items in
               Settings Screens and Help Screens as well as the "Press any
               key" messages.  Links braille display to soft cursor, which
               tracks items in Help Screens but does not speak them... press
               ALT-CTRL-F3 again to hear them.

ALT-CTRL-F4    Read the pop-up error messages in Lotus  2.3 and 2.4.

ALT-CTRL-F5    Cell address and formula mode.

ALT-CTRL-F6    Cell address mode (speaks only the cell address).

ALT-CTRL-F7    Cell contents only ("Row and Columns OFF").

ALT-CTRL-F8    Cell address and contents ("Row and Columns ON").

ALT-CTRL-F9    Lotus 2.01:  Speak highlited Help items.

ALT-CTRL-F10 through F12 are not used.       

ALT-CTRL-HOME  Lotus 2.3 and 2.4:  Speak the entire HELP screen.

ALT-CTRL-END   Lotus 2.01:  Speak the entire HELP screen or Status Screen.