1-2-3 Release 5 for Windows Product Updates (README.TXT)

**CONTENTS**

1.  Updating Release 4 Worksheet Files to Release 5
2.  Install
      Information for Upgraders
      Installing on Computers with Multiple Configurations
      Server and Distribution Install
3.  Windows and Available Memory
4.  Charting Information for Upgraders
5.  Printing Performance Information
      Printer Drivers and Devices
      Print Resolution
6.  DataLens and ODBC Drivers
      ODBC Drivers
      Environment Variables
7.  Version Manager
8.  Solver
9.  Command-Line Parameters
10. Corrections to the Documentation
      Macros Help
      Help for 1-2-3 Messages
      The Guided Tour
11. Font Usage
      Font Mapping
      Font Performance Tips
      Removing ATM
12. Map Performance Information
      Finding the Correct Map Type
      Map Resolution
      Map Macros
      Maps and Lotus Approach
13. Compatibility
      Working with .WK1 Files
      Working with Excel Files
      Working with dBASE Files
14. Using 1-2-3 with OS/2


**1. UPDATING RELEASE 4 WORKSHEET FILES TO RELEASE 5**

Upon opening a worksheet file that was last saved in 1-2-3 Release 4,
Release 5 automatically recalculates all formulas in the file. This
recalculation, which completes the transition from Release 4 to Release 5,
may take a noticeable amount of time, depending on the size of the file.
Once you save the file using 1-2-3 Release 5, this recalculation will not
happen again.

**2. INSTALL**

INFORMATION FOR UPGRADERS: 123 INI FILE SETTINGS

If you install 1-2-3 Release 5 on a system that contains a version of 1-2-3
that is older than Release 4, you must install Release 5 to a new directory.
The old directory will remain intact and none of the 123w.ini settings will
be carried over to Release 5.

If you install 1-2-3 Release 5 on a system that contains a previous version
of 1-2-3 Release 4 or 4.01, you have a choice of installing in a new
directory or over the existing version.  Regardless of your choice, certain
settings that exist in the 123r4w.ini from the previous version will be
automatically carried over into the new 123r5w.ini file.  They are as
follows:

[COUNTRY]
driver=

[AUTOLOAD ADDINS]

[PRINTER]
DefaultPrt=

[CONFIG]
beep=
undo=
autoexec=

INFORMATION FOR UPGRADERS: HARD DISK SPACE REQUIREMENTS

If you install 1-2-3 Release 5 in a directory that contains a previous
release of 1-2-3 for Windows, you may need as much as 19MB of free hard-disk 
space, depending on the options you choose to install.

If your Windows directory is on a different drive from your 1-2-3 directory,
the drive that contains your Windows directory should have 1MB to 4MB of
free hard-disk space.

INFORMATION FOR UPGRADERS: CUSTOMIZED SETS OF SMARTICONS

If you have modified any of the sets of SmartIcons in a previous release of
1-2-3 for Windows, follow these steps to ensure your icon sets display the 
same in Release 5:

If you have not yet installed Release 5:

1. Copy the .SMI files for the icon sets you have customized from the
   123R4W\PROGRAMS\SHEETICO, 123R4W\PROGRAMS\GRAPHICO, etc., directories to
   a temporary directory.

2. Install Release 5.

3. Copy the .SMI files into the 123R5W\PROGRAMS\SHEETICO, etc., directories.

If you have already installed Release 5, but have not yet deleted your 
previous version of 1-2-3 for Windows:

1. Copy the .SMI files for the icon sets you have customized from the 
   123R4W\PROGRAMS\SHEETICO, 123R4W\PROGRAMS\GRAPHICO, etc. directories
   to the corresponding directories in 123R5W\PROGRAMS.


INSTALLING ON COMPUTERS WITH MULTIPLE CONFIGURATIONS

The 1-2-3 Install program may offer to update the PATH statement in your
autoexec.bat file. If the Install program offers to update the path, and you
choose Yes, the Install program will modify only the first path statement it
encounters. If you use a release of DOS that supports multiple start-up
configurations, and your autoexec.bat file contains multiple path statements
for multiple start-up configurations, the Install program may not modify the
correct path.

After you install 1-2-3, examine the autoexec.bat file to verify that the
Install program modified the path for the configuration under which you will
run 1-2-3.

