Copy Calc cell range into Writer table

Discuss the word processor
Post Reply
Owyn
Posts: 7
Joined: Wed Oct 02, 2024 6:22 pm

Copy Calc cell range into Writer table

Post by Owyn »

rocket_sciensce.jpg
rocket_sciensce.jpg (22.8 KiB) Viewed 233 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?
Last edited by MrProgrammer on Thu Nov 21, 2024 3:52 am, edited 2 times in total.
Reason: Add "Calc" to topic subject
OpenOffice 4.1.15 on Windows 10
FJCC
Moderator
Posts: 9455
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

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

Post 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.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
User avatar
Hagar Delest
Moderator
Posts: 32841
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

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

Post 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!
LibreOffice 24.8 on Xubuntu 24.10 and 24.8 portable on Windows 10
Owyn
Posts: 7
Joined: Wed Oct 02, 2024 6:22 pm

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

Post 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:
OpenOffice 4.1.15 on Windows 10
User avatar
Hagar Delest
Moderator
Posts: 32841
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

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

Post by Hagar Delest »

Yes, no trick at all.
LibreOffice 24.8 on Xubuntu 24.10 and 24.8 portable on Windows 10
Post Reply