[Libreoffice-bugs] [Bug 53274] : N() doesn't return 0 if input is #N/A
bugzilla-daemon at freedesktop.org
bugzilla-daemon at freedesktop.org
Mon Aug 13 18:55:30 CEST 2012
https://bugs.freedesktop.org/show_bug.cgi?id=53274
David Lynch <david_lynch at blueyonder.co.uk> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CLOSED |REOPENED
Resolution|NOTABUG |
Ever Confirmed|0 |1
--- Comment #4 from David Lynch <david_lynch at blueyonder.co.uk> 2012-08-13 16:55:30 UTC ---
There is a bug, either in the software or the documentation.
The documentation is:
"N
Returns the numeric value of the given parameter, if the parameter is a number.
Returns the number 1 if the parameter is TRUE. Returns the number 0 for other
parameters (text, FALSE or #NA).
If an error occurs, other than #NA, the function returns the error value."
Clearly, this says that N(NA()) should return 0. And previous versions of the
software did this. I and (and apparently others) have been relying on this.
If it is decided that is right to change the behaviour of N(), then I suggest
that adequate warning of this is given, and the documentation amended to
reflect this warning.
Meanwhile, the software does not behave as the documentation says so there is a
bug somewhere.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
More information about the Libreoffice-bugs
mailing list