Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

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.


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.