Issue 22817 - Spreadsheet graphics don't stay put
Summary: Spreadsheet graphics don't stay put
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: PC Windows 2000
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 22819 65297 (view as issue list)
Depends on:
Reported: 2003-11-24 23:27 UTC by Unknown
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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

example spreadsheet (186.62 KB, patch)
2003-11-25 00:04 UTC, Unknown
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-11-24 23:27:21 UTC
We have some users on MS Office (2000 and XP) and some on OpenOffice 1.1.0 (we
hope to make a total transition one day - but there are some hearts and minds to
be won over first). They are using lots of spreadsheets with graphics in them
(pictures of shoes, can be jpgs or bmps mostly, but sometimes giffs).

When the spreadsheet is opened with OO (with or without changing the file format
from .xls) the graphics all lose their alignment - they tend to all move
upwards. When you straighten them all out again in OO - make sure they are
fitting into a cell nicely, all anchored properly, etc. save it as Excel, and
send it back to a MS Office user, they open it in Excel and save it, the images
tend to have moved around again. Needless to say this is annoying the users.
(example file can be provided - how?)

Also, even when we take great care to set it all up carefully (images anchored
into cells large enough to totally contain them works best) the OO document
image sizes will not adjust properly when you move to a zoomed view of (say) 75%
from 100% or whatever (only in Windows - works fine with Red Hat Linux). They
tend to appear too big or to move upwards or otherwise lose alignment.
Comment 1 Unknown 2003-11-25 00:04:14 UTC
Created attachment 11540 [details]
example spreadsheet
Comment 2 daniel.rentz 2003-11-25 07:58:21 UTC
*** Issue 22819 has been marked as a duplicate of this issue. ***
Comment 3 rblackeagle 2003-11-25 10:28:21 UTC
This problem is program-wide.  They will also not stay put in Writer.
 The "incredible bouncing graphics" has been reported for years.  I
would love to know if anyone is working on getting graphics to stick
where they are put (relative to anchoring).  "As character" should
mean that -- but doesn't.  Samme with other anchors.  One problem
seems to be that no one has decided what to do with the graphic if
something changes.
Comment 4 frank 2003-11-27 11:22:58 UTC
Hi Daniel,

I think for Calc it's yours.

Comment 5 frank 2004-05-04 14:40:37 UTC
Due to limited time ressources I re-Target this one to OOo Later
Comment 6 fitirocz 2004-09-22 20:02:16 UTC
Can you please list steps for how you got this bug.  My steps:

1) Open Excel
2) Create spreadsheet adding pictures
3) Saved spreadsheet
4) Open spreadsheet in Open Office
5) Pictures were still in same locations
6) Save file as .xls in OO
7) Reopen spreadsheet in Excel
8) Pictures were still in same locations
9) Save again in Excel
10) Open spreadsheet again in OO
11) Pictures once again fine

I also opened your file and saw where the pictures were.  I moved them and 
performed steps 6 - 11 above.  In the end they stayed in place each time I 
opened the file in Excel and OO.  

My system:
XP Pro w/ SP2
P4 2.6 GHz
80 GB harddrive
Open Office v.1.1.2
Comment 7 fitirocz 2004-09-22 20:04:57 UTC
Forgot. Using Office 2003 as well.
Comment 8 frank 2006-05-11 14:56:30 UTC
*** Issue 65297 has been marked as a duplicate of this issue. ***