Created attachment 188221 [details] SAMPLE CALC SHEET FOR BUG REPRODUCTION I report a defect in LibreOffice Calc, in the Text-To-Columns function. I have a set of data in a column that when submitted to the text-to-columns function, spliting the text only by the "/" character, the final block of data occupies more lines than the original block, probably because there was some LF-CR character in some cell of the original block. I understand that even if there is this character, the final block should have strictly the same number of lines as the original block. Because in a situation where I have two columns in the original block, the lines of the final block will be shifted and broken.
In tdf#155948, the request was the opposite: > Given a columnar range, allow the application of Text Import on the text in > those cells, separated by newlines; with the result placed in the (infinite?) > range beginning at the top-start cell of the range.
Well, as you can see in the example file provided, when your dataset has 2 or more columns, only one column gains more rows, and that breaks the correspondence between data of different columns.
The point is: there are contradicting requirements; the current way it functions is not "defective" by itself; so an option should be considered, not an unconditional change how it works.
(In reply to Silvio from comment #0) > probably because there was > some LF-CR character in some cell of the original block. In attachment 188221 [details], there are cells with [CTRL]+[ENTER] within some of the cells (e.g. B95). This means that the UNICODE 10 (line feed) character is included in some cells, generating the row "offset". A workaround would be (before using the Text-to-Columns feature) to use the Find and Replace dialog to replace (by nothing) the LF character, probably using some Regular Expression. This alternative is less user-friendly. The behavior described in comment 0 is already present in OOo. Considering comment 3 > needsUXEval.
How about adding an option whether or not the #10 LF char should be considered? UI wise I'd add it after "Space" using the term "Line Break" and move "Other" into the next line.