To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68636 Issue #|68636 Summary|Not possible to save an opened csv file with full nume |ric precision Component|Spreadsheet Version|OOo 2.0.3 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|hvbakel
------- Additional comments from [EMAIL PROTECTED] Tue Aug 15 02:04:37 -0700 2006 ------- I often work with csv files containing high-precision numeric data (10 decimals or so) generated by statistical software. When I open these files in calc it automatically rounds these numbers to 2 decimals for display purposes, while still maintaining the underlying high-precision numbers. However, when I save the file after editing (again in csv format) it only saves the rounded numbers. I believe this is caused by the calc feature "Save cell content as shown", which is by default enabled in the dialog window that appears when I select 'Save file as' -> text(csv). Unfortunately this same window only appears if I am currently working on a openoffice calc file, not with an opened csv file. I believe two things need to be changed: 1) The default behaviour of saving csv files must be to save the original data, not the 'data as shown' because this can lead to serious data loss. At the very least, this behaviour should be configurable in the calc settings. 2) The 'Export of text files' dialog window should always appear when selecting 'save file as' and selecting 'text(csv)' as file format. To reproduce: 1) open a CSV files that contains numeric data with more than 2 decimals 2) Save the same CSV file again and notice how all data is now rounded to 2 decimals. --------------------------------------------------------------------- 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]