https://bugs.documentfoundation.org/show_bug.cgi?id=168905
Bug ID: 168905
Summary: Calc: Problems with descriptions and labels of sorting
with comments
Product: LibreOffice
Version: 26.2.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: UI
Assignee: [email protected]
Reporter: [email protected]
Created attachment 203376
--> https://bugs.documentfoundation.org/attachment.cgi?id=203376&action=edit
File for testing
The sort dialog (Data > Sort) has the checkbox `Include boundary
row(s)/columns() containing only comments` on tab `Options`. Its label and
descriptions are insufficient.
This feature has been introduced with fix for bug 100517. The idea is, that if
LibreOffice auto-detects the to be sorted range then the sort dialog allows to
include cells, that only contain comments. That is, if your data is in column A
and column B has only comments on empty cells and nothing else, the setting
allows to include these comments in sorting. The setting tells LibreOffice to
include the empty comment cell into the to be sorted data record.
I have attached a document where you can play around with this feature.
Problems:
If you sort rows (which is the default), then the label is `Include boundary
row(s) containing only comments`. That is wrong. The feature is not about rows
with empty cells but about an adjacent column with comments on empty cells.
Thus it needs to be `Include boundary columns(s) containing only comments`. The
help has the correct row/column use. You can test it on Sheet2 (sort
descending).
If a user thinks, that it is about rows with empty cells, then he will notice,
that empty cells are always sorted at the end and comments will be moved or not
moved, but in any case that it is useless. You can test it on Sheet1 (sort
descending).
The wording "boundary" is not clear, see bug 168687.
There is no normal tooltip for this checkbox and the extended tooltip is "Sets
additional sorting options", a generic tooltip that is used for other options
as well. The extended tooltip needs to be specific.
The help has the text "Range boundary columns (for sorting rows) or boundary
rows (for sorting columns) of a sorting range are not sorted by default if they
are empty." That does not really catch the problem. If they belonged to the
sorting range, then they would be sorted. But LibreOffice makes an automatic
"shrink sorting range to data" and that reduces the sorting range even if you
have selected that area before calling the Sort dialog.
--
You are receiving this mail because:
You are the assignee for the bug.
