Why do excel drawing text boxes move relative to each other durin.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Some small excel text boxes are what I call movers. After viewing and
modifing a drawing at high magification, upon returing to %100 view, some
individual boxes move relative to other text boxes - are they alive?

I like to do complex drawings with many objects some of which are linked to
display cell data. A drawing is worth a lots to me for understanding an
system but to have it distort with use is a real pain.

What's neat about excel drawings is they can be big, very big.
 
hi,
Text boxes and other objects just sit on top of the sheet.
They are not attached to any thing. all of them can
become "movers" given the right coditions. apparently when
you magnify and return, it just don't return to the same
exact place. a flaw in excel.
regards
Frank
 
Thanks much for your comment. Any and all help is appreciated. What do I do
to minimize the problem?

I believe that the drawing object can be selected to be located relative to
a cell and moves when it moves. When that link is broken it's not clear what
happens. If I was to guess, I suspect that in general all objects have a
location on a large integer global grid array, say 63k by 63k, and if its
value is within a cell then its link, if linked, sort of moves with the cell.
It would be neat if it was tightly tied to the cell. I could have some
control over it and what I see is what I would get.

I believe that if the view 100% or less, there is no rounding error for
object locations, but when the view is greater than 100%, we focus in on a
small region. When converting back to 100% or less, truncation screws things
up. If the orgiinal object was at the wrong spot, truncation would cause it
to move, and if it was at integral values, it wouldn't move. This is just a
guess.

Even with the glider problems, I find large excel drawings a great way to
think. I wish I could see inside excel.
 
Back
Top