Q: How to paste text into multiple cells in a single Writer table row?

English
#1

I have an existing Writer table with roughly 30 rows of 15 columns each. (Well, actually dozens of such tables; which is why I am quite keen on automating this process.) I have data for the first row of this table in plain text; or, rather, in 15 small chunks of plain text that I can separate with whatever character(s) desired. But I have tried separating these chunks with newlines (U+000A), horizontal tabs (U+0009), and carriage returns (U+000D) to no avail. In all three cases, whether I choose Edit>Paste or Edit>Paste Special (which gives me only two choices that are not greyed-out: “Paste Unformatted Text” and “Paste Special”, the latter of which gives me only one choice “Unformatted text”), and whether or not the desired row is selected or the cursor is just in the first cell, all 15 snippets end up in either the first cell or copied into all cells, but never distributed (in order) among the cells.

Any way to do this?
Thank you for your time.

I am using:
Version: 24.2.7.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 32; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-US (C.UTF-8); UI: en-US
Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.4
Calc: threaded

#2

→ Convert Text to Table

1 Like
#3

Thank you!

That does not do what I was asking for (to be able to paste into an existing table), but does what I need reasonably well. It generates a new table from which if I copy the row and paste it into my existing table, it is pasted correctly. So it is a bit more involved than what I was hoping for, but still a lot less work than generating each of the 15 cells individually (dozens of times over).

Yay!

Thanks again for the quick help.

#4

as usual, the extra mile may be done by Recording a Macro

could also be done by specific code if you can clarify your workflow here, with an `.odt` example.

e.g. https://doc.services.openoffice.org/en/forum/viewtopic.php?t=26203

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.