Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Embedded newlines in .csv files give wrong column width|
|Component:||open-import||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||DEFECT||Latest Confirmation in:||4.0.0|
Description jimavera 2008-12-30 21:38:22 UTC
Comma-separated-value (csv) files may contain "quoted fields with embedded newlines". When importing into scalc, the width of the spreadsheet column is set incorrectly to the width of the widest datum as if the newlines were ordinary characters. This results in spreadsheet columns which are extremely wide (often much wider than can be displayed), even though the longest text line is much shorter. Expected results: The spreadsheet column width should be set according to the longest line in any cell in the column, taking into account embedded newlines. I will attach a small .csv file. To see the problem, open it from scalc. (Note: Applying 'Optimal Column Width' to the column removes the excess space)
Comment 1 jimavera 2008-12-30 21:39:29 UTC
Created attachment 59086 [details] Demo CSV file with embedded newlines in a "text field"
Comment 2 jimavera 2008-12-30 21:40:10 UTC
Created attachment 59087 [details] Demo CSV file with embedded newlines in a "text field"
Comment 3 jimavera 2008-12-30 21:43:03 UTC
Created attachment 59088 [details] Screen-shot showing incorrect column width
Comment 4 Edwin Sharp 2013-04-26 12:11:52 UTC
Unreasonable width when importing attachment in Rev. 1467605