Works: Effects of Pasting a Spreadsheet into the Word Processor (118596)
The information in this article applies to:
- Microsoft Works 2.0
- Microsoft Works 2.0a
- Microsoft Works 3.0
- Microsoft Works 4.5
- Microsoft Works 4.5a
- Microsoft Works for Windows 95, version 4.0
- Microsoft Works for Windows 95, version 4.0 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.
| Modification Type: | Major | Last Reviewed: | 11/15/2004 |
|---|
| Keywords: | kbhowto kbinfo KB118596 |
|---|
|