Importing Spreadsheet - Last Few Columns Over

DocumentID: 637242
Revision Date: 29-Feb-96 3:04:33 PM

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

Problem

Symptoms: When the user imports a spreadsheet, the columns are wider in WordPerfect than in the spreadsheet, and the last few columns are being stacked on top of each other at the right margin. Solutions: The columns are wider because WP calculates the tab positions in a text import, and the column widths in a table import, by taking the column width of the spreadsheet, adding 2, and multiplying that value by the average character width of the font in WP. WP adds 1 space for a "fudge" factor and another space for formatting codes such as dollar signs, $, parentheses, (), and minus signs, -. The text is stacking up on the right margin because WP tabs to the last tab position and then prints numbers to the right of that tab stop. Then, the left tab code positions the cursor back at the last tab position, and the process is repeated. The customer will have to find out how many columns will fit on his page, and limit his import to those columns. A user can increase the amount of spreadsheet data that will fit on a page by decreasing the column widths of the spreadsheet (this can cause problems with text overflowing into the next column), or by defining a smaller font in WP before the import.

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.