MS Office -> Open Office

[sdz]

I've been having a bad afternoon. Excel keeps moving my pictures around and won't print thenwhere they appear on the screen.

Is Excel2007 the best reason yet to switch to Open Office?

 

[sdz]

Here's an example using Excel 2007

 

[IDS]

I don't know what the problem is, but the easiest solution would probably be to copy and paste into Word (which I guess is how you produced your attached image file).

If you are saving as an xls you might try changing to one of the new formats, could help.

Just in case you haven't found the "copy as picture" command in 2007, it's buried under the paste menu!:

http://newtonexcelbach.wordpress.com/2009/10/18/copy-and-paste-as-picture/

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[IFRs]

OpenOffice has been good to me for years

 

[IRstuff]

So, what you can do is to turn off gridlines in the Options, and do a screen capture like you did in your posting.

TTFN

FAQ731-376

 

[IDS]

IRstuff - that's the point of the "Copy as Picture" menu. It gives you the option to "copy as printed" so you can get an image without the grid lines without having to turn them off and on.

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[sdz]

I found the problem.
By closing the Excel spreadsheet and reopening the display of my graphics was fixed.

I think this might be an undocumented Excel feature :Þ