Download it now!
Bug 113151 - FILEOPEN: Proportion of imported png image is wrong after import from XLSX (with specific twoCellAnchor?)
Summary: FILEOPEN: Proportion of imported png image is wrong after import from XLSX (w...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: Calc-Images XLSX
  Show dependency treegraph
 
Reported: 2017-10-16 15:02 UTC by Bartosz
Modified: 2020-06-08 17:50 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample xlsx document which illustrate wrong png import (455.13 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-10-16 15:03 UTC, Bartosz
Details
Sample XLSX minimized (15.65 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-09-17 12:17 UTC, Timur
Details
Sample XLSX with image moved (15.65 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-09-17 12:19 UTC, Timur
Details
Screenshot of the original document side by side in Excel and Calc (93.53 KB, image/png)
2020-06-08 17:49 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Bartosz 2017-10-16 15:02:02 UTC
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
Comment 1 Bartosz 2017-10-16 15:03:13 UTC
Created attachment 137015 [details]
Sample xlsx document which illustrate wrong png import
Comment 2 Xavier Van Wijmeersch 2017-10-16 15:44:20 UTC
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
Comment 3 Xisco Faulí 2017-10-16 19:11:09 UTC
Confirmed back to 

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 4 Bartosz 2017-10-23 09:16:39 UTC
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.
Comment 5 Bartosz 2017-10-23 23:59:06 UTC
Additional information about Two Cell Anchoring
http://officeopenxml.com/drwSp-size.php
http://officeopenxml.com/drwPicInSpread-twoCell.php
Comment 6 Xisco Faulí 2018-01-22 10:58:33 UTC Comment hidden (obsolete)
Comment 7 Roman Kuznetsov 2019-02-28 10:18:10 UTC
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
Comment 8 Timur 2019-09-17 12:17:28 UTC
Created attachment 154224 [details]
Sample XLSX minimized

Sample minimized, repro with LO 6.4+.
Comment 9 Timur 2019-09-17 12:19:10 UTC
Created attachment 154225 [details]
Sample XLSX with image moved

If image is moved in minimized XLSX in MSO, no repro.
Comment 10 NISZ LibreOffice Team 2020-06-08 17:49:38 UTC
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.
Comment 11 NISZ LibreOffice Team 2020-06-08 17:50:16 UTC
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