Ask Your Question
0

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

Comments

1

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
2

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

regards,

b.

edit flag offensive delete link more

Comments

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
1

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

Stats

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

Seen: 53 times

Last updated: Jan 17