https://bugs.documentfoundation.org/show_bug.cgi?id=100575
Bug ID: 100575
Summary: "Sort Ascending" forces "Range contains row labels" on
text only range.
Product: LibreOffice
Version: 4.0.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mrelw...@yahoo.com
If you select an area with text (no value) in all cells of first row, then
"Range contains column labels" is automatically ticked. This means that the
toolbar sort button behavior changes without notice, and may cause severe
problems if the user doesn't notice.
This is unpredictable behavior that works wrong in many situations.
I ask for this to be a user selectable option, in settings or wherever seen
best.
SITUATIONS where current behavior is wrong:
- A single column of names (or any other text).
- A list of text only items, that later gets a column for price. Sort behavior
changing is unpredictable.
- A list of items that has single alphabets in a column to represent
importance.
- Selecting a range and clicking "Sort" doesn't always sort.
I have used spreadsheets several times weekly for about two decades, and I have
never done a sort that would benefit from skipping the first line. But this
automatic guessing going wrong has bothered me for years.
Currently the only predictable way to do a sort is through menus or popup
windows with tabs. It takes 4 clicks and typing a name for the range. It should
only take one.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs