Ask Your Question

Images in Calc

asked 2017-12-10 19:50:19 +0200

jodybingo gravatar image

On occasion the images I insert into my spreadsheet becomes broken (?) and sometimes shoots in the top left corner of the screen I have a screenshot on facebook (link provided below). Protecting the sheet does nothing tho prevent this btw. link text

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-12-10 22:26:46 +0200

librebel gravatar image

Hello @jodybingo,

The “broken image” is probably caused when the original source image file is deleted or moved to another location on your disk, in the case that you had LINKED the image instead of Embedding it inside the Document.

Then Calc cannot find the image at the specified location anymore, and displays a standard image icon instead.

To prevent this in the future, just make sure to Uncheck the checkbox “Link” in the FilePicker dialog when inserting the image. Then the image will be embedded inside the document.

To repair any existing broken images in your document, i suggest you re-insert them as Embedded ( i.e. “Not Linked” ).

As for the image moving to the topleft corner of the Sheet, that is possibly caused when the image is anchored to the Page instead of to the Cell.

Just right-click on the image, in the menu choose “Anchor : To Cell”.

HTH, lib

edit flag offensive delete link more

answered 2017-12-26 02:18:33 +0200

jodybingo gravatar image

Hello. The "link" button is always unchecked. As for files mssing/moved, the spreadsheets are prepared on my laptop then moved to the company file server. the images remain on my laptop and are not transferred to our server. The images can remain in tact for several weeks and then several become broken.

edit flag offensive delete link more


Is this an answer to your question? If so, can we close it as answered?

Seriously: don't use "Answer" to provide more data to question - edit original question instead, or use "comment" under an answer you are commenting.

Mike Kaganski gravatar imageMike Kaganski ( 2017-12-26 02:48:23 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-12-10 19:50:19 +0200

Seen: 1,571 times

Last updated: Dec 26 '17