OpenOffice spreadsheet locked

Issues with installing under all versions of MS Windows
Post Reply
Adjer108
Posts: 2
Joined: Wed Apr 28, 2021 6:06 pm

OpenOffice spreadsheet locked

Post by Adjer108 »

I have a number of spreadsheets that will not open. I can open them using Libre Office. Libre Office tells me that I have locked my Open Office files. I can only read the spreadsheets in Libre. Q. How do I unlock my Open Office spreadsheets. Thanks, Adjer108.
Open Office 4 : Windows 10 Home
User avatar
Hagar Delest
Moderator
Posts: 32594
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Open Office spreadsheet

Post by Hagar Delest »

Hi and welcome to the forum!

What format? Native ODF (.ods) or external format like .xls/x?
Are they read only (properties that can be checked by a right click in the file Explorer)?
Any protection with a password?
Can you at least save them under another name?
Are they stored in a folder on which you have read-write access?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Adjer108
Posts: 2
Joined: Wed Apr 28, 2021 6:06 pm

Re: OpenOffice spreadsheet locked

Post by Adjer108 »

Thanks for your reply.
Format? don't know, just says Open Office Spreadsheet. .ods rings a bell I think.
Right click gives a menu only, Sort by, Group by etc If I L click then R click I get a different formula, Open , Open with etc.
No protection used.
Cannot save because cannot open in Open Office.
I have used this system for many years & had no problems opening & writing
I can Open & Write In Libre Office which I do not use, except now.
Adger108.
Open Office 4 : Windows 10 Home
Post Reply