Encrypt And Decrypt ODS files

Encrypt with OpenOffice Calc

  1. Select Save as and Click the Save With Password box.
  2. Click the Save button.
  3. Type your desired password into both the Enter Password to Open and Confirm Password fields in the Set Password window that opens.
  4. Click the OK button to save the file.

Encrypting/Decrypting ODS File:

For encrypting an ODS file, load the file and pass the actual password to WorkbookSettings.setPassword() before saving it. The output encrypted ODS file can be opened in OpenOffice only. For decrypting an ODS file, load the file by providing the password in the LoadOptions.setPassword(). Once the file is loaded, call function Workbook.unprotect() with actual password as argument and finally pass null to Workbook.getWorkbookSettings().setPassword().

Sample Code: