To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80122 Issue #|80122 Summary|Miscalculations in floating point operations Component|Spreadsheet Version|OOo 2.2.1 Platform|All URL|http://tikker.org/Miscalculation_Testdata.ods OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|oo_tikker
------- Additional comments from [EMAIL PROTECTED] Fri Jul 27 16:08:03 +0000 2007 ------- I have spotted a strange issue that occurs when I try to subtract three float figures like: 0,71 - 0,7 - 0,01 The result should be 0, but isn't. Maxing out the number of digits, I get the following: 0,71000000000000000000 - 0,70000000000000000000 - 0,01000000000000000000 = -0,00000000000000010235 It appears to be the same with several other figures, too, yet not with all. I have put together a few examples in the file available through the URL. My guess would be a problem with periodic binary representations of certain values in combination with the internal rounding algorithm. Maybe you can spot it? Thanks for the great project, and keep up the good work! Thomas --------------------------------------------------------------------- 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]
