Positioning copied pictures

[keepitcool]

something curious (Excel version 8.0 thru 11.0..)


This works:
I insert a png or gif into a worksheet.
I right align it with cell H2's right border.
I do print preview. The picture is correctly right aligned with the
underlying cell.

This DOESN't work:
I copy the png from sheet 1
I paste it into another sheet or workbook
I repeat the alignment process... In normal view everything looks perfect.

I do print preview... and the damned picture has moved 10 or 20 pixels to
the left, and there's NO way that I know of to get it properly aligned.

I've tried many variations.
PasteSpecial metafile/pastespecial bitmap etc. etc.
Changing Printers...

I don't want to store this picture on disk, I need to copy it from my
addin...

Anyone?


keepITcool




< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Bob Flanagan]

Is the zoom setting on the sheet wth the problem at exactly 100% when you do
the copy and align? I have found it to cause problems like the one you
described.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[keepitcool]

Nope. it's not the zoom.
However I did discover that is has to do with
the placement porperty of the shape.

If the placement is xlMoveAndSize the positioning is correct,
if it's xlFreeFloating it does start to float... and positioning is
different in NormalView and PrintPreview.

You have to be Microsoft to get away with the fact that your print
rendering is still based on Courier 10, fixed pitch....
I dumped my Epson FX100 a while ago....

Thanks anyway.



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >