Protecting Spreadsheets

From Apache OpenOffice Wiki
Jump to: navigation, search



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.
Content on this page is licensed under the Public Documentation License (PDL).
Personal tools
In other languages