16

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

before

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

after

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?

Andrej Repiský
  • 477
  • 1
  • 6
  • 19
  • 5
    If you do a sort with just that column highlighted (selected), then that column is all that gets sorted. You need to select ALL the data you want sorted, then tell it you want to sort on column D. – lurker Feb 05 '15 at 20:36
  • OK, I selected multiple columns. Now I get multiple rows with the same country (after applying sort), although I had filtered out the duplicates. Why do they reappear? – Andrej Repiský Feb 05 '15 at 20:46
  • What, exactly, is your filtering criteria? Do you have rows that are completely duplicate? Or just the country? And if just the country, which do you decide you want to keep if the other data is different? It would be good if you could make your filter criteria clear in your question (use "edit") and give an example of what you want, not just a display of what isn't right. – lurker Feb 05 '15 at 20:58
  • Voting to close as off-topic as not programming. Try: http://ask.libreoffice.org/ – Ciro Santilli OurBigBook.com Jan 25 '16 at 14:31

1 Answers1

4

(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.

Joachim Wagner
  • 860
  • 7
  • 16
  • @KansaiRobot Thanks for your feedback. I tried to make it more readable to visitors who have not read all of the question description. Does this new version receive a better clarity score by your algorithm? – Joachim Wagner May 14 '21 at 10:01