We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How should I correctly prepare data from clipboard to be inserted in table rows in Writer?

asked 2018-09-24 17:55:30 +0200

Norbert gravatar image

updated 2018-09-24 18:03:22 +0200

Let's consider that we have simple formatted text with tabs and four columns:

01.09   1     Some_Text Some_Text #1
02.09   2     Some_Text Some_Text #2
03.09   3     Some_Text Some_Text #3

I want to copy this text to clipboard buffer and then paste it to LO Writer table.

I would like to start with two-rows table (filled header and empty row for data):

Step 1 - empty table

and then after pressing Ctrl+v I expect to have table rows filled with data from clipboard buffer:

Step 2 - expected filled table

but this does not happen (I need to manually cut and paste data between cells).

How should I change the text formatting above to automatically get text inserted in corresponding table rows?

Note: I'm using LibreOffice (from official PPA) on Ubuntu 16.04 LTS.

edit retag flag offensive close merge delete


I tried preparing the clipboard data as a .csv file but this results in the entire csv file being copied entirely into the first cell of the table, the last cell of the table, or all cells of the table. The table feature in Writer doesn't seem able to handle data that is distributed over more than one cell at a time. Maybe someone else can suggest a solution.

ve3oat gravatar imageve3oat ( 2018-09-25 03:14:22 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-09-24 00:41:59 +0200

LeroyG gravatar image

You will need a few intermediate steps:

  • Paste the data in a instance of Writer.
  • Convert text to table (menu Table - Convert - Text to Table…).
  • Copy/cut the data from the newly created table and paste it in the second row of the target table; or drag it.

Maybe you will need to reaply the format to the cells.

Tested with LibreOffice (x86); OS: Windows 6.1.

Add Answer is reserved for solutions.

Press edit below your question if you want to add more information; also can comment an answer.

Check the mark (Correct answer mark) to the left of the answer that solves your question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2018-09-24 17:55:30 +0200

Seen: 168 times

Last updated: Sep 24 '20