Ask Your Question

Drawing elements change location after file close and open

asked 2017-08-11 01:08:15 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have a spreadsheet with 23 tabs on which I've placed many cut-and-pasted images, and also added rectangles as drawing elements. The images and some rectangles were carefully aligned to have their top-left corners coincident with the top-left corners of a cell. Other rectangles aren't so aligned, but are carefully placed relative to other rectangles. But whenever I close the file (after saving it) and reopen it, the drawing elements, both images and rectangles, have moved slightly from where I put them, and the discrepancy is increasing with each close and reopen. On some tabs, all the drawing elements are now about 8mm to the right and 2.5 mm above where they ought to be. I hoped that anchoring the elements to the cell rather than the page might help, but it didn't. I can move the elements back to where they ought to be, but they just start drifting again.

Doing some testing, it appears that every time I close and reopen the spreadsheet, the graphical images move 0.75 mm to the right, and 0.25 mm up. (After 4 saves, they had moved 3 mm to the right and 1 mm up)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-08-12 13:14:50 +0200

scrivener121 gravatar image

Not a complete answer, but a workaround. My spreadsheet was in .xlsx format. If I save in .ods format, this problem does not occur. When I created an empty spreadsheet in .xlsx format, pasted an image into a cell, the image kept moving to the right and up every time I saved and reopened. So the problem is specific to .xlsx format. Operating system is Windows 10.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-08-11 01:08:15 +0200

Seen: 18 times

Last updated: Aug 12