https://bugs.documentfoundation.org/show_bug.cgi?id=168905
--- Comment #7 from Regina Henschel <[email protected]> --- (In reply to Olivier Hallot from comment #6) > Please verify in > https://help.libreoffice.org/master/en-US/text/scalc/01/12030200. > html?DbPAR=CALC#bm_id3147228 The "Natural Sort" part is OK. The "Boundary " parts are still problematic. The text is now, "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." For users a cell, that has an image or shape anchored to the cell or has a comment, is not "empty". Thus "empty" needs to be more precise. `Not sorted by default` does not really describe the problem. The user wants the columns to be sorted. Therefore he marks the cell range so, that these columns are marked too and then he expects, that they are sorted together with the other cells of a record. The user has no information, which area is actually affected by sorting (see also bug 132521). BTW, do you have noticed, that if there is a cell in such "empty" column, that has a background set (and `Include formats` is checked and column is included in the marked cell range), that then it is moved together with the records even if options `Include boundary...` are not selected? Wrong: Section `Range contains row/column labels` does not belong to tab "Options" but to tab "Sort Criteria". It was changed in bug 131155. And same for section `Direction`. See also the similar problem for the `Sort criteria` tab, bug 168961. Wrong: `Copy sort results to` Copies the sorted list to the cell range that you specify. Not the sorted list is copied, but the original unsorted list is copied to the target location and then the target range is sorted "in-place". You can see in the Undo stack that this process order is used. This process order might become important if your original unsorted list contains formulas, because a copy of a range adapts relative addresses in formulas. Do you want a new bug report or do you will handle the problems here? -- You are receiving this mail because: You are the assignee for the bug.
