Although LibreOffice is a free software, it is increasingly used not only by private individuals but also for commercial purposes. If one gathers important data in the LibreOffice spreadsheet, one may need or want to secure the document. Protecting the file with a password ensures that no unauthorized person reads the information stored in it.
LibreOffice enables strong file-encryption using the AES algorithm with a 256-bit key, which in turn is derived from the key via a special function (PBKDF2).
In the free LibreOffice package, password protection is not a complicated task. Below is a brief instruction on how to get started. However, it is worth to remember to choose a password that is “strong”, i.e., difficult to crack.
How to set up a password on a spreadsheet and LibreOffice document?
1. Select the “Save as” option from the “File” tab.
2. Set the document name and location to save it, uncheck the “Save with password” box, and then save the changes by clicking “Save”.
3. The “Set password” window will open where you must enter the passwod you have set and repeat it. Finally, confirm with “OK”.
4. Close the file, and from now on, any attempt to open it will require entering the access text.
Change of access password
1. After opening the encrypted file, select the “Properties” option from the “File” tab.
2. In the opened window go to the “General” tab and select the “Change password” option.
3. A window will open in which you must enter the new password, repeat it and confirm the change by clicking “OK”.
Setting different passwords for opening and editing a file
1. When setting the password for the file, expand the “Options” field.
2. Check the “Open read-only file” box.
3. Enter the second password.
In this situation, when you enter the first, main password while opening the document, it will open in the read-only mode. You will be prompted to enter the second password in case you will try to edit it.