table from calc to writer?

users
#1

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

#2

Bonjour,

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

#3

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,

#4

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