Apache OpenOffice (AOO) Bugzilla – Issue 52506
Sorting messes up previous order
Last modified: 2005-07-27 10:23:08 UTC
If you have two colums with name and an amount like this e.g.: 3 expense 5 income 1 debt 6 income 4 expense 2 debt and you sort it (ascending) by the second column (the one with names) the numbers should in this case result in (like in Excel): 1 debt 2 debt 3 expense 4 expense 5 income 6 income Note that I didn't sort by the number colum but by the names which in this case gives the same result. HOWEVER Calc shuffles the lines individually and it seems the former individual order is not kept. Open Office gives you this unpredicable result: 2 debt 1 debt 3 expense 4 expense 6 income 5 income even though each pair of rows with the same word in the second column, was listed with the lowest number in the top of the two. So two of the pairs' individual placement has been changed for no apparent reason - and it's even inconsistently as the "expense" pair was NOT swapped as with the other two... very confusing and cause for alot of toruble and misunderstandings in my line of work. Cheers -- David
If the column A is ordered, you can get a better result, if you use Data - Sort and there not only set 'Sort by B' but also 'Then by A'. But that is only a workaround for special situations. The problem is known, see issue 20491. *** This issue has been marked as a duplicate of 20491 ***
and closed double