Apache OpenOffice (AOO) Bugzilla – Issue 97673
Embedded newlines in .csv files give wrong column width
Last modified: 2013-04-26 12:11:52 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)
Created attachment 59086 [details] Demo CSV file with embedded newlines in a "text field"
Created attachment 59087 [details] Demo CSV file with embedded newlines in a "text field"
Created attachment 59088 [details] Screen-shot showing incorrect column width
Unreasonable width when importing attachment in Rev. 1467605