-------- Original Message -------- From: Jeffrey Walton [mailto:noloa...@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+unsubscr...@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