SERVER AND DISTRIBUTION INSTALL

Lotus recommends installing the Server and Distribution versions of the
product in new or empty directories.


**3. WINDOWS AND AVAILABLE MEMORY**

Before you start 1-2-3, find out how much memory is available by opening
Program Manager and choosing Help About Program Manager.

If less than 2100KB of memory is free, you will not be able to start 1-2-3
Release 5. Close open applications and remove memory-resident programs
to make more memory available. Then check the amount of free memory again.

If slightly more than 2100KB of memory is free, you can start 1-2-3, but
you may encounter Memory Full messages while you work.

The following suggestions can help you increase the amount of available
memory. 

*  For maximum memory savings, remove SMARTdrive. (If you do not want to
   remove SMARTdrive, see the next bullet to reduce the SMARTdrive cache
   size.) 

   To remove SMARTdrive, remove the
   [x]:\WINDOWS\SMARTDRV.EXE statement from AUTOEXEC.BAT.

   You can either delete this statement or type REM in front of it.
   For example, REM [x]:\WINDOWS\SMARTDRV.EXE

*  If you do not want to remove SMARTdrive, you can save memory by reducing
   the SMARTdrive cache to 256K.

   Edit the SMARTdrive statement in AUTOEXEC.BAT so it reads
   [x]:\WINDOWS\SMARTDRV.EXE 1024 256.

*  Increase the Windows swap file size to at least 2MB. For best results, 
   Lotus recommends a swap file twice as large as your systems's random
   access memory (RAM). To learn how to change the swap file size, see the
   Microsoft Windows documentation.

*  If Adobe Type Manager (ATM) is installed on your system, you can turn 
   off ATM to maximize memory savings. To turn off ATM, double-click the
   ATM Control Panel icon. Under ATM, select Off. Select Exit. Restart
   Windows.

Tip: If 1-2-3 displays the message "Out of memory" or "Not enough Windows
resources to complete the operation," and you cannot save your files with
File Save, use the keyboard shortcut Ctrl+S.


**4. CHARTING INFORMATION FOR UPGRADERS**

To work with named charts that you created in 1-2-3 for Windows Release 1 
or Release 1.1, but did not add to the worksheet, open the .WK3 file that
contains the charts and choose Edit Go To. Select Chart in the "Type of
item" drop-down box, and then select the named chart in the list box. 

1-2-3 adds the chart to the center of the worksheet area displayed on the
screen. You can move the chart anywhere in the worksheet.


**5. PRINTING PERFORMANCE INFORMATION**

PRINTER DRIVERS AND DEVICES

Printer manufacturers periodically update printer drivers. In some cases,
drivers newer than those that shipped with Windows 3.1 are available.
To find out if a newer driver is available for your printer, check bulletin
boards such as CompuServe, or contact your printer manufacturer.

The following table lists some popular printers and newer drivers that
are currently available.

PRINTER			NEW DRIVER
=======			==========
HP DeskJet Family	Version 4.1 or higher

HP LaserJet III		Universal Printer Driver Version 3.1.2
                          (HP LaserJet III Version 2.0)
                        Universal Printer Driver Version 3.1.4
                          (HP LaserJet III Version 2.1)

HP LaserJet IV		Version 31.V1.27 or higher

HP LaserJet IV          Postscript Printer Driver by Adobe
  (Postscript)            Version 2.1.1

Postscript		Version 3.58


To find out the version number of your printer driver, do the following:

1. Open the Windows Control Panel and select Printers.

   Windows displays a list of printers installed on your system.

2. Highlight a printer in the list.

3. Choose Setup.

   The Setup dialog box for your printer appears.

4. Choose About to see information about your printer, including the
   version number of the driver.


PRINT RESOLUTION

1-2-3 Release 5 is optimized for printing at 300 dots-per-inch (dpi).

Tip: If you want to print at 600 dpi, and your print job contains
many different fonts, and you encounter problems printing, open
Printers in the Windows Control Panel, and select the "Print True Type
as Graphics" check box in your printer's Setup Options or Setup Options
Advanced dialog box.


**6. DATALENS AND ODBC DRIVERS**

ODBC DRIVERS

