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

**CONTENTS**

1.  Install
      Information for Upgraders
      Distribution Install
      Installing on Computers with CD-ROM Drives
2.  Windows and Available Memory
3.  Charting Information for Upgraders

4.  Printing Performance Information
      Printer Drivers and Devices
      Print Resolution
5.  DataLens and ODBC Drivers
      ODBC Drivers
      IBM Database Manager
      Environment Variables
      LOTUS.BCF File
6.  Version Manager
7.  Solver
8.  Command-Line Parameters
9.  Corrections to the Documentation
      User's Guide
      What's New
      DataLens Drivers for 1-2-3
      Macros Help
10. Font Usage
      Font Mapping
      Font Performance Tips
      Installing and Removing ATM


**1. INSTALL**

INFORMATION FOR UPGRADERS

If you install 1-2-3 Release 4 in a directory that contains a previous
release of 1-2-3 for Windows, you should have 2MB to 3MB of free hard-disk 
space.

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


DISTRIBUTION INSTALL

To streamline the installation of 1-2-3 on many stand-alone computers, copy
the 1-2-3 Release 4 files to a network server and then let licensed users
install 1-2-3 on their hard disks from the server.

Follow these instructions to copy 1-2-3 to the server:

1. Follow the instructions on the label of Disk 1 to start Install.

2. Enter your name and company name in the Recording Your Name and
   Company Name dialog box, and then choose OK.

   Note: Each user who installs from the server must enter his or her
   name during Install, but the company name you enter now remains fixed.

3. Choose OK to confirm the names.

4. Choose Exit Install to end the Install program.

5. End Microsoft Windows.

6. At the operating system prompt, type a:crsby and press ENTER.

   If Disk 1 is not in diskette drive A:, substitute the correct
   letter.

   CRSBY.BAT copies the compressed 1-2-3 files to the server, prompting you
   to change disks until all the files are copied.

Users can now follow these instructions to install  1-2-3 Release 4 on their
hard disks.

1. In the Windows Program Manager, choose File Run.

2. Type [x]:\path\install in the Command Line text box.

   [x]:\path is the drive letter and path for the server directory that
   contains the 1-2-3 files. For example, type t:\123r4w\install to start
   Install from a directory named \123R4W on drive T:.

3. Choose OK.

   The Install program displays a series of dialog boxes that prompt users
   for information about what to install and how to install it.

INSTALLING ON COMPUTERS WITH CD-ROM DRIVES

If you are installing 1-2-3 on a computer that has a CD-ROM drive, make
sure the drive contains a CD-ROM and is closed before you start Install.


**2. WINDOWS AND AVAILABLE MEMORY**

Note: Windows 3.1 requires more memory than Windows 3.0, so you may need to
free additional memory before you use 1-2-3 with Windows 3.1.

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 1800K of memory is free, you will not be able to start 1-2-3
Release 4. 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 1800K 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 in Windows 3.0, remove the
   DEVICE=[x]:\WINDOWS\SMARTDRV.SYS statement from CONFIG.SYS.
  
   To remove SMARTdrive in Windows 3.1, remove the
   [x]:\WINDOWS\SMARTDRV.EXE statement from AUTOEXEC.BAT.

   You can either delete these statements or type REM in front of them.
   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.

   In Windows 3.0, edit the SMARTdrive statement in CONFIG.SYS 
   so it reads DEVICE=[x]:\WINDOWS\SMARTDRV.SYS 1024 256.

   In Windows 3.1, edit the SMARTdrive statement in AUTOEXEC.BAT so it reads
   [x]:\WINDOWS\SMARTDRV.EXE 1024 256.

*  386 users only: Increase the Windows swap file size to at least 1MB.
   To learn how to change the swap file size, see the Microsoft Windows
   documentation.

*  Windows 3.1 users only: Windows 3.1 comes with a scalable font manager,
   so 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.


**3. CHARTING INFORMATION FOR UPGRADERS**

To work with named charts that you created in a previous release of 1-2-3
for Windows, 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.


**4. 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 3 or higher

HP LaserJet III		Versions 2 and 2.1 (newer than 31.3.89)

HP LaserJet IV		Version 31.V1.18 or higher

IBM 4019/4029		Version 3.08 or higher

Postscript		Versions 3.5 and 3.53


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.

4. Choose Setup.

   The Setup dialog box for your printer appears.

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


PRINT RESOLUTION

1-2-3 Release 4 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.


**5. DATALENS AND ODBC DRIVERS**

If 1-2-3 displays the message "Invalid field name" when you query against
worksheets on disk, choose Set database table before you use any other
Query command.

