Issue 103671 - "Text to Columns" converts newline to extra rows
Summary: "Text to Columns" converts newline to extra rows
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: DEV300m52
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needhelp, oooqa
Depends on:
Reported: 2009-07-20 17:23 UTC by Joe Smith
Modified: 2013-01-29 21:44 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Sample document showing problem (11.09 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-07-20 17:24 UTC, Joe Smith
no flags Details
Updated sample document (11.61 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-07-20 19:15 UTC, Joe Smith
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Joe Smith 2009-07-20 17:23:21 UTC
When using the Data > Text to Columns feature, if a value in the source range
contains a newline character, the value will be split over multiple columns in
the result.

A1: Alpha\nBravo\nCharlie

After "Text to Columns" will be:
A1: Alpha
A2: Bravo
A3: Charlie

If the cells below the source (A2, A3 in the example) contain data, it will be
overwritten without warning.

Expected behavior:
Values processed by "Text to Columns" should always remain in the same row.
Comment 1 Joe Smith 2009-07-20 17:24:21 UTC
Created attachment 63655 [details]
Sample document showing problem
Comment 2 Joe Smith 2009-07-20 19:14:58 UTC
There is another problem that occurs when the source data contains newlines and
the source range contains empty cells: extra copies of unprocessed source data
can appear in the result.

An example is included in the updated sample document.
Comment 3 Joe Smith 2009-07-20 19:15:52 UTC
Created attachment 63656 [details]
Updated sample document
Comment 4 Joe Smith 2009-07-20 19:27:21 UTC
This is a change (regression?) compared to OOo 3.1, where "Text to Columns"
deletes the newline characters from the source but keeps the output data in the
same row as the source.

I'm guessing this has something to do with the changes for Issue 35913.
Comment 5 Rainer Bielefeld 2009-07-21 10:20:14 UTC
I checked "t2c_updated.ods" with "Ooo 3.1.0 WIN XP multilingual version German
UI activated  [OOO310m11 (Build 9399)]" and also with "Ooo Dev 3.2.0
multilingual version German UI WIN XP: [DEV300m52 (Build 9411)]". I can confirm
that behaviour changed between these versions. 

I can confirm all reported (unexpected?) effects with 3.2, but none of them with

Bug or feature? I belive a feature "Text to columns" should only create new
columns, but not new rows, but I do not know all specification details EXCEL
compatibility or what ever might have influence ...).