Created attachment 119152 [details] Does not load/display images in column D A simple spreadsheet was made with simple text in the first 3 columns. In column D a picture was inserted for each row. The image was them anchored to the cell. After the file was saved and then reloaded the images are not displayed (not loaded?). The file was then loaded into excel which loaded everything fine. A copy was saved from excel and loaded into LibreOffice which then loaded the file correctly.
Hello Paul, version 4.3 is old and unsupported, please retest with actual version. You can download new version here: https://www.libreoffice.org/download/libreoffice-fresh/ Setting bug as needinfo, set as unconfirmed again if problem still occurs in newer version. Thank you.
Retested with 5.0.2.2 same result.
Hi raal, Just noticed a difference between the two versions. When saving the file out again the old version kept the images, but 5.0.2.2 dropped the images from the file (at least Excel didn't load them anymore).
Please attach images, I'll try to recreate file from scratch.
NEEDINFO until requested files are provided
Created attachment 119315 [details] Org graphics used to build sheet
The org spreadsheet was made by importing a .csv file with the file names in column A, a 4 number with spaces between them in column B. The file names where sorted in column A (reordering the whole spreadsheet). Column C then had the graphic inserted using Insert->Image... for each file. The Anchor was then changed to cell. A new column C was inserted. The spreadsheet was them saved out and an attempt was made to reload the file (into an empty spreadsheet)
I tried inserting two of the images to a new spreadsheet. The images did not disappear after save & reload. attachment 119152 [details] can be unzipped and the files seen in Pictures folder. Win 7 Pro 64-bit, Version: 5.0.2.2 (x64) Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe Locale: fi-FI (fi_FI)
I tried the following with the latest Libreoffice: * Loaded the original .ods file into Excel (file1). * Saved it back out (file2) * Loaded that into Libreoffice (file2) * Saved it back out (file3) * Closed Libreoffice * Loaded the new file back in (file3) * Loaded without issue. It looks like the question is now why does Excel load the file but Libreoffice does not. Was the .ods file corrupted by the older version of Libreoffice or is there a loading problem with the current version of Libreoffice If it's a corrupted file, the question is should Libreoffice load it anyway as Excel does.
Yeah, let's set to NEW and focus on why the images are not displayed even though they live inside the document container.
the images are still there: * open navigator sidebar * click in the sheet * navigator shows Image 1 to 21 * double click an entry * switch to properties sidebar * unfold position and size * width is 0, the rest looks normal * increase width to make image visible again why width is 0? does lo import the value wrong or is width in the document really 0 and should we sanitize the value
This is what one row looks like: > <table:table-cell office:value-type="string" calcext:value-type="string"> > <text:p>001BC500B0016C1E.bin</text:p> > </table:table-cell> > <table:table-cell office:value-type="string" calcext:value-type="string"> > <text:p>03 05 09 01</text:p> > </table:table-cell> > <table:table-cell office:value-type="string" calcext:value-type="string"> > <text:p>Field of FF's Damage</text:p> > <draw:frame table:end-cell-address="Details.C1" table:end-x="7.8827in" table:end-y="5.9602in" draw:z-index="0" draw:name="Image 1" draw:style-name="gr1" draw:text-style-name="P1" svg:width="7.8827in" svg:height="5.9594in" svg:x="1.7524in" svg:y="0in"> > <draw:image xlink:href="Pictures/10000000000002CF0000023AFD0A1A6E.png" xlink:type="simple" xlink:show="embed" xlink:actuate="onLoad"> > <text:p/> > </draw:image> > </draw:frame> > </table:table-cell> > <table:table-cell/> in the cell of column C is a frame with a width and inside is the picture. while the cell of column D is empty. don't know if the frame should be in column D and the document was saved wrong or lo imports it wrong. needs someone who knows ods specs
'needsConfirmationAdvise' is only used for unconfirmed bugs. Removing it from this bug. [NinjaEdit]
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Attachment 119152 [details] no repro LO 3.3, I mark regression from 3.4, repro 7.0+. If ODS is opened in LO 3.3 and resaved, images open. So likely damaged by LO. Original ODS has table:end-cell-address="Details.C1" and saved ODS has table:end-cell-address="Details.D2".
Created attachment 159390 [details] Does load images in column D if resaved in LO3.3 This one further loads and saves fine.
I see a lot of blue-black images, if I load the file with Version: 7.1.0.0.alpha1+ (x64) Build ID: a689cf1672e89cb78fbcfa14c505850927e71f58 CPU threads: 8; OS: Windows 10.0 Build 19041; UI render: default; VCL: win Locale: de-DE (en_US); UI: en-US Calc: CL Please try your problematic files again with a current daily build.
Regina, great catch. Recent fix in 7.1+ by .... you :) commit 25b3c957bfcb95a1da27a6021d1514495fd7df51 Date: Sat Oct 31 15:47:22 2020 +0100 source 1f0b3c7a40edfa81bbc7a58d123a6a2dfd83e4ca prev source a4d8f8930d96da59505f73e9f063243eafa1efc9 https://git.libreoffice.org/core/+/1f0b3c7a40edfa81bbc7a58d123a6a2dfd83e4ca%5E!/ commit 1f0b3c7a40edfa81bbc7a58d123a6a2dfd83e4ca [log] author Regina Henschel <rb.henschel@t-online.de> Sat Oct 10 17:55:31 2020 +0200 committer Regina Henschel <rb.henschel@t-online.de> Sat Oct 31 15:36:00 2020 +0100 tree f731afbd007f6b19bbe369342b81cdf6c7141d8d parent a4d8f8930d96da59505f73e9f063243eafa1efc9 [diff] Improve 'resize with cell' handling
Nice!!