Issue 101866 - protect sheet prevents inserting of new Objects in unprotected cells
Summary: protect sheet prevents inserting of new Objects in unprotected cells
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2009-05-13 09:14 UTC by garyuu
Modified: 2013-01-29 21:40 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

OpenOffice3 version information for issue report (59.51 KB, image/png)
2009-05-13 09:17 UTC, garyuu
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description garyuu 2009-05-13 09:14:21 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'

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)

Protecting a 'sheet' should prevent amendments to existing formulas but allow
new formulas to be added.
Protecting a 'sheet' should only prevent amendments to existing formulas that
are anchored to a cell which itself is 'protected'.
Comment 1 garyuu 2009-05-13 09:17:12 UTC
Created attachment 62227 [details]
OpenOffice3 version information for issue report
Comment 2 Rainer Bielefeld 2010-01-01 12:32:15 UTC
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.
Comment 3 Rainer Bielefeld 2010-01-01 12:33:44 UTC
More general summary