Copy Calc cell range into Writer table
Copy Calc cell range into Writer table
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
Reason: Add "Calc" to topic subject
OpenOffice 4.1.15 on Windows 10
Re: insert data from table to another table - it inserts table into table :-(
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.
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
- 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 :-(
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!
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
Re: Insert data from table to another table - it inserts table into table :-(
Without any tricks? that's a good reason to "update"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!
OpenOffice 4.1.15 on Windows 10
- 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 :-(
Yes, no trick at all.
LibreOffice 24.8 on Xubuntu 24.10 and 24.8 portable on Windows 10