Hi, Maoyg and all
I would like to suggest three alternative modifications. They deviate
from the competitor's solution, so I explain the least controversial
first.
Proposal 1. Change some of the labels. This includes changing the
letter case, such as "Current Range" to "Current range":
#2 Label:
There is data next to your selection. Since you have not selected this
data, it will not be sorted.
#3 CheckBox Label:
You can sort:
#4 CheckBox Label:
Expanded range A1:A4(E)
Use a colored outline to highlight the range in the expanded
spreadsheet, and use the same color for the text "A1:A4" above.
#5 CheckBox Label:
Current selection(C)
Also, maybe Radio button #5 should be the default instead of radio
button #4, because label #2 says that the data will not be sorted
(button #5).
Proposal 2. Replace the two radio boxes and two buttons by three buttons:
- "Sort whole range"
- "Sort selection"
- "Cancel"
#2 Label would read:
There is data next to your selection. If you sort the selection, that
data will not be sorted. Instead, you can sort the whole range A1:A4
which includes that data.
#3 Label would read:
You can:
The whole dialog would look like this:
+---------------------------------------------------------------------+
| There is data next to your selection. If you sort |
| the selection, that data will not be sorted. |
| Instead, you can sort the whole range A1:A4 which |
| includes that data. |
|
|
| [Sort whole range] [Sort selection] [Cancel] |
+---------------------------------------------------------------------+
Proposal 3. Integrate the warning inside the sort dialog, so as to
avoid interrupting the user's work flow with another dialog. We still
have to alert the user using a label like #2, but do not pop up an
extra window or require an extra click. In particular, this can be
done by replacing the current "OK" button with two buttons labeled
"Sort selection" and "Sort whole range XXX", where "XXX" stands for
the address range, such as A1:A4. The extended range can be
highlighted in the spreadsheet using a colored outline. When the
whole contiguous data is selected, the "Sort whole range" button is
disabled.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
