Ask Your Question
0

Paste list of numbers separated by paragraph breaks directly into Writer table rows all at once?

asked 2020-03-10 15:16:49 +0100

appreciatethehelp gravatar image

MacOS Mojave 10.14.6 / Libreoffice 6.2.5.2.

I have a list of numbers separated by paragraph breaks like so:

12

23

34

45

56 etc.

Note: there is only one paragraph break between each number in the actual document- I added two here in order to illustrate the appearance of my number list, as otherwise the numbers won't display in a top-to-bottom list on this website.

I want to copy/paste this list directly into writer table row cells, so that each two-digit number is in its own row/cell (eg. "12" is in row 1 (cell A1), "23" is in row 2 (Cell A2) etc.), all at once/without having to copy/paste each number individually. I remember having done this once in the past but can't recall how it was done- some kind of Paste Special? The options in Paste Special dialog didn't prove to be much use here...

Cheers.

edit retag flag offensive close merge delete

Comments

12
23
34
45
56
To get this appearance i had to type two (at least) ordinary spaces behind each number before entering a linebreak. (That's the same with text.)

12
23
34
45
56

Without the extra spaces you get it using the tool 'preformatted text'. Mouse over the respective icon you get also informed that you can use Ctrl+K.

Lupp gravatar imageLupp ( 2020-03-10 20:07:51 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2020-03-10 17:51:29 +0100

ajlittoz gravatar image
  1. Paste your list as normal text where you want the table to appear
  2. Select the list
  3. Table>Convert>Text to Table and set the parameters to fit your case

To show the community your question has been answered, click the ✓ next to the correct answer, and "upvote" by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!*

In case you need clarification, edit your question (not an answer which is reserved for solutions) or comment the relevant answer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-03-10 15:16:49 +0100

Seen: 146 times

Last updated: Mar 10 '20