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.