Preventing BASIC crash unprotecting Calc sheets [closed]

asked 2017-04-16 14:09:32 +0100

JET
1 ●2 ●2 ●2

How can I prevent the Illegal Argument Exception crash when BASIC attempts to unprotect a sheet using no (null) password? On error does nothing & the macro crashes. I want to use this automate some functions in Calc & skip properly protected sheets.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-29 22:24:11.291974

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2017-04-16 14:45:22 +0100

karolus

5584 ●17 ●40

Hallo

Here is an Example for python

from com.sun.star.lang import IllegalArgumentException

def sheet_unprotect_test():
    doc = XSCRIPTCONTEXT.getDocument()
    sheets = doc.Sheets
    for sheet in sheets:
        try:
            sheet.unprotect('')
        except IllegalArgumentException:
            continue
        # do other stuff
        sheet.protect('')

edit flag offensive delete link

add a comment

Question Tools

1 follower

Stats

Asked: 2017-04-16 14:09:32 +0100

Seen: 67 times

Last updated: Apr 16 '17

Preventing BASIC crash unprotecting Calc sheets [closed] edit

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2020-09-29 22:24:11.291974

1 Answer

Question Tools

Stats

Related questions

Preventing BASIC crash unprotecting Calc sheets [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-29 22:24:11.291974