Tables - Calculating Formulas In Two Places

DocumentID: 600942
Revision Date: 29-Feb-96 1:28:33 PM

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

Problem

Symptoms: If the customer places a formula in the lower right corner of a Table, and also in the upper right corner (same formula), they must press Calculate twice before the program will total the number in the upper right corner. This can be duplicated in-house with the latest release. Solutions: When WordPerfect calculates, it starts at the top and then calculates from left to right. Then, WP goes down to the next row and does the same thing over again. If, in one of the formulas, you address a cell that's down on the page somewhere, WP will grab the current value for that cell and use it in the calculation. When it gets to the cell in the normal procedure of things, WP will calculate it but it may have a different value. At this point, the first formula that addressed this cell is not recalculated but appears to be incorrect because of the new value. Actually, it is correct according to what the value was at the time. Thus, the second calculation is correct with all the right values. The only workarounds are to actually calculate twice, or avoid addressing cells in a formula that still need to be calculated.

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.