1-2-3 Release 5 can be configured to use drivers that meet the Microsoft
Open Database Connectivity (ODBC) specification. The dBASE DataLens driver
and the Lotus Notes driver that come with 1-2-3 Release 5 use ODBC engines.

Note: Most ODBC drivers have not been certified with 1-2-3. Lotus does not
provide technical support for these drivers.

If you are using the dBASE DataLens driver, the Lotus Notes driver, or any 
other ODBC driver with 1-2-3, and you do not use Windows for Workgroups 
Release 3.1 or 3.11, start SHARE.EXE before you start Windows. To start
SHARE.EXE before every Windows session, add the following line to your
AUTOEXEC.BAT file:

C:\DOS\SHARE

See your DOS documentation for information about SHARE.EXE.

You can configure 1-2-3 to use either all ODBC drivers or one specific
driver. To provide access to all ODBC sources, add the following line to
your LOTUS.BCF file, located in \LOTUSAPP\DATALENS:

DN="ODBC" DL="DLODBC" DD="All ODBC sources";

You can add support for a specific ODBC driver by including a DC parameter
to the ODBC record in LOTUS.BCF.  If an entry with the string DL="DLODBC",
as shown above, also includes a string of the form DC="driver=xxx" then 
1-2-3 will make available only those sources that use "xxx" as a driver.
For example:

DN="SQL Database via ODBC" DL="DLODBC" DC="driver=sql.dll" AC=UI,PW;

You can configure 1-2-3 to prompt for a user ID and password for a data 
source by adding the following line to the LOTUS.BCF:

DB="source name" DN="ODBC" AC=UI,PW;

When the 1-2-3 user picks the DataLens driver for dBASE files, the list of
available databases includes the following:

  * The current directory
  
  * All data sources in ODBC.INI that have "driver=qodbf.dll"

In addition, you can also add a new database name to ODBC.INI and type in
the new path.

Data source names for dBASE must be paths when using DLODBC.

When you use a macro to send updates to ODBC-dBASE IV tables, you must
follow the {SEND-SQL} command with a {COMMIT} command. 

ENVIRONMENT VARIABLES

Unlike some other releases of 1-2-3, 1-2-3 Release 5 does not use the
"LOTUSBCF" environment variable, but reads only records listed in the
LOTUS.BCF file located in \LOTUSAPP\DATALENS.


**7. VERSION MANAGER**

If you are using Version Manager with Lotus Notes Release 3 or higher, and 
you do not use Windows for Workgroups Release 3.1 or 3.11, start SHARE.EXE
before you start Windows. To start SHARE.EXE before every Windows session,
add the following line to your AUTOEXEC.BAT file:

C:\DOS\SHARE

See your DOS documentation for information about SHARE.EXE.

	
When you use shared files, Lotus Notes may display certain messages in a
special untitled error window during your 1-2-3 session. Attempting to
close this window ends communication with the Notes server for the rest
of the 1-2-3 session. 

If 1-2-3 displays the message "Error Initializing Lotus Notes" when you
try to open a shared file (.NS4), check the following:

  * If the LotusMail section in your WIN.INI file specifies Notes, make sure
    it includes the correct Notes program path. For example:
	[LotusMail]
	Application=Notes
	Program=x:\notes\notes.exe NoDialogs

  * If the LotusApplications section of your LOTUS.INI file specifies Notes, 
    make sure it includes the correct Notes program path. For example:
	[LotusApplications]
	Notes=x:\notes\notes.exe

  * Make sure SHARE.EXE was started before you started Windows.


If you delete all versions from a range in a shared file (.NS4), you will
be unable to create any more versions in that range. Do not delete all
versions from a range unless you are sure you no longer want to share it.


**8. SOLVER**

Solver uses relationships among formula cells in 1-2-3 to arrive at its
answers. Since DDE links get their data from sources outside 1-2-3, you
should not use @DDELINK formulas in cells that you use as adjustable or
constraint cells for Solver.


**9. COMMAND-LINE PARAMETERS**

To specify command-line parameters for 1-2-3 Release 5

1. Highlight the 1-2-3 Release 5 icon.

2. Choose File Properties from the Windows Program Manager.

