To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97673 Issue #|97673 Summary|Embedded newlines in .csv files give wrong column widt |h Component|Spreadsheet Version|OOo 3.0 Platform|All URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|jimavera
------- Additional comments from jimav...@openoffice.org Tue Dec 30 21:38:22 +0000 2008 ------- 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) --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
