Continuing the discussion from CALC Protected cell, then protected sheet. Fat fingered password:
I guess I haven’t had enough coffee this morning. Quite simply, I don’t understand.
The file is in .xls format. I use PeaZip on my machine.
Thanks,
Rich Ramik
Like I said, not enough coffee. File Format is .xlsx
Save as ods.
And continue working in Open Document Format (ods spreadsheets, odt text, odp presentations). This is the one and only suitable file format when working with LibreOffice. Save a copy of your ods in foreign file formats when technically inevitable (almost never since Excel supports ods).
Fwiw, it would be less confusing if you edited your original question instead of splitting it up into two.
Open the file and save it as Open Document Spreadsheet (.ods).
File>Save as… File Type: “Open Document Spreadsheet (.ods)”.
You are using Windows, right?
Open the file explorer.
View>Options>Folder Options…
Tab “View”
“Hide extensions of known file types” = OFF
By default this is on. This is the worst default since Windows 95 since it hides away the most important info about a file.
Now you see the full name of your spreadsheet, say “MySpreadsheet.ods” with .ods extension. Rename the file to “MySpreadsheet.zip” (which is difficult to do with default settings). Ignore any stupid warning. Every byte of the file remains intact. We just change the label.
Open the zip file.
Load content.xml into a text editor. You may have to extract a copy out of the zip archive.
Replace table:protected="true" with table:protected="false"
Save content.xml and push it back into the zip.
Rename the document file back to “MySpreadsheet.ods”.
If anything went wrong, you still have the xlsx.