Works: Effects of Pasting a Spreadsheet into the Word Processor

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.