[Solved] Best way to encrypt my Calc sheet?

Discuss the spreadsheet application

[Solved] Best way to encrypt my Calc sheet?

Postby Veda » Sun Sep 16, 2018 1:54 am

Hi, I have a couple of questions please, both related...

1. What would be the best method to encrypt a calc file so that if my laptop was stolen or lost when travelling then the spreadsheet and most importantly the formula's within would not be be able to be seen by mostly anyone else. I see there is a "save with password" option, is that easy to bypass or should I use third-party encryption software?

2. To retrieve a replacement file I could simply keep a copy in a folder from an email that I sent to myself, but in the event I had to buy a new laptop and download a new install of OpenOffice, would I be able to open a password protected file on a computer different than the one that created the file? I only have one computer atm so can't test this.

Any thoughts on this are appreciated, thank you.
Last edited by Veda on Sun Sep 16, 2018 2:28 am, edited 1 time in total.
Win 10, open office 4.1.5
Veda
 
Posts: 55
Joined: Mon Apr 16, 2018 1:18 am

Re: Best way to encrypt my calc sheet?

Postby FJCC » Sun Sep 16, 2018 2:19 am

The save with password option in the File -> Save dialog encrypts the file. If you use a strong password, you should be fine. I can't find a description of the algorithm at the moment but I recall that it is strong encryption. This is not true of the protection provided by Tools -> Protect Document. That is just a Child Safety feature to prevent accidental edits.
A password protected file can be opened on any computer with OpenOffice if the password is known.
AOO 3.4 or 4.1 on MS Windows XP ( before 2013-08-03) or Windows 7
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 6711
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Best way to encrypt my calc sheet?

Postby Veda » Sun Sep 16, 2018 2:27 am

That sounds good enough, appreciate the answer, thank you. :)
Win 10, open office 4.1.5
Veda
 
Posts: 55
Joined: Mon Apr 16, 2018 1:18 am


Return to Calc

Who is online

Users browsing this forum: robleyd and 20 guests