On 3/21/19 12:04 AM, Brian Barker wrote:
Another option is to use the OLE (Object Linking and Embedding)
function. This feature allows taking an existing spreadsheet and insert
it into a Writer document. I know this is the opposite the OP asked for,
but it may be a possible solution. Historically, I have had mixed
results with the LO OLE feature, so it may need some experimentation to
get it to work as needed. Here is how:
At 19:20 20/03/2019 -0400, Charles Meyer wrote:
Has anyone been able to "import" or "insert" content from Writer
(tables) into Calc so there are no extra spaces, fits on the same one
page, etc. in Calc as it does on one page in Writer?
Very probably not! Formatting in spreadsheets is entirely different
from that in text documents. But you can easily paste material from a
table in a text document into cells of a spreadsheet. Then you can
reformat the material in the spreadsheet appropriately.
Why would you want to do this? Pagination comes into the story only
when you print your document. If the text document is paginated as you
wish, why not print that? I can more easily imagine a need for the
opposite: pasting an image of (part of?) a spreadsheet into a text
This sounds like a task that needs to be rethought from the beginning:
consider exactly what you are trying to do. Would it be better to
start with the spreadsheet?
I trust this helps.
Insert > Object > OLE Object > LibreOffice x.x Spreadsheet
I would choose "Create from file" and maybe "Link to file". That way, a
Calc file is used by Writer, but can still be maintained by Calc.
Without Link to file, Writer will create a local spreadsheet in the
document and not use a separate file, so Calc would not have access to
it outside the document. How it works is that clicking on the OLE
spreadsheet in Writer will bring up a Calc-like editor where the
spreadsheet data can be edited. Exiting this editor will return the the
Writer document mode. All without exiting the document. That may have
some advantages, so it will need to be decided by the OP which type
function is needed.
I checked, and Calc does have the insert OLE function, but the Writer
option is "LibreOffice x.x Text", which may just insert the Writer
document into a spreadsheet cell. I am guessing, having never used that
function in Calc. Both features will need some experimentation.
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: 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