Ask Your Question

Problem with Calc spreadsheet. Says I created spreadsheet in "read only" Not true!

asked 2017-11-14 19:25:08 +0100

Greg R gravatar image

I have a spreadsheet that I use. Now when I open it it says it is open in "read only". How can I change this?

edit retag flag offensive close merge delete


What OS are you using?

EasyTrieve gravatar imageEasyTrieve ( 2017-11-14 23:55:17 +0100 )edit

I have been using Windows 10 for quite awhile. Problem started after upgrading to 5.3

Greg R gravatar imageGreg R ( 2017-11-16 18:41:11 +0100 )edit

I agree w/ erAck below, that the most likely cause of this is insufficient file permissions. The permission structure on W10 is quite complex and it took me quite awhile to fully understand it, and how to use their tools to inspect, and edit it. The directory and file probably need to be owned by you (your user name). Also you might try at first simply setting "Full control" for each of these. Inheritance also plays a part so watch out for that.

EasyTrieve gravatar imageEasyTrieve ( 2017-12-11 08:58:46 +0100 )edit

Can you edit this spreadsheet with some other program, like a text editor that will handle binary files? (First make a copy of it!) And then can you edit and save it? This should help figure out if it's a permission problem or some other problem.

EasyTrieve gravatar imageEasyTrieve ( 2017-12-11 09:00:12 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-11-14 19:51:08 +0100

erAck gravatar image

Check the file's permissions on file system level, it needs to be writeable. You didn't specify your OS, but if you upgraded from Windows 7 to Windows 10 there are some known quirks around user access rights and file permissions, search the interweb in that case.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-11-14 19:25:08 +0100

Seen: 27 times

Last updated: Nov 14 '17