when will there be a sort function in calc (like excel)
i need to click on a column and the sort it alphabetically (as Excel)
First time here? Check out the FAQ!
i need to click on a column and the sort it alphabetically (as Excel)
hello @Edwardo,
if you -> do:
regards,
b.
free software tends to be a little slow in changing
Is it as in:
or in:
or in:
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!
Asked: 2021-01-17 02:44:43 +0100
Seen: 47 times
Last updated: Jan 17
Is there an automatic sort function in Calc? [closed]
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]
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 ...