![]() |
Limitations Of Using Tables As A Spreadsheet |
The information in this document applies to:
WordPerfect® 5.1 for DOS
Problem
Symptoms: A customer using the Tables feature for some calculations is going to calculate vertically but wants to format the first cell in that column for text with a number or two in that cell. If that cell is formatted as text, the calculation cell come out with ?? instead of the sum. If the first cell is formatted as numeric, but not included in the formula, it calculates fine. The customer felt that the manual leads you to think WP won't calculate a cell formatted as a text cell. Solutions: The manual accurately says that a cell containing a formula which is marked as a text cell will not be calculated. This says nothing about text cells being referenced by other formulas. It clearly states that "text cells cannot be referenced by formulas in other cells." The tables feature brings very limited spreadsheet capabilities to WP. With the features have come some of the conventions. When you use a spreadsheet and a formula is entered which cannot be logically calculated, the cell will show ??. WP uses the same convention. The ?? is a flag to notify the user that the formula is invalid. If you have further calls on this, please resubmit an STR 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. |