Converting a Spreadsheet to a Writer Table

If you want to put the contents of a spreadsheet in a Writer document, but the spreadsheet is too big to fit on the Writer pages, use this procedure to convert the spreadsheet to a Writer table that will span multiple pages.

1. Select the contents of the spreadsheet.

2. In Writer, click where you want to insert the table, and choose Edit > Paste Special.

3. In the Paste Special window, select the Unformatted text option, and click OK.

   The text of the spreadsheet is pasted into the Writer document.

4. Select the text that was just pasted into Writer, and choose Tools > Text <-> Table.

5. In the Convert Text to Table window, select the Tabs option, as shown in Figure 8-22.

   Figure 8-22. Converting tab-delimited text to a Writer table

   

6. Select any other options or formatting you want.

7. Click OK.