On the help page from Calc "Sets additional sorting options." I'm missing two option points. https://help.libreoffice.org/7.0/en-US/text/scalc/01/12030200.html Between: "Enable natural sort" and "Copy sort results to:" we have two more options: - Include boundary column(s)/row(s) containing only comments My suggestion for a help text: Border columns (for sorting rows) or border rows (for sorting columns) of a sorting area are not sorted by default if they are empty. If you have only entered a comment in a cell of a column or row, you can use this option to ensure that the column or row is also sorted. The second one is: - Include boundary column(s)/row(s) containing only images My suggestion for a help text: Border columns (for sorting rows) or border rows (for sorting columns) of a sorting area are not sorted by default if they are empty. If you have only entered a image in a cell of a column or row, you can use this option to ensure that the column or row is also sorted.
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/d97287d7f83c7e48c27d2541895a7230f09b0ee8 tdf#139543 Update Calc sort Option page