To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77215 Issue #|77215 Summary|CSV Import/Export is lossy due to default numerical ro |unding Component|Spreadsheet Version|OOo 2.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|dlm
------- Additional comments from [EMAIL PROTECTED] Thu May 10 17:45:24 +0000 2007 ------- I regularly use the CSV import and export features in Calc to edit simple parameter input files for numerical computation models. By default Calc displays 2 decimal point precision in all cells. This seems to be arbitrarily based on the notion that any floating point number is a currency. It is irritating to have to change the displayed precision manually (especially when this typically results in resized columns) More importantly, upon export (file, save as) Calc by default outputs the displayed 2dp precision instead of the actual precision. I eventually figured out I could change this behavior by editing filter settings, but these setting reset upon restart. Thus, I always face the risk of losing precision if i don't check my export settings carefully. I do not have the same problems in Microsoft Excel. My proposals are: 1. default behavior maintains full precision for non-native file types that do not support display formatting: a) on display after csv import unless the user selects otherwise. b) on output after csv export (again unless the user selects otherwise). 2. persistent text import settings be stored (output formatting, delimiters etc) allowing one click opening under preferred settings --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
