Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | "Text to Columns" converts newline to extra rows | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | Joe Smith <jes> | ||||||
Component: | editing | Assignee: | AOO issues mailing list <issues> | ||||||
Status: | CONFIRMED --- | QA Contact: | |||||||
Severity: | Trivial | ||||||||
Priority: | P3 | CC: | issues, rainerbielefeld_ooo_qa | ||||||
Version: | DEV300m52 | Keywords: | needhelp, oooqa | ||||||
Target Milestone: | --- | ||||||||
Hardware: | PC | ||||||||
OS: | All | ||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||
Developer Difficulty: | --- | ||||||||
Attachments: |
|
Description
Joe Smith
2009-07-20 17:23:21 UTC
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 ...). |