Apache OpenOffice (AOO) Bugzilla – Issue 103671
"Text to Columns" converts newline to extra rows
Last modified: 2013-01-29 21:44:01 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. E.g. 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.
Created attachment 63655 [details] Sample document showing problem
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.
Created attachment 63656 [details] Updated sample document
Note: 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.
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 3.1. 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 ...).