To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114430
------- Additional comments from [email protected] Fri Sep 10 12:27:43 +0000 2010 ------- I can confirm this error at OOO330m7. OpenFormula draft says: 6.4.6 Infix Operator "^" Summary: Exponentiation (Power). Syntax: Number Left ^ Number Right Returns: Number Constraints: NOT(AND(Left=0; Right=0)); Evaluators may evaluate expressions where OR(Left != 0; Right != 0) evaluates to a non-Error value. So this may be a defect compared to OpenFormala definions but more important this is a big error compared to mathematics. There is no reason leave this defect as it is now even if there may be mathematically loose definitions for the Power function in OpenFormula definitions. Still it allow implement the Power funtion too to give error message for Power(0;0). So only solution which is correct both mathematically and by OpenFormula definitions is change this ^ operator and the power function so that they product error message for 0 ^ 0. There is not even compatibility reason for this defect because for example gnumeric gives #Numero error in this situation. --------------------------------------------------------------------- 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]
