Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I would judge what the OQ wants to achieve can not be done for the open document from within Calc. It can - in principle - be done accessing the closed document with a program written for the purpose or by directly applying some tools.

Why? The internal password protection is a weak protection, mainly provided as a means to prevent inadvertent changes. As long as respected it can also be used to hide some contents. However, anybody with phsical access to the closed document can do a bit of surgery on it and remove this kind of protection. He may even be able to make changes and to reinstate the protection with the unchanged password subsequently. This is surely not acceptable in the described situation.

The option to 'Save with Password' is completely different. It encrypts the document based on the password. To open the document again requires decryption then. Password inevitably needed for that.

The goals the OQ is heading for would require a detailed rights management which IMO is only available for full-grown databases.

I would judge what the OQ wants to achieve can not be done for the open document from within Calc. It can - in principle - be done accessing the closed document with a program written for the purpose or by directly applying some tools.

Why? The internal password protection is a weak protection, mainly provided as a means to prevent inadvertent changes. As long as respected it can also be used to hide some contents. However, anybody with phsical physical access to the closed document (and some knowlege) can do a bit of surgery on it and remove this kind of protection. He may even be able to make changes and to reinstate the protection with the unchanged password subsequently. This is surely not acceptable in the described situation.

The option to 'Save with Password' is completely different. It encrypts the document based on the password. To open the document again requires decryption then. Password inevitably needed for that.

The goals the OQ is heading for would require a detailed rights management which IMO is only available for full-grown databases. databases.