Microsoft KB Archive/60070

Works: Copying Spreadsheet Data to the Word Processor

PSS ID Number: Q60070 Article last modified on 06-12-1996

1.00 1.05 2.00

MS-DOS

= SUMMARY =

In moving information from the Works Spreadsheet to the Word Processor using Edit Copy, some columns are misaligned. This problem is caused by spreadsheet entries overlapping the edge of the cell they are in.

Before copying information, verify that each spreadsheet column is at least two characters wider than its widest entry.

After copying to the Word Processor, set the left and right margins to zero to allow for the maximum number of characters per line. If columns are still misaligned, format the word processing document for a smaller font.

= MORE INFORMATION =

Works inserts a tab stop in the Word Processor for each column copied from the Spreadsheet (even if the column is blank). The position of the tab stop depends on the width of the columns. For instance, column A (width = 10), column B (width = 5), and column C (width = 10) produce tab stops at 0.1, 1.0, and 1.5 inches, respectively.

In addition to column tabs, special tabs are inserted depending on the type of data and the formatting used in the Spreadsheet.

If data Is: Tab Is: ———– ——-

Standard text Left aligned General numeric Decimal Fixed numeric Decimal Currency Decimal Exponential Decimal Percent Decimal Date Right aligned True/false Right aligned Centered (any data) Centered

Exceptions: If all numeric data in a column have the same number of decimal places, Works may insert a right aligned tab instead of a decimal tab for this column.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words:

=
================================================================ Copyright Microsoft Corporation 1996.