https://bugs.documentfoundation.org/show_bug.cgi?id=168905
--- Comment #1 from Eyal Rozenberg <[email protected]> --- (In reply to Regina Henschel from comment #0) > 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. Oh, wow, that is _totally_ not what the label and the documentation say this should do. My assumption - reading the label and the documentation - was that this option regarded the behavior of the "shrink sort range to data" functionality; but it seems that is really not the case. But this takes me ever deeper down the rabbit hole: When comments are also accounted for in sorting - where are they to be placed? What is their order relative to empty cells with no comments? Non-empty cells? And what about their order relative to each other? Is the comment text to be taken into account somehow? And if there is no clear ordering in the cases I mentioned above - are the results even stable? These may be moot poins when there are additional columns with contents, but when sorted rows have other strong ordering due to other columns, e.g. in a one-column case, they do need answers... -- You are receiving this mail because: You are the assignee for the bug.
