To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68636
------- Additional comments from katz...@openoffice.org Wed Jun 3 10:17:35 +0000 2009 ------- This issue has caused me many hours of work, especially since precision data loss is hardly discoverable. I frequently use CSV as exchange format for latitude longitude coordinates, so a truncation to 2 digits shifts all locations by a few 100 meters each. If one infrequently works with OO this always leads to data loss and requires lots of diagnostic and data recovery time. I do not see any use-case or application that would benefit from rounded CSV output data. OO Spreadsheet is a not-recommended tool for our customers until this is fixed, even though it excels in UTF-8 handling and CSV reading capabilities. Data loss without *HUGE* warning or alaert panel is not acceptable. Solutions: 1. Import the CSV with all digits shown by default. If rounding is desired the CSV should already be rounded. Make no assumptions about the imported data. 2. Export with a HUGE warning that precision loss may occur. --------------------------------------------------------------------- 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