Cell Attributes Don't Hold When Linking A Spr

DocumentID: 617779
Revision Date: 29-Feb-96 1:37:44 PM

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

Problem

Symptoms: When a spreadsheet is brought into a WordPerfect table, the column attributes stay correct but the cell attributes are overwritten by the spreadsheet. When you are in Table Edit and press 2 (Format), the cell attributes say Top, Right, and Normal. To get the cell attributes to work correctly, you then have to manually edit the cell as well as get rid of the trailing space that has been brought in. Is this the way spreadsheets should come into a table? Solutions: The program is working as designed. If you look in the Reference manual (p. 658) under the title Appearance, you will see that WordPerfect tries to import the file in the same format as the spreadsheet was in. The reason why the column format in WP holds while the cell format changes is that spreadsheets format not by columns, but by blocking and setting formats for each individual cell. Therefore, there is no spreadsheet format for columns to override WP's settings. Spreadsheets usually have a default cell setting for numbers to be Top, Right Justify, and Normal. The spaces that are placed in the file when imported are there intentionally. If the file being imported has extra characters, such as brackets around numbers or minus signs in front of numbers, the space is used for these extra characters.

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.