Re: [libreoffice-users] What does LibreOffice recognize as a column delimiter?

-------- Original Message --------
From: Jeffrey Walton [mailto:noloader@gmail.com]
Sent: Thursday, January 28, 2021, 12:02 UTC
To: users@global.libreoffice.org
Subject: [libreoffice-users] What does LibreOffice recognize as a column
delimiter?

> Hi Everyone,
>
> I have a Writer document with a Table inside. The table is large at
> about 3 columns x 500 rows. When I attempt to highlight the table
> cells and paste the data from a single 1 x 1500 source LibreOffice
> mishandles populating the table.
>
> I'm generating the data from a C++ program so I can format the data in
> a way that makes Writer happy. For example, I can use a vertical bar:
>
>    a  |  b   |   c
>    d  |  e   |   f
>    ...
>
> Or I can use something else.
>
> I already tried to use vertical bars and HTML tags like <tr>...</tr>,
> but the paste did not work.
>
> What does LibreOffice recognize as a column delimiter? So I can
> perform the 3x500 paste into the table?
>
> Thanks in advance.
>
> Jeff

Hi Jeff.

One possible option would be to generate your table in a csv layout
using tabs as the delimiter.

1<tab>2<tab>3<tab>4<cr>
5<tab>6<tab>7<tab>8<cr>

Rather than trying to paste into an existing table, paste the csv format
as plain text. Then highlight the pasted text and select Writer's main
menu "Table -> Convert -> Text to Table"option, identifying tabs as the
delimiter.

See Chapter 13 of the Writer Guide:
https://wiki.documentfoundation.org/images/a/a4/WG64-WriterGuide.pdf

Hope this helps.

Dave

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy