Ask Your Question
1

Can't sort by name with LibreOffice Calc

asked 2018-05-28 14:56:16 +0100

JoyceF gravatar image

updated 2018-06-11 15:35:40 +0100

David gravatar image

I entered names and address, etc for my school alumnae, to my horror, I couldn't sort by name.

I am using latest version of LibreOffice Calc on Windows 7.

Also thought it could be opened with Microsoft Works, but that doesn't work either.

edit retag flag offensive close merge delete

Comments

Did you try highlighting the column of last names and then use Data -> Sort

or Data -> Sort Ascending

or Data -> Sort Descending

If you entered only a last name (or a first name) in that column, it should work.

ve3oat gravatar imageve3oat ( 2018-05-28 16:45:48 +0100 )edit

The problem is the sort is grayed out.

JoyceF gravatar imageJoyceF ( 2018-05-28 16:46:56 +0100 )edit

Perhaps the sheet is write protected or the document is opened in read-only mode. We would know for sure if you uploaded the file to a server somewhere and then edited the question to give the link. Note: Titles should be summaries of the question. The title you gave is too long, and there should be more relevant tags. See guidelines for asking.

Jim K gravatar imageJim K ( 2018-05-28 17:08:46 +0100 )edit
3

Certainly a document containing names and addresses should have its data replaced by placeholders before publishing..

However, if Sort is disabled and the document is not read-only it may also be that ChangeTracking is enabled, check menu Edit -> Track Changes and if Record Changes is checked then choose that to disable. Which also discards existing tracking though.

erAck gravatar imageerAck ( 2018-05-28 17:44:47 +0100 )edit
1

to erAck. Your suggestion to uncheck track changes did the trick. I am self-taught so I didn't realize there was a strict protocol for asking questions. I appreciate your help.

JoyceF gravatar imageJoyceF ( 2018-05-28 20:10:39 +0100 )edit

1 Answer

Sort by » oldest newest most voted
4

answered 2018-05-29 14:15:25 +0100

erAck gravatar image

For completeness, also as answer.

If Sort is disabled and the document is not read-only it may be that ChangeTracking is enabled, check menu Edit -> Track Changes and if Record Changes is checked then choose that to disable. Which also discards existing tracking though.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-05-28 14:56:16 +0100

Seen: 95 times

Last updated: Jun 11