ProtectSheet.bsh 1.2 KB

123456789101112131415161718192021222324252627282930
  1. /*
  2. * This file is part of the LibreOffice project.
  3. *
  4. * This Source Code Form is subject to the terms of the Mozilla Public
  5. * License, v. 2.0. If a copy of the MPL was not distributed with this
  6. * file, You can obtain one at http://mozilla.org/MPL/2.0/.
  7. */
  8. import com.sun.star.uno.UnoRuntime;
  9. import com.sun.star.frame.XModel;
  10. import com.sun.star.sheet.XSpreadsheetDocument;
  11. import com.sun.star.sheet.XSpreadsheet;
  12. import com.sun.star.sheet.XSpreadsheets;
  13. import com.sun.star.container.XIndexAccess;
  14. import com.sun.star.util.XProtectable;
  15. oDoc = UnoRuntime.queryInterface(XModel.class,XSCRIPTCONTEXT.getInvocationContext());
  16. if ( oDoc == null )
  17. oDoc = XSCRIPTCONTEXT.getDocument();
  18. XSpreadsheetDocument xDoc = (XSpreadsheetDocument) UnoRuntime.queryInterface(XSpreadsheetDocument.class, oDoc);
  19. XSpreadsheets xSheets = xDoc.getSheets();
  20. XIndexAccess xSheetsIA = UnoRuntime.queryInterface(XIndexAccess.class, xSheets);
  21. XSpreadsheet xSheet = UnoRuntime.queryInterface(XSpreadsheet.class, xSheetsIA.getByIndex(0));
  22. XProtectable xProtectable = UnoRuntime.queryInterface(XProtectable.class, xSheet);
  23. xProtectable.protect("myPassword");
  24. //xProtectable.unprotect("myPassword");
  25. return 0;