https://bugs.documentfoundation.org/show_bug.cgi?id=168687
Bug ID: 168687
Summary: Sort dialog Options tab very confusing
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: needsUXEval
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 108386
When you select a range of cells and choose Data > Sort... on the menus, you
get the Sort dialog, which has an Options tab, or pane.
The options on this tab are very confusing - certainly to the novice user, but
also to a more experienced one.
* "Include formats" - it is wholly unclear what this means. What are "formats"?
Is that the same as "formatting", or something else? What does it mean to
"include" things in a sort procedure? How can formatting affect a sort? etc.
* "Natural sort" - this is about to change, and discussed in the separate bug
161948; the current state of affairs is confusing because different people have
different notions of what "natural" sorting might be, and even to what aspect
of sorting it would apply. In fact, this toggle regards the interpretation of
string values in cells, and whether, and how, to parse them for numbers; few
would guess what it does exactly.
* "Copy sort results" - is that in addition to sorting the data? If not, why is
this not a radio group with "Sort in place" and "Make sorted copy"? Or two
action buttons for the dialog? And - why is this wedged between options
regarding the sort order (custom order, natural sort)
* What are "boundary rows" w.r.t. sorting? We don't have "boundary rows" in
Calc
* What does it matter if a row "contains only images" or "only comments"? What
would the "inclusion" here even mean?
* What is the locale used for? It could be for parsing numbers within strings,
but then - why is this control separated from the control(s) regarding parsing
strings for numbers?
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=108386
[Bug 108386] [META] Calc sorting related bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.
