Excel range truncates when Pasted as Picture to PPT & Word
 

Hi...

I have been trying to copy an Excel Spreadsheet into PPT, but have had
problems. In order to solve it, I created new .xls and .ppt files to create a
test, but got the same problems...

The following steps recreate the problem:

1) In a blank spreadsheet, I placed a single number in each cell, starting
at A1 and going across to AS, until there are 1 through 45 across. Format
them in some way... say Red text with an underline.

2) Set the width of all the columns to 2.00 (0.11 inches).

3) Select A1:AS

4) Copy (or Add to Scrapbook) -- The result is the same with both.

5) From Scrapbook, Paste as Picture, right there in Excel, or in PPT or in
Word

---- You will see that everything is fine. It pasted it just as is should,
with a picture of the formated row, numbers 1 through 45

---- Now, go back and change the width of cells A1:AS to 4.29 (.17 inches),
and repeat steps 3, 4 & 5.

This time, the numbers are cut off... The pasted area is the correct width,
but only up to 27 is visible, with the rest just blank.

If you click Paste in scrapbook, it pastes all the data, but it is
unformatted. But Paste as Picture cuts it off.

From the Edit/Paste Special menu, the results are the same. -- And if you
widen the columns further, even fewer numbers are visible.

I am running a PB G4, 17" with 1GB RAM, latest OS, Updated Office 2004.

It makes no sense that the Metafile would be so small. Needless to say, this
is very annoying... Any help figuring this out would be greatly appreciated.

Rgds,
Floyd

What's a scrapbook?
-----Original Message-----
Hi...

I have been trying to copy an Excel Spreadsheet into PPT,
but have had
problems. In order to solve it, I created new .xls
and .ppt files to create a
test, but got the same problems...

The following steps recreate the problem:

1) In a blank spreadsheet, I placed a single number in
each cell, starting
at A1 and going across to AS, until there are 1 through
45 across. Format
them in some way... say Red text with an underline.

2) Set the width of all the columns to 2.00 (0.11 inches).

3) Select A1:AS

4) Copy (or Add to Scrapbook) -- The result is the same
with both.

5) From Scrapbook, Paste as Picture, right there in
Excel, or in PPT or in
Word

---- You will see that everything is fine. It pasted it
just as is should,
with a picture of the formated row, numbers 1 through 45

---- Now, go back and change the width of cells A1:AS to
4.29 (.17 inches),
and repeat steps 3, 4 & 5.

This time, the numbers are cut off... The pasted area is
the correct width,
but only up to 27 is visible, with the rest just blank.

If you click Paste in scrapbook, it pastes all the data,
but it is
unformatted. But Paste as Picture cuts it off.

From the Edit/Paste Special menu, the results are the
same. -- And if you
widen the columns further, even fewer numbers are visible.

I am running a PB G4, 17" with 1GB RAM, latest OS,
Updated Office 2004.

It makes no sense that the Metafile would be so small.
Needless to say, this
is very annoying... Any help figuring this out would be
greatly appreciated.

Rgds,
Floyd

.

"hmmm" wrote:

What's a scrapbook?


Scrapbook is a copy & paste utility in Excel.