Top Navigational Bar

Imported Spreadsheet Text Lines Up On Incorre
DocumentID: 654405
Revision Date: 29-Feb-96 8:29:31 PM

The information in this document applies to:
WordPerfect® 5.1 for DOS

Problem

Symptoms: When the customer imports a spreadsheet from Lotus as text, any text that is wider than the defined column in Lotus extends past the defined tab stops in WordPerfect. Therefore, the text for the next column is pushed to the next tab stop and the columns of data do not line up. Solutions: The customer will need to either edit the text in Lotus so that it fits inside of the defined column widths or edit the text in WordPerfect after it is imported.

WP is working as designed. WP calculates the tab stops according to the column widths in the spreadsheet. When a spreadsheet is imported as text, WP will put tab stops before and after the text depending on which column of the spreadsheet the text is in. For example, if the text was in column C, WP will put enough tab codes to place the text in the third tabular column of the document. If the text in column 1 extends past the defined tab stops, the tab codes in the document will push the text in column C to the fourth tabular column of the WP document. WP cannot determine if the text extends past the defined tabs stops. This is a limitation of the program.

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.