To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78729 Issue #|78729 Summary|Strange sorting behaviour in scalc. Component|Spreadsheet Version|OOo 2.2.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|jdkaye
------- Additional comments from [EMAIL PROTECTED] Thu Jun 21 05:38:45 +0000 2007 ------- When doing a sort using upper ascii characters (128-255) the presence of trailing numbers effects the sorting results. This is very strange and probably quite easy to correct. You can try the experiment yourself. It's quite surprising. From The OpenOffice.org sort order for the Latin 1 characters you see that the character Ô appears before the character Õ. In an empty spreadsheet put aÕ in cell A1 and aÔ in A2. Do a sort based on column A and the contents of cells A1 and A2 change places. This is exactly what you expect since Õ is ordered AFTER Ô in the collating sequence. Ok now put aÔ3 in cell A3 and aÕ2 in A4 and do the sort again. You would expect that aÔ3 remains above in the sorted version right? But it doesn't! Now enter aO in A5 and sort again. aO appears at the top of the list. Edit cell A1 (now containing aO) changing it to aO9 and do another sort. Boom! Now aO is at the bottom of the list. The problem seems clear: the addion of numbers changes the sensitivity of the sort. If there are no numbers then the characters O, Ô and Õ are distinct and sorted in the order given by the table. If you add a following number they all merge and the sort is then based on sorting the following number. To summarise: aO5 aÕ2 aÔ4 will give a bad sort. If the numbers are the same as in aO5 aÕ5 aÔ5 then the sort is good BUT if anything follows the "5" in the previous example then the sort is bad so aO5z aÕ5a aÔ5g is sorted based on the FINAL character. The sort comes out as aÕ5a, aÔ5g, aO5z. I don't think this can be a feature so I guess it must be a bug. --------------------------------------------------------------------- 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]
