Apache OpenOffice (AOO) Bugzilla – Issue 22817
Spreadsheet graphics don't stay put
Last modified: 2013-08-07 15:12:27 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.
Created attachment 11540 [details] example spreadsheet
*** Issue 22819 has been marked as a duplicate of this issue. ***
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.
Hi Daniel, I think for Calc it's yours. Frank
Due to limited time ressources I re-Target this one to OOo Later
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
Forgot. Using Office 2003 as well.
*** Issue 65297 has been marked as a duplicate of this issue. ***