Bug 159981

Summary: Pasting table data with no coloumn breaks (only row breaks), but with fixed number of columns.
Product: LibreOffice Reporter: Agnar Renolen <agnar.renolen>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEEDINFO ---    
Severity: enhancement CC: stephane.guillou
Priority: medium    
Version: 7.3.7.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description Agnar Renolen 2024-03-01 10:27:45 UTC 
I often need to copy and paste data from Web-pages into a spread sheet.

cell-11 cell-12 cell-13
cell-21 cell-22 cell-23
...

When pasted into the spread sheet, they end up like this:

cell-11
cell-12
cell-13
cell-21
cell-22
cell-23

What I want to secify, when pasting the text (paste special) is
that 

- newline (or row break) can be selected as a column separator.
- and that the pasted data has N (N=3 in this example) columns.

This would save me a bunch of time in many cases.

Adobe InDesign has this feature where you can convert text into tables.
Comment 1 Stéphane Guillou (stragu) 2024-05-20 13:41:23 UTC 
Can you provide an example website to copy the HTML from?
Have you tested right-click > paste special > unformatted text? That text import dialog provides many options to define the structure of the table.
Comment 2 Stéphane Guillou (stragu) 2024-05-20 13:41:49 UTC 
(also, please test a version that is currently maintained, like 24.2)