Download it now!
Bug 129338 - Option to merge delimiters for text to table conversion
Summary: Option to merge delimiters for text to table conversion
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
6.3.3.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Writer-Tables
  Show dependency treegraph
 
Reported: 2019-12-12 08:23 UTC by elias estatistics
Modified: 2019-12-16 08:50 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
text to table - sample text (8.15 KB, application/vnd.oasis.opendocument.text)
2019-12-14 09:45 UTC, elias estatistics
Details
Text to table results - observed vs expected behavior (86.03 KB, image/jpeg)
2019-12-15 18:19 UTC, elias estatistics
Details

Note You need to log in before you can comment on or make changes to this bug.
Description elias estatistics 2019-12-12 08:23:19 UTC
Description:
Text to Table: Option to add: Possibility to use all empty "spaces" in order to make table from text

Currently, there is no the option to treat1 or multiple spaces as a single indication for seperation of text into cells.

Example spaces as "."
1.....2
2...3
3.4

How to convert that into a nice table without the use of regex?  " +" and "\t" ?
|1|2|
|2|3|
|3|4|

Sincerely,
Elias Tsolis
Psychologist /Statistician 

p.s. Keep up the good work
p.s. Peace in your plate
p.s. "If Slaughterhouses had Glass Walls, Everyone would be Vegetarian"


Steps to Reproduce:
1. Text with variable number of spaces / mix kind of spaces
2. Text to Table
3. Failure

Actual Results:
1. Text with variable number of spaces / mix kind of spaces
2. Text to Table
3. Failure

Expected Results:
1. Text with variable number of spaces / mix kind of spaces
2. Text to Table
3. Success


Reproducible: Always


User Profile Reset: No



Additional Info:
1. Text with variable number of spaces / mix kind of spaces
2. Text to Table
3. Success
Comment 1 Dieter 2019-12-13 14:27:52 UTC
(In reply to elias estatistics from comment #0)
> Steps to Reproduce:
> 1. Text with variable number of spaces / mix kind of spaces

Elias, thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it)
Comment 2 elias estatistics 2019-12-14 09:45:46 UTC
Created attachment 156586 [details]
text to table - sample text

text to table - sample text - see description on the proposed enhancement
Comment 3 Dieter 2019-12-15 11:58:54 UTC
It's possible for me to use empty spaces as indicators for table cells:

1. Open document from comment 2
2. Mark all
3. Tabel => Convert => Text to table
4. Add "space" in "Separate text at other"

Result: Table with 7 colums is created

Tested with

Version: 6.3.4.2 (x64)
Build-ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: threaded

and with

Version: 6.5.0.0.alpha0+ (x64)
Build ID: 89f0af144c18efafe2573801641689a1432c0cae
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-GB
Calc: threaded


Elias, please describe your steps => NEEDINFO
Comment 4 elias estatistics 2019-12-15 18:19:12 UTC
Created attachment 156598 [details]
Text to table results - observed vs expected behavior

Text to table results - observed vs expected behavior

 
This is not the expected Table format. Number of spaces are interpreted as so many cells. e.g. If there are 5 empty spaces, then 4 empty cells will be created.

1.....5
2..3
4.5

|1| | | | | |5|
|2| | |3| | | |
|4| |5| | | | |

The expected table format... a bulk of spaces are interpreted as “single cell separator”. This must take into consideration every type of “empty spaces” e.g. tabs, spaces etc.

|1|5|
|2|3|
|4|5|


Sincerely,
Elias Tsolis
Estatisticseu
Psychologist/Statistician
Comment 5 Dieter 2019-12-16 07:10:09 UTC
(In reply to elias estatistics from comment #4)
> Created attachment 156598 [details]
> Text to table results - observed vs expected behavior

So we have different opinions. I expect the observed behaviour. So I would say NOTABUG

cc: Design-Team for further input and decision
Comment 6 Heiko Tietze 2019-12-16 08:50:29 UTC
In Calc, we have the option "Merge delimiters". Let's add this to the table conversion dialog in Writer too.

See bug 116448 and bug 113979 for the solution to skip empty cells.