![]() |
Tables - Sorting Tables With Formulas - Stran |
The information in this document applies to:
WordPerfect® 5.1 for DOS
Problem
Symptoms: The customer is sorting a table with formulas. The results are very strange. There are question marks (?) after some of the results, such as G?. Solutions: This is working correctly. Formulas, when moved, work under a principle called relative cell addresses. This is designed to help people so that if their formulas are moved due to adding or deleting in the table they won't be messed up. For example, if you have a formula on row 2 that addresses row 3 and you delete row 1, you have a problem. If the formula stayed as it was, it would still be addressing row 3. But, row 3 is now row 2 because of the row that was deleted. So, WP changes the formula that addresses row 3 to address row 2. One row in the table was deleted. So, all formulas below will have one row subtracted out and they will still be addressing the same information. If you sort a table with formulas, very strange things happen because the formulas use this principle. In the case of this customer, he was sorting the table, and then deleting many of the rows. In each row, he had a formula that addressed cell G1. When cells above these formulas were deleted, WP tried to address cell G0. Obviously, there is no cell G0, so WP returns G?. This is what should happen with the way the software works right now. See also: ID # WP51_2808D. |
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. |