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
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
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.
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.