[Issue] Disable selection of protected cells

[cheviot]

I created a Calc spreadsheet that contains protected and unprotected cells (the
protection is simply to avoid casual mistakes.) I then password protected the
sheet, setting the attribute that disables user selection of protected cells.
All this done via the Calc GUI.

I then wrote a Basic macro to manipulate the spreadsheet. The macro removes
the sheet protection, manipulates the sheet and finally reapplies the sheet
protection. However, the macro sheet protection does not honour the originally
applied "disable user selection of protected cells" attribute. Is it possible for a
Basic macro to disable user selection of protected cells? If so, then how can this
be done?

The relevant code I am using is:-

Code: Select all

Dim Sheet As Object
Sheet = ThisComponent.getcurrentcontroller.activesheet

Sheet.unprotect("mypasswd")

Sheet.protect("mypasswd")

I'm a beginner in writing Basic macros and a google search and a forum search on macro
sheet protection didn't produce anything useful.

[B Marcelly]

Hi,
According to Bug 123703 (confirmed) :

• Option "Select locked cells" does not survive a document reload.
• This feature was introduced in AOO 4.0.0.
  However I could not find it described in AOO 3.4 Release Notes

The "Select locked cells, Select unlocked cells" items have not been added in the help pages descriptions of sheet protection.
I could not find the equivalent in API (nothing in the IDL description, nothing using Xray).

In my opinion, this is a not finished, not debugged, not documented feature. No wonder the API aspect is missing.

[cheviot]

Many thanks for your reply. Much appreciated.
Perhaps there will be a future fix for this. I
live in hope.

[ricaltman]

5 years and no fix

[Villeroy]

Works fine with https://libreoffice.org/
It will never be fixed in OpenOffice.