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.
Please upload the problem document.
Created attachment 42197 [details]
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.
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.
[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
Created attachment 49754 [details]
Screenshots, See Comment 5
Only for the sake of completeness, I opened the .xls by double click in WIN Explorer.
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.
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.
Ah, nevermind, this bug is about image positions not border thickness.
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.
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.
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.
(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 )