Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Office -> Open Office

Status
Not open for further replies.

sdz

Structural
Joined
Dec 19, 2001
Messages
586
Location
AU
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?
 
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!:




Doug Jenkins
Interactive Design Services
 
OpenOffice has been good to me for years
 
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
 
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
 
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 :Þ
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top