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: users+help@global.libreoffice.org
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
Context
   
 
  Privacy Policy |
  
Impressum (Legal Info) |
  
Copyright information: Unless otherwise specified, all text and images
  on this website are licensed under the
  
Creative Commons Attribution-Share Alike 3.0 License.
  This does not include the source code of LibreOffice, which is
  licensed under the Mozilla Public License (
MPLv2).
  "LibreOffice" and "The Document Foundation" are
  registered trademarks of their corresponding registered owners or are
  in actual use as trademarks in one or more countries. Their respective
  logos and icons are also subject to international copyright laws. Use
  thereof is explained in our 
trademark policy.