Writer into Calc

classic Classic list List threaded Threaded
5 messages Options
charles meyer charles meyer
Reply | Threaded
Open this post in threaded view
|

Writer into Calc

My apologies if this has been posted.

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?

Thanks so much.

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Johnny Rosenberg Johnny Rosenberg
Reply | Threaded
Open this post in threaded view
|

Re: Writer into Calc

Den tors 21 mars 2019 kl 00:24 skrev charles meyer <[hidden email]>:

> My apologies if this has been posted.
>
> 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?
>

I'm not sure what you mean by ”page” in this case. Calc has no ”pages”.


Kind regards

Johnny Rosenberg



--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Brian Barker Brian Barker
Reply | Threaded
Open this post in threaded view
|

Re: Writer into Calc

In reply to this post by charles meyer
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 document.

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.

Brian Barker


--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Girvin Herr-5 Girvin Herr-5
Reply | Threaded
Open this post in threaded view
|

Re: Writer into Calc


On 3/21/19 12:04 AM, Brian Barker wrote:

> 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
> document.
>
> 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.
>
> Brian Barker
>
>
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:

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.

HTH.
Girvin Herr



--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
fudmer rieley fudmer rieley
Reply | Threaded
Open this post in threaded view
|

Re: Writer into Calc

this is a giant problem for me.. the bastardized way in which calc has
been amended (makes each cells a text box or whatever has corrupted my
entire library of saved articles..
I have spent many years defending open source, but this change was hit
that forced me to move to paid for tools that work and do not crash..


If LO would return to versions before 2015 they could correct all the
crap that messes up what used to be a good product.

quit upgrading quit version development, just make sure LO works in all
of its iterations and on all platforms..
people are leaving you left and right.. everyone I deal with that used
to use LO have moved away..


it is no longer a stable platform.



On 2019-03-21 02:13 PM, Girvin Herr wrote:

>
> On 3/21/19 12:04 AM, Brian Barker wrote:
>> 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 document.
>>
>> 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.
>>
>> Brian Barker
>>
>>
> 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:
>
> 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.
>
> HTH.
> Girvin Herr
>
>
>


--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy