Top Navigational Bar

Spreadsheet-Ranges Are Not Updated When Named
DocumentID: 652324
Revision Date: 29-Feb-96 8:29:15 PM

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

Problem

Symptoms: The customer created a spreadsheet in a spreadsheet program (PlanPerfect, Lotus, etc.) and then entered WordPerfect to set up a link for the spreadsheet. They changed the link option to Update On Retrieve. Then, the customer returned to the spreadsheet and moved a range of data to another place. For example, they moved everything in cells A1:A3 to C1:C3. If the customer enters WP again, the program will update the link, but the range displayed is still the old range. In the list of ranges, the new range is included. Is this working as designed? Solutions: WordPerfect uses the named ranges to define cell ranges. If the customer looks at the range in WP, they will see the cell range after the named range. WP imports spreadsheets using the cell range that is listed after the named range. WP does not look at the named ranges in the spreadsheet to see if the range has been updated. An enhancement has been written up for WP to update the range when the named range is edited. If you continue to receive calls on this, please submit the problem as a candidate for the Hotlist.

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.