Issue 27840 - Its possible to insert objects into protected tables
Summary: Its possible to insert objects into protected tables
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2004-04-15 11:27 UTC by norbert2
Modified: 2017-05-20 11:13 UTC (History)
4 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description norbert2 2004-04-15 11:27:45 UTC
- Please open a new spreadsheet
- select "Extras/Dokument schützen/Tabelle..." (german version)
- drop down a or right-click to insert a picture from the Gallery to the 
It's possible!

Also CTRL+V works if the clipboard contains graphics. (Only the GUI-elements to 
paste are disabled.)
I have not tested if inserting into protected tables also works for other (non-
graphic) objects.
Comment 1 norbert2 2004-04-15 11:30:52 UTC
(I have increased prio to 2, because this should really be not possible.)
Comment 2 frank 2004-04-15 12:09:56 UTC
Hi Niklas,

this one is for you.

Comment 3 niklas.nebel 2004-04-23 11:07:30 UTC
Comment 4 frank 2004-05-05 10:22:37 UTC
Due to time problems this is re-targeted to OOo2.0
Comment 5 norbert2 2006-08-15 08:52:07 UTC
There is a similar bug with locked layers in Draw (pasting disabled in GUI but
CTRL + v works), so this could be a framework bug:

Issue 68628
Comment 6 cno 2008-04-11 09:42:00 UTC
cannot reproduce in 2.4.0
seems to be fixed in the mean time ...
Comment 7 norbert2 2008-04-12 08:54:59 UTC
Right click a image of the gallery insert/copy still adds an image into
protected tables on OOo 2.4 Linux. (I have not tested Windows build.)
Comment 8 cno 2008-04-13 09:58:35 UTC
@ norbert: Indeed, the same still works on Windows builds. I only tried D&D.
Comment 9 Rainer Bielefeld 2010-01-01 12:33:22 UTC
Not only pictures, also OLE objects can't be inserted into protected tables.

Steps to reproduce:
0. open my "sampledocument.ods" from Issue 108009 
1. Cell Cursor on 'E20'
2. Menu 'Insert -> Object ->'
   expected: it should be possible to insert some objedt, I can't see any reason
             what protection would be violated
   actual: all items greyed out

Same with "Insert Picture".
There is no logic in that behaviour, you can copy paste objects from sheet 2 to
'sheet1.E20' without any problem.

@nnCan the scope for this issue be extended to cover this OLE objects issue, so
that Issue 101866 becomes a DUP of this one?
Comment 10 norbert2 2010-01-02 17:51:40 UTC
[Summary adjusted according to rainerbielefeld's comment.]
Comment 11 Marcus 2017-05-20 11:13:46 UTC
Reset assigne to the default "".