Apache OpenOffice (AOO) Bugzilla – Issue 104288
OO 3.1 sort is corrupting the data
Last modified: 2009-08-17 21:08:04 UTC
Download http://www.matera.com/~tcarlos/OOBugs/SortBugOO31.ods. Sheet "BeforeSort" contains original data to be sorted. Sheet AfterSortOO30 contains the same information sorted using OO3.0 (no problem here). Sheet AfterSortOO31 contains the same information sorted using OO3.1. Note that column C (Sheet AfterSortOO31) is not sorted in a right way. If you go to C5, you'll see this formula is referring ROW 8 instead of ROW 5.
Well known bug : issue 101690. It is fixed in OOo 3.1.1 RC1. Your bugdoc is sorted without problem by OOo 3.1.1 RC1. You can try it : http://download.openoffice.org/next/index.html Regards *** This issue has been marked as a duplicate of 101690 ***
closing as duplicate.