![]() |
Spreadsheets - Dates In Files From Lotus 1-2 |
The information in this document applies to:
WordPerfect® 5.1 for DOS
Problem
Solutions: When a spreadsheet is exported from Lotus 123 into DIF format, the dates in the spreadsheet are converted to Julian format (a series of numbers rather than words). This, obviously causes some problems when the file is brought into WP because the dates are unreadable. The only 2 ways to get around this are: (1) reset cell to "displayed value" only in Lotus or (2) save the spreadsheet out as ASCII text. According to testing, this occurs because a DIF file saves the cell entries as an ASCII delimited file. The file formats and cell formulas are not saved with the data. Without those formats there is nothing WP can look at to determine if the numbers are Julian values or numerical text. -Brady |
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. |