Ask Your Question

when will there be a sort function in calc (like excel)

asked 2021-01-17 02:44:43 +0200

Edwardo gravatar image

i need to click on a column and the sort it alphabetically (as Excel)

edit retag flag offensive close merge delete



You are asking an invalid question, because it is based on wrong assumption, that there is no sort functionality. Further your question is imprecise: SORT()function (which you'd use in formulas and which indeed does not exist in LibreOffice contrary to Excel) is a different thing than sort functionality (which is, as per your description, what you are looking for). Sorry for the nitpicking ...

Opaque gravatar imageOpaque ( 2021-01-17 10:56:48 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2021-01-17 07:49:44 +0200

newbie-02 gravatar image

hello @Edwardo,

if you -> do:

  • want to have everything exact as in ex$el -> use ex$el,
  • want to promote ex$el -> do it somewhere else, people here know about ex$el and why to avoid,
  • want to sort data -> use 'data - sort' (or appr. entry in your locale) and the options there,
  • find something missing or incorrect under 'data - sort' -> make good proposals for enhancement (bugzilla) and wait some time, free software tends to be a little slow in changing :-(



edit flag offensive delete link more


free software tends to be a little slow in changing

Is it as in:

  • "When I require something from my favorite non-free competitor, they typically implement that faster"

or in:

  • "Typical free software release includes less changes than non-free competition has in comparable time"

or in:

  • "I have no idea how free software compares to non-free, but I would love my requests be always implemented immediately"?
Mike Kaganski gravatar imageMike Kaganski ( 2021-01-17 12:52:27 +0200 )edit

answered 2021-01-17 08:00:51 +0200

ajlittoz gravatar image

updated 2021-01-17 08:01:34 +0200

Select the area to sort, not only the sort keys. By this I mean usually there are several cells contributing to a "record", such as last name, first name, street, city, ...

Data>Sort where you can tell which column or row contains the sort key, the sort "geometry" (row or column) and direction (ascending/descending).

To show the community your question has been answered, click the ✓ next to the correct answer, and "upvote" by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-01-17 02:44:43 +0200

Seen: 53 times

Last updated: Jan 17