BobJordanB
New Member
- Joined
- Sep 9, 2010
- Messages
- 8
In Excel Mac 2011
If you use the Chart.Export command to produce a PNG file, it produces a file of the expected size if screen viewing size is 100%.
If view is 75% then each dimension of the result file is 75% of the correct size
If view is 200% then the outer border of the picture is double the size, but only the top left 25% of the image has any content.
Interestingly, the Rt Click command 'Save Picture As' does not exhibit this 'feature'.
Screen Viewing size should have no impact on picture pixel dimensions whether it is called from vba or using a Rt Click.
Solution
.Keep viewing size to 100% - but this is a viewer controlled parameter.
.Rescale the viewing size before the command is executed and then restore.
.Run a script to invoke the command using applescript or the like.
Hope this helps others.
Bob J.
If you use the Chart.Export command to produce a PNG file, it produces a file of the expected size if screen viewing size is 100%.
If view is 75% then each dimension of the result file is 75% of the correct size
If view is 200% then the outer border of the picture is double the size, but only the top left 25% of the image has any content.
Interestingly, the Rt Click command 'Save Picture As' does not exhibit this 'feature'.
Screen Viewing size should have no impact on picture pixel dimensions whether it is called from vba or using a Rt Click.
Solution
.Keep viewing size to 100% - but this is a viewer controlled parameter.
.Rescale the viewing size before the command is executed and then restore.
.Run a script to invoke the command using applescript or the like.
Hope this helps others.
Bob J.