table from calc to writer?

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

table from calc to writer?

Hi,my intuition tells me that it ought to be possible to copy a block of cells from calc and paste as (or into) a table in writer; but I haven't been able thus far to do it. Is it possible? I'm using LO 5.2.2.2 on Ubuntu.
thanks,
/Gary

--
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/
All messages sent to this list will be publicly archived and cannot be deleted
Jean-Baptiste Faure-3 Jean-Baptiste Faure-3
Reply | Threaded
Open this post in threaded view
|

Re: table from calc to writer?

Bonjour,

Le 24/11/2017 à 15:35, Gary Collins a écrit :
> Hi,my intuition tells me that it ought to be possible to copy a block of cells from calc and paste as (or into) a table in writer; but I haven't been able thus far to do it. Is it possible? I'm using LO 5.2.2.2 on Ubuntu.
> thanks,
> /Gary
>

Use Paste Special and choose Formatted text [RTF]

Best regards.
JBF

--
Seuls des formats ouverts peuvent assurer la pérennité de vos documents.
Disclaimer: my Internet Provider being located in France, each of our
exchanges over Internet will be scanned by French spying services.

--
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/
All messages sent to this list will be publicly archived and cannot be deleted
Gary Collins Gary Collins
Reply | Threaded
Open this post in threaded view
|

Re: table from calc to writer?


Thank you, yes, that does seem to do it for now. I could've sworn I'd tried that before, but apparently not. Or maybe I was doing something wrong.... I'll play around with it.

/G,
      From: Jean-Baptiste Faure <[hidden email]>
 To: [hidden email]
 Sent: Friday, 24 November 2017, 18:08
 Subject: Re: [libreoffice-users] table from calc to writer?
   
Bonjour,

Le 24/11/2017 à 15:35, Gary Collins a écrit :
> Hi,my intuition tells me that it ought to be possible to copy a block of cells from calc and paste as (or into) a table in writer; but I haven't been able thus far to do it. Is it possible? I'm using LO 5.2.2.2 on Ubuntu.
> thanks,
> /Gary
>

Use Paste Special and choose Formatted text [RTF]

Best regards.
JBF

--
Seuls des formats ouverts peuvent assurer la pérennité de vos documents.
Disclaimer: my Internet Provider being located in France, each of our
exchanges over Internet will be scanned by French spying services.

--
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/
All messages sent to this list will be publicly archived and cannot be deleted


   
--
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/
All messages sent to this list will be publicly archived and cannot be deleted
Gary Collins Gary Collins
Reply | Threaded
Open this post in threaded view
|

Accessing cells in macro

In reply to this post by Jean-Baptiste Faure-3
Hi,I have a column in calc which contains strings of characters (actually representations of words in an ancient script) and in another column I will need to create a cipher for those words (in which each of the characters in a string is mapped to a specific different character) so that I can sort the rows into the customary "alphabetical" order for the script. I can write a macro to do this, but in order to do so I need to know how to access specific cells and cell ranges in the spreadsheet, and I'm not sure how to do this in calc (I've done it in excel, so the procedure should be similar). Can anyone help me out here, perhaps pointing me to some appropriate code snippets that address the issue?
thanks,/Gary






 
   


   
--
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/
All messages sent to this list will be publicly archived and cannot be deleted
Gary Collins Gary Collins
Reply | Threaded
Open this post in threaded view
|

Re: Accessing cells in macro

I am resending this as i didnt get it in my inbox and havent seen any replies so i assume it didnt get through the first time.
G.
--------------------------------------------
On Sat, 25/11/17, Gary Collins <[hidden email]> wrote:

 Subject: Accessing cells in macro
 To: "[hidden email]" <[hidden email]>
 Date: Saturday, 25 November, 2017, 12:10
 
 Hi,I
 have a column in calc which contains strings of characters
 (actually representations of words in an ancient script) and
 in another column I will need to create a cipher for those
 words (in which each of the characters in a string is mapped
 to a specific different character) so that I can sort the
 rows into the customary "alphabetical" order for
 the script. I can write a macro to do this, but in order to
 do so I need to know how to access specific cells and cell
 ranges in the spreadsheet, and I'm not sure how to do
 this in calc (I've done it in excel, so the procedure
 should be similar). Can anyone help me out here, perhaps
 pointing me to some appropriate code snippets that address
 the issue?
 thanks,/Gary
 
 
 
 
 
 
 
 
   
 
 
 
   
 

--
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/
All messages sent to this list will be publicly archived and cannot be deleted