Bug 147599 - The text-to-table conversion feature lacks the ability to choose the number of columns
Summary: The text-to-table conversion feature lacks the ability to choose the number o...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Writer-Tables
  Show dependency treegraph
 
Reported: 2022-02-22 20:41 UTC by nutrientman
Modified: 2023-05-29 16:58 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Word 2016 "Convert Text to Table" dialog (24.82 KB, image/png)
2022-03-03 06:33 UTC, Mike Kaganski
Details

Note You need to log in before you can comment on or make changes to this bug.
Description nutrientman 2022-02-22 20:41:25 UTC
Description:
from irc: <jwash> in ms word i can have a text file with one piece of data on a line, then i can specify that my table should be 7 columns wide and word will make the table 7 columns wide, each row starting on the 8th piece of data. is there an equivalent for Libreoffice Writer? 

<mikekaganski> jwash: no; you are welcome to file a request to enhance Table->convert

Steps to Reproduce:
1. Paste the following in a text file:
a
b
c
d
a
b
c
d
a
b
c
d

Actual Results:
a
b
c
d
a
b
c
d
a
b
c
d

Expected Results:
a,b,c,d or a|b|c|d
a,b,c,d or a|b|c|d
a,b,c,d or a|b|c|d
a,b,c,d or a|b|c|d


Reproducible: Always


User Profile Reset: No



Additional Info:
a,b,c,d or a|b|c|d
a,b,c,d or a|b|c|d
a,b,c,d or a|b|c|d
a,b,c,d or a|b|c|d
Comment 1 nutrientman 2022-02-22 20:42:30 UTC
delimiter should be user defined: \t , | ; etc
Comment 2 Mike Kaganski 2022-03-03 06:33:38 UTC
Created attachment 178627 [details]
Word 2016 "Convert Text to Table" dialog

(In reply to nutrientman from comment #0)
> Steps to Reproduce:

The original steps are not precise. The proposal is to improve the existing Table->Convert->Text to Table function.

So here are the steps:

1. Paste the text from #1 of comment 0.
2. Select the pasted text, and open menu Table->Convert->Text to Table.
3. Try to use 'Separate Text At'->'Paragraph', or any other setting, to define that the text should be split to *some number of columns* using paragraphs.

In fact, the 'Paragraph' setting makes no difference compared to any other option in the dialog; and the dialog does not provide a way to control resulting number of columns to override automatic conversion.

For comparison, the attachment shows how Word's respective function looks like; and you can directly control the number of resulting columns there.