![]() |
Convert Lotus 1-2-3 To WP Secondary Merge Fil |
The information in this document applies to:
WordPerfect® 5.1 for DOS
Problem
Solutions: FYI: The user wanted to use a Lotus 1-2-3 Release 3 spreadsheet containing several hundred records as a WordPerfect 5.1 Secondary Merge file. No matter what the user does to convert it, every numeric field resulting from a formula in the Lotus file translated into the WP file in scientific format, regardless of the format specified in the Lotus file. Fields of text and of numeric values, not resulting from formulas, translated correctly. The user felt that the following steps to do this, with the least amount of editing, are as follows: 1. Load Lotus and retrieve the desired file. Print the file to disk, using /Print, File. This creates a .PRN file. 2. In a blank Lotus worksheet, use /Import, Text to bring up the .PRN file. Every row now is one continuous line of text, rather than a series of separate cells. 3. Use the /Data, Parse operation to separate the text into fields. Format all fields as labels in this procedure. 4. Save the Parse output data as a new .WK3 file. 5. Exit to the Lotus Translate utility and translate the new .WK3 document to a .DIF document, following the menu prompts. 6. Exit to DOS. Go to the WP 5.1 directory. Run the WordPerfect Convert utility to convert the .DIF document to a WordPerfect secondary merge, following the menu prompts. 7. Load WordPerfect. Retrieve the new secondary merge file. The field data will be in the desired text format and not in scientific. The important thing to remember about spreadsheet DIF format files is that the DIF format does not allow for cells with formulas. WP can only use the DIF format for spreadsheets. Any user wanting to use a spreadsheet which contains formulas in the cells needs to ensure that they have adequately compensated in the originating spreadsheet package for the cells containing formulas prior to saving it in the DIF format. This is one customer's solution to the dilemma. |
Answer:
Details:
Product specifications, packaging, technical support and information (*Specifications*) refer to theUnited States retail English version only. Specifications for other versions may vary. All Specifications, claims, features, representations, and/or comparisons provided are correct to the best of our knowledge of the date of publication, but are subject to change without notice.OUR MAXIMUM AGGREGATE LIABILITY TO YOU AND THAT OF OUR DEALERS AND SUPPLIERS IS LIMITED. IT SHALL NOTEXCEED THE AMOUNT YOU PAID TO ACCESS THE INFORMATION. SEE LEGAL DISCLAIMER. |