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]

Reply via email to