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
(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)
Created attachment 156586 [details] text to table - sample text text to table - sample text - see description on the proposed enhancement
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
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
(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
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.