Issue 10019 - Controls are loosing their position even if they are move protected
Summary: Controls are loosing their position even if they are move protected
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 3.1
Hardware: All All
: P3 Trivial with 5 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 75868 (view as issue list)
Depends on: 102061
  Show dependency tree
Reported: 2002-12-12 10:43 UTC by Oliver Brinzing
Modified: 2017-05-20 11:11 UTC (History)
3 users (show)

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

Controls are loosing their position even if they are move protected (5.79 KB, application/octet-stream)
2002-12-12 10:44 UTC, Oliver Brinzing
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Oliver Brinzing 2002-12-12 10:43:04 UTC

If you use grouping/ungrouping or insert rows/columns in a spreadsheet,
you run into trouble, if you have Controls in these areas, because
the move protection seems not to work. The position of the controls
are changed ...

I will create an attachment ...


Comment 1 Oliver Brinzing 2002-12-12 10:44:18 UTC
Created attachment 4008 [details]
Controls are loosing their position even if they are move protected
Comment 2 Frank Schönheit 2002-12-12 13:29:20 UTC
still present in latest internal build
Comment 3 Frank Schönheit 2002-12-12 13:30:27 UTC
Spreadsheet problem. Changing component, owner and QA contact accordingly.

Niklas, this does not only happen for buttons, but for other shape
types, too (I tried an ordinary rectangular shape).
Comment 4 Frank Schönheit 2002-12-12 13:30:43 UTC
now really changing QA contact
Comment 5 Oliver Brinzing 2002-12-14 10:03:11 UTC
If you change the anchor from "at cell" to "at page" via the GUI it
seems to work ...
But I can't find the Property "AnchorType" for a calc document (to
change it via macro) ...

For a writer document, you can change the anchor with


Comment 6 niklas.nebel 2002-12-19 13:54:52 UTC
A drawing object that is anchored to a cell has its position updated
when cells are moved, even if the position is protected. This is
supposed to be that way.
When the cells are collapsed and expanded again, the objects have lost
their position because an obejct's anchor cell isn't really stored
anywhere, but simulated using the object's position. This can't be
changed with the current drawing layer implementation, so I'll mark
the issue as resolved/later.
Comment 7 Oliver Brinzing 2002-12-19 14:30:10 UTC
Hi Niklas,

so as a workaround I anchor the objects to the drawpage ...
But I can't find the Property "AnchorType" for a Control in a 
calc document ... 
Can this be fixed soon ? (cause I wrote a sub to create controls
at runtime, the problem is now, that I can't anchor them to the page,
so they will lose their positions :-( ...

best regards

Comment 8 ooo 2004-08-03 13:17:22 UTC
Target OOoLater instead of status resolved/later.
Comment 9 Oliver Brinzing 2006-02-17 13:24:09 UTC

this issue is still valid for oo 2.0.2 rc1 ...

Comment 10 frank 2007-06-26 13:39:05 UTC
*** Issue 75868 has been marked as a duplicate of this issue. ***
Comment 11 llewelyn_mt 2007-06-27 14:10:26 UTC
As the creator of the issue 75868, I strongly encourage the reading of my
synopsis and its follow-ups, as well as the related issue 76776. 

I consider it a major problem as it affects formulas, pictures, shapes, just
about anything I tested. It changes both size and position of these objects,
whether their size and/or position is protected or not. It affects the two major
OS (linux and win32) and all app versions (until 2.2 at least). Looks like a
huge usability problem for me, if you rely on finding objects inserted into Calc
cells in places you left them. 

The comment in related issue 8303 considering target milestone is *NOT* funny.
Is there any other error anywhere in that is that serious and was
celebrating it's fourth birthday last year already?

Please change the OS to all, as it was observed on Win2k, WinXP and a multitude
of GNU/Linux distributions. 
BTW isn't this a "formatting" subcomponent issue, rather than "UI"? It does
wreck havoc in my thesis' formatting and really has nothing to do with UI,
rather the philosophy of object anchoring as stated in issue 8303.
Comment 12 Oliver Brinzing 2009-05-19 06:35:43 UTC
issue verified in OO 3.1 - setting target to 3.2
Comment 13 Oliver Brinzing 2009-05-21 16:21:42 UTC
cmc is working on a patch for this issue
Comment 14 niklas.nebel 2009-10-14 17:04:20 UTC
adjusting target
Comment 15 Marcus 2017-05-20 11:11:43 UTC
Reset assigne to the default "".