To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97949 Issue #|97949 Summary|362.2 - 360 <> 2.2 for 3 significant digits (2.19) Component|Spreadsheet Version|OOO300m9 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|code Assigned to|spreadsheet Reported by|kenandrews
------- Additional comments from kenandr...@openoffice.org Sun Jan 11 16:45:02 +0000 2009 ------- While comparing numbers with COUNTIF, I found values that didn't match, even though they should have. Subsequent testing showed rounding errors in the subtraction. (I have a small spreadsheet demonstrating it, but I don't see a method of attaching it, so:) Columns A to E: Format / Cells / Number / Decimal Places 2. Cell C1 function =B1-A1 Cell D1 function =int((B1-A1)*10)/10 Cell E1 function =int((B1-A1)*100)/100 Cell F1 function =if(C1=E1;"";"Bad") Copy C1:F1 to C2:F5 Type in the following values for A1:A5 <-- 0 / 60 / 360 / 125 / 126 Type in the following values for B1:B5 <-- 2.2 / 62.2 / 362.2 / 127.2 / 128.2 Note that this is NOT specific to 0.2; (for 360) it happens with any decimal values other than 0 or 5. (Implication to me is that it's a binary rounding problem.) Checking through your issues list, I think this is probably a duplicate of your Issue 69749, which in turn has had several other issues folded into it. If so, then this problem has been outstanding since at least 2003 (earliest one you've folded into 69749). That's 5 years. In my opinion, this is NOT a Priority 3 problem, it's a Priority 1 problem. Basic arithmetic is *important* for a spreadsheet. --------------------------------------------------------------------- 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
