Calc security

[random32]

Version: 4.4.3.2 Component : Spreadsheet OS: Windows 7 (32-bit) Language: English

I want to achieve the following:

1. User should not be able to unhide hidden rows/columns
2. User should not be able to unhide hidden sheets
3. User should be able to work on only un-protected cells.

I have performed the following actions, please let me know are they enough, or there is more I can do to enhance security:

1. Protected the document with password
2. Protected the sheet (with option to select only un-protected cells) with password

[PYS]

Hi

Your actions match your goals. You could also consider to give a template to users. In this way the original document is not modified. Of course, there are also opening/editing passwords but it seems not to be the problem…

Regards

[random32]

Its basically a output generator based on specific inputs by user, hence copies of the file are sent to several users. The only concern is, users should not be able to interfere with the logics set in the file, by way of formulas etc.

[PYS]

Ok - I just add a document saved with password is encrypted, making it very safe protection.
Lupp’s comment refers to protection via the menu Tools Protect

[Lupp]

In addition to the statements by @PYS I would like to state that internal protection of documents and sheets is very weak. It can easily be avoided and even completely abolished by direct editing of the file with the help of an XML editor. There are no means to hide functional elements of a Calc document on the security level of actual encryption.

In short: We can get a kind of protection for a working Calc document, but no actual security.

[random32]

Thanks, I also understand that a document is only secure upto a particular point…