https://bugs.documentfoundation.org/show_bug.cgi?id=168905
--- Comment #8 from Olivier Hallot <[email protected]> --- (In reply to Regina Henschel from comment #7) > (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." The Sort dialog should be reworked. The tab Criteria has options (headers/boundaries) that affects to the Option tab. These options should be kept together for easier understanding. Bad. > > 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. empty = "no value and no formula" ? What else can describe "cell emptiness"? I notice that using Ctrl+A in a data block does not select commented or imaged "empty" headers. > > `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). So... drop the "default sentence (?). > > 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. Already fixed. https://help.libreoffice.org/master/en-US/text/scalc/01/12030100.html?DbPAR=CALC#bm_id3152350 > > > 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. That is a catch I never could imagine as end user. The dialog has "Copy results to:", that implies for the common mortals that the sorting is performed "under the hood" and then copied to the target range. > > Do you want a new bug report or do you will handle the problems here? let's keep this one. -- You are receiving this mail because: You are the assignee for the bug.
