Top Navigational Bar

Spreadsheet - Importing Problem From Quattro
DocumentID: 654940
Revision Date: 29-Feb-96 8:29:34 PM

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

Problem

Symptoms: The customer regularly imports spreadsheets from Quattro. However, when he used Quattro's Extraction feature to save out a portion of the spreadsheet as its own, that extracted file would not import correctly into a WordPerfect 5.1 table. The table was created with correct dimensions, but was void of data. The extracted file can be retrieved and edited correctly in Quattro. The spreadsheet portion imports blank whether it includes numbers or formulas. The parent spreadsheet imports correctly as a whole into WP. Solutions: The customer created a link in WP to the range of the large spreadsheet he needed. The link performed correctly.

Note from Problem ReAnswer:
When you use a name to create a link, WP will look in the name list of the spreadsheet and set the range coordinates to be those of the named range. When the file is extracted, the cell range will be moved to begin in cell a1 regardless of where the range originated. However, WP will not automatically update the range. The link will have to be edited.

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.