To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=71158
------- Additional comments from [EMAIL PROTECTED] Mon Jan 1 22:47:34 -0800 2007 ------- Perhaps it would be useful to talk to whoever implemented this function, if that is possible, to find out the thinking behind it? There is another function GCD_ADD which should be the same as GCD in Excel; one of the differences with Calc GCD is that Calc GCD can handle negative numbers. If there is to be a difference between Calc and Excel I suppose this is a good one, and returning a negative number when the arguments have mixed signs is at least defined, even if not in maths textbooks. I'm not very convinced though. Note that Calc GCD(0,0) currently returns an error so this probably needs fixing too (Excel does manage a 0 here). Also note that GCD_ADD(A1;A2) where: A1="text", A2=2 returns 2; A1=2, A2="text" returns error; A1="text", A2=-2 returns error; A1="text", A2 blank returns 0; A1 blank, A2 blank returns 0; so there is some inconsistency that should really be fixed. I think all these should return errors as in Excel. [Calc GCD(A1;A2) works OK here] There seem to be different mathematical definitions of the GCD function. MathWorld http://mathworld.wolfram.com/GreatestCommonDivisor.html is usually reliable. But it talks about the Mathematica implementation that deals with non- integers. That might be useful to imitate? It seems to me that we could do with a maths specialist to help decide what is really wanted. --------------------------------------------------------------------- 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]
