To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=49629
------- Additional comments from [EMAIL PROTECTED] Tue Oct 31 11:36:16 -0800 2006 ------- > problems reported in issue 60681: > - known numeric sort order problem from this issue here Confirmed: sort by "Numeric" key fails unless cell format is also numeric (i.e. problem reported in this issue, 49629, is still present) Note: sorting numbers by "Alphanumeric" key does not sort by the number value. It may produce the expected order for the 'Sorting problems in tables.odt' part 1 case, but only because the numbers in column 1 all have one digit. If you change 3 to 33, and sort by column 1 "Alphanumeric", it will fall between 2 and 4. The only workaround for the problem in this issue (49629) is to assign a numeric number format to the cell data. > - Alphanumeric sort order with fields > Attachment issue 60681 'Sorting problems in tables.odt' part 1 [part 2?] Confirmed. Sort by either "Numeric" or "Alphanumeric" key, with either Text or Number/General number format, does not result in correctly ordered rows. Sorting of simple "set variable" "var=n" fields does not sort numerically either, even when the field has a numeric format. > - General alphanumeric sort order problem > Attachment issue 60681 'myowntest.odt' Confirmed. Sort descending works; ascending does not. Sorting the table contents as text paragraphs (i.e. copied out of the table) works for both directions. These were confirmed using OOo 2.0.4rc3 [680m5(Build:9073)] under Fedora Linux 5. *** Note *** I think something weird may be happening. As I was trying different combinations of formats and sort options, sorting that had failed previously started working. Restarting OOo and repeating the test went back to the previous failing behavior, so the problem may not be 100% reproducible, or I may simply be confused. --------------------------------------------------------------------- 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]
