Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Floyd
 
Posts: n/a
Default 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

  #2   Report Post  
hmmm
 
Posts: n/a
Default

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

.

  #3   Report Post  
Floyd
 
Posts: n/a
Default



"hmmm" wrote:

What's a scrapbook?



Scrapbook is a copy & paste utility in Excel.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Convert Word labels to Excel spreadsheet Lisa Excel Discussion (Misc queries) 2 January 18th 05 10:36 PM
Help, insert a word document contents into excel tab? Dan Ward Excel Discussion (Misc queries) 2 December 15th 04 12:01 AM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM
Copying an Excel spreadsheet to a Word document KG Excel Discussion (Misc queries) 1 November 28th 04 07:38 PM


All times are GMT +1. The time now is 12:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"