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.