Positioning Spreadsheet Link in Table Importa

DocumentID: 651162
Revision Date: 29-Feb-96 8:29:04 PM

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

Problem

Solutions: If you have imported a spreadsheet and are creating a link, the position of the cursor in the spreadsheet when you create the link and also the range you specify are very important. This is important if you want to preserve any formatting changes made in the spreadsheet after it was imported. For example, if you import a spreadsheet that has a title in the third column of the first row, then join the cells in the first row to make one cell and center the text, when you create and perform a spreadsheet link just after the table definition code (to preserve the formatting of the table), you now have one empty cell at the top of the table. The title is missing. This is needed because in the spreadsheet program the title is in the third column on the first row but your first row only has one column. When you perform the link, only the information in the first column, which is blank comes in. To avoid this you can create the link after the title and change the range you are linking so that it does not include the title from the spreadsheet. If you don't change the range you will get the title twice.

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.