openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Arthur Schwarz" <aschwarz1...@att.net>
Subject RE: How do you insert a spreadsheet into a text document
Date Thu, 12 Dec 2013 10:45:01 GMT
Hi Brian;

That was a truly awesome response. Everything worked except repeating the
top two lines across multiple pages. I can live with that.

Thanks
art

-----Original Message-----
From: Brian Barker [mailto:b.m.barker@btinternet.com] 
Sent: Thursday, December 12, 2013 2:16 AM
To: users@openoffice.apache.org
Cc: Arthur Schwarz
Subject: Re: How do you insert a spreadsheet into a text document

At 19:40 11/12/2013 -0800, Arthur Schwarz wrote:
>What I would like is to have a couple of pages in my document in 
>landscape mode, the rest in portrait mode. When I go to Format -> 
>Page -> Page I can format for landscape mode but it formats the 
>entire document. How do I format just a few pages and not the entire
document?

Orientation is a property of page style, so you need to change your 
page style in order to change orientation.  In this case, you will 
want to insert manual page breaks to mark the places where the 
orientation changes:
o Go to Insert | Manual Break... .
o Under Type, select "Page break".
o Under Style, select a suitable page style for your landscape pages, 
perhaps Landscape - or one you have created yourself.
o After your landscape pages, repeat the procedure to change the page 
style back - to Default or whatever.

>I know about copy and paste. Works great. But, my table is 59 rows 
>and is organized into landscape mode. So, copy and paste produces 
>one condensed page.

But you may not know about Paste Special, which will be your friend 
here.  You get to it at Edit | Paste Special... or by using 
Ctrl+Shift+V (instead of Ctrl+V).  This gives you a number of paste 
options, and you will want to experiment to see what suits your 
purpose.  The default mode gives you a copy on a single page within a 
frame; you can reshape the frame but not (easily) split it between 
pages.  Note that you can double-click the result to give an editable 
spreadsheet.  Other options give you a picture of the spreadsheet, or 
a table mimicking the spreadsheet cells.

>The second question is that I would like to copy the entire OOCalc 
>spreadsheet into the landscape pages and have the spreadsheet occupy 
>more than a single page.

Some options will do this.

>Perhaps to make it a table within the text document. I've tried the 
>Copy/Paste into a table and that doesn't seem to work well.

Instead of pasting into a table, allow Paste Special... to create the 
table on the fly.

>And I guess at the bottom of the list, once the spreadsheet is 
>inserted, I'd like to make changes to it.

There are various possibilities here:
o If you use an option that creates a table, you can easily modify 
values in the text document.
o If you use an option that enables you to edit the result, you can 
use the full spreadsheet functionality on the result.

With either of these, you are modifying a copy of the spreadsheet data.

>Do I use Copy/Paste or is there another way to do it (I've looked at 
>Insert->Object but nothing seems to apply).

Oh, it does!

o You can use Insert | Object > | OLE Object..., choose "Create from 
file", and browse to the spreadsheet file.  There are two options 
here: you can embed the spreadsheet into the text document, or you 
can choose to link the text document to the spreadsheet file itself - 
by ticking "Link to file".  In the latter case, you are actually 
handling the spreadsheet file from within the text file.  Typically, 
you would want to edit the spreadsheet and would then see any changes 
appear automatically in your text document.

Horses for courses.

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Mime
View raw message