Opening an 2010 Excel (created on a PC) with Libre 3.5.1. Made sure ‘read only’ flag was off. But when open, Libre says it was opened as read only. Tried with Liber “read only” flag on and got same result.
Mac Intel, OSX 10.6.8
Suggestions?
there is a button on the second row of your menu over which if you hover your mouse it’ll say Edit file. Just click on this button and it’ll prompt for the password which was assigned by the author to lock editing. Once you enter correct password it’ll be unlocked for editing.
Are you sure that the file is not WriteProtected?
If it is you find the option to unprotect it at Extras->Protect Document.
Hi,
Having the same problem. I have 3 workbooks from Excel that I built. Opening them for the first time in Libre Excel. They opened OK. However, one of them is opening Ready-Only. I checked file permissions. Some were set to read only, not read and write. I closed Libre Excel and opened again. Still getting Read-Only upon opening the file.
What is wrong, please?
Thanks,
SHD
Took a shot this morning. Opened the file, again as ready-only. Did a save as. It took a bit, but it saved and now is not ready-only. Error message saying, “All Basic code is lost, but code is saved a VBA.” Is there something in this workbook that is causing it to be forced to read-only?
Please advise.
Thanks,
SHD
File has a password. LibreCalc is not prompting for the 2nd password. Enter that, with the Edit File button. It accepts it. Still showing file as read-only.
File permissions are:
user@host$ ls -la
…
-rw-rw-rw- 1 dude dude 3444224 May 20 11:31 calc for mom.xls
…
Hmmm…need to determine why this is not allowing edit mode.
-S
Hello,
First of all I want to thank Sudhansu, who wrote 24/9-12:
“there is a button on the second row of your menu over which if you hover your mouse it’ll say Edit file. Just click on this button and it’ll prompt for the password which was assigned by the author to lock editing. Once you enter correct password it’ll be unlocked for editing.”
I’m not exactly sure if I found this button, however, I found that if you let the mouse hover the symbol of a sheet and a pencil, located on the 2nd row of the menu (that is, the first row of symbols), the fifth symbol from the left. If it says “Edit file” make a right click on the mouse, and you will be asked if you want to save a copy. Say “Yes” and there you go- a copy of the original document, except this time you can edit it:)