Opening pasted SPSS tables in Word for Mac

[mpgartland]

I have Word for Mac 2004.

If someone copies and pastes a table or graph from SPSS into Word, I
have trouble viewing it.

A table shows the boundaries with garbled info inside of it. A graph
shows just the outline of where it should be.

Tables and graphs pasted from Excel view fine.

In addition, these same tables and graphs are viewed fine when opened
in a PC version of Word.

Suggestions?

(e-mail address removed)

 

[John McGhie [MVP - Word and Word Mac]]

Try Edit>Paste>Special... "As Picture"

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 4 1209 1410

 

[Martin59]

Maybe it does not fit 100% here, in addition it is already discussed
in microsoft.public.mac.office.excel and microsoft.public.mac.office
....

but - Microsoft told me to handle it like this:

Workaround:
mark the table, hold the shift key, copy with the mouse (menu changes
from "copy" to "copy as picture"). You will be asked if you want to
copy as shown on screen or as printout; choose as printout if you do
not want the red and green little triangles to be shown within the
Word Document.
Change to Word, just "paste", not "paste special" because the
clipboard already contains a "pic" or knows you wish to paste as
"pic".

Choosing "as shown on screen" shows the markers for comments/potential
mistakes.

If I choose "as printed" the problem (cropped pic) persists on my
Powerbook, but not with my G5; perfect result. Started a clean install
of Office 2004 on the Powerbook, same results.

Who helps? Thanks, Martin

 

[Martin59]

This morning showering I found the solution: we have to respect the
printout limitations if we "copy picture - as printout".

Very easy, isn't it?

Exactly these columns are cropped within Word or any other program,
which would not fit into the printout (and would find their way by
printing with Excel to the 2nd, 3rd ... page).

Follow these rules:

If you want

A
to choose "as printed"

reduce the column width so it would fit into a printout
or
change the Excel print settings to "scale fit on one page"

or

B
choose "as displayed on screen" during the process "shift-copy" - as
picture

no problem at all, besides the triangles are shown in Word

Workaround: hide the comment (red) and mistake (green) triangles in
Excel's settings.

HTH Martin59