On 12/28/2011 09:51 AM, Regina Henschel wrote: > Hi ??? > > . schrieb: >> Many of the Calc sheets I work on get pasted into Draw (or Writer) using >> the Paste Special-----> Calc8 or GDI options. >> >> It takes some time to resize the sheets I'm pasting into Draw or Writer >> so that they fit to the margins in Draw or Writer. >> >> Is there a simple and quick way to re-size the pasted sheets so that >> they will fit to the margins of the page in Draw or Writer? >> >> If so....how? > > It depends on the document and on the target format. > Draw: > Calc8 --> OLE > GDI --> Picture > Use Format > Position&Size. Or you single click the object and > drag the green handles while pressing the Shift-key. > RTF --> native Draw-table > Single click the table and drag the handles. In Addition use > the table properties to change the font size. > Draw has no object size relative to page size. Only when you change > the page settings, you can check to adapt the object sizes. > > Writer: > Calc8 --> OLE > Use Format > Frame/Object. In tab "Type" check "keep ratio", check > width "relative" and set width to 100%. > GDI --> Picture > Use Format > Picture, then same as above for OLE > RTF --> native Writer-table > Use the Table Properties, tab "Table". Check width "relative" > and set to 100%. > HTML --> native Writer-table > Nothing to do, table is already at width 100% > > Kind regards > Regina
Wow...you folks are really smart! Here's how I solved the problem with all of your help; In Writer- Paste the Calc sheet into Writer Right click on the pasted in sheet and select Picture Select the first tab which is "Type" Adjust the Size so that the sheet will fit loosely between the page's margins Under Position change the Horizontal and Vertical so that the sheet is Centered......to......The Entire Page Thank you everyone > > -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
