Re^2: Excel Picture Size Changes & other actions

Thanks for that. However, I want to be able to change the aspect ratio so that I can distort the original image.
I have tried the following 2 lines

$pic_cur ->{AspectRatio}  = "False";
$pic_cur ->{LockAspectRatio} = "False";
[download]

but neither had the desired effect.

Comment on Re^2: Excel Picture Size Changes & other actions Download Code

Replies are listed 'Best First'.
Re^3: Excel Picture Size Changes & other actions by bart (Canon) on Nov 02, 2010 at 14:41 UTC
Well, as I calculate the aspect ratio from the picture dimensions from the original image as it is loaded, you can simply ignore that value and set the desired aspect ratio yourself — or at least, modify it at will. For example, inserting `$aspect *= 2;` [download] before using the value, will make the picture twice as high as it should be, although it might be scaled back to fit the maximum allowed size.	[reply] [d/l]
Re^4: Excel Picture Size Changes & other actions by merrymonk (Hermit) on Nov 02, 2010 at 15:48 UTC
Thanks for that but I still have a problem. In my original Perl I had the lines `$pic_cur ->{Width} = 200; $pic_cur ->{Height} = 100;` [download] The issue is that setting the width to 200 is, in effect, ignored because I believe some setting is there which means that the aspect ratio of the image is kept the same. Therefore the Height setting and the 'fixed' aspect ratio means that after setting the Height the Width is reset to 81.818. Therefore I am still puzzling how to say that I do not want the aspect ratio of the image to be constant. Then I will be able set the Width and Height to what I want.	[reply] [d/l]