To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=11145
------- Additional comments from [EMAIL PROTECTED] Fri Oct 26 05:11:13 +0000 2007 ------- Don't know if commenting/voting on a closed issue will have any effect however, here goes. fst says null cell has nothing to sort so isn't sorted, appears last. I would say before there can be anything there is nothing. From sort order perspective nothing should therefore preceed any value. >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'+'date created'+'action requested' it doesn't work. For most users it would be natural to want to order rows like this. Problem can be defeated with non-intuitive step of putting a space in 'date resolved' column. That though makes the worksheet very hard to maintain because it isn't possible to determine if 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. My votes are for nulls to be sorted either before or after other values based on a global setting in tools|options. They are already sorted after this would enable the option of sorting them before as well. --------------------------------------------------------------------- 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]
