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.