Bug 33251 - Wrong vertical position of pictures in .xls import
Summary: Wrong vertical position of pictures in .xls import
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.0 RC1
Hardware: Other All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2011-01-18 11:41 UTC by Benoit Rouleau
Modified: 2013-11-23 13:38 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

View of the software rendering Vs view of the printed page (73.56 KB, image/jpeg)
2011-01-18 11:41 UTC, Benoit Rouleau
Original file (375.50 KB, application/vnd.ms-excel)
2011-01-19 04:51 UTC, Benoit Rouleau
Screenshots, See Comment 5 (300.94 KB, application/pdf)
2011-07-31 00:25 UTC, Rainer Bielefeld Retired

Note You need to log in before you can comment on or make changes to this bug.
Description Benoit Rouleau 2011-01-18 11:41:58 UTC
Created attachment 42178 [details]
View of the software rendering Vs view of the printed page

If I add images to a sheet and attach it to a specific cell, I have to get the images completely out of whack in the software view in order to get it alligned properly when printing.
Comment 1 tester8 2011-01-19 02:22:50 UTC
Please upload the problem document.
Comment 2 Benoit Rouleau 2011-01-19 04:51:45 UTC
Created attachment 42197 [details]
Original file
Comment 3 Jeffrey 2011-06-22 19:56:59 UTC
I seem to have problems doing a page preview of the attached calc file you posted because the cells appear incredibly small. (I do not know if something is wrong with the version I'm using but I cannot seem to get an acceptable preview).

Anyways, your attachment does not confirm that when printing, the border problem is resolved. From your first attachment, there is indeed a border problem with the picture of a man doing a squat in col Q. However, the bottom picture of attachment 1 does not look like to be from col Q. Rather, it looks like it is from col A.

From your second attachment, there is no border for col A while there is a border problem for col Q. So it does not look like the printer resolved the problem but rather you were comparing two different cells. I do agree that Calc should have a better way of handling objects within cells, for right now the auto-adjust for cell dimension considers only text and not the picture at all (double-click the col borders and it will wrap around the longest text in the col).

So from comparing your two attachments, it looks like WYSIWYG stands? The printer printed exactly as it displayed on the sheet. If you cannot confirm otherwise, perhaps we should re-label this bug.
Comment 4 Miguel Angel 2011-07-06 01:20:36 UTC
I have a different problem created because this bug, i am creating .xls files with python library xlwt and inserting bitmaps in cells, Gnumeric and Microsoft Excel open the file and shows the images in his cell, but Libreoffice calc get down the images a bit for every row and given many rows it shows completely out of his cell.
Comment 5 Rainer Bielefeld Retired 2011-07-31 00:02:36 UTC
[Reproducible] with reporter's sample and "LibreOffice 3.4.2 RC3 - WIN7  Home Premium (64bit) German UI [OOO340m1 (Build:203)]", please see attached screenshots.

I also can confirm that printout looks better than sheet view, when you select a range 'A91:F131' and printed selected range, vertical position of the pictures was correct.

Only for information, might be an other bug: new little print problem was that Picture in A92:A99 exceeded the right column border, what was not a problem in sheet view.

Please feel free to reassign if it’s not your area
Comment 6 Rainer Bielefeld Retired 2011-07-31 00:25:27 UTC
Created attachment 49754 [details]
Screenshots, See Comment 5

Only for the sake of completeness, I opened the .xls by double click in WIN Explorer.
Comment 7 Kohei Yoshida 2011-08-01 07:40:31 UTC
There a duplicate for this though the bug number escapes me.

This is purely for display only.  The problem is due to the resolution of screen output which is not fine enough to show differences of the thickness of the borders.  When printing to a paper or increasing the zoom level the problem goes away.

This is hard to fix, since to fix it correctly we need to re-work the drawing layer for Calc.
Comment 8 Kohei Yoshida 2011-08-01 07:44:19 UTC
In addition to that, Excel and Calc use different border thicknesses for the pre-set thin, medium and thick border styles, and this problem is a manifestation of it.

Again, fixing that will be tricky, but we are aware of this.
Comment 9 Kohei Yoshida 2011-08-01 07:45:48 UTC
Ah, nevermind, this bug is about image positions not border thickness.
Comment 10 Kohei Yoshida 2011-08-01 07:48:20 UTC
Caolan was/is working on something similar in this area, to fix drawing object's positioning problem on import.  I'll add him to CC.
Comment 11 Björn Michaelsen 2011-12-23 13:25:34 UTC
Since all new unconfirmed bugs start in state UNCONFIRMED now and old unconfirmed bugs were moved to NEEDINFO with a explanatory comment, all bugs promoted above those bug states to NEW and later are automatically confirmed making the CONFIRMED whiteboard status redundant. Thus it will be removed.
Comment 12 Eike Rathke 2013-01-28 10:17:11 UTC
This looks much better now on master and 4-0, images are within cells. I guess this is due to the work of Noel, thanks. Closing.
Comment 13 Noel Power 2013-01-28 11:20:18 UTC
(In reply to comment #12)
> This looks much better now on master and 4-0, images are within cells. I
> guess this is due to the work of Noel, thanks. Closing.

delighted to see that this has fixed something this time :-) ( I was getting too used to breaking things )