norbert-radyk/spoiwo

When protecting Worksheet, how to specify the actions allowed?

Closed this issue · 1 comments

alain-espina commented

Is there a way to specify which actions are allowed in Excel when protecting it with a password? I can locked the cells but then I want to allow the user to perform other things like when you protect the worksheet in Excel, you can specify which ones are allowed.

image

norbert-radyk commented

This functionality was indeed missing from spoiwo, so I have added it now in the 1.8.0 version of the library (I expect it to be available from the distribution servers in the next 24h).

Also added a small example of how you'd use this functionality: https://github.com/norbert-radyk/spoiwo/blob/master/examples/src/main/scala/com/norbitltd/spoiwo/examples/features/LockingExample.scala

Hope that helps :)