Issue 22817

Summary: Spreadsheet graphics don't stay put
Product: Calc Reporter: Unknown <non-migrated>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1   
Target Milestone: ---   
Hardware: PC   
OS: Windows 2000   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
example spreadsheet none

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.

Frank
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
1 GB RAM
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. ***