How to sort rows according to one of the columns?

libreoffice-calc
Andrej Repiský picture Andrej Repiský · Feb 5, 2015 · Viewed 14.1k times · Source

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?

Answer

Joachim Wagner picture Joachim Wagner · Feb 1, 2017

(1) Select all for row sorting, (2) filter issue mentioned in the description: unclear; question closed (suggestion to check ask.libreoffice.org).

Related questions

Does LibreOffice Calc support JSON file importing/sorting?

I've been trying to import a couple of .json files into LibreOffice Calc. Although I can get the raw data in, it isn't sorting as I would think it might (by placing different pieces of info into each cell). Does …

Read More
Applying row based filter instead of column based in LibreOffice or other SpreadSheet tool

We all know the standard filter, where you pick which rows to show depending on values in a particular column (or columns). Is it at all possible to the the same, but picking which columns should be visible depending on …

Read More
How to refer to a cell when the address is in a variable

For example, in an expression, instead of writing the address A1, how can I write something like: A(B1) with B1 = 1.

Read More