To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85325
------- Additional comments from [EMAIL PROTECTED] Thu Jan 24 10:01:31 +0000 2008 ------- The problem is the setting "Decimal Places" in "Tools -> Options -> OOo Calc -> Calculation". By default this is set to 2 which is the reason why the numbers which originally have 4 decimal places in the csv file are cut/rounded to only 2 decimal places in the display (not internally). And this causes this confusion. It should be possible to set the "Decimal Places" to "unlimited" and not only from "0" to "20". And this should be the default setting. Then it wouldn't matter how many decimal places the numbers in a csv file have. They would be shown with every decimal places by default. So the sum was not calculated incorrectly but when I recalculated it manually I didn't think of this setting "Decimal Places" and that these numbers are displayed rounded. So my (wrong) conclusion of course was that OOo Calc made arithmetical errors. --------------------------------------------------------------------- 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]
