Microsoft KB Archive/118596

= Works: Effects of Pasting a Spreadsheet into the Word Processor =

Article ID: 118596

Article Last Modified on 11/15/2004

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a

-



This article was previously published under Q118596



SUMMARY
When you paste a range of cells with gridlines visible from a spreadsheet into a Word Processor document in Works, variations of the original information appear, depending on the format used to paste the information. The following table outlines the formats available and the paste results:

NOTE: You can choose the format with which to paste by selecting Paste Special from the Edit menu in the Word Processor module.

Under Works 2.0 and 2.0a
 Format                 Primary Result            Secondary Result -- Works internal format  ANSI text with no         Empty rows will be                         gridlines and cells       replaced with a single separated by tabs. tab and a carriage return. Each row contains a leading tab before the data.

Text                   ANSI text with no         Empty cells internal gridlines and cells      to the range will separated by tabs. have only the tabs separating the cells.

OEM Text               ASCII text with no        Empty cells internal gridlines and cells      to the range will separated by tabs. have only the tabs separating the cells.

Picture                Graphic picture object    Depends on page size with gridlines. and margin settings of target document. Cannot be edited in                                                  Works.

Microsoft Works        Embedded spreadsheet      Depends on page Spreadsheet            object with gridlines. size and margin settings of target document. Can be                                                  edited by double- clicking the object.

Bitmap                 Graphic bitmap object     Adjusts itself to the with gridlines. target document. Cannot be edited in Works.

Under Works 3.0, 4.0, 4.5, and 4.5a
 Format                 Primary Result            Secondary Result -- Microsoft Works        Embedded spreadsheet      Depends on page Sheet or Chart Object  object with gridlines. size and margin settings of target document. Can be                                                  edited by double- clicking the object.

Works internal         ANSI text with no         Empty rows will be Spreasheet/Database     gridlines and cells       replaced with a single separated by tabs. tab and a carriage return. Each row contains a leading tab before the data.

Picture                Graphic picture object    Depends on page size with gridlines. and margin settings of target document. Cannot be edited in                                                  Works.

Bitmap                 Graphic bitmap object     Adjusts itself to the with gridlines. target document. Cannot be edited in Works.

Unformatted Text       ANSI text with no         Empty cells internal gridlines and cells      to the range will separated by tabs. have only the tabs separating the cells.

Additional query words: 2.00 2.00a 3.00 4.00 4.00a 4.50 4.50a kbhowto embed embedded copy paste special range cells word processor Pasting Ctrl+V

Keywords: kbhowto kbinfo KB118596

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.