Importing Spreadsheets - [RGT TAB] Throws Ali

DocumentID: 652479
Revision Date: 29-Feb-96 8:29:16 PM

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

Problem

Symptoms: The customer is having problems importing a spreadsheet. The customer is importing an Excel spreadsheet file into WordPerfect 5.1 (Ctrl-F5, 5, 1, 3, 2). When text of the spreadsheet is imported into WP, there are a lot of right tab codes inserted into the document; this throws off the alignment. The only way to correct this, without manually deleting these right tab codes, is to do a Search and Replace. But this can only be done by pressing Home, Alt-F6 for a hard right tab [RGT TAB], at the Search prompt. This is difficult for the customer to understand. Can this problem be fixed so that an Excel spreadsheet file imports cleanly without placing [RGT TAB]s into the document? Solutions: No, the right tabs are there because data can be right or left aligned in spreadsheets. If WP doesn't have the right and left tab stops, WP can't align the text left or right. Numbers in a spreadsheet are generally right aligned, while text is usually left aligned. WP uses right tabs to get the numbers right aligned. The alignment is probably off because WP adds two spaces to every column. The first space is for the extra tab stop (right and left), and the second space is a fudge factor. Another customer encountered this same problem after retrieving a document that had been formatted by a scanner.

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.