LibreOfice calc - sort grayed-out

I'm using LibreOffice 4.2.8.2. I've opened a csv file. I want to sort. Data > Sort is grayed-out. Why?
LVL 1
jmarkfoleyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
Don't know.  Can you post the CSV file so we can examine it?
0
jmarkfoleyAuthor Commented:
Here's a clue I didn't notice before. At the top of the spreadsheet it says "Read Only". In fact, I can't change anything in the cells.

The CSV file was opened from the web. I'm using Libre Calc on Ubuntu. When I open this same CSV file in Excel on Windows I can make changes.

Is this a "feature" of Libre Calc? Is there a way to make it not read only? I'm evaluating LibreOffice as a replacement for MS Office in our office. Many intranet programs create CSV files on the fly. This will be a big issue if such files can't be manipulated.
0
rindiCommented:
First, if you are evaluating LibreOffice, you should do that wi a newer version, like Version 5, which would be the current version, and not an outdated one. I suggest trying the portable version, which has the same features as the installed version has, but you don't need installation, and updates are managed via the PortableApps tool:

http://portableapps.com/download
http://portableapps.com/apps/office/libreoffice_portable

And, yesthat is a feature of LibreOffice. You must download the file to your PC so that it is editable. Or click on "Edit Document", then select something in the document, after that you should get "sort" ungreyed.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jmarkfoleyAuthor Commented:
rindi:
you should do that wi[th] a newer version, like Version 5 ...
I'm using Ubuntu which I keep up-to-date. Perhaps the LibreOffice suite doesn't get updated, or perhaps the latest has not made it into to the Ubuntu repository.
... yes that is a feature of LibreOffice. ... click on "Edit Document"
I did find that "Edit" button, but is there no way for that to be a default? Trying to pry MS Office out of the hands of users in favor of LibreOffice is challenge enough. The extra step will make them grumble.
0
Dave BaldwinFixer of ProblemsCommented:
MS Office doesn't run on Linux.  Ubuntu versions of programs tend to be stuck at the version that came with that version of Ubuntu.  

It says 'Read Only' because it has been opened from 'temp' folder.  All you have to do to remove the 'Read Only' (which occurs on Windows also) is to save it to a location where the user has read/write permissions.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
LibreOffice

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.