To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93576 Issue #|93576 Summary|unable to specify sort sequence for empty cells Component|Spreadsheet Version|OOo 2.4.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|aboba
------- Additional comments from [EMAIL PROTECTED] Sun Sep 7 20:56:12 +0000 2008 ------- Empty cells appear last in sort regardless of whether ascending or descending sort is selected. >From a practical point of view there are instances where users would want to sort nulls first. e.g. sheet with columns 'date created', 'date resolved', 'action requested' If user wishes to keep unresolved requests at top of sheet by ordering on 'date resolved'/descending+'date created' the desired result isn't achieved. All the unresolved (null cell) issues sort to the bottom of the list. Depending on the length of the list they disappear off the bottom of the screen. A workaround is non-intuitive step of putting a space in 'date resolved' column. That makes the worksheet difficult to maintain because it can't be determined if a cell has space entered or is null just by looking at it. Plus user must remember to put spaces in otherwise empty cells to make sort occur in desired fashion. The enhancement requested is that an option to sort nulls before or after other values be provided. There has already been a conscious decision made to have nulls appear at the end of a sorted list, regardless of sort order. The effect is that nulls are, in effect, being sorted but _always_ being forced to the end of the list. How about providing some control over that behavior so that nulls appearing at the beginning or end of the sorted list is user selectable? Hopefully it can be seen from the scenario described above that there are practical user focused reasons to provide this behavior. --------------------------------------------------------------------- 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]