Page 1 of 1

Copy Calc cell range into Writer table

Posted: Wed Nov 20, 2024 3:37 pm
by Owyn
rocket_sciensce.jpg
rocket_sciensce.jpg (22.8 KiB) Viewed 241 times
:crazy:

I want to copy data from one table (from Calc) and fill it into another table (Writer one) (into different cells) but with no luck so far, only time it worked is when I copied the data from the same table back into the very it again

Is there really no way to do this seemingly super-simple operation with a state-of-art office software?

Re: insert data from table to another table - it inserts table into table :-(

Posted: Wed Nov 20, 2024 6:49 pm
by FJCC
I can't find a direct way to copy from a spreadsheet into a Writer table. It can be done in a multi-step process.
Copy the Calc cells
Do Paste Special -> Unformatted Text into a regular text area (not a table) of a Writer document. It can be a different document than the one that will have the final table.
Select that text and use the menu Table -> Convert -> Text to Table (using tab as the separator) to make a table
Copy the cells of the new table into the original table in your Writer document.

Re: Insert data from table to another table - it inserts table into table :-(

Posted: Wed Nov 20, 2024 10:30 pm
by Hagar Delest
In AOO, the only trick IIRC is to use the paste as DDE link outside the table and then copy from that table to the final table: [Solved] Using data from Calc in Writer Table.

Note that I just tried with LO (24.8.2) and it works directly from Calc to Writer!

Re: Insert data from table to another table - it inserts table into table :-(

Posted: Wed Nov 20, 2024 11:28 pm
by Owyn
Hagar Delest wrote: Wed Nov 20, 2024 10:30 pm Note that I just tried with LO (24.8.2) and it works directly from Calc to Writer!
Without any tricks? that's a good reason to "update" :super:

Re: Insert data from table to another table - it inserts table into table :-(

Posted: Thu Nov 21, 2024 12:24 am
by Hagar Delest
Yes, no trick at all.