To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=52506
                  Issue #:|52506
                  Summary:|Sorting messes up previous order
                Component:|Spreadsheet
                  Version:|OOo 2.0 Beta
                 Platform:|All
                      URL:|
               OS/Version:|All
                   Status:|UNCONFIRMED
        Status whiteboard:|
                 Keywords:|
               Resolution:|
               Issue type:|DEFECT
                 Priority:|P3
             Subcomponent:|editing
              Assigned to:|spreadsheet
              Reported by:|filkin





------- Additional comments from [EMAIL PROTECTED] Tue Jul 26 14:05:55 -0700 
2005 -------
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

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to