To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78250
------- Additional comments from [EMAIL PROTECTED] Fri Jun 8 23:27:02 +0000 2007 ------- As these functions have been (obviously) fixed in recent versions of MS Office (I do NOT have access to those versions), I consider this: - a priority 2 issue - should be definitely fixed until OOo2.3 (preferably even faster, OOo2.2.1 ?) - at least a partial improvement Please note, with X = 909999992, both RSQ() and CORREL() return 0!!! Actual values should be close to 1, respectively to -1. So, this value of '0' is plausible (aka possible), BUT definitely very wrong. There are many similar examples. Here another two obviously wrong examples, though the two x-values are almost identical, and yet the difference is extreme: X RSQ() CORREL() 910000000.1149 196 Err:503 910000000.1150 -192 Err:503 As pointed out, RSQ() can give only values between 0 AND +1. So, both values are wrong, and CORREL() fails altogether to compute. --------------------------------------------------------------------- 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]