ODBC DRIVERS

1-2-3 Release 4 can be configured to use drivers that meet the Microsoft
Open Database Connectivity (ODBC) specification. The dBASE DataLens driver
that comes with 1-2-3 Release 4 uses an ODBC engine.

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 DataLens dBASE driver or any other ODBC driver with
1-2-3, 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:

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;

For more information on editing your LOTUS.BCF file, see DataLens Drivers
for 1-2-3.

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. 


IBM DATABASE MANAGER

For Database Manager access to an OS/2 2.0 server, you need the Local Area
Network Support Program Version 1.3.

ENVIRONMENT VARIABLES

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


**6. VERSION MANAGER**

If you are using Version Manager with Lotus Notes Release 3, 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

  * 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.


**7. 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.


**8. COMMAND-LINE PARAMETERS**

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

1. Highlight the 1-2-3 Release 4 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:\123R4W\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.

-s
Makes 1-2-3 Release 4 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).

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

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


**9. CORRECTIONS TO THE DOCUMENTATION**


USER'S GUIDE

Page 89: The second sentence of the Note should read: To delete a named
range that contains versions, you must first delete the versions. 

Page 125: The last sentence in the second paragraph under "Changing
column width" should read: Use Style Column Width to change the column to
a specific width, reset to the default width, or set the width to fit the
largest entry in the current selection.

Page 126: The second bullet under step 3 of "To change columns to a
specified width" should read: "Fit widest entry" adjusts the columns to
the width of the widest entries in the current selection.


WHAT'S NEW

Pages 88: Add the following to the Transcript Commands section:
 Record Relative  Records range selections as offsets of the current cell.
 Record Absolute   Records range selections as cell addresses.

Appendix D: @USER is not supported by 1-2-3 Release 4. Use
@INFO("setup-user-name"} instead.

Appendix E: Add the macro command {SELECT-RANGE-RELATIVE}. Remove the
macro commands {PARSE-CREATE} and {PARSE-RESET}.


DATALENS DRIVERS FOR 1-2-3

Pages 5 and 6: Wherever the variable [range-name] appears, substitute
the variable [table-name].


MACROS HELP

{LINK-CREATE} topic: Remove the last sentence from the description of
the app-name argument.


**10. FONT USAGE**

FONT MAPPING

1-2-3 Release 4 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 123R4.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 123R4.INI file.


FONT PERFORMANCE TIPS

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.


INSTALLING AND REMOVING ATM

If you installed 1-2-3 on a network node, you can install ATM from the
server if your network administrator transferred ATM to the server. To
install ATM:

1. Open the Windows Program Manager.

2. Choose File Run.

3. Type x:\path\ATM\install in the Command Line text box.

   x:\path is the driver letter and path for the 1-2-3 directory on your
   server. For example, type t:\123r4w\atm\install to install ATM from a
   1-2-3 directory named \123R4W on drive T:.

4. Choose OK. 


If you run Windows from a network server, you will be able to install ATM
only if you have write access to the WINDOWS\SYSTEM directory while you are
installing. See your network administrator to get write access to this
directory.

After you install ATM, other Windows applications may look slightly
different onscreen because ATM substitutes its scalable fonts for certain
Windows bitmap fonts. The point size at which ATM makes this substitution
is controlled by the SynonymPSBegin= statement in ATM.INI.

SynonymPSBegin= is initially set to 9; this means ATM substitutes its
fonts for Windows fonts larger than 9 points. If you change this statement
to SynonymPSBegin=13, ATM substitutes its fonts for Windows fonts larger
than 13 points. Other Windows applications that use 10 and 12 point fonts
will continue to look the same as they did before you installed ATM.

If you experience difficulties with ATM soft fonts, you can remove ATM
from your hard disk and re-install it.

Before you remove ATM from your hard disk, do the following:

1. If you installed additional fonts, copy those fonts to a temporary
   directory.

2. Remove all Windows soft fonts from your WIN.INI file. Soft fonts are
   listed with the installed printers. In the example below, an * (asterisk)
   marks each line to remove.

   [PostScript,LPT2]
   device=14
   color=2
   feed1=1
   *softfonts=11
   *softfont1=c:\psfonts\pfm\_a______.pfm,c:\psfonts\_a______.pfb
   *softfont2=c:\psfonts\pfm\bdbc____.pfm,c:\psfonts\bdbc____.pfb   

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.

4. To re-install ATM, start Windows and insert the ATM disk in drive A:.
   Open the Windows Program Manager. Choose File Run. Type a:install in
   the Command Line text box and then Choose OK.