Ask Your Question

How do I include a spreadsheet in a text doc? [closed]

asked 2014-01-27 00:25:26 +0200

Medukie gravatar image

updated 2015-09-06 22:40:06 +0200

Alex Kemp gravatar image

I have a spreadsheet that I want to print out as an .odt so I can add other text before and after the spreadsheet.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 04:06:22.997696

2 Answers

Sort by » oldest newest most voted

answered 2014-01-28 01:46:10 +0200

m.a.riosv gravatar image

Depending if calc output is less than a page, you can copy from calc and paste directly in writer, but you can paste several parts of calc in different pages of writer. There is also an option creating an Ole object in Menu/Insert/Object/Ole/Spreadsheet, with the spreadsheet embedded in writer. Could be useful also Menu/Paste speciall/DDE link, this create a table in writer referenced to the cells in calc, what you can format in writer.

edit flag offensive delete link more

answered 2014-01-27 00:38:05 +0200

oweng gravatar image

updated 2014-01-28 04:23:24 +0200

This answer was originally provided to indicate how to save a spreadsheet in text format (i.e., CSV). For more appropriate advice (relating to the amended question) please refer the answer by @mariosv.

In terms of Calc, the common "text" format used is referred to as Character Separated Value (CSV) format i.e., the contents of each cell is written to a text file, separated by a common delimiting character, such as a semicolon ;. This can be done via:

  1. File > Save As...
  2. Select File Type of "Text CSV (.csv)" > optionally check the Edit filter settings option to allow setting of the separating character > click Save.
  3. Confirm File Format dialog > click "Use Text CSV Format".
  4. On the Export Text File dialog set options as required > click OK.

Related Help pages are here and here.

edit flag offensive delete link more


Sorry - I guess I didn't properly explain my issue. I have a spreadsheet that I want to print out as an .odt so I can add other text before and after the spreadsheet.

Medukie gravatar imageMedukie ( 2014-01-27 13:40:45 +0200 )edit

Question Tools

1 follower


Asked: 2014-01-27 00:25:26 +0200

Seen: 146 times

Last updated: Jan 28 '14