Spreadsheets - WP Bringing In Wrong Cell Rang

DocumentID: 652607
Revision Date: 29-Feb-96 8:29:17 PM

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

Problem

Symptoms: WordPerfect retrieves the wrong cell range when linking to Lotus files that were created by extracting a named range from an existing file. Solutions: Lotus files that are created by extracting a named range have a segment in the document prefix called the Worksheet Dimension Record. The Dimension Record stores information about names and ranges. The Dimension Record says the active range for the name that was used to extract the data is the original cell range. When the files are linked, WP looks for the name in the Dimension Record and uses the defined active range to set up the link. Because Lotus still has the original range defined as active, WP picks up the original range. The problem is Lotus moves the data from the original range to begin in cell A1, thus, the original range may contain empty cells or different data. It seems that Lotus does not update the active range information in their prefix codes. A simple work around is not to use names when linking to files that were created by extracting a named range.

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.