Difference between revisions of "Documentation/DevGuide/Spreadsheets/Protecting Spreadsheets"

Revision as of 13:05, 15 February 2008

The interface com.sun.star.document.XActionLockable protects this cell from painting or updating during changes. The interface can be used to optimize the performance of complex changes, for instance, inserting or deleting formatted text.

The interface com.sun.star.util.XProtectable contains methods to protect and unprotect the spreadsheet with a password. Protecting the spreadsheet protects the locked cells only.

• The methods protect() and unprotect() to switch the protection on and off. If a wrong password is used to unprotect the spreadsheet, it leads to an exception.
• The method isProtected() returns the protection state of the spreadsheet as a boolean value.