I have a spreadsheet that I want to print out as an .odt so I can add other text before and after the spreadsheet.
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.
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:
- File > Save As…
- Select File Type of “Text CSV (.csv)” > optionally check the Edit filter settings option to allow setting of the separating character > click Save.
- Confirm File Format dialog > click “Use Text CSV Format”.
- On the Export Text File dialog set options as required > click OK.
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.
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.