Apache OpenOffice (AOO) Bugzilla – Issue 105588
Formulas inside an area are not reassigned when you sort that area by a column
Last modified: 2009-10-04 18:05:35 UTC
When you try to sort an area with formulas inside it, then the formulas are not reassigned. See example bellow: - The unsorted area has 8 rows (alternating one filled and one blank) - The area has 4 columns: column A with the key I need to sort column B and C with values column D with a formula pointing to B and C (ie =B1*C1) - When you select that area A1:D7 and sort it by column A, then the formulas in column D are not reasigned propertly. They remain with the original values. The result in column D is then wrong, because the formulas area pointing to other cells than the original ones. This error was not present in version 3.0. You can find bellow a copy/paste of the example document. Mind column D has formulas pointing to column B and C (ie D1=B1*C1). I'll try to attach an example calc-document. Regards, Yamir Horta Unsorted area The area I need to sort is marked bellow Column D has some formulas pointing to the area I need to sort a 1 2 2 b 2 3 6 c 3 4 12 d 4 5 20 When I sort that area by column A, then the formulas in column D are not reassigned, so they remain untouched and the result ind column D is wrong a 1 2 2 b 2 3 12 c 3 4 0 d 4 5 0
Created attachment 65117 [details] Example of how to see the error submited
Sorts ok using using OOO311 en_US on Vista SP2. Attaching bugdoc showing correct sort. TomW
Created attachment 65122 [details] bugdoc showing correct sort
Yes, that is a bug in OOo3.1. It has already been fixed in OOo3.1.1. Please use the newest version of OOo. http://download.openoffice.org/index.html *** This issue has been marked as a duplicate of 101690 ***
closing, duplicate and already fixed