M Singh wrote:
Michael Adams wrote:
The plot thickens.
Thanks to a private correspondent who wrote to me after seeing this
message, I have found that if one uses the Data | Sort workflow, one
does get a pop up box asking which column I wish to sort on provided I
select the entire spreadsheet before doing that. The main toolbar
buttons do what I described in my first post.
I wish Calc could mimic the Excel behavior as described here
completely. What it currently does with the toolbar buttons is not
terribly useful for most people (at least offer that pop up box).
hat do you get using teh toolbar buttons if you select the entire range
to be sorted (not just one column).
A sort on the first column selected (always A if one selects the entire
page). It does not ask which column to sort on.
In my case, the columns are :
Column A - names of materials
Columns B-D - physical properties of those materials (numbers)
A dictionary sort on column A is not very useful (at least not most of the
time). It should ask the user to disambiguate the sort request with a pop
up box, just like Data | Sort workflow does.
Further, if I select just one column, it should show some rudimentary
intelligence and at least offer to sort the entire table (I cannot imagine
a situation where a user has multiple adjacent columns in a spreadsheet
with the same / similar number of rows, and would want to sort just one
column and mess up the entire data set).
Once again though -- all you have to do is select a single cell in the
data range, not a whole column, and the selection will expand to select
the whole data range. Even if you click the toolbar sort button, or if
you use the menu path Data > Sort.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
