To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103445 Issue #|103445 Summary|Wrong substruction result for compare Component|Spreadsheet Version|OOO310m6 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|code Assigned to|spreadsheet Reported by|sibskull
------- Additional comments from [email protected] Thu Jul 9 16:38:24 +0000 2009 ------- In Calc I put followed content for cells: 47723.5 47587,4 =A1-A2 -> 136.1 136.1 =IF(A3=A4;"OK";"Error") -> Error Real result of substruction is 136,099999999999000 I know about float point number but I expect right result (possible, need round values) for simple numbers and comparison. --------------------------------------------------------------------- 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]
