Top Navigational Bar

Tables Math Numbers Must Fit On One Line
DocumentID: 610352
Revision Date: 29-Feb-96 1:34:30 PM

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

Problem

Symptoms: A customer created a table using 10 columns across and 30 rows down and was using a formula. A13 is the initial number such as 50, the formula for B13 is A13+300, the formula for C13 is B13+300, and so on, all the way to the last column, but when he calculates it gets to 1,250.00 for E13, but then starts over at 300 for F13, and then G13 is 600. Solutions: In a table, if a cell is addressed through a formula, and there are two numbers in the cell, the bottom one is used in the formula. In this case, the number was wrapping to the second line because there was not enough room for it on the first line. When this happens WP treats the number as two separate numbers, and uses the bottom one in the formula. In this case, the bottom number was .00, and so the formula used 0 to calculate. So, WP was calculating correctly. Customers just need to make sure that the numbers they are using fit onto one line.

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.