https://bugs.documentfoundation.org/show_bug.cgi?id=90393
Bug ID: 90393
Summary: Text cell as first cell in range should not
automatically be considered as label
Product: LibreOffice
Version: 4.5.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: rb.hensc...@t-online.de
This issue is about the one-click sort options in the toolbar, which are
commands .uno:SortAscending and .uno:SortDescending.
If you select a vertical range of cells and use these commands, you can observe
the following behavior:
(1) If the first cell is numeric, LibreOffice sorts the whole range.
(2) If the first cell is a text cell, LibreOffice assumes first cell is a label
and sort starts with the second cell of the range.
In case of (2) there is no way to tell LibreOffice to _not_ use the first cell
as label. [I know you can sort it as desired by using the long way over Data >
Sort etc., which is command .uno:DataSort, but this issue is about the above
mentioned special sort icons.]
The missing ability to allow the user to decide whether the first cell is a
label or not creates confusion, read e.g thread
http://nabble.documentfoundation.org/LibreOffice-Sort-Bug-td4144500.html
In addition, Excel does not assume a label, if all cells are text cells.
Therefore the behavior in LibreOffice is unexpected for persons switching from
Excel.
Softmaker works as Excel, Gnumeric has no one-click sort, but only a dialog.
You can think of a global setting, a per document setting, a popup asking,
different commands for assuming label or not, or other ideas. There is no
obvious solution and therefore I think, it should be discussed in UX.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
