How to protect sheet with password in OpenOffice Calc?
To protect a particular worksheet in openoffice spreadsheet, follow the steps below.
Step 1: Click Tools -> Protect Document -> "Sheet..."
Step 2: In the Protect Sheet dialog box, provide the password under Password and retype the password under Confirm field.
Step 3: Click Ok.
When you open the spreadsheet file for the next time, the particular password protected sheet cannot be accessed without the password.