Apache OpenOffice (AOO) Bugzilla – Issue 101866
protect sheet prevents inserting of new Objects in unprotected cells
Last modified: 2013-01-29 21:40:52 UTC
Sheet protection being active prevents any new mathematical formulas from being added anywhere in the sheet - even in cells that have been set to 'unprotected' Scenario: I have a set of values in a spreadsheet and a couple of them took a long time for me to work out or might be difficult to follow when I return to the spreadsheet later - So I protect those couple of cells. How: I select the whole spreadsheet and do Format/Cells/Unprotect so that no cells are protected. Then I pick the couple of cells I want to protect and highlight them and set them to 'protected' through Format/Cells. Now setting the sheet to protected allows me to overwrite all cells except them two important cells. So far so good. I can type and write over most cells in the spreadsheet still, however what I cannot do is add a new formula through 'Insert/Object/Formula' (that menu option appears greyed out) Suggestion1: Protecting a 'sheet' should prevent amendments to existing formulas but allow new formulas to be added. Suggestion2: Protecting a 'sheet' should only prevent amendments to existing formulas that are anchored to a cell which itself is 'protected'.
Created attachment 62227 [details] OpenOffice3 version information for issue report
Reproducible with "Ooo-Dev 3.2.0 multilingual version German UI WIN XP: [DEV300m68 (Build 9474)]"! Pls. see my comments in Issue 27840, this one might be a DUP of that one. I see this as a DEFECT, because it's no problem to copy/paste objects.
More general summary