Hello.
When I open Excel (xls) with LibreOffice, some photos which are in the cells have disappeared.
My file is about 114mo and contains about 4500 rows with 3000 photos.
Could anyone here tell me why these photos are not present when I open it with LibreOffice please?
Thank you
Yannick
Just a tip:
Determine the count of the embedded images in your file. (I do not know how you can do it)
Then take a copy of your file. Rename it to .zip extension. Unzip the archive. Check if the all of the images exists in the inside directory. (You can encount them with a file manager software.)
If all of them exist, maybe the some of them are damaged, or has not supported file type.
If some of them missing: That is the reason, why they not appeared.
.
.
Note:
A spreadsheet file is not the best photo album.
The foreign, obsolete, never standardized .xls file format is not the best choose for the LibreOffice.
Thank you for your answer.
The photos appear in the first 1500 cells and the following cells are empty.
I think this excel file is too big (114mo)
Do you know if 114mo is too much for Calc?
Thank you
XLS is not a ZIP archive. You can’t examine it this way.
No it’s not too much. And most of that size is images, so not much data.
1 Like
Thank you for your answers.
I have tried many things and none works.
I think I have to buy Microsoft 365 but it’s pity, this LibreOffice one seems to be very good though
Y
Oh, I have just found one thing.
The 2000 (or so) missing photos are there but somewhere in the table.
They are all in the same cells!!
Then the anchoring is probably not right.
You can select and hold an image and move it to another cell with the mouse.
The anchor will be moved to the desired cell.
In my excel file, I have anchored all the images in their cells and I thought it would be ok but the result is the same when I open with Calc.
Compatibility problem?
https://wiki.documentfoundation.org/Faq/General/118#Edit_different_file_formats_in_LibreOffice
Please report the behavior also as an error in Bugzilla .
See also:
How to Report Bugs in LibreOffice .
Please post the link to the bug here.
format: tdf#nnnnnn (use only the number, not the link)
To do this, edit your original question. Thank you very much.
Differences between the OpenDocument Spreadsheet (.ods) format and the Excel for Windows (.xlsx) format
And you guess right: Calc is an ODS machine.
1 Like