To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109861
------- Additional comments from [email protected] Sat Mar 6 17:13:59 +0000 2010 ------- In Help stanfs for the N function N Returns the numeric value of the given parameter. Returns 0 if parameter is text, FALSE or #NA. If an error occurs, other than #NA, the function returns the error value. Syntax N(Value) Value is the parameter to be converted into a number. N() returns the numeric value if it can. It returns the logical values TRUE and FALSE as 1 and 0 respectively. It returns text and errors as 0. Example =N(123) returns 123 =N(TRUE) returns 1 =N(FALSE) returns 0 =N("abc") returns 0 =N(1/0) returns #DIV/0! either the help is wrong or the implemantation. This is another incompatible change to MS --------------------------------------------------------------------- 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]
