How do I import a spreadsheet into open office?
I have an already existing spreadsheet in open office, and I would like to import it into an already existing open office writer doc.
so it would look like:
text
text
spreadsheet
text
text
all nice and clean.
I already tried pasting the info, but it doesn’t work, and tried opening columns in the writer, but I’d like not to have to type it all over in the provided columns. any ideas?
I forgot to mention that I would like the spreadsheet to be smaller then the text in the text doc. because the spreadsheet is long, and it needs to be condensed to fit.
Mail this postPopularity: 2% [?]
1 Comment »
RSS feed for comments on this post. TrackBack URL
In Calc select the portion of the spreadsheet you wish to copy over.
Press CTRL-C to copy or select Edit → Copy.
This will copy the area you want into your clipboard.
Go to the Write document into which you want to copy the spreadsheet. Place the mouse point approximately where you want the spreadsheet to appear. Presss CTRL-V or select Edit → Paste to paste the spreadsheet from your clipboard into the Write document.
The spreadsheet will now appear in approximately the proper area.
Right-click on the spreadsheet. This will open up a menu which provides a number of options for changing the appearance.
To change the size select “Object” and use the “Type” tab. This provides a “Size” area which lets you change the size of the spreadsheet either vertically or horizontally or both. You will probably want to make sure there is a check mark in the “Keep ratio” box before changing the size.
You might also want to user the “Borders” tab to put a border around the outside of the spreadsheet menu. Set everything as you like.
When you right-click on the spreadsheet within Writers one of the the choices that appears is “Edit”, If you select this, it will temporarily show that spreadsheet as though it were a real spreadsheet with a header rows which you can adjust. Select any areas you want to change and then right click again, and you will see a menu of choices almost identical to those which you would see in Calc itself. “Format Cells…” is likely to be useful. You can use it to change the colors or borders or fonts in the cells you have selected.
Placing the mouse cursor in a text area in Writer will turn off this spreadsheet appearance.
Play around with these commands. You should be able to easily get the spreadsheet to appear exactly as you wish.