3. In the Command Line text box, append a command-line parameter to
   123W.EXE. (For example, C:\123R5W\PROGRAMS\123W.EXE -s)

You can specify the following command-line parameters:

[filename]
Lets you specify a file to load whenever you start 1-2-3.

-i [filename.ini]
Lets you specify an initialization file other than 123R5.INI. For example,
C:\123R5W\PROGRAMS\123W.EXE -iC:\123R5W\MYINI.INI specifies the
initialization file C:\123R5W\MYINI.INI.

Note: If you use 1-2-3 Release 5 with Lotus Notes Document Inset 
Protocol (DIP), you must have 123R5.INI in your Windows directory.

-l
Skips the 1-2-3 for Windows splash screen.

-q
Skips the "Welcome to 1-2-3" dialog box

-s
Makes 1-2-3 Release 5 use the software floating point driver instead
of a math coprocessor. Use this parameter if you have a defective math
coprocessor in your computer or if your computer tells 1-2-3 you have a
math coprocessor when you do not. Under these circumstances, all your
formulas may evaluate to 0, ERR, or *** (asterisks).


**10. CORRECTIONS TO THE DOCUMENTATION**


MACROS HELP

In the Macro Help topic entitled "Using a Dialog Box Created with the Lotus
Dialog Editor," the third paragraph should read as follows:

To see a sample dialog-description table, open the file UIMACROS.WK4 and 
click the worksheet tab Custom Dialogs, or press CTRL+PG UP five times to 
go to worksheet F.

HELP FOR 1-2-3 MESSAGES

The Help topic for the message "Cannot load .dll for status bar" should
refer to the file LTSSB03.DLL in the LOTUSAPP directory, which is usually
located in your Windows subdirectory.

The Help topic for the message "Cannot load .dll for SmartIcons" should
refer to the file LTSICN05.DLL in the LOTUSAPP directory.

THE GUIDED TOUR

If you experience display problems while running the Guided Tour, the
problems may be due to an incompatibility with your display driver. Consult
your Microsoft Windows documentation for instructions on how to temporarily
install the standard Windows VGA driver.


**11. FONT USAGE**

FONT MAPPING

1-2-3 Release 5 can map requests for Adobe Type Manager (ATM) fonts to
TrueType fonts, or requests for TrueType fonts to ATM fonts.

Font mapping is controlled by the TT_MAP statement in the [TTMAPPING]
section of your 123R5.INI file. When you start 1-2-3 for the first time,
1-2-3 automatically sets TT_MAP according to your configuration.

Note: When you open a file created with 1-2-3 for DOS, Wysiwyg fonts are
mapped to Windows fonts using the settings in the [FONTMAPPING] section
of your 123R5.INI file.


FONT PERFORMANCE TIPS

If Adobe Type Manager (ATM) is installed on your system, use ATM fonts,
such as Arial MT, when rotating text blocks in 1-2-3. For information 
about rotating text blocks, search on "Rotating drawn objects" in Help.

Use TrueType fonts to increase printing speed with a Hewlett-Packard
LaserJet IV, because Arial and Times New Roman are internal fonts for
this printer.


REMOVING ATM

1-2-3 Release 5, unlike previous releases of 1-2-3 for Windows,
does not include Adobe Type Manager (ATM). If ATM is installed
on your system, 1-2-3 Release 5 will take advantage of it.

If you experience difficulties with ATM soft fonts, you can remove ATM
from your hard disk. 

To remove ATM from your system, do the following:

1. End Microsoft Windows.

2. Change the following lines of your SYSTEM.INI file, which is located in
   your Windows directory:

   * Change system.drv=atmsys.drv to system.drv=system.drv
   
   * Delete the line atm.system.drv=system.drv

   Note: These lines may be different on some systems (for example, the 
   Hewlett-Packard Vectra); however, the result should be a single line
   that reads system.drv=system.drv.

3. Delete the following files:

   * Delete ATM16.DLL and ATM32.DLL from the \SYSTEM subdirectory of your
     Windows directory.

   * Delete ATM.INI and ATMCNTRL.EXE from your Windows directory.

   * Delete any .PFM, .PFB, .SFP, and .SFL files from the directories in
     which you installed fonts.

**12. MAP PERFORMANCE INFORMATION**

FINDING THE CORRECT MAP TYPE

