[libreoffice-users] Protection in Calc

LO 3.4.4 Kubuntu 11.10

Two issues (and the second is the big one as far as I am concerned):

1) Tools --> Protect Document --> Document (Alt+T,P,D) when the Document is 
unprotected does not appear to protect anything. This appears to be a long 
standing issue that has been noted by others -- most notably A.D.P. in his 
comprehensive macro document. I don't have Excel to poke and to prod to 
investigate its corresponding actions.

2) Tools --> Protect Document --> Sheet (Alt+T, P, S) when the Sheet is 
unprotectd does activate protection of cells on that sheet. This functionality 
covers all the protection options that exist in the cell formatting dialog. In 
addition it includes the _global_ ability to prevent users from moving the cell 
cursor into any Protected cell and/or into any Unprotected cell on the Sheet.

Protecting a Sheet by means of a macro does not appear to have the ability to 
restrict movement of the cell cursor. I have not seen any mention of this by 
others so maybe I'm going about this the wrong way or maybe I'm trying 
something that others haven't tried.

This is most likely the wrong forum to recommend a feature upgrade but here it 
goes anyway.

Recommendation: Add two optional parameters to oSheet.protect(). The one 
existing parameter that I know about is the password string. In poking and 
prodding Calc I have found that oSheet.protect()  appears to ignore any 
parameters other that the password string. There is not even a run-time error 
reported regardless as to what type they may be. The only options from the menu 
other than the password are the two accessed by menu Alt+T, P, S, Alt+A. So I 
am suggesting this format for the function:

 oSheet.protect(sPassword, bEnterProtected, bEnterUnprotected)

The defaults for the two new parameters could be TRUE and TRUE which would 
match the current behavior. A common usage of this call would be 
oSheet.protect("password", FALSE, TRUE) which would protect the sheet using the 
specified password and would permit the cell cursor to only be moved into 
unprotected cells.

The oSheet.protect() function is not the only one that permits setting 
protection on a Sheet. Using the Macro Recorder shows another one which, as far 
as I can tell, does not even support the use of a password when establishing 
protection on a Sheet.

If someone knows of a third technique to establish protection on a Sheet and 
that provides the capability that I have mentioned earlier in this post, please 
call it to my attention.

--
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