Issue 52506 - Sorting messes up previous order
Summary: Sorting messes up previous order
Status: CLOSED DUPLICATE of issue 20491
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0 Beta
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2005-07-26 22:05 UTC by david
Modified: 2005-07-27 10:23 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description david 2005-07-26 22:05:55 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
Comment 1 Regina Henschel 2005-07-26 22:57:10 UTC
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 ***
Comment 2 frank 2005-07-27 10:23:08 UTC
and closed double