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