Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index




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.