![]() |
Spreadsheet Link Update--How To Preserve Attr |
The information in this document applies to:
WordPerfect® 5.1 for DOS
Problem
Symptoms: In WP 5.1, when importing a spreadsheet as a table using the link option, if you edit the table (i.e., add a row and input column headers), then edit the spreadsheet file and use the link option to "update all links", the table will be updated, but all editing changes made to the table will be lost and the table returns to the default format for width, shading, attributes, lines, etc. Solutions: There is a way to create a spreadsheet link, and preserve text attributes: 1. Create the table, then place the cursor inside cell A1. 2. Create the spreadsheet link (Ctrl-F5, 5, 2, insert spreadsheet path and name) while the cursor is still inside cell A1. 3. Make any font attribute changes that you want to make, edit the table (Alt-F7, 2, row or cell, then 2 for attributes, choose size or appearance). These font appearances will stay even when you update the link. The only drawback is that a customer cannot go into Base Font and select a particular typeface. However, they have access to all sizes of the designated default font, including appearance fonts. Another alternative: 1. Create and perform the link. This will bring in the spreadsheet. 2. Delete the link codes from Reveal Codes. This code usually precedes the table definition code. 3. Move inside the first cell of the table and press Ctrl-F5 to recreate the link. Notice the settings from the deleted link are still intact. All that is left is to perform the link. |
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. |