How to unlock password protected documents in OpenOffice Calc?
To remove the password for a spreadsheet file, follow the steps given below.
Step 1: Click Tools -> Protect Document -> "Document..."
Step 2: In the Unprotect document dialog box, provide the password and click OK. Spreadsheet document will be unlocked.