How to sort rows according to one of the columns?

Question

I have a table in which I attempted to sort rows by the D column:

So I selected the column and clicked Data > Sort > Current Selection > OK. The result is this:

Which is not what I want because

• it has modified cells in the D column. Before, there was only one cell with 229 in it, after there are many. Could this be because I applied Filter before (see the skipped row numbers on the left)?

• it actually didn't sort rows, just cells in the column D (Sort wasn't applied to other columns)

So how can I actually sort rows?

Answer 1

(1) To change the order of entire rows by sorting, you must select all cells, not just the columns that you want to use as sort criteria.

(2) The filter issue mentioned in the description remains unclear. The question has been closed without a clarification. Suggestion is to check ask.libreoffice.org.