Bug 88592 - VIEWING: Green display bug;picture with zero width [xlsx]
Summary: VIEWING: Green display bug;picture with zero width [xlsx]
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.2.8.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-01-19 16:49 UTC by Estan
Modified: 2015-01-23 13:53 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments
problem file (24.58 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-01-19 16:49 UTC, Estan
Details

Description Estan 2015-01-19 16:49:46 UTC
Created attachment 112486 [details]
problem file

There is an image into the spreadsheet, the label of "Agriculture
Biologique", which isn't well decompressed by LO: http://i.imgur.com/x7KafJZ.png
Comment 1 Estan 2015-01-19 16:52:04 UTC
The problem is still here with 4.3.5 and 4.4.0.2 versions.
Comment 2 V Stuart Foote 2015-01-19 19:09:27 UTC
Comment on attachment 112486 [details]
problem file

correct mime type
Comment 3 raal 2015-01-19 22:19:51 UTC
With excel 2010 I see no image. With LO 4.5.0.0.alpha0+ I see the same broken file as in screenshot.Can you provide steps how to reproduce this faulty file?
Comment 4 Estan 2015-01-19 22:43:38 UTC
Unfortunately I didn't produce this file, I had to fill it (and can't possibly ask its author to modify or explain it), sorry.
Comment 5 MM 2015-01-20 00:14:40 UTC
Well you can show the image correctly if you select 'edit with external tool' or copy the image and paste it to draw, paint or any other image program. So the image *is* actually there. Only not correctly shown in LO / Excel.
Comment 6 Estan 2015-01-20 00:18:04 UTC
That is that "Only not correctly shown" which is the reported bug actually :-)
Comment 7 MM 2015-01-20 00:35:21 UTC
Well yes and no. You said it didn't decompress well. Which isn't really the case I think. The graphics are there, but they aren't the correct size. Looks they are stretched (a lot). If you look at the 'position and size' you'll see that the image is shown as width 0.0 points and height 104.2 points. If you set it to (for example) w = 104, h = 104 it looks a lot better. Only the image got flipped. But that's another problem.
Comment 8 raal 2015-01-20 07:49:32 UTC
File is created in excel 14.0300, excel 2010. Picture is in tehe file, but with zero width

Steps to reproduce in excel 2010:
- insert picture
- set width = 0 (picture disappear)
- save
- open in LO

Actual results:
picture is showed garbled

Expected results
picture not appear as in excel.

I can reproduce with excel2010, LO 4.3.5.
Comment 9 MM 2015-01-20 19:39:20 UTC
Well if it's allowed in excel to set a width of 0 then it's not a bug of LO. LO imports the file correctly then, maybe even better than excel does (showing nothing).
Comment 10 raal 2015-01-20 21:22:48 UTC
(In reply to MM from comment #9)
> Well if it's allowed in excel to set a width of 0 then it's not a bug of LO.
> LO imports the file correctly then, maybe even better than excel does
> (showing nothing).

no, excel showing nothing. LO showing garbled image. LO should showing nothing.
Comment 11 MM 2015-01-22 20:22:49 UTC
(In reply to raal from comment #10)
> (In reply to MM from comment #9)
> > Well if it's allowed in excel to set a width of 0 then it's not a bug of LO.
> > LO imports the file correctly then, maybe even better than excel does
> > (showing nothing).
> LO should showing nothing.

That's fine, but wouldn't it be even better if you'd get an info window saying LO found some images that should be fixed ?! At least it would save some reports about missing images.
Comment 12 raal 2015-01-23 13:53:16 UTC
(In reply to MM from comment #11)
> That's fine, but wouldn't it be even better if you'd get an info window
> saying LO found some images that should be fixed ?! At least it would save
> some reports about missing images.

Should be as in .ods format with 0 width pictures - red word "Picture.." which disappears after scrolling.


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.