To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112910
------- Additional comments from j...@openoffice.org Sun Jul 4 15:04:08 +0000 2010 ------- Nothing official here, just my take... I think it's a numerical problem, not a sorting problem: the values in I23 & I24 *look* the same, but they're not. As Calc compares them, I23 is a very tiny bit less than I24, so it does not compare the values in column H. I honestly can't tell you why they're different, or even how to see it. If you try =I23=I24, Calc shows TRUE, and both =I23<I24 and =I23>I24 show FALSE. =1-I23/296.16 gives zero, as does =1-SUM(F23:H23)/296.16. However, if I change the formula in column I from =IF(F5="";"";SUM(F5:H5)) to =IF(F5="";"";ROUND(SUM(F5:H5);2)) --just rounding off the sum to the same number of places your data are already limited to, so it should not change the answers, then I get the expected order with your sort. You can even see it if you copy cells G23:I24 and then paste-special with only the values--no formulas--to a new sheet. If you sort those two rows, you'll see the same sort order problem, but if you just save and reload that file, or edit the values in the last column (just to re-enter them, not to change the value), then the sort gives the expected order. So it seems there's some invisible difference between the SUMs in cells I23 & I24. Surely this is a nasty problem, even if it's not literally a bug; as far as I know, it's just something that happens occasionally with any spreadsheet. Changing to "precision as shown" is one way to protect against floating-point gremlins, but it doesn't seem to help in this case. --------------------------------------------------------------------- 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