When 1-2-3 creates a map, it automatically tries to determine which map to
use, based on the uniqueness of the map codes in the range of map data.
This may result in slower performance, especially when (1) the machine is
slow, (2) the range of map data is large, or (3) a large number of maps
is installed. The more map codes there are and the more maps, the more
comparisons 1-2-3 must make to determine the map automatically.

To avoid slower performance, 1-2-3 provides a switch to enable a map
resolution timer. If the automatic process takes too long, 1-2-3 prompts
you to pick the map you want from the list of available maps in the Map Type
dialog box.

The following entry in the [MAPS] section of 123r5.ini controls the time:

mapsearchtime=n

where n has the following values:

-1                          Take as much time as is needed to automatically
                            determine the map type.

 0 or a non-numeric value   Always display the Map Type dialog box
                            immediately. If you have many installed maps
                            you may wish to use this option.

>0                          Try to determine the map type automatically for
                            only this many seconds; then display the Map
                            Type dialog box.

The default setting is mapsearchtime=4

Note: When launched as a macro keyword, the setting is treated as if it were
-1. This lets 1-2-3 skip the ONERROR handling caused by the need to put up
the prompt dialog, which is not necessary since the map name is already an
optional argument for the macro.

MAP RESOLUTION

1-2-3 can display and print maps in two different resolutions, High and 
Regular. You will likely find Regular resolution is satisfactory for most
applications, particularly if you use maps in their regular size. Complex 
maps, expanded beyond their default size, will display and print better 
in High resolution.

High resolution maps contain four times as much data as Regular resolution
maps. They therefore require more memory, take up more disk space when saved
in a file, and demand more of your printer.

Regular resolution, the default, is recommended for computers with less than 
8 megabytes RAM. Lotus recommends that you have at least 8 megabytes RAM and
a 16 megabyte swap file before you consider switching to High resolution.

The following entry in the [MAPS] section of 123r5.ini controls the
resolution:

mapres=n

where n has the following values:

1                       Use High resolution.

0 or any other value    Use Regular resolution.

The default setting is mapres=0

MAP MACROS

In macros that create or change maps, use the {MAP-REDRAW} macro command
immediately following the command that creates or changes a map.

MAPS AND LOTUS APPROACH

If you use maps to plot data that is also used by a Lotus Approach embedded
object, Lotus recommends setting Map Redraw to Manual.

**13. COMPATIBILITY**

WORKING WITH .WK1 FILES

If you save @functions that are new in 1-2-3 Release 5 in .wk1 files, you
may experience problems opening those files in other releases of 1-2-3 for
Windows. To avoid unexpected behavior, use .wk3 or .wk4 files when you need
to save new @functions in files that you share with other users.

WORKING WITH EXCEL FILES

When you save a 1-2-3 file that you have sealed with a password as an Excel
file, you can read it into Excel and modify the file without using the
password.

WORKING WITH DBASE FILES

When you use File Save As to save a database range as a dBASE (dbf) file,
1-2-3 does not save any information outside of the selected range. To save
all the information in a file, first save it as a 1-2-3 (.wk4) file; then
select a range to save as a dBASE file.

**14. USING 1-2-3 WITH OS/2**

Lotus does not support the 1-2-3 Guided Tour in OS/2.

Lotus does not support using 1-2-3 in multiple Win-OS/2 sessions.

Lotus does not support integration between 1-2-3 and Lotus Approach when
they are running in separate Win-OS/2 sessions.

The Licenser may not run correctly on workstations using IBM LAN Server 3.0
in a Win-OS/2 session of OS/2 2.1. To use 1-2-3 in this network
configuration, don't use the Licenser.

On an OS/2 system, if 1-2-3 displays the message "Cannot find _bsafe.dll"
followed by the message "Cannot find _lib.dll" after you choose either File
Save As, File New or Tools User Setup, edit the [LotusMail] section of your
WIN.INI file as follows: 

If you have only Notes for OS/2 installed, remove the following line:

application=notes 

If you have both Notes for OS/2 and Notes for Windows installed, check the
following line:

Program=d:\notes\notes.exe NoDialogs

and make sure that the location given for notes.exe is the location of
Notes for Windows, not Notes for OS/2.