Password lost
I have inadvertantly set a unintended password on a spreadsheet page and cannot unlock the sheet. How can my sheet be unlocked? Thanks
First time here? Check out the FAQ!
I have inadvertantly set a unintended password on a spreadsheet page and cannot unlock the sheet. How can my sheet be unlocked? Thanks
If it is not a password to encrypt the document (in which case there's nothing but brute force trying all possibilities) but only a password to protect a sheet, then it is more or less only a flag in the document that can be removed. It depends on the document format. In an .ods zip file it is in the content.xml file's element table:table, remove the table:protected and table:protection-key and table:protection-key-digest-algorithm attributes and freshen the .ods zip with the modified file. In an .xlsx zip file it is in an xl/worksheets/sheet*.xml file, remove the entire <sheetProtection.../> element and freshen the .xlsx zip with the modified file. If this is all mumbo-jumbo to you ask someone who can do it for you.
You have a very long discussion here explaining why it is impossible.
But, in the same thread, you'll find a macro trying to guess what the password is, provided some favourable circumstances are met. Have a try but success is not guarantedd.
Asked: 2018-03-29 17:35:03 +0100
Seen: 2,926 times
Last updated: Mar 29 '18
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]
Are refering to the spreadsheet file or a single sheet in the spreadsheet?