Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Opening pasted SPSS tables in Word for Mac

854 views
Skip to first unread message

mpgar...@sbcglobal.net

unread,
Feb 24, 2005, 2:30:33 PM2/24/05
to
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?

mpgar...@sbcglobal.net

John McGhie [MVP - Word and Word Mac]

unread,
Feb 28, 2005, 11:18:10 PM2/28/05
to
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 <jo...@mcghie.name>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 4 1209 1410

<mpgar...@sbcglobal.net> wrote in message
news:1109273433.4...@g14g2000cwa.googlegroups.com...

Martin59

unread,
Mar 2, 2005, 6:49:24 PM3/2/05
to
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

unread,
Mar 3, 2005, 3:34:37 AM3/3/05
to
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

0 new messages