Description: After import .xlsx file, the proportion of the .png image "Lenovo for those who do" at the "Contents" tab is wrongly imported Steps to Reproduce: 1. Open attached .xlsx file 2. 3. Actual Results: The .png image "Lenovo for those who do" at the "Contents" tab is wrongly imported (ratio is wrong) Expected Results: After import, the png image should be properly imported Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36
Created attachment 137015 [details] Sample xlsx document which illustrate wrong png import
confirm with Version: 6.0.0.0.alpha0+ Build ID: 8eacd3be08bf6e1a97900624611822de9b00a379 CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group Version: 5.3.1.2 Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2 CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout Engine: new; Locale: nl-BE (en_US.UTF-8); Calc: group Version: 5.3.8.0.0+ Build ID: a0fae00a2d52960eebbb14f08d2de251e0a8ff3f CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout Engine: new; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:libreoffice-5-3, Time: 2017-10-05_05:58:12 Locale: nl-BE (en_US.UTF-8); Calc: group Version: 5.4.2.2.0+ Build ID: SlackBuild for 5.4.2 by Eric Hameleers CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group
Confirmed back to LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
In xl/drawings/drawing1.xml the is definition of image position: <xdr:twoCellAnchor> <xdr:from> <xdr:col>2</xdr:col> <xdr:colOff>1600201</xdr:colOff> It seems that it is wrongly imported.
Additional information about Two Cell Anchoring http://officeopenxml.com/drwSp-size.php http://officeopenxml.com/drwPicInSpread-twoCell.php
Dear Bartosz, This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW. Please assigned it back to yourself if you're still working on this.
I got warning message: Warning loading document 113151 LENOVO_SERVICES_PRODUCT_GUIDE_EMEA_v9_June_9_2015.xlsx: The data could not be loaded completely because the maximum number of columns per sheet was exceeded. and it still repro in Version: 6.3.0.0.alpha0+ Build ID: c57dc7d41bd62f933cffab6131edb7252606382d CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded
Created attachment 154224 [details] Sample XLSX minimized Sample minimized, repro with LO 6.4+.
Created attachment 154225 [details] Sample XLSX with image moved If image is moved in minimized XLSX in MSO, no repro.
Created attachment 161772 [details] Screenshot of the original document side by side in Excel and Calc Looks like the height is imported correctly but the width becomes only 0.34 cm instead of the original 4.79 cm.
This is on: Version: 7.1.0.0.alpha0+ (x64) Build ID: 59939d2490726336546c7ad05082d23031074e12 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL
Reproduced in Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 465c3ad95059f0efa13c8027f7383c4d20a5b2ff CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: kf5 (cairo+xcb) Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded Received the same warning message as comment #7. Only the image width is off, as reported in comment #10.
Dear Bartosz, 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