[libreoffice-users] Sheet Protection in Calc

I need help finding the programatic technique to access a new LibreOffice Calc 
feature.

LibreOffice Calc has a feature that is absent in OpenOffice.org relating to 
protection within a sheet. Try Alt+T, P, S on an unprotected sheet. You will 
see a box where you can check "Protect this sheet and the contents of protected 
cells". You can also enter a password and confirm it. The new feature is that 
you can select either, both, or neither of two options dealing with allowing 
all users of this sheet to select protected or unprotected cells. Finally there 
are three buttons -- OK, Cancel, and Help. Use the OK button to activate your 
selections. You can restore the unprotected sheet mode by simply using Alt+T, 
P, S once again.


The upper half of the dialog box that I just described is available in 
OpenOffice.org also but the lower half dealing with the options regarding 
permission to select cells has been added in LibreOffice. This is a great 
addition but I have not yet found a way to influence the option settings from 
within a LibreOffice Basic Macro. Is a feature request needed or does this 
feature already exist? I don't know how to submit a feature request if that is 
needed. I hope that when the feature was added to the menu that access to it 
was also added to the Macro interface and that I just have not seen the 
documentation spelling out how to utilize it.

The technique that I know to programatically establish sheet protection is this:

   oSheet.protect("password")

The easiest implementation I can think of to add these two options is to expand 
that command to include two boolean parameters -- one corresponding to each of 
the two option checkmarks in the dialog box. Example which is equivalent to the 
default.

   oSheet.protect("password",TRUE,TRUE)

I currently have access to LibreOffice 3.5.0 Build ID:350m1(Build:13) on Linux 
and LibreOffice 3.4.5 OOO340m1 (Build:502) on Windows.

--
Jim


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted