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


**CONTENTS**

1.  Updating Release 4 Worksheet Files to Release 4.01
2.  Install
      Information for Upgraders
      Distribution Install
      Installing on Computers with CD-ROM Drives
3.  Application Field Exchange
4.  Windows and Available Memory
5.  Maximum Number of Open Files Has Increased
6.  Charting Information for Upgraders
7.  Printing Performance Information
      Printer Drivers and Devices
      Print Resolution
      If You Have Not Selected a Default Printer
8.  DataLens and ODBC Drivers
      ODBC Drivers
      IBM Database Manager
      Paradox
      Environment Variables
      LOTUS.BCF File
9.  Version Manager
10.  Solver
11.  Command-Line Parameters
12.  Corrections to the Documentation
      User's Guide
      What's New
      DataLens Drivers for 1-2-3
13. Font Usage
      Font Mapping
      Font Performance Tips
      Installing and Removing ATM


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

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


**2. INSTALL**

INFORMATION FOR UPGRADERS

If you install 1-2-3 Release 4.01 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.01 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.

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, change to drive A: and type crsby a: [x]:\path
   and press ENTER.

   NOTE [x]:\path represents the drive and directory where you want
   CRSBY.BAT to copy the 1-2-3 files.

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


**3. APPLICATION FIELD EXCHANGE**

Application Field Exchange lets you exchange data between 1-2-3 and
Notes by embedding a 1-2-3 Worksheet object in a Notes form. Information
that you enter in either 1-2-3 or Notes then appears in the other application.

For more information, search on "Application Field Exchange" in Help.


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


**5. MAXIMUM NUMBER OF OPEN FILES HAS INCREASED**

Windows 3.1 users can have up to 32 worksheet files open at the same time
in 1-2-3 Release 4.01.



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


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

IF YOU HAVE NOT SELECTED A DEFAULT PRINTER

Do not use the 1-2-3 command File Printer Setup until you have selected a
default printer. For information about selecting a default printer, open
Printers in the Windows Control Panel and then choose Help.



**8. 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.01 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.01 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";

When configuring an ODBC driver for use with 1-2-3, the Data Source Name
should not have any spaces -- 1-2-3 uses spaces as a delimiter in the Connect
to External dialog box.  Suggestion: use underscore characters instead of spaces.

For example:

Data Source Name = Accounting_Dept_Databases
Data Source Name = My_Files
Data Source Name = Database_Files
Data Source Name = Z:\ACCTNG\DATA


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 the dBASE IV DataLens driver must be paths. For example:

C:\DATA
Z:\ACCTNG\DATA

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.

The DataLens driver for IBM Database Manager now supports the DB 2/2 database.

PARADOX

The DataLens driver for Paradox tables is now compatible with the table
format of Paradox 4.0, including Paradox for Windows. This section explains
differences between this new driver and the Paradox driver included in the
1-2-3 Release 4 package. For more information about using the Paradox driver,
see DataLens Drivers for 1-2-3.

The Paradox driver cannot update, create, or insert data into a memo field
and cannot index memo fields.

The Paradox driver does not support the BLOb Paradox data type, but does
recognize when a data type is a BLOb.

The Paradox driver uses table creation strings to specify a table's format.
If you do not specify a format when creating a table, the driver creates
the table in a format compatible with Paradox 3.5. To create a standard
Paradox 4.0 format table, enter VER4.0 in the "Table creation string"
text box.

If you specify both a sort order and a table format in the table creation
string, separate the sort order and table format with a comma. You can
specify the sort order and table format strings in any order. For example,
you can use either SORT INTL,VER4.0 or VER4.0,SORT INT.
 
The Paradox driver is compatible with the Paradox 3.5 file locking scheme
and the PARADOX.NET file. 

ENVIRONMENT VARIABLES

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


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


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


**11. COMMAND-LINE PARAMETERS**

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

1. Highlight the 1-2-3 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 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.01 with Lotus Notes Document Inset 
Protocol (DIP), you must have 123R4.INI in your Windows directory.


**12. 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.01. 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].


**13. FONT USAGE**

FONT MAPPING

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