Office 2004: "Paste Special" "Picture" loses 67% of the image

[davidsol]

Is anyone else experiencing this problem:

--I create a speadsheet or drawing in Excel or PowerPoint.

--I select say the spreadsheet, and "copy".

--Then I go to Word and "Paste Special":"Picture" and the resulting
image is:
-->Missing the right 2/3rd of the picture, meaning if my
spreadsheet has 10 columns, the first three appear in the picture, but
the next 7 are "gone".
-->The "picture" is "full size" meaning that when I pull on the
corner, it's not like the "missing" part comes into view. It just
resizes it but it's still "missing" the rigthmost 2/3rds.

--This happens from Excel to Word, from Excel to PowerPoint, from
PowerPoint to word. I haven't tried the other combinations.

This never happened in Office X. I upgraded to Office 2004, and now
this problem is happening. I am using the same Macintosh (iBook G4)
that I used for Office X.

I would be curious if other Mac Office2004 users could try this out.
Either it's a bug with my own system, or a problem that others are
having.

If anyone has figured a work around for this, I would be very
interested in knowing what it is.

Thank you for time!

David

 

[Daiya Mitchell]

I just tried this in Word/Excel 2004 with a 7-column spreadsheet that I
expected to fit within a portrait page, and it worked fine. Tried it with a
14 column spreadsheet that I did *not* expect to fit, and it worked fine,
Word scaled it for me.

Okay, tried it again with a 17-column spreadsheet, this time I got 14
columns and some blank space. The blank space is *part of the picture.* Is
that what you are seeing? (columns is not a very useful term in this
context, by the way) Is Word pasting just part of what you copied, or is it
pasting something that is the right size but doesn't contain all of the
text/lines?

Interestingly, in this last experiment--I got 14 columns fine, a 15th column
with Excel's gridlines but no text and half my color formatting cut off, and
2 blank columns without even gridlines from excel. (Zoom to 500% in Print
Preview) But I am not losing anywhere near 67% of the image. In both my
texts, problems began at column O, though to different extents.

Running Office 11.1. Have you applied the Office 2004 update?

DM

 

[Martin59]

Hi together,
having the ssame probelem, I just phoned with a friendly guy Microsoft
Germany.

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".
Have fun with Office 2004. I feel better now ;-)
Regards, Martin
P.S. I translated from Germany, so the menu items maybe are not 100%
correct

 

[Benjamin Amsaleg]

Just a warning

Be careful about using the copy/paste as picture. The german languages use
high ASCII specific letters like ß

If you need to share this file with a Office:Win user all pasted element
will be converted. Unfortunately in this conversion process, high ASCII
characters are not remap to the Windows encoding scheme resulting in strange
or blank characters

If you need to past as image, make sure that you don't use any accents to
avoid this problem

Just my 2 euros cents ;-)

 

[Martin59]

Be careful about using the copy/paste as picture. The german languages use
high ASCII specific letters like ß

If you need to share this file with a Office:Win user all pasted element
will be converted. Unfortunately in this conversion process, high ASCII
characters are not remap to the Windows encoding scheme resulting in strange
or blank characters

This is a bug I discussed with Microsoft, too. They say they work on
it.
Sharing brings the strange results you describe. Workaround in my
special case: I pass the files as PDFs to the Windows colleagues. Not
very elegant.
Thanks, best regards und noch einen schönen Abend
Martin

 

[Martin59]

.... in addition, Microsoft told me it depends on the font used. E.g.
if you use Verdana, there is no problem with the ASCII.
Regards, 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

 

[Bob Greenblatt]

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

OK, I don't question your solution. And, I'm very glad you solved the
problem. But I really would like to know how you discovered and tested this
in the shower.

 

[JE McGimpsey]

But I really would like to know how you discovered and tested this
in the shower.

I think that's a bit more information than I need...<g>

 

[Martin59]

But I really would like to know how you discovered and tested this
in the shower.

The morning shower's ideas are the only ones all day long. So I use
them


There had to be another reason - it could not be Excel nor Mac OS
(problem on PB G4, no prob on G5). So I suspected the printer driver
to be the ugly guy ...
So the solution was not far away and could be further investigated - I
admit - in dry condition

Thanks for praising my efforts
Martin

 

[Priyanka Singhal [MSFT]]

Hi David ,
Will it be possible for you to send the excel sheet you are using to me.
My email address is (e-mail address removed) .
Thanks,
Priyanka

 

[Klaus Kamppeter]

Same thing happens to me if the selected area en Excel is wide. Small
selections copy correctly to Word.

A way to avoid is to copy en Excel as image (Shift + copy menu), select
option "as on screen", an just paste en Word (a problem may be the green
and red marks, but it's possible to deactivate them).


Bye

 

[CyberTaz]

Hi Folks-

This is a technical issue that has been kicked around for some time. You
might want to search the forum using "paste special" as well as other
keywords on the subject.

FWIW, I personally prefer to use Insert>Object or Insert>File rather than
copying & pasting between file type for almost anything other than regular
text. The option for linking also provides for update insurance when
required as well a more reliable results overall.

HTH |:>)

Just a warning

Be careful about using the copy/paste as picture. The german languages use
high ASCII specific letters like ß

If you need to share this file with a Office:Win user all pasted element
will be converted. Unfortunately in this conversion process, high ASCII
characters are not remap to the Windows encoding scheme resulting in strange
or blank characters

If you need to past as image, make sure that you don't use any accents to
avoid this problem

Just my 2 euros cents ;-)

-- (e-mail address removed)

 

[Klaus Kamppeter]

Same thing happens to me if the selected area en Excel is wide. Small
selections copy correctly to Word.

Meanwhile the Excel selections copy just fine pasted as picture. Maybe
it has to do with the printerdriver selected.

Bye

 

[DWP @ ACTEWAGL]

I have 25 eMacs in a lab at school. I also have 25 licences for Mac Office
2004. It was too hard to install a different code for each machine as I
built one machine with all software installed and updated and then carbon
copy cloned it to the others BUT now I have the 'only one machine at a time
will run office syndrome. I followed the previous instructions on deleting
the invisible file OfficePID, and it gets deleted but when I then launch say
Word, the file OfficePID gets recreated!!
So what do I do to be able to delete the previous CD code from each machine
and install the 25 codes?
Thanks to all of you in advance for your help.