Created attachment 169629 [details] Screen shot around row 5125 What I did: A table with over 9800 lines from File.xlsx opened. Structure of the table: First line with headings and fixed display. All other lines each with an image in the first column and short text in the other four columns. The images in the first 5125 lines are anchored in cell A <line number> as expected. Picture format is JPG. Sum of images 1 to 5125: 17 Mb, total of images 1 t0 9089: 31.6 Mb, average 3.5kb. The error is: All subsequent images are also placed and anchored in cell A5125. Same behavior with previous calc version (guess 7.0.2). Cross-checks: 1. The extracted folder filename/Pictures contains 9089 images after saving as filename.ods. 2. The .xlsx file is opened and displayed correctly with FreeOffice 2018 (rev F982.0109) 64bit. 3. The .xlsx file was saved in LibreOffice as an .ods file and then opened in FreeOffice. Now the wrong behavior described above is also evident there. Unfortunately, for legal reasons I cannot provide the .xlsx file.
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Note that the attachment will be public, remove any sensitive information before attaching it. See the QA FAQ Wiki for further detail.)
As I said earlier, I cannot provide the original file, nor manipulate it. And I can't create a sample file either, because I don't have access to Microsoft Excel. OS Linux/Manjaro: If the original *.xlsx file is cleaned up in Planmaker (2018) - document info deleted - Autofilter off - all text columns deleted - no macros, no formulas - one text column with Image0001 to Image9089 as column B inserted and then opened in Calc, the message Warning loading document *.xlsx: The data could not be loaded completely because the maximum number of characters per cell was exceeded. is displayed. The result is the same as in the none edited version: all images above 5125 are placed in cell A5126. If someone can tell me how to get a valid xlsx file again after all images have been exchanged in the unzipped original file tree, then i can provide it. All of my attempts ended up with a broken compressed file that calc won't open. Workaround: ––––––––––– If the original file is read into Planmaker and written out as *.xls, it can be opened in Calc without any error.
Created attachment 171741 [details] Reproducer document from Excel
Created attachment 171742 [details] The example file in Excel and Calc at the row where the dog image should be
Created attachment 171743 [details] The example file in Excel and Calc where the dog image appears in Calc
Confirming with: Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 9bfe083adf1fd9d470b600d0a801d144db24474f CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: threaded Somehow the image that is placed way down is imported at a position of 5965 cm vertically. IIRC there was some other bug for an xlsx chart with this same specific number as position.
*** Bug 142410 has been marked as a duplicate of this bug. ***
Dear Peter Ragosch, 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 https://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://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
*** Bug 152213 has been marked as a duplicate of this bug. ***