Given data in a Calc spreadsheet, how do I copy them to a Writer table? Just the data as text in a table (even if the data are numbers).
I have tried several ways, but without success:
a) Copy the Calc data and insert them into the Writer document. This gives me a Calc object within the Writer document, but with less ability of formatting as would be the case for a table.
b) Creating the table first, then copying the Calc data. This gives me a Calc object within the first cell of the table.
c) As b), but selecting the whole table first. Result is worse: Each cell contains a calc object with all data!
d) Saving Calc data as html or csv, then opening the data and inserting in the table. Still no conversion to table.
Does anybody has a better (and perhaps simpler) idea?