Bug 159981 - Pasting table data with no coloumn breaks (only row breaks), but with fixed number of columns.
Summary: Pasting table data with no coloumn breaks (only row breaks), but with fixed n...
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.7.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-03-01 10:27 UTC by Agnar Renolen
Modified: 2024-05-20 13:41 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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)