Top Navigational Bar

Results Of Updated Formula Incorrect After De
DocumentID: 624976
Revision Date: 29-Feb-96 1:40:47 PM

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

Problem

Symptoms: The user has the formula A1+A2+A3 in cell A4. When any of the rows containing data are deleted, the formula is updated so that the results are incorrect. Solutions: WP 6.0 and spreadsheets such as PlanPerfect update their formulas in a relative manner. WP 6.0 refers to cells in formulas by rows and columns relative to the formula cell. In this case, A4 referred to a value in cell A1, A2, and A3. Cell A1 would have been represented as Row-3:Col+0, and cell A2 would have been Row-2:Col+0, etc.

If the user deletes row 2, then the formula becomes A1+A2+A2. Because the row and column references do not change, the Row-1:Col+0 now refers to cell A2 instead of cell A3. Because of the row-column designations, formulas in cells from the point of deletion to the end of the spreadsheet that point to the range of columns or rows that were deleted, will be updated.

A better way to access this same range would be to use Sum or + Subtotal. Both of these update correctly because they do not reference specific addresses that can be deleted.

